Please note that this website will be temporarily unavailable during the period 5:00 PM PST on Friday, Dec. 19 and 11:59 PM PST on Saturday, Dec. 20 due to a planned server migration. PASS apologizes for any inconvenience.

PowerPivot Data Modeling Techniques

SPEAKER: Susan O'Connell, Principal Architect & Director, RevGen

PowerPivot enables an Excel user to combine data from various sources, quickly perform information analysis, and share insights. Understanding how to combine and organize this data can be critical to getting the correct results and successfully sharing your data model and insights with other users. In this 24 Hours of PASS session, we'll discuss PowerPivot data modeling concepts as well as tips and tricks to get the best information results for your users. Throughout the session, we'll explore how to mash up data, create relationships, calculate new columns, create KPIs, and define hierarchies.


To access your 24 Hours of PASS session recording, please provide the following: