Disclosure: when you buy through links on our site, we may earn an affiliate commission.

DA-100 certification: Analyzing Data with Microsoft Power BI

Learn skills for Microsoft DA-100 certification using the free Power BI Desktop. Learn Power Query, DAX, M and more.
4.6
4.6/5
(6,146 reviews)
28,814 students
Created by

10.0

CourseMarks Score®

10.0

Freshness

9.5

Feedback

10.0

Content

Platform: Udemy
Video: 27h 11m
Language: English
Next start: On Demand

Top Microsoft Certification courses:

Detailed Analysis

CourseMarks Score®

10.0 / 10

CourseMarks Score® helps students to find the best classes. We aggregate 18 factors, including freshness, student feedback and content diversity.

Freshness Score

10.0 / 10
This course was last updated on 11/2021 .

Course content can become outdated quite quickly. After analysing 71,530 courses, we found that the highest rated courses are updated every year. If a course has not been updated for more than 2 years, you should carefully evaluate the course before enrolling.

Student Feedback

9.5 / 10
We analyzed factors such as the rating (4.6/5) and the ratio between the number of reviews and the number of students, which is a great signal of student commitment.

New courses are hard to evaluate because there are no or just a few student ratings, but Student Feedback Score helps you find great courses even with fewer reviews.

Content Score

10.0 / 10
Video Score: 10.0 / 10
The course includes 27h 11m video content. Courses with more videos usually have a higher average rating. We have found that the sweet spot is 16 hours of video, which is long enough to teach a topic comprehensively, but not overwhelming. Courses over 16 hours of video gets the maximum score.
The average video length is 12 hours 42 minutes of 1093 Microsoft Certification courses on Udemy.
Detail Score: 10.0 / 10

The top online course contains a detailed description of the course, what you will learn and also a detailed description about the instructor.

Extra Content Score: 9.9 / 10

Tests, exercises, articles and other resources help students to better understand and deepen their understanding of the topic.

This course contains:

29 articles.
22 resources.
0 exercise.
0 test.

Table of contents

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.

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

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 programs.That’s it! The more experience in reporting using other packages including Excel, the better, but it is not essential.

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.

How much does the DA-100 certification: Analyzing Data with Microsoft Power BI course cost? Is it worth it?

The course costs $14.99. And currently there is a 83% discount on the original price of the course, which was $89.99. So you save $75 if you enroll the course now.
The average price is $17.6 of 1093 Microsoft Certification courses on Udemy.

Does the DA-100 certification: Analyzing Data with Microsoft Power BI course have a money back guarantee or refund policy?

YES, DA-100 certification: Analyzing Data with Microsoft Power BI has a 30-day money back guarantee. The 30-day refund policy is designed to allow students to study without risk.

Are there any SCHOLARSHIPS for this course?

Currently we could not find a scholarship for the DA-100 certification: Analyzing Data with Microsoft Power BI course, but there is a $75 discount from the original price ($89.99). So the current price is just $14.99.

Who is the instructor? Is Phillip Burton a SCAM or a TRUSTED instructor?

Phillip Burton has created 48 courses that got 59,777 reviews which are generally positive. Phillip Burton has taught 380,554 students and received a 4.5 average review out of 59,777 reviews. Depending on the information available, Phillip Burton is a TRUSTED instructor.
Best Selling Instructor – over 350,000 students so far
Phillip is a Computing Consultant providing expert services in the development of computer systems and data analysis. He is a Microsoft Certified Technology Specialist. He has also been certified as a Microsoft Certified Solutions Expert for Business Intelligence, Microsoft Office 2010 Master, and as a Microsoft Project 2013 Specialist.

He enjoys investigating data, which allows him to maintain up to date and pro-active systems to help control and monitor day-to-day activities. He has also developed expertise and programmes to catalogue and process and control electronic data, large quantities of paper or electronic data for structured analysis and investigation.

He is one of 9 award winning Experts for Experts Exchange’s 11th Annual Expert Awards and was one of Expert Exchange’s top 10 experts for the first quarter of year 2015.

His interests are working with data, including Microsoft Excel, Access and SQL Server.

10.0

CourseMarks Score®

10.0

Freshness

9.5

Feedback

10.0

Content

Platform: Udemy
Video: 27h 11m
Language: English
Next start: On Demand

Students are also interested in

Review widget (for course creators):

DA-100 certification: Analyzing Data with Microsoft Power BI rating
Code for the widget (just copy and paste it to your site):
<a href="https://coursemarks.com/course/70-778-da-100-analyzing-and-visualizing-data-with-power-bi/" target="_blank" title="DA-100 certification: Analyzing Data with Microsoft Power BI on Coursemarks.com"><img border="0" src="https://coursemarks.com/widget/100.svg" width="200px" alt="DA-100 certification: Analyzing Data with Microsoft Power BI rating"/></a>