Excel: Data Analysis with PowerPivot
PowerPivot Extra Online Resources from Get started with Power Pivot in Microsoft Excel 2013/2016
- Create a memory-efficient Data Model using Excel and the Power Pivot Add-in
- Data Model specification and limits
- Dates in Power Pivot
- Filter Data in DAX Formulas
- Key Performance Indicators (KPIs) in Power Pivot
- Lookups in Power Pivot Formulas
- Time Intelligence in Power Pivot in Excel
- Understand and create date tables in Power Pivot in Excel
Additional Online Resources: