![Complete Introduction to Excel Power Pivot [2023 Edition]](https://res.cloudinary.com/db194k5td/image/upload/v1680014706/profilepictures/trtrbmocu0f5bzt5uboe.jpg)
Share Description
In this course, you will learn :
- Quickly learn to use Power Pivot in Excel for powerful data analysis
- Work with millions of rows of data, create relationships between tables and learn the DAX formula language
- Have a COMPREHENSIVE understanding of creating data models in Excel
- Create calculated fields and calculated measures using DAX in Excel
- Perform SOPHISTICATED calculations such as Time Intelligence, Filtered Data and Segmentation
- Create RELATIONSHIPS between tables of data
- Analyze data using Pivot Tables and Pivot Charts
Syllabus :
- Power Pivot and the Data Model
- Power Pivot and Pivot Tables
- Calculated Columns
- Measures in the Data Model
- Time Intelligence Measures
- Additional Measures
- Case Studies
- Relationships
- Sets and KPIs
