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.
Mark Stacey founded the Aphelion Software Group, and works tirelessly to cross the business / technical boundaries in Business Intelligence, working in both SharePoint and SQL.
He has published 2 books on BI - Sharepoint 2010 BI and Visual Intelligence and frequently speaks at both SQL Saturday and SharePoint Saturday events.
He is one of the few Microsoft PDW trainers, and has trained in Africa, India and Europe on the PDW, as well as all over the world on other technologies