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: