Microsoft Power BI - Go Beyond Pivot Tables with Power Pivot
Available Anytime
Location:
Online
4Credits
Technical Business
Registration is Open
FICPA Members
Nonmembers
$109.00 Regular Price
Product Code: AI23-PWRBI6
Level: Overview
Vendor: AICPA CPE Division
Field of Study: Computer Software and Applications
Overview:
Take the next step with Power Pivot!
This is the sixth course in the Microsoft Power BI series. 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.
This self-study online course is part of the Microsoft Power BI: Power BI Series.
Objectives:
Learning Outcomes
- Create a data model using Power Pivot
- Differentiate between calculated columns and measures
- Use Power Pivot for data analysis
Major Topics:
Key Topics
- Data modeling
- Basic DAX and calculations
- Calculated columns and measures
- Data models and pivot tables
- Hierarchies