Power BI Data Analyst (PL300)

OVERVIEW

This official Microsoft Power BI training course will teach you how to connect to data from many sources, clean and transform it using Power Query, create a data model consisting of multiple tables connected with relationships and build visualisations and reports to show the patterns in the data.

The course will explore formulas created using the DAX language, including the use of advanced date intelligence calculations. Additional visualisation features including interactivity between the elements of a report page are covered as well as parameters and row-level security, which allows a report to be tailored according to who is viewing it. The course will also show how to publish reports and dashboards to a workspace on the Power BI Service.

COURSE BENEFITS:

• Learn how to clean, transform, and load data from many sources
• Use database queries in Power Query to combine tables using append and merge
• Create and manage a data model in Power BI consisting of multiple tables connected with relationships
• Build Measures and other calculations in the DAX language to plot in reports
• Manage advanced time calculations using date tables
• Optimise report calculations using the Performance Analyzer
• Manage and share report assets to the Power BI Service
• Prepare for the official Microsoft PL-300 exam using Microsoft Official Courseware

WHO IS THE COURSE FOR?

• Data Analysts with little or no experience of Power BI who wish to upgrade their knowledge to include Business Intelligence
• Management Consultants who need to conduct rapid analysis of their clients’ data to answer specific business questions
• Analysts who need to upgrade their organisation from a simple Excel or SQL-based management reporting system to a dynamic BI system
• Data Analysts who wish to develop organisation-wide reporting in the form of web reports or phone apps
• Marketers in data-intensive organisations who wish to build visually appealing, dynamic charts for their stakeholders to use

COURSE OUTLINE