• Presenter
    • Adam Cogan
  • Duration
    • 1 day
  • Price (ex GST)
    • $299

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