Power BI · Course on Udemy

Build interactive Power BI reports, from your first dashboard to DAX

Connect your data, clean it with Power Query, model it and write DAX measures, with real projects including a budget versus actual dashboard.

★ 4.6 from 365 ratings on Udemy · 96 lessons · 9 hours

Enroll on Udemy →Watch a free lesson first

30-day refund through Udemy · Lifetime access · Certificate of completion

Watch the course trailer (3:39)

Is this course for you?

Power BI turns spreadsheets into reports people can explore on their own.

You will get the most from it if you…

build reports in Excel and want something more interactive
need to combine data from Excel, CSV files, the web or databases
are new to Power BI or have only tried it briefly
want to understand DAX, not just copy formulas

By the end you will be able to…

connect to Excel, CSV, web, database and Dataverse sources
clean, unpivot, append and merge data in Power Query
build a data model with relationships and a calendar table
write DAX measures with SUMX, DIVIDE, CALCULATE and SWITCH
design reports with slicers, filters and Q&A, and publish them

Prefer to start inside Excel? See the Power Query, Power Pivot & DAX course.

Projects you will build

Practice on real data sets, not just slides.

01US population analysisA Power Query project

02Sales dashboardCombining and merging data

03DAX understandingA six-part project

04Story-telling with Power BIA two-part demo

05Budget vs actual dashboardThe milestone project

What is inside

Four parts, from installing Power BI Desktop to a complete milestone project.

1. Getting started and data sources

A tour of Power BI and its tools, installing Power BI Desktop, a lesson on preparing for the Microsoft PL-300 exam, and connecting to Excel, CSV, web, database and Dataverse sources, including DirectQuery and Import modes.

2. Your first dashboard and Power Query

Designing a first dashboard with charts, interactions and drill-down, then shaping, unpivoting, appending and merging data in Power Query.

3. Reports and the data model

Formatting visuals, cards, tables and matrices, conditional formatting, slicers and filters, Q&A, publishing from Power BI Desktop, and the basics of data modelling and relationships.

4. DAX and the milestone project

Measures and calculated columns, COUNTROWS, DISTINCTCOUNT, SUMX, DIVIDE, date functions, CALCULATE and SWITCH, then a complete budget versus actual dashboard.

What students say

Reviews from students of this course on Udemy.

“Great flow of the lesson! I love how you take your time explaining things in a way that helps the student apply this lesson to their own knowledge. The teaching style is "Elite" keep up the great work sir!”Scott F.

“This was a great course that allowed me to learn at my own pace. The lessons were clear and easy to follow along with.”Oscar

“The way he connects with his audience is just extraordinary, he teaches you in a funny way that you always want to learn”Onos

What is included

96 video lessons, 9 hours
Course resources and project files
Lifetime access on any device, including the Udemy app for offline viewing
Certificate of completion
A Q&A section on every lesson
30-day refund through Udemy

Your instructor

Andreas Exadaktylos, MSc in Computer Science, has taught Excel for over 25 years and runs Mellon Training.

More than 80,000 students have taken his courses on Udemy. He also publishes free Excel tutorials on YouTube and on this site.

Questions before you start

Anything else? Write to info@mellontraining.com.

Do I need Power BI experience?

No. The course starts with installing Power BI Desktop. Being comfortable with Excel helps.

Do I need a paid Power BI licence?

Power BI Desktop is a free download from Microsoft, and you can build everything in the course with it. Sharing reports online can need a Power BI licence.

Does it work on a Mac?

Power BI Desktop runs on Windows only. On a Mac you would need a Windows virtual machine.

Where is the course hosted?

On Udemy. You buy and watch it there, keep it for life, and can learn offline in the Udemy app.

What if it is not right for me?

Udemy offers a refund within 30 days of purchase, under its refund policy.

Can I see a lesson before I buy?

Yes. Watch the free Power BI tutorial for beginners on YouTube, or the preview lessons on the Udemy course page.

Ready to build your first Power BI report?

96 lessons and five projects, from your first dashboard to DAX.

Enroll on Udemy →