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.