PL-300 certification prep: Microsoft Power BI Data Analyst

Learn skills for Microsoft PL-300 certification using the free Power BI Desktop. Power Query, DAX, M. Helps with DP-600

Preview this Course

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, the updated Power BI Service User Interface, and the PL-300 exam updates as of 6 February, 23 April and 21 October 2024.

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 and Analyze the Data)

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

The course will take around 28 hours to complete, but completing this will enable you to create visuals, transform and refine the model, and use the Power BI Service.

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?

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.
No prior experience in reporting tools or creating formulas is required.
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.
This course may not be for you if you have a Mac, as Power BI is not natively installable onto Macs.