PL-300 certification: Microsoft Power BI Data Analyst

Learn skills for Microsoft PL-300 certification using the free Power BI Desktop. Power Query, DAX, M, more. (Was DA-100)

4.56 (22041 reviews)
Udemy
platform
English
language
IT Certification
category
instructor
113,711
students
29 hours
content
Mar 2024
last update
$99.99
regular price

What you will learn

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

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

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

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

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

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

Description

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, and the PL-300 exam updates as of 27 October 2023.


What do students like you say about this course?

Girma says: "This is another great course taught by the instructor – well-paced, every important aspects of Power BI are discussed in detail. I gained the real power of Power BI in this course."

Mohan says: "Another Excellent course by Mr Burton. This course can be used as a refresher , manual reference to review, understand and use Power BI tools efficiently. Explanations are very clear and crisp. Can help from Beginner to Intermediate level learning."

Andrew says: "I took a similar Power BI course through my work and I think this one is better. Highly recommend this training. I am a Lead ERP Financial Systems Analyst who worked mostly with Oracle BI tools. Company wants to go in a different direction so I am learning Power BI."



Do you already use reporting software such as Access, SSRS, Tableau or WebI? Or is this your first reporting software tool? Either way, welcome.

In this course, learn the skills that Microsoft want you to know, and add another tool to your CV, and even go for the Microsoft Power BI certification.

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.

This course comes in four parts:

Part 1 - Creating Visualizations (also known as Visualize the Data, and Analyze the Data)

We'll download and install for free Power BI Desktop. We'll start by creating our first visualizations (vizzes) 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, guages, 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.

The course will take around 28 hours to complete, but completing this will enable you to create vizzes, dashboards and stories of your own, and know how to overcome common problems.

The course increases in difficulty slowly, so you'll create for instance a table or basic bar chart, then turn it into a stacked bar chart, and investigate more of their properties, step by step.

The course is fairly relaxed - there will be a few "wrong turns", so you can see what problems might arise, but every lesson works towards an end goal at a relatively slow pace, so you can follow on your own computer easily. I assume that you know how to use a computer, including installing programs, but the actual analysis will be at a basic level, and I'll introduce every component as we go on.

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?

Content

Introduction

Introduction
Welcome to Udemy
What are we going to learn?
Installing Power BI Desktop
Resources

Level 1: Creating and formatting a table visualization

Viewing data
1b. Importing from Excel, and Creating our first visualization
Focus mode and Different visualizations
10b. Saving visualization to the Desktop and to the Power BI service
Practice Activity Number 1
Practice Activity Number 1 - The Solution

Level 2: Formatting our first visualization

Formatting font and font size
Formatting colors
Stylistic options
8g. Position visuals
8g. Align visuals
8f. Configuring summarization, both default and in a specific visualization
8i. Changing number and date formatting
Practice Activity Number 2
Practice Activity Number 2 - The Solution

Level 3: 8a. Creating different visualizations: Matrices and bar charts

Matrix
Drill down data, see data and records, and export data
Stacked bar charts and 8j. switch theme for reports
Bar Chart formatting
8c. Configure interactions between visual (Edit interactions)
Clustered and 100% Stacked bar charts
Line and area charts, including 8b. Configure duplicate pages
Combo charts (Line and column charts)
Practice Activity Number 3
Practice Activity Number 3 - The Solution

Level 4: Adding more control to your visualizations

11a. Adding Text boxes, Images and Shapes
11b. Visual level, page level and report level filters - basic filters
Advanced Filtering
Filter Top N Items
Slicer
Slicer Warning
8g. Sort visuals
8j. Use Bookmarks for reports
Drillthrough
Buttons and Actions
11e. Enable Natural Language Queries (Ask A Question)
Practice Activity Number 4
Practice Activity Number 4 - The Solution

Level 5: 8a. Other visualizations

Ribbon charts
Waterfall charts
Scatter, bubble and dot charts
Pie charts and donut charts
Treemaps
Funnel charts
Adding Marketplace visualizations
Practice Activity Number 5
Practice Activity Number 5 - The Solution

Mapping

Maps
Formatting maps
8g. Adding Data Categories
Filled Maps,Conditional Formatting, and color blindness
Creating hierarchies
ArcGIS Maps for Power BI
Practice Activity Number 6
Practice Activity Number 6 - The Solution

6. Measure performance by using KPIs, gauges and cards

Gauges
Cards and Multi-row cards
More conditional formatting
KPIs
Practice Activity Number 7
Practice Activity Number 7 - The Solution

Part 2 - Get and Transform Data - Home Part 1

Introduction - let's Get some more Data
Exploring the Power Query Editor interface
Introducing the M language
Let's start look at the Home tab
Home menu - Manage Columns
Home menu - Reduce Rows and Use First Row as Headers
Practice Activity Number 8

Get Data - Home Part 2

Sort and Filter
Split Column
Other Transform activities
Practice Activity Number 9

Getting Multiple files - Don't forget to create Visualizations.

Merge Queries and Expand Table
Merge Queries with Group By, and different types of Joins
Appending two queries together
Appending three or more queries together + resolving a problem with data types
Combine Files (getting information from a folder)
Practice Activity Number 10

Transform Menu

Transform - Table and Any Column
Pivot Column
Unpivot
Practice Activity Number 11
Practice Activity 11 - The Solution
Unpivot in conjunction with other Transform features
Practice Activity Number 12
Practice Activity 12 - The Solution

Transform - Text and Numbers

Transform/Add Column - Text - Format
Transform/Add Column - Text - Merge Columns
Transform/Add Column - Text - Extract
Transform/Add Column - Text - Parse
Transform/Add Column - Number Column - Statistics and Standard
Transform/Add Column - Other Number Column functions
Practice Activity Number 13

Transform - Dates and Time

Creating a list of dates
Transform/Add Column - Date
Transform/Add Column - Dates in other cultures/languages
Transform/Add Column - Time
Transform/Add column - Duration
Practice Activity Number 14
Practice Activity Number 14 - The Solution

Add Columns, View and Help Menus

Column from examples
Conditional Column
Resolving Errors from Conditional Columns
Index Column and Duplicate Column
Custom Column - If Then Else
Practice Activity Number 15

View and Help menus and advanced functionality

Other M Functions
View and Help menus
Advanced Editor
Functions and Parameters
DateTimeZone date type and Functions
Worked Practice Activity 16 - Dividing Annual data into Months

Get other types of data

Introduction to SQL Server
Importing database data into Power BI, and Query Folding
Expanding multiple tables in SQL Server
Importing data from SQL Server Analysis Services (SSAS)
Setting up Azure SQL Database
Using Azure SQL Database in Power BI
Using Big Data

An introduction to DAX functions, including Logical functions

Get multiple data sets, and connecting them together
The problems with direction of relationships between data sets
DAX functions - A useful Resource
Calculated columns - an introduction
Basic operators
IF, BLANK and ISBLANK
AND, OR and NOT
SWITCH
Other functions

Statistical functions

Measures - an introduction, with standard aggregations including Countblank
Aggregation of calculations
Other statistical functions

Mathematical functions

Introduction to mathematical functions
Rounding functions
Division functions - MOD and QUOTIENT
SIGN (and use with SWITCH) and ABS
Exponential functions
Other functions

Text functions

Text searching
Text extraction and substitution
Text conversion
Other functions

Information Functions

ISERROR and LOOKUPVALUE
Other functions

Filter and Value Functions

RELATED
RELATEDTABLE and COUNTROWS
Context
ALL
FILTER
CALCULATE
ALLEXCEPT
ALLSELECTED
Other functions

Time Intelligence Functions

Date and Time Functions
FIRSTDATE, LASTDATE
Start of... and End of...
Previous... and Next...
DATESINPERIOD
DATESMTD, DATESQTD, DATESYTD, TOTALMTD, TOTALQTD, TOTALYTD
Opening Balance and Closing Balance
SAMEPERIODLASTYEAR and PARALLELPERIOD
Other Time Intelligence Functions

Well done

Congratulations for finishing the course!

Screenshots

PL-300 certification: Microsoft Power BI Data Analyst - Screenshot_01PL-300 certification: Microsoft Power BI Data Analyst - Screenshot_02PL-300 certification: Microsoft Power BI Data Analyst - Screenshot_03PL-300 certification: Microsoft Power BI Data Analyst - Screenshot_04

Reviews

Rimple
November 15, 2023
I passed my Pl-300 exam today. This was the course where I started learning two months back. It's very detailed and topics are covered deeply for better understanding. Philip does a great job in making learning process easier. Thanks!
Sabine
November 15, 2023
Easy to follow along, but lessons may be more compact. There are too many examples and repetitions, which can feel slow.
Rövşən
November 4, 2023
Instructor explains things and repeats himself to the extent that it is time consuming and irritating
Stylianos
November 2, 2023
Its a 10 out of 10 course that i have already forwarded to the company that i work for. I haven't done the certification yet, but this particular one covers the most (based on my experience working with PowerBI as a professional so far) WELL DONE !
Jaime
November 2, 2023
By far the best Power BI course of this platform, the instructor is excellent and I will definitely follow more of his courses.
Elise
October 29, 2023
Power BI is a very complex software. It doesn't help that it is constantly changing too. But the instructor manages to navigate through these complexities and changes very well. This benefits the student.
Abhishek
October 24, 2023
Hi, I have been working on Power BI for the past 2 years but don't have a certification and am using this amazing course to prepare for my PL-300. I don't know how to contact you so I am mentioning this in my review. There is an easier way to get the middle name in the Practice Activity 13. After you get the middle and last name column select "Text Before Delimiter" set the Delimiter as space and in the advanced options select "From the end of input" and the Number of delimiters to skip as "0". Click ok and you get the middle name without having to do so many additional steps.
Leyvi
October 22, 2023
So far, I'm enjoying the course. The course is well structured, and the teacher is thorough with his explanations and seems to be super knowledgeable.
Kurinji
October 4, 2023
This is my first time about Udemy and my first course for my pl-300 exam. I feel it is above my expectations" the concepts are clear and the explanations are amazing".Hopefully i will crack the exam.
DIRK
September 10, 2023
really great and comprehensive course on the topic that covers pretty much everything. Very good presented
Santiago
September 6, 2023
This course has been great so far. I reviewed some of the resources available on Microsoft Learn but it is not as detailed as this course, also this course allows me to practice what I learn in every video. Awesome!
Murad
September 5, 2023
The course was very detailed and covered the PL-300 exam but Microsoft updates Power BI frequently. That's why in some videos the interface of Power BI was different, especially in Power BI Service. it must be replaced with new videos. Additionally, It would be great to make practice activities in the Power BI service.
Sarika
September 5, 2023
yeah it matched to my requirement and was enhancing to my search for the information pertaining to power BI
Bryan
September 4, 2023
This is an excellent course and I've learned a ton. But I'd HIGHLY suggest the instructors not use load mechanical keyboards when recording. This course's instructor uses an extremely distracting keyboard that is VERY load. It's hard to focus with all that clacking.
Carrie
September 4, 2023
Great so far. Video sections are broken up well into thorough but manageable chunks. The instructor is also good about pointing out some of Power BI's quirks and providing extra tips and warnings for scenarios that could come up.

Coupons

DateDiscountStatus
8/19/202285% OFF
expired
3/28/202390% OFF
expired

Charts

Price

PL-300 certification: Microsoft Power BI Data Analyst - Price chart

Rating

PL-300 certification: Microsoft Power BI Data Analyst - Ratings chart

Enrollment distribution

PL-300 certification: Microsoft Power BI Data Analyst - Distribution chart
2265622
udemy ID
3/11/2019
course created date
2/7/2020
course indexed date
Bot
course submited by