bestcourses is supported by learners. When you buy through links on our website, we may earn an affiliate commission. Learn more

DA-100, PL-300 certification Analyzing Data with MS Power BI

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

4.62 / 5.0
41021 students27 hours 55 minutes

Created by Phillip Burton, offered on Udemy

bestcourses score™

Student feedback

8.8/10

To make sure that we score courses properly, we pay a lot of attention to the reviews students leave on courses and how many students are taking a course in the first place. This course has a total of 41021 students which left 8617 reviews at an average rating of 4.62. Impressive!

Course length

8.8/10

We analyze course length to see if courses cover all important aspects of a topic, taking into account how long the course is compared to the category average. This course has a length of 27 hours 55 minutes, which is pretty short. This might not be a bad thing, but we've found that longer courses are often more detailed & comprehensive. The average course length for this entire category is 4 hours 29 minutes.

Overall score

8.8/10

This course currently has a bestcourses score of 8.8/10, which makes it a great course to learn from. On our entire platform, only 15% of courses achieve this rating!

Description

This course covers the content required for the DA-100 certification exam, current as per the DA-100 exam update of 23 November 2021. The DA-100 exam will be retired on 31 March 2022. However, the PL-300 exam, which has virtually the same requirements, will be offered from 28 February 2022.


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 27 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 DA-100 or PL-300 exam - wouldn’t that certificate look good on your CV or resume? And if you are an American college student, you might even get college credit for passing that exam (DA-100 only).

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.

Requirements

  • Before you begin this course, you should have a computer with access to the internet, and be able to install Windows programs.
  • You will need Windows 8.1, 10 or 11 or Windows Server 2012 R2 or later, to install the Power BI program.
  • That's it! The more experience in reporting using other packages including Excel, the better, but it is not essential.
  • If you have a Mac, then you will need to be able to either dual-boot into Windows, or use Parallel Desktop boot into Windows. However, Mac users can use the Power BI Service, and be able to do most of Part 1 and Part 4 of this course.
Udemy logo
Available on

Udemy

With almost 200,000 courses and close to 50 million students, Udemy is one of the most visited online learning platforms. Popular topics include software development, the digital economy, but also more traditional topics like cooking and music.

Frequently asked questions

  • Price: $139.99
  • Platform: Udemy
  • Language: English
  • 27 hours 55 minutes
DA-100, PL-300 certification Analyzing Data with MS Power BI thumbnail

bestcourses score: 8.8/10

This course is better than many others in its category.