PowerPivot Advanced Data Modeling

During this session we are going to analyze common business problems that require and advanced usage of DAX functions and data modeling. Examples include banding of price in ranges, advanced simulation with the usage of many-to-many relationships, usage of dynamic sets in PowerPivot and many other examples, all taken from common budgeting problems. This session is based on part of the book Microsoft PowerPivot for Excel 2010:Give Your Data Meaning, written by the speaker.
Presented by Alberto Ferrari at SQLBits VIII
  • Downloads
  • SpeakerBIO
    Alberto Ferrari is a Business Intelligence consultant. Alberto helped several software houses to build complex BI solutions, from the OLTP to the final OLAP cubes, providing planning hints all over the development lifecycle. He is a book author also, having worked on "Exper Cube Development with Microsoft SQL Server 2008" with Marco Russo and Chris Webb and Microsoft PowerPivot for Excel 2010: Give Your Data Meaning with Marco Russo.
    http://sqlblog.com/blogs/alberto_ferrari/default.aspx http://sqlblog.com/blogs/alberto_ferrari/rss.aspx
  • Video