Our vision is simple: We enhance Microsoft SQL Server and Microsoft Business Intelligence skills in organisations by providing expert consulting, mentoring and training services.
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.
For details on booking courses or seminars, please visit our booking page.
This course is intended 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.
Upon completion of this course, the student will be able to: