Data Modelling and Analysis with Excel Power Pivot(Ian)
Categories:
Skill Productivity tools
Course Info
Curriculum
About Course
Introduction
- Welcome to Power Pivot
- Overview of the Power Pivot Course
- Activating Power Pivot in Excel
- Download the Training Data File
- Loading Data into Power Pivot
- Browse Filter and Sort Power Pivot Data
- PowerPivot Menu Options
- Home Menu Options
- The AutoSum Function in Power Pivot
- Design Menu Options
- The Advanced Menu Option
- Power Pivot Menu in Excel
- Creating Pivot Tables with PowerPivot Data
- Creating Pivot Tables
- Changing the Method of Aggregat...
Introduction
- Welcome to Power Pivot
- Overview of the Power Pivot Course
- Activating Power Pivot in Excel
- Download the Training Data File
- Loading Data into Power Pivot
- Browse Filter and Sort Power Pivot Data
- PowerPivot Menu Options
- Home Menu Options
- The AutoSum Function in Power Pivot
- Design Menu Options
- The Advanced Menu Option
- Power Pivot Menu in Excel
- Creating Pivot Tables with PowerPivot Data
- Creating Pivot Tables
- Changing the Method of Aggregation
- Pivot Table Calculations
- Filtering with Slicers
- Pivot Table Filters and Slicers
- Pivot Table and Pivot Chart
- Creating Hierarchies
- Create Relationships with PowerPivot Data
- Download the Training Data File
- Create Relationships to Master Data
- Create Pivot Tables with Table Relationships
- DAX Calculated Columns
- Download the Training Data Files
- Create Calculated Columns in DAX
- Date Functions in Power Pivot
- Using the Sort By Option
- Download the Date Master File
- Create a Date Table
- Text and Logical Calculated Fields
- Download the Price Increase File
- Creating Related Calculated Formulas
- DAX Measures
- Review of Calculated Measures
- Power Pivot Calculated Fields
- The Calculate Formula
- Date Mesure Examples
- Named Sets and KPIs
- Download the KPI Workbook
- Creating Named Sets
- Creating KPIs
- Conclusion
- Conclusion
About the instructors
Course Curriculum
