Data preparation: Introduction to Power BI
Microsoft Power BI is an excellent tool for building effective dashboards. Discover the key concepts you need to create data visualizations that communicate meaningful strategic information with your audience.
After transforming raw data into a workable format, the next step is disseminating that refined data throughout your organization. One of the most effective ways to do this is by creating custom dashboards.
Microsoft’s analytics platform, Power BI, can be used to develop high impact data visualizations. In this course, you will learn how to use Power BI to make dashboards that express meaningful, easy-to-understand, evidence-based insights – ideal for strategic presentations to senior management.
Note: This course can be taken individually or as part of the Data Management Foundations Certificate.
- dashboarding techniques
- introduction to Power BI
- how to access and transform data into model-ready formats
- Power Pivot data modelling
- formulas to aggregate KPI values from data models
- controllers
- financial analysts
- business professionals
- senior accountants
- IT professionals
- consultants
- business intelligence educators
+
CPA Canada recommends that you be familiar with the concepts covered in Data Preparation: Cleansing, Modelling and Dashboards prior to enrollment.
Minimum software requirements:
- PC (not all functions noted in the course for Excel, Power Query, Power Pivot and Power BI may not be compatible with iOS devices)
- Power BI
- Microsoft Excel 2013 or higher
- Microsoft Power Query for Excel (free download for Excel 2013, built-in for higher versions)
- Power Pivot for Excel (Excel add-on)
