Alberto Ferrari
sqlbi.com
Alberto started working with SQL Server in 2000 and immediately his interest focused on Business Intelligence. He and Marco Russo created sqlbi.com, where they publish extensive content about Business Intelligence.
SQLBits 2011
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 with PowerPivot.
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.