How to Build Power BI Reports from Start to Finish
Ғылым және технология
🔻 DOWNLOAD the completed Power BI Desktop file and data files here: www.myonlinetraininghub.com/h...
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.
Get Power BI Desktop here: powerbi.microsoft.com/en-us/d...
🎓 LEARN MORE
- My Power BI course: www.MyOnlineTrainingHub.com/p...
- Introduction to cleaning data with Power Query: • How to easily automate...
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟♀️ CONNECT with Mynda on LinkedIn: / myndatreacy
🎁 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
Пікірлер: 1 000
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.
@MyOnlineTrainingHub
3 жыл бұрын
Wow, thanks for your kind words, Victoria!
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 :)
@MyOnlineTrainingHub
3 жыл бұрын
Awesome, thank you, Catalin!
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 !!!
@MyOnlineTrainingHub
2 жыл бұрын
Great to hear you found this video helpful, Suhair! The data model in Power BI requires the data in a tabular format, but you can use the built in Power Query tool to get and clean the data from Excel worksheets, CSV files etc. and convert it into a tabular layout if it isn't already. I don't have any Power BI survey data examples, but these Excel examples might give you some ideas: www.myonlinetraininghub.com/segmented-survey-data-chart and this: www.myonlinetraininghub.com/excel-charts-for-surveys
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!
@MyOnlineTrainingHub
3 жыл бұрын
Great to hear, Bob! Have fun with Power BI :-)
Very clean, no repetition and many interesting hints included. Will look for more complicated topics explained in this channel. Good job! Thanks!
@MyOnlineTrainingHub
2 жыл бұрын
Glad you liked it 😊
Hi Mynda. Looks like a great training. Looking forward to walking through it in depth with the data files. Thanks for sharing. Thumbs up!!
@MyOnlineTrainingHub
3 жыл бұрын
Thanks for your support, Wayne!
@lithinsyrus
3 жыл бұрын
@@MyOnlineTrainingHub pls share the link to download
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!!
@MyOnlineTrainingHub
3 жыл бұрын
Thank you so much, Rodion! 😃
This is amazing. So simple to follow and execute, even with what I’d characterize as moderate (at best) Excel skills. Thank you!
@MyOnlineTrainingHub
3 жыл бұрын
Glad it was helpful!
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 !
@MyOnlineTrainingHub
3 жыл бұрын
Congratulations on your success with Power BI, Diana! Great to know I could help.
@hanselcreado3570
3 жыл бұрын
Congratulations!!!
Excellent tutorial. Appreciate your approach to pacing and content leveling, thanks!
@MyOnlineTrainingHub
3 жыл бұрын
Great to hear :-)
@muhangiandrew8172
Жыл бұрын
@@MyOnlineTrainingHub share with me some files or books to use
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!!!
@MyOnlineTrainingHub
3 жыл бұрын
You are so welcome, Muhammad!
I love your training Mynda! Finally I have built my own dashboards by following your tutorial :) Thanks for sharing!
@MyOnlineTrainingHub
2 жыл бұрын
Congratulations, Victoria!
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 👍
@MyOnlineTrainingHub
3 жыл бұрын
Glad you enjoyed it, Saleh!
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.
@MyOnlineTrainingHub
2 жыл бұрын
Thanks for sharing, Uwe. In the files you downloaded from our site there is a file called READ_ME_FIRST.txt and in this file I explain how to change the data types for the dates using 'From Locale', as explained here: kzread.info/dash/bejne/g3-btZWhotXTpto.html This is the same issue you're having, except for thousand separators.
@uwehaleksy
2 жыл бұрын
@@MyOnlineTrainingHub Yes: "except for thousand separators". But those are much more difficult do deal with. And they are usually much more. Of course I have read "READ ME" and watched that video, but sincerely: what are the odds to read a "READ ME" file? And as I mentioned in the comments there, the checkbox "column qualiy" doesn't work reliably, so if one is not so experienced with odd data and not so curious as me, he wouldn't even realize that he has a data problem - before a later step in the processing of that data. And if he wouldn't have figures over 1,000,000 he probably wouldn't realize it at all, because a 17,100 turned 17.1 will not even throw an error message. Therefor my recommendation for all people dealing with numerics of unknown origin (dates and numbers and percentages): check your data in Notepad++ (your file might be too long for Excel) and search with the following regular expressions for the existance of possibly problematic numbers: ".*,.?.?.?" - for numbers over one Thousand (containing one Thousands separator) ".*,.*,.?.?.?" - for numbers over one Million (containing at least two Thousands separators) The formulation of the regular expressions might be different in different local settings due to the same exasperating Comma-Point-Problem. For the understanding of regular expressions see here: www.regular-expressions.info/tutorial.html
@juanfranciscogiustina5895
Жыл бұрын
Hi! I had the same problem, but there is another way to solve it. Firstly, I deleted the "Changed Type" as well, but then I split the column "Budget" by delimiter (comma) and finally merged the columns again. I am not sure if it is a final or correct solution, but for the example it helps.
Super straight forward and easy to follow. Thank you.
@MyOnlineTrainingHub
3 жыл бұрын
Great to hear, Kayode!
thank you, I'm starting learning power BI.
@MyOnlineTrainingHub
3 жыл бұрын
My pleasure. Have fun with it :-)
I really appreciate your methodical and thoughtful steps that you showed in the video.
@MyOnlineTrainingHub
3 жыл бұрын
Glad it was helpful!
One of the best starting videos for new PBI users. Thanx a lot, Mynda!
@MyOnlineTrainingHub
3 жыл бұрын
Glad you enjoyed it!
This is amzing..nice pace, short and concised. I learned a lot is so short time! Thank you!
@MyOnlineTrainingHub
3 жыл бұрын
You're most welcome!
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
@MyOnlineTrainingHub
3 жыл бұрын
Great to hear it was helpful, Venkat! Have fun with Power BI :-)
Your ability to transfer knowledge is amazing. Thank you for sharing 🙏
@MyOnlineTrainingHub
3 жыл бұрын
My pleasure, Kuben!
I have bookmarked this Video for future learning. I am a beginner in PowerBI. Thank you for the lovely illustration
@MyOnlineTrainingHub
2 жыл бұрын
Glad it was helpful!
I am from Taiwan and cannot find any satisfactory source in Chinese. It’s so glad to find your video which really help me to understand the key functions of power BI. Thank you very much!
@MyOnlineTrainingHub
3 жыл бұрын
Glad it was helpful!
I learned so much ... thank goodness its the weekend so I can relax and reflect on it
@MyOnlineTrainingHub
5 ай бұрын
Great to hear!
No question but only a thank you for your continued services!
@MyOnlineTrainingHub
Жыл бұрын
I appreciate that!
If you want to learn, watch this video. Thank you Mynda, you are superb at what you do.
@MyOnlineTrainingHub
2 жыл бұрын
Thanks for your support, Jamie! 😊
Thank you very much. You probably dont even realize how much your lessons help me in my work and it probably saves me from losing my job. I do really appreciate your teaching us valuable lessons.
@MyOnlineTrainingHub
2 жыл бұрын
Wow! I’m grateful I can help in some way, but really it’s you who’s doing the work and that tenacity is what helps keep you in a job.
@banksofnoon7867
2 жыл бұрын
@@MyOnlineTrainingHub Thank you, please keep educating us.
Thank you! Clear, concise and extremely knowledgable presentation
@MyOnlineTrainingHub
2 жыл бұрын
Glad you liked it 😊
I am regular learner from your videos. This is so far simplest and best video on Power BI. Look forward to see advance PBI videos covering essential DAX measure and advance data analysis.
@MyOnlineTrainingHub
3 жыл бұрын
Great to hear! DAX to come 😉
@Everyonelovesyou
3 жыл бұрын
@@MyOnlineTrainingHub Thanks.....so creative and simple......how can I inbox. I am put in back to back workload by my office. Which I am capable of doing. But being field sales manager things are quite divergent and convex. Need assistance to develop few dashboards if I could get support.
@MyOnlineTrainingHub
3 жыл бұрын
I don't do consulting, but if you want to learn how to build your own dashboards, please consider my course: www.myonlinetraininghub.com/excel-dashboard-course If you'd like me to refer you to a consultant, please get in touch via email: website at MyOnlineTrainingHub.com
Exceptional rendering! Loved it the way it went. Great Job! Thank you for sharing!
@MyOnlineTrainingHub
3 жыл бұрын
Great to hear, Sajil!
most clear and clean tutorial. no non sense straight to the point and topic. i loved it
@MyOnlineTrainingHub
10 ай бұрын
Thanks so much!
This was a perfect and inspiring tutorial. Thanks for sharing!
@MyOnlineTrainingHub
3 жыл бұрын
You are most welcome!
Hi, Great to see you sharing your knowledge on YT. I signed up to several of your Excel training programs a few years ago and they helped me enormously
@MyOnlineTrainingHub
5 ай бұрын
So happy to read that! Thank you for your kind words of support 😊
Thanks a lot Mynda for sharing your knowledge. It really helped me to understand PowerBI. The whole content and tutorial are amazing.
@MyOnlineTrainingHub
3 жыл бұрын
Great to hear 😊
Thank you so much, I came upon this video because I needed to add a slicer, but I learned a lot more than I thought. Great video, will definitely be coming back to it.
@MyOnlineTrainingHub
Жыл бұрын
Great to hear, Maiara!!
Really appreciate your instruction on building this report. I followed it step by step and learned a lot. Couple things would like to share. For the date columns in the source excel, they are formatted in UK dates for e.g. 1/2/2020 actually for 2/1/2020. So for USA learners like me, we need to format them to US dates otherwise the time related vis such as Line Chart won't work correctly. The other is about the running total measure, I created the formula with your code and checked it with data table. The numbers were not correct. I used the Quick Measure tool to generate the formular and checked it to make sure it worked. The one I have is: ISONORAFTER('Actuals'[Date], MIN('Actuals'[Date]), DESC) instead of MAX('Actuals'[Date], DESC). Thanks again for your wonderful teaching. Keep up the good work!
@MyOnlineTrainingHub
Жыл бұрын
Glad you found it helpful! Yes, in the READ_ME_FIRST.txt file included with the data download for this video I explain the date issue and a link to a tutorial on changing type using Locale. Hopefully you found it and didn't waste time trying to figure out why the dates were wonky for you. MAX or MIN in the running total formula yields the same results, so there's no right or wrong.
@webwatcher188
Жыл бұрын
@@MyOnlineTrainingHub Thank you for the explaination. I tried use the Locale to convert the date to US but didn't work. I then used "Split column" and "Merge column" to finally get it right. This was a good learning experience and helped me using different way to solve the problem. For the running total, you are correct, both MAX and MIN will work with the right sorting direction. I think for MAX, the sorting needs to be ASC. Thank you again for the wonderful lecture.
Hi Mynda.Thank you so much for amazing training.
@MyOnlineTrainingHub
3 жыл бұрын
You are most welcome, Tarkan!
Excellent tutorial, easy to understand. Thank you.
@MyOnlineTrainingHub
2 жыл бұрын
Great to hear!
this is one of the best tutorials i have watched
@MyOnlineTrainingHub
11 ай бұрын
Wow! Thanks so much 😊🙏
Thank you for this free course!
@MyOnlineTrainingHub
2 жыл бұрын
Our pleasure!
I don't usually like to comment, but when I do it's for an amazing tutorial like yours. Excellent presentation!
@MyOnlineTrainingHub
2 жыл бұрын
Wow! Thank you, Mesfin 😊
This is the clearest and most simplest training instructor I've seen. Really love her content. Please keep it up! :D
@MyOnlineTrainingHub
Ай бұрын
Wow, thank you! 🥰
@mzzzzz2179
Ай бұрын
@@MyOnlineTrainingHub I watched your video back 4yrs ago as my first Excel dashboard tutorial. I am now advanced in Excel and have moved over to Power BI last year. Though I know Power BI fairly well now, it' still nice to see your videos. You're a true inspiration :)
@MyOnlineTrainingHub
Ай бұрын
Wow! Congratulations on your success!
Thank you So much for the wonderful Presentation!
@MyOnlineTrainingHub
3 жыл бұрын
So nice of you, Suneetha!
You taught me power query now you're up to this... TYSM. You're amazing.
@MyOnlineTrainingHub
2 жыл бұрын
Thanks so much 😊
Amazing, you are so clean and clear, thanks!
@MyOnlineTrainingHub
2 жыл бұрын
Glad it was helpful!
Love the way you present these..
@MyOnlineTrainingHub
2 жыл бұрын
Thanks so much!
You're simply amazing! Bless you !
@MyOnlineTrainingHub
3 жыл бұрын
Thanks so much 😊
Excellent as usual, thank you for sharing your knowledge
@MyOnlineTrainingHub
3 жыл бұрын
Glad you enjoyed it :-)
I thank you so much for this explanation, it made it so easy to understand an assignment I had left until last minute
@MyOnlineTrainingHub
2 жыл бұрын
Glad I could help 😊
Amazing tutorial,the decomposition functionality is a game changer.
@MyOnlineTrainingHub
3 жыл бұрын
Thank you!
Simply perfect! Thanks a lot Mynda!
@MyOnlineTrainingHub
4 ай бұрын
Thanks so much 🙏😁
Thanks for the video, it helps me to understand different reporting visualization.
@MyOnlineTrainingHub
3 жыл бұрын
Glad it was helpful!
Very well done! Clear and precise, thanks for this.
@MyOnlineTrainingHub
Жыл бұрын
Glad you enjoyed it!
the best power bi presentation and expanation I have witnessed so far !
@MyOnlineTrainingHub
2 жыл бұрын
Wow, that's awesome to hear!
Amazing tutorial! Awesome level of detail ❤️👌🏼
@MyOnlineTrainingHub
2 жыл бұрын
Thanks so much! 😊
Hi Mynda!Really Enjoyable Tutorial...Thank You :)
@MyOnlineTrainingHub
3 жыл бұрын
Thanks for watching, Darryl!
Hi! Your tutorials are great! Nice graphics, calm voice. During Covid i try to upgrade my skills and your videos are perfect. Thank you for these. Regards from Poland.
@MyOnlineTrainingHub
3 жыл бұрын
Glad you like them, Artur! And great to hear you're making the most of your downtime during COVID.
Thank you, Excellent tutorial I'm starting learning power BI
@MyOnlineTrainingHub
3 жыл бұрын
Glad it was helpful!
How I wish you had more Power BI videos!!
@MyOnlineTrainingHub
3 жыл бұрын
Working on it :-)
Hi Mynda, I was trying to learn how to create Dashboards for different data sets, when I came across your video. Learned lots from it! My only point would be that if you could explain why each visual is chosen on the dashboard, it would help us gain more insights.
@MyOnlineTrainingHub
Жыл бұрын
Glad you found it helpful!
This is Brilliant!! Very well explained and demonstrated! Thank You!
@MyOnlineTrainingHub
2 жыл бұрын
Glad it was helpful, Roland!
Thank you for amazing training!
@MyOnlineTrainingHub
10 ай бұрын
So pleased you enjoyed it!
wonderful training! I also like your courses
@MyOnlineTrainingHub
3 жыл бұрын
Awesome, thank you!
Interesting for me. I want to start learn power bi and power query since long. You have explained very clearly thanks alot
@MyOnlineTrainingHub
3 жыл бұрын
Pleased to hear that, Raj!
found this to be a better overview and example of a "first" report than the one from a dedicated PowerBI channel. thanks!
@MyOnlineTrainingHub
2 жыл бұрын
Wow, thanks, Zac!
Very concentrated and effective course
@MyOnlineTrainingHub
3 жыл бұрын
Glad you think so!
Hi Mynda, You are a Super Pro. Liked the coaching to the fullest. Will subscribe to view all your videos . Thanks a ton.
@MyOnlineTrainingHub
2 жыл бұрын
Awesome! Thank you!
Hi Mynda, really a good training, i appreciate.
@MyOnlineTrainingHub
3 жыл бұрын
You're most welcome!
You are an amazing trainer thank you
@MyOnlineTrainingHub
3 жыл бұрын
You're most welcome!
Thank you Ma'am. Really great content and the way you explain every concept is incredible. Thanks again.
@MyOnlineTrainingHub
2 жыл бұрын
So nice of you :-)
Mam, Your explanation is very clear and one of the best video on Power BI and excel in KZread thank you .
@MyOnlineTrainingHub
2 жыл бұрын
Wow, thanks so much, Vijay!
Great training! I've sure picked up a few tricks along the way.
@MyOnlineTrainingHub
2 жыл бұрын
Great to hear!
Very helpful. Can't wait to create my first Power BI visuals.
@MyOnlineTrainingHub
2 жыл бұрын
Great to hear 😊
Thanks for the information rich tutorial! I like the constant subtle variations in doing similar things to show some of the options available.
@MyOnlineTrainingHub
Жыл бұрын
Glad you noticed 😊
Amazing and Professional. I love to check your Videos to give my Ideas the finish they need or check for complex solutions. Thank for your online content.
@MyOnlineTrainingHub
2 жыл бұрын
Great to hear, Marc!
Waou, I am amazed by the clarity of your explanation. Thank you for the excellent job you put in here!!
@MyOnlineTrainingHub
Жыл бұрын
Thanks so much!
The best tutorial BI video, Thanks!
@MyOnlineTrainingHub
3 жыл бұрын
Wow, thanks!
This is so good I’m following right now. Watched through and now I’m following with the dataset. Amazing Thank you
@MyOnlineTrainingHub
6 күн бұрын
Awesome to hear!
You have helped me in understanding power bi . Thank you so much
@MyOnlineTrainingHub
2 жыл бұрын
My pleasure 😊
Very informative and useful . Thank you .
@MyOnlineTrainingHub
3 жыл бұрын
Great to hear 🙂
very informative tutorial, clear and simple, thank you
@MyOnlineTrainingHub
11 ай бұрын
Glad it was helpful!
This video helped my learning so much. Thank you.
@MyOnlineTrainingHub
Жыл бұрын
Awesome to hear 😊
Excellent video. You made Power BI very easy to understand. Thank you very much.
@MyOnlineTrainingHub
Жыл бұрын
Glad to hear that!
Great course! Thanks for sharing
@MyOnlineTrainingHub
2 жыл бұрын
My pleasure!
You are such a blessing. Pls keep up the good work
@MyOnlineTrainingHub
3 жыл бұрын
Thank you so much!
Great tutorial. Thank you very much!
@MyOnlineTrainingHub
2 жыл бұрын
Glad you enjoyed it!
Thank You So Much. Its very helpful
@MyOnlineTrainingHub
2 жыл бұрын
Glad to hear that 😊
I usually enjoy your videos but there were so many subjects that you seemed to not mention for someone just learning. Thank you for your other work.
@MyOnlineTrainingHub
Жыл бұрын
Yes, Power BI is a vast app with what seems like endless functionality, which is why I put together a comprehensive course (www.myonlinetraininghub.com/power-bi-course). The idea of this video was to provide a lesson and data where you could try it out yourself and experience using it and a platform from where you can then go and learn more if you like it.
Half-way in, great so far! Thank you
@MyOnlineTrainingHub
Ай бұрын
Awesome to hear 😁🙏
best vid so far. Thanks Mynda!
@MyOnlineTrainingHub
3 жыл бұрын
Thanks so much, Melinda!
Excellent tutorial Mynda - many thanks
@MyOnlineTrainingHub
3 жыл бұрын
Glad you liked it 😊
Very nice presentation and way too informative, thanks
@MyOnlineTrainingHub
3 жыл бұрын
Glad you found it useful, Sarath!
Your content is excellent. I have respect and praise for what you are doing, Mynda. Keed educating the world with your awesomeness. Love.
@MyOnlineTrainingHub
2 жыл бұрын
Thanks so much 😊
well this is an alien thing ... My native language is Spanish, but I struggle to understand this with the subtitles, I have learned Power BI and English with you. I will follow your channel.
@MyOnlineTrainingHub
3 жыл бұрын
Thanks for following :-)
You are doing great! Thank you so much!
@MyOnlineTrainingHub
2 жыл бұрын
Glad you liked it 😊
You got a subscriber here. Excellent work !!
@MyOnlineTrainingHub
2 жыл бұрын
Awesome, thank you!
Really help me so much. Thank you so much. Looking for advance Powerbi from you soon. A Million thank you to you
@MyOnlineTrainingHub
Жыл бұрын
Happy to hear that!
Thanks a lot of the great training
@MyOnlineTrainingHub
3 жыл бұрын
Glad you enjoyed it, Mutaz!
Wondering.... Why even click the dislike button? They can just leave the video if they didn’t like it right? Dear land lord, This video is amazing. Thank you for your presentation and knowledge.
@MyOnlineTrainingHub
3 жыл бұрын
Thanks so much for your kind words and support, Jin!
Hey Mynda, very informative session. looking forward to see more of it.
@MyOnlineTrainingHub
3 жыл бұрын
Thanks for watching, Ravi!