- Presenter
- Duration
- Price (ex GST)
About the Course
The release of SQL Server 2008 R2 and SharePoint 2010 delivers a new generation
of data tools with a specific focus of self-service BI. In this one day seminar,
learn how Excel 2010 has been enhanced to provide richer reporting and analytic
features, and how PerformancePoint Services has evolved to become a feature-rich
service that delivers rich KPI, Scorecard and Report definitions, and interactive
dashboard experiences.
The "jewel in the crown" of Excel 2010 is PowerPivot, a powerful data analysis tool
that enables users to create and report from data models. Worksheets that store
PowerPivot data models can be deployed to SharePoint 2010 to become data sources
that can be managed by IT and consumed by user queries and reports. The first half
of the seminar will cover how to load, prepare and report from PowerPivot models.
The second half of the seminar will introduce PerformancePoint Services and demonstrate
how to produce a library of data connections, indicators, KPIs, scorecards and reports
to produce and deploy interactive dashboards to SharePoint. This seminar is suitable
for IT professionals and business users, and equally to management who are interested
to understand and evaluate Microsoft's upcoming product release. No prior understanding
of the features products is required.
Course Location
|
SSW Sydney
Suite 10, 81-91 Military Rd - Neutral Bay - NSW
|
Course Times
|
9AM - 4PM
|
Who should attend
|
Anyone required to report, monitor and analyze data, and for those interested to understand and evaluate Microsoft's next generation data tools
|
Agenda
9AM - 12PM
Topic
|
Description
|
Analysis and Reporting with the Excel 2010
|
- What's New in the Excel 2010 Client
- Loading and Preparing Data in the Excel 2010 PowerPivot Client
- Creating Excel 2010 PowerPivot Reports
- Defining DAX Calculations with Excel 2010 PowerPivot
- Managing Excel 2010 PowerPivot Solutions in SharePoint 2010
|
1PM - 4PM
Topic
|
Description
|
Monitoring and Analyzing with SharePoint 2010 PerformancePoint Services
|
- Introducing SharePoint 2010 PerformancePoint Services
- Developing KPI's and Scorecards with SharePoint 2010 PerformancePoint Services
- Developing Reports and Dashboards with SharePoint 2010 PerformancePoint Services
|
Acknowledgements
Adam Cogan