This site uses cookies to store information on your computer. Some are essential to make our site work; others help us improve the user experience. By using the site, you consent to the placement of these cookies. Read our privacy policy to learn more.

Digital skills

Microsoft Power BI - Go Beyond Pivot Tables with Power Pivot Logo aicpa

  $89.00 - 109.00 |   CPE: 4.0 |   AICPA |   12 Feb 2020 |   AICPA Store
Who Will Benefit?
  • Anyone who uses or wants to use Excel for data analysis
Key Topics
  • 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
How will this product help you with the work on your desk?
  • You will learn how to add data to your data model either directly into Power Pivot or from Power Query.

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.

Topics covered:
  • Management accounting: Digital skills: Data analytics, Foundational