How to Build Power BI Reports from Start to Finish

In this video you will learn how to create two interactive Power BI dashboards, plus a decomposition tree using the free Power BI tools available to everyone.

🎓 LEARN MORE

🔔 SUBSCRIBE if you’d like more tips and tutorials like this.

💬 Please leave me a COMMENT. I read them all!

🎁 SHARE this video and spread the Excel love.

Or if you’re short of time, please click the 👍

⏲ TIMESTAMPS
0:00 Introduction
0:27 What is Power BI
1:16 Data Overview
2:33 Get Data with Power Query
7:15 Set up Relationships
8:34 Calendar Table
11:03 Set Formatting & Data Categories
12:04 Gauge Chart
12:45 KPI
13:54 Line Chart
14:44 Running Total Measures
16:14 Area Chart
17:05 Quick Measures
18:28 Clustered Column & Line Combo Chart
19:24 Clustered Bar Charts
22:12 Slicer
22:30 Dynamic Card for Period
23:45 Color Theme
24:58 Cross Filter & Highlight
25:11 Explain the Increase/Decrease
26:01 Regions Report - Clustered Bar Chart
26:44 Clustered Bar Chart
26:57 Matrix Tables
28:44 Filled Map
29:25 Scatter Chart
30:24 Decomposition Tree
32:55 Publishing Reports
35:49 Q&A Tool
36:18 Sharing Reports
37:16 Updating Reports
39:00 Summary
40:30 File Download Link

#powerbi #dashboards #reports

[bluesage]

Amazing as all your tutorials! So clear, no extra words or confusing extra mouse movements, everything to the point, clean and crispy. I think you are the best teacher in your field.

[TA-DV]

One of the best tutorials I've watched so far. Love presentation approach, zooming in, focusing on the elements and adding the extra notes to make it perfect. Well done! & THANK YOU! Subscribed :)

[wayneedmondson]

Hi Mynda. Looks like a great training. Looking forward to walking through it in depth with the data files. Thanks for sharing. Thumbs up!!

[jegareis]

This is amazing. So simple to follow and execute, even with what I’d characterize as moderate (at best) Excel skills. Thank you!

[SohairChauhan]

Hi Mynda, I am a beginner and this is the most comprehensive Power BI tutorial I have seen. The way you teach really simple to follow, you make it look very easy. I would really appreciate if you can guide me to a tutorial regarding preparing / structuring / formatting your excel sheets / CSV files to import in PBI. Also I would love to see a tutorial apart from sales, budgeting or forecasts, like a online survey result where there are no dates involved (it would be a great help).
Thank you very very much for this tutorial !!!

[rodionpopescu]

Mynda, I can't stop marveling about your presentation skills and the way you deliver these lessons to audience. Amazing job and appreciate all your effort !! Worth to highlight!!

[bobthorp]

Thanks Mynda. You've done an excellent job at explaining how to build a very useful BvA report in Power BI. Great job, love your systematic step by step training. Now, to get busy building my own Power BI reports! Thanks so much!

[lienecirule]

Very clean, no repetition and many interesting hints included. Will look for more complicated topics explained in this channel. Good job! Thanks!

[-nepherim]

Excellent tutorial. Appreciate your approach to pacing and content leveling, thanks!

[Diana_Coutinho]

Already applied on my data. This video is really helpful. Got an appreciation from my Boss for the dashboards. Thank for your efforts in this video. Really appreciate it !

[Termoils]

Mynda you are the best subject matter expert on Power BI and Excel. Thank you so very much for educating us. I am a regular follower of all your videos and they are super helpful. Cheers!!!

[victoriaalbulescu]

I love your training Mynda! Finally I have built my own dashboards by following your tutorial :) Thanks for sharing!

[salehhazrami]

Great video, i am quite surprised how you managed to do a start to finish video with decent details in 41 minutes 😃 Following you for more videos like this 👍

[uwehaleksy]

Rather important amendment to your tutorial:
In your budget file the untransformed loading of the budget column works only in English speaking countries, where your Thousands separator is a Comma and the decimal separator is a point. In other countries, as for example Germany, the separators are the other way. Thus you have to transform the budget column in the budget file as follows:
- delete the Item "Changed Type" in the Query settings on the right edge. That unfortunately resets all the already automatically recognized and changed data types in all colums to Text, but unfortunately you can not change a once wrongly recognized column to another type.
- now set the data type of all undoubted columns by "Detect Data Type" (Datentyp erkennen)
- rightclick on the header of the suspicious column (wich is recognized as text due to the issues described below) --> context menu
- Typ ändern (change data type)
- Mit Gebietsschema (with locale settings)
- change data type to decimal
- *AND* change locale (Gebietsschema) to English (Australia)
I am not sure about the corect menu denominations in the English version.
Only now you have correct data. Otherwise you would have 30 data sets with values in the millions where the two thousands separators would be confused for two decimal separators, wich then cause an error in those 30 rows.

Also check and transform all other files of unknown / foreign provenience that contain columns with date values or currency values.

[genmanvangyongyang]

thank you, I'm starting learning power BI.

[Globa_me]

One of the best starting videos for new PBI users. Thanx a lot, Mynda!

[kubenmoodliar]

Your ability to transfer knowledge is amazing. Thank you for sharing 🙏

[LuanNguyen-plwf]

I really appreciate your methodical and thoughtful steps that you showed in the video.

[rephechaun]

This is amzing..nice pace, short and concised. I learned a lot is so short time! Thank you!

[venkatiyer]

Thanks for teaching in an organized and a disciplined way ... I need to shell out time to understand everything .... slowly but yes with your video I am confident that I'll do it .... Thanks again