Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

Data Modelling and Analysis with Excel Power Pivot

Video Introducing this tutorial


Introduction :
Welcome to Analyze Data with Power Pivot
Overview of Power Pivot Course
Activating Power Pivot in Excel
Download the Training Data File
Loading Data into PowerPivot
Browse, Filter and Sort PowerPivot Data

PowerPivot Menu Options :
Home Menu Options
The AutoSum Function in Power Pivot
Design Menu Options
The Advanced Menu Option
PowerPivot Menu in Excel

Creating Pivot Tables with PowerPivot Data :
Creating PivotTables
Changing the Method of Calculation
Pivot Table Calculations

Filtering with Slicers :
PivotTable Filters and Slicers
Filtering PivotTables and PivotCharts
Creating Hierarchies

Create Relationships with PowerPivot Data :
Download the Training Data Files
Create Relationships to Master Data
Create PivotTables with Table Relationships

DAX Calculated Columns :
Download the Training Data
Create Calculated Columns in DAX
Date Functions in PowerPivot
Using the Sort By Option
Download the Date Master File
Create a Date Table
Text and Logical Calculated Fields
Download the Price Increase Excel file
Creating Related Calculated Formulas

DAX Measures :
Review of Calculated Measures
Power Pivot Calculated Fields
The Calculate Formula
Date Measure Examples

Named Sets and KPIs :
Download the KPI Workbook
Creating Named Sets
Creating KPIs

Conclusion :
Conclusion

You Have Got Gift 25% OFF

Use this Coupon Code “J3JKN396