Event Detail

Data Analytics and Dashboards Leverage the Power of Microsoft Power BI


Data Analytics and Dashboards

Leverage the Power of Microsoft Power BI (Two Days)

Course Description

Two of the most important skills that every CFO, CPA, or auditor should develop are applying data analytics and creating visual dashboard reporting models. This two-day course will teach you both skills using one of the most popular tools available

When you complete this course, you will have advanced to the top of the profession in your ability to perform powerful data analytics and create engaging dashboards. You will be sought after in your organization as the “go-to” person to tap into these skills to help your management team and colleagues make better business decisions. You will leave with knowledge that will set you apart in you profession.

To optimize your learning experience, we highly recommend that you bring your laptop with the appropriate software installed. Instructions will be provided.


Program Content

The key topics that will be covered in this course:

  • Introduction to Excel Power BI tools
  • Loading data into Power Pivot
  • Using Power Query to clean and transform data
  • Building a data model
  • Creating calculations using DAX functions and formulas
  • Using a date table to create time-intelligent measures
  • Building visuals using Power BI Desktop
  • Publishing data models and visualizations to Power BI Services


Learning Objectives

Upon completing this course, you will …

  • Understand the various PowerBI tools available
  • Know which PowerBI tool to use in various situations
  • Know how to use PowerPivot to take your data analysis to the next level
  • Create measures that weren’t possible in regular PivotTables
  • Analyze date-based data in many new ways
  • Build interactive visuals to present your data analysis


Thorough understanding of PivotTables

Back to Events