Course Overview

PL-300 Microsoft Power BI Certification Training

This course covers the content required for the PL-300 certification exam. It has been updated in line with the March-June 2023 User Interface update for Power BI Desktop on object interaction, the updated Power BI Service User Interface, and the PL-300 exam updates as of 6 February and 23 April 2024.

Power BI is one of the most requested reporting tools that are requested in the job market, and the ability to being able to use it now could be very useful for your current work, and your next job hunt.

Course Structure

This course comes in four parts:

Part 1

Creating Visualizations

(also known as Visualize and Analyze the Data)

We'll download and install the Power BI Desktop. We'll start by creating our first visualizations and investigate the Power BI interface. We'll look at the various visualisations available and go through their common properties. We'll create maps, hierarchies, KPIs, gauges, and all sorts of chart types.

Part 2

Get and Transform Data

(also known as Prepare the Data)

We see how data can be transformed, saving you time in analysing the data. We'll look at sorting and filtering, split columns, and other transform activities. We'll merge, append and combine queries together. We'll Pivot and Unpivot, and transform text, numbers, dates and times, and create custom columns using the M language.

Part 3

Refining the Model

(also known as Model the Data)

We'll see how relationships can be made through multiple tables, and refine the data with custom columns and measures using the DAX language.

Part 4

Power BI Service

We'll then publish our visualisations onto the Power BI Service (which you can sign up for free), and then from your reports create dashboards. With the Power BI Pro (for which you can get a free trial), you can also create workspaces and apps.

Course Details:

Duration: One Month (3 days a week) - Approximately 28 hours
Venue: Virtual, In-person, or Hybrid
Time: To be agreed upon
Delivery Mode: In-person, Virtual (Google Meet)
Special Arrangements: Available for groups of 5+ participants at their preferred venue

What You'll Learn

Power BI Desktop Installation

Download for free and install and run the full version of Power BI Desktop, the BI and analysis software.

Data Visualization Creation

Be able to create analyses, such as line charts, stacked bar charts, or geographic analyses using maps.

Formatting & Animation

You will be able to format numbers and dates, and add labels, tooltips and animation.

Data Transformation

You will be able to Get and Transform multiple sources of data, including merging multiple files from a folder, pivoting and unpivotting.

Model Building

Building and refine models, including adding calculated columns and measures.

M and DAX Functions

You will learn the important M and DAX functions, to enable you to build your own formulas.

Who This Course Is For

This reporting course is meant for anyone who has no prior experience of Power BI. It's also for you if you have used it, but never designed a report.

It's great if you have created analyses in other reporting tools, such as Microsoft Access, WebI, SSRS, Tableau or Yellowfin, but it not essential. If you have, then it will be another string to your bow.

It would also be good if you had prior experience in using Excel formulas, but again, that is not essential.

Requirements:

  • No prior experience in reporting tools or creating formulas is required
  • Basic computer skills including program installation
  • Access to a Windows computer (Power BI is not natively installable on Macs)

Note: This course is probably not for you if you always know how to use Power BI and know how to create reports, although we will be looking at some more advanced topics, including the M and DAX languages.

Certification Benefits

At the end of the course, you can download a certificate of completion, so you can show everyone your new-found skills, and be able to start creating analyses for yourselves. And with a bit of practice, you could also go for the official Microsoft PL-300 exam - wouldn't that certificate look good on your CV or resume?

Course Modules

Module 1: Power BI Fundamentals

Day 1 - 8 hours
  • Power BI ecosystem overview
  • Connecting to data sources
  • Basic data transformation with Power Query
  • Creating your first report

Module 2: Data Modeling & DAX

Day 2 - 8 hours
  • Building data models and relationships
  • Introduction to DAX functions
  • Calculated columns and measures
  • Time intelligence functions

Module 3: Advanced Visualizations

Day 3 - 8 hours
  • Advanced chart types and custom visuals
  • Interactive features and drill-through
  • Report design best practices
  • Mobile-optimized reports

Ready to Create Powerful Business Intelligence Solutions?

Master Power BI and transform the way your organization uses data.

Register Now Call for Details