Author(s)
Publisher:
AICPA
-
NASBA Field of Study
-
Format
On demand
-
Level
-
CPE Credit
0
-
Course acronym
-
Prerequisites
-
Course duration
4 Hours
Credit Info
Microsoft Power BI – Go Beyond Pivot Tables with Power Pivot
This course focuses on using the Power Pivot features to enhance data analysis. Four features of Power Pivot will be reviewed:
Data model
Calculations
Hierarchies
KPIs
A majority of the course will be spent on building a data model and using calculations. You will learn how to add data to your data model either directly into PowerPivot or from Get & Transform/Power Query.
Data model
Calculations
Hierarchies
KPIs
A majority of the course will be spent on building a data model and using calculations. You will learn how to add data to your data model either directly into PowerPivot or from Get & Transform/Power Query.
Topics discussed
Data Modeling
Basic DAX and calculations
Calculated columns and measures
Data models and pivot tables
Hierarchies
Learning objectives
Create a data model using Power Pivot
Differentiate between calculated columns and measures
Use Power Pivot for data analysis
Who will it benefit?
Anyone who wants to analyze data in Excel
