DA-100 and PL-300 Certification: Analyzing Data with Microsoft Power BI

Back To All Courses

285 Lessons

All

Skill Level

27:11h

course Duration

English

Audio

Eng & Esp

Subtitles

Share This Class:

Overview

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.

The course will take around 24 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.

Completing this course will help you:

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.
You will learn how to use Power BI Public to upload and share dashboards, reports and apps.

Who is the course for?

Before you begin this course, you should have a computer with access to the internet, and be able to install programs. That’s it! The more experience in reporting using other packages including Excel, the better, but it is not essential.

Learning Path

Part 1 – Creating Visualizations

Level 1: Creating and formatting a table visualization

Level 2: Formatting our first visualization

Level 3: Creating different visualizations: Matrices and bar charts

Level 4: Adding more control to your visualizations

Level 5: Other visualizations

Level 6: Mapping

Level 7: Measure performance by using KPIs, gauges and cards

Level 8: Other Visualization Items for the DA-100 exam

Part 2 – Get and Transform Data

Level 1 – Home

Level 2 – Getting Multiple files

Level 3 – Transform Menu

Level 4 – Transform – Text and Numbers

Level 5 – Transform – Dates and Time

Level 6 – Add Columns, View and Help Menus

Level 7 – View and Help menus and advanced functionality

Level 8 – Get other types of data

Level 9 – Other Get and Transform Topics for the DA-100 exam

Part 3 – Refining the model

Level 1 – An introduction to DAX functions, including Logical functions

Level 2 – Statistical functions

Level 3 – Mathematical functions

Level 4 – Text functions

Level 5 – Information Functions

Level 6 – Filter and Value Functions

Level 7 – Time Intelligence Functions

Level 8 – Other Modeling and DAX Topics for the DA-100 exam

Part 4 – Power BI Service

Section 1 – An Introduction to the Power BI Service

Section 2 – Power BI Pro and adding users

Section 3 – Row Level Security

Section 4 – Dashboards

Section 5 – Manage datasets

Section 6 – Create and manage workspaces

Section 7 – Other Power BI Service Topics

What people are saying

“It is a great experience!! Each and every detail is covered in this course, I am sure this would help me cracking the certification. Keep up the good work!!”
Swapneel
“Just cleared my DA-100 exam on first attempt. Although I was following some content with exam prep questions also as supplementary materials to get acquainted with the exam, this course was definitely the base of my knowledge in Power BI, and undoubtedly the best content regarding DA-100 that’s available on the net. Thanks Phillip!”
Ivan
“There is no DA-100 courses in the market that covers the content like Philip. He goes beyond and above. He pretty much goes though every single button in PBI desktop and services and show practical scenarios that will help you prepare for the exam. Highly recommend.”
Pedro
“Absolutely the BEST course if you are a beginner and planning to eventually take the DA-100 test. Love the step by step approach and the ability to test your knowledge with the practices. Definitely highly recommend!”
Janet
Previous
Next