Power Pivot is an Excel business intelligence tool that allows you to create a data model by connecting multiple tables, enabling you to analyse related information without needing to combine everything into one large table. Using DAX (Data Analysis Expressions) you can create calculated columns, measures and Key Performance Indicators (KPIs) to support more advanced data analysis and reporting.
This half day course will look at:
- Getting Started with Power Pivot in Excel
- Understanding Fact Tables and Dimension Tables
- Creating Relationships Between Tables
Introduction to DAX (Data Analysis Expressions)
- Understanding Calculated Columns and Measures
- Using RELATED to retrieve information from related tables
- Introduction to CALCULATE to modify the filter context of a calculation
- Understanding the difference between calculated columns and measures
Creating and Managing Measures
- Using SUM and SUMX to aggregate data
- Using DIVIDE to calculate ratios and percentages
Understanding and Creating Key Performance Indicators (KPIs)
- Defining Targets and Performance Thresholds
- Using Status Indicators to Monitor Performance
Generating Analysis from Power Pivot Using Pivot Tables and Pivot Charts
For more information, please email info@the-it-trainer.co.uk or call us on 0114 4040 160