Level

Intermediate

Duration

3 days

Competency

Data Analyst

Product

Power BI

Overview

In this course, the student will learn how to implement and manage data engineering workloads on Microsoft Azure, using Azure services such as Azure Synapse Analytics, Azure Data Lake Storage Gen2, Azure Stream Analytics, Azure Databricks, and others. The course focuses on common data engineering tasks such as orchestrating data transfer and transformation pipelines, working with data files in a data lake, creating and loading relational data warehouses, capturing and aggregating streams of real-time data, and tracking data assets and lineage.

This course prepares you to take the Microsoft Power BI Data Analyst (PL-300) exam to achieve the Microsoft Certified: Power BI Data Analyst Associate certification.

Who is this course for?

The primary audience for this course is data professionals, data architects, and business intelligence professionals who want to learn about data engineering and building analytical solutions using data platform technologies that exist on Microsoft Azure. The secondary audience for this course includes data analysts and data scientists who work with analytical solutions built on Microsoft Azure.

Course Syllabus

  • Getting Started with Microsoft Data Analytics
  • Getting Data in Power BI
  • Cleaning, Transforming, and Loading Data in Power BI
  • Design a Data Model in Power BI
  • Create Model Calculations using DAX in Power BI
  • Optimise Model Performance in Power BI
  • Create Reports in Power BI
  • Perform Data Analysis in Power BI
  • Create and Manage Workspaces in Power BI
  • Manage Files and Datasets in Power BI
  • Create Dashboards in Power BI
  • Row-level Security in Power BI

What Our Trainees Say

Start your learning journey!

Use the form below to get in touch and we'll contact you to discuss your training requirements.