31/01/2011 12:35:27 AM
One of the pillars of the SQL Server 2008 R2 release is Managed Self-Service BI. The SQL Server PowerPivot for Excel add-in is a key offering in this pillar, and delivers an entirely new analytic experience to Excel 2010. The add-in allows analysts to load and prepare large volumes of data from various sources to create a multidimensional model. The model can be enriched with sophisticated calculations. Then the model can then be used as the source for PivotTable and PivotChart reports. And yet that’s not the end of the story. With the SQL Server PowerPivot for SharePoint add-in, the Excel workbooks that host the PowerPivot model can be catalogued in SharePoint and exposed as a data source for other Excel and Reporting Services reports. These SharePoint hosted models can then be managed by IT with scheduled data refreshes from the originating data stores.
In this session, you will be introduced to the two add-ins. An end-to-end series of theory, demonstrations and discussion will describe how you can effectively leverage the add-ins with your own analysis and reporting requirements.
Speaker: Peter Myers (SolidQ)
Peter Myers has 13 years' solid experience working in OLTP database design and development, DBA support and Data Warehousing/Business Intelligence with SQL Server.
Specializing in Microsoft Business Intelligence, Peter provides mentoring, technical training and course content authoring for SQL Server and Office. Specifically he works with Integration Services, Analysis Services (cubes and data mining), Reporting Services, Excel, PowerPivot and PerformancePoint Services.
Venue: Sydney Mechanics' School Arts |
Duration 12:00 - 14:00 |
On: Wednesday, 2 March 2011