Power Pivot lets you import massive amounts of data from different sources and mash it together to create useful reports. But perhaps you’ve been struggling with it. Or maybe you’d like some tips on how to best work with a data model. Owen Duncan, Senior Content Developer for Power Pivot, will show you the ropes. He’ll walk you through some basics and also teach you some best practices.
What you will learn
- Quick tour of the Power Pivot window
- The difference between implicit and explicit calculated fields
- How to create a calculated column
- How to create a calculated field (also known as a measure)
- How to create a hierarchy
- A quick look at Power View
References for this webinar
- What is Power Pivot? (Microsoft Business Intelligence website)
- How to get Power Pivot (download)
- Starting the Power Pivot add in (how-to)
- The difference between data modeling in Excel versus Power Pivot (how-to)
- Calculations in Power Pivot (how-to)
- Data Analysis Expressions (DAX) in Power Pivot (how-to)
- Hierarchies in Power Pivot (how-to)
- Time Intelligence in Power Pivot in Excel 2013 (how-to)
- Profit and Loss Data Modeling and Analysis with Microsoft PowerPivot in Excel (downloadable white paper)
–Dave Ludwig