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

Created by: Phillip Burton • 800,000+ students so far
Best Selling Instructor - over 800,000 students so far

Created by: I Do Data Limited
Improve your skills in SQL, Office, Tableau, Power BI + more

What Will I 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 Desktop 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.

Target audience

• 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.