BI from space: PowerPivot with NASA data
PowerPivot, while being an Excel add-in, was built by the SQL team, and is one of the most powerful data integration tools in the Microsoft stack. In this session, you will learn how to combine data from web services, tables and cubes to build a powerful model, and visualise it in Excel. An introduction to Time Intelligence using DAX will lead us on to the new features in version 2, and we will move from the Date table to relationships, perspectives and KPIs.
You will also see the difference between developing in the Excel addin vs Visual Studio.
(no tags)
- Downloads
- SpeakerBIO
Mark founded Pragmatic Works South Africa, and his technical role is Business Intelligence & Information Management architect specialising in the Microsoft platform. His credentials include publishing the first Sharepoint 2010 BI book and representing Microsoft at the launch events of the version of SQL Server in EMEA.
Mark participates widely in the SQL and Sharepoint communities, having founded a BI user group, and assisting with SQL and Sharepoint saturdays, as well as being a frequent presence on the #SQLHelp and #SPHelp hashtags on twitter (@MarkGStacey)
- Video
The video is not available to view online.
- Session Files Explorer
Could not find a part of the path '\\sqlbits01\DENALI\SQLBitsFiles\'.