MSPTDA 16: Power BI Desktop Comprehensive Introduction: Power Query, DAX, Dashboards, Publishing

Download Zipped Folder with Text Files & Excel File: people.highlin...
Download Power BI Desktop FINISHED File: people.highlin...
Download pdf Notes: people.highlin...
Assigned Homework:
Word document with homework problem description : people.highlin...
Zipped Files for homework: people.highlin...
Examples of Finished Homework: people.highlin...
This video is a comprehensive lesson in Power BI Desktop: Power Query to import data, DAX Formulas and Relationships to complete Data Model, Creating Dashboards, Publishing and Sharing Reports.
Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.
Topics:
1. (00:15) Introduction of what we will do in this video.
2. (02:25) Overview of Excel Power Pivot & Power BI Desktop
3. (02:44) Approximate History of Power BI Desktop :
4. (03:15) Different Versions of Power BI (Different Power BI Products) Available from Microsoft
5. (04:56)Download Power BI Desktop (link to Avi’s video: • FREE Power BI Download... )
6. (05:43) List of Charts and Visualizations for your Dashboard (Review from prerequisite classes Busn 216 & 218)
7. (06:02) Overriding Steps for our Project
8. (06:27) Open a blank Power BI File
9. (07:04) Introduction to Power BI Window and User Interface
10. (08:32) Power Query to Import Multiple CSV Files and Clean and Transform Data
11. (13:38) Why we do NOT use Number or Date Fields from a Fact Table
12. (15:57) Import Dimension Tables from a Single Excel File
13. (18:09) Merge Snow Flake Dimension Tables into dProduct Table
14. (19:30) Do NOT import to Data Model (Uncheck Enable Load)
15. (20:22) Old Relationship View & New Relationships View with Properties & Better Selection Capability
16. (20:41) Steps to create Date Table using CALENDAR DAX Table Function & Calculated Columns. See many DAX Functions such as CALENDAR, FORMAT and others.
17. (25:58) Sort By Column to get Months to Sort correctly.
18. (27:47) Create Fiscal Periods for Data Table, including Helper Column for Sorting Fiscal Period correctly.
19. (33:12) Hide Columns from Report View
20. (34:00) Create DAX Measures and see why we do not use Implicit Measures.
21. (36:17) SUMX DAX Function
22. (38:15) Row Context (how formula calculates for each row in a table or Iterator Function)
23. (40:12) Filter Context (How Measures Calculate and how Tables are Filtered when Measures Calculate)
24. (41:50) Measure for Average Daily Revenue. Learn about Context Transition. See AVERAGEX Function to iterate at the Daily level.
25. (47:55) Conventions for DAX Formulas with a great tip from Marco Russo and Albetro Ferrari
26. (49:00) More About Filter Context and Context Transition
27. (49:26) Gross Profit Measures
28. (51:48) Refine Data Model in Power Query by Removing Columns in dProduct Table
29. (52:40) Learn about how to Create & Format Visualizations
30. (52:40) Create “Ave Daily GP” Dashboard.
31. (52:40) Create Matrix and add Conditional Formatting
32. (55:29) Create Column Chart and add Conditional Formatting
33. (56:00) Hierarchies
34. (56:52) Drill Down Icons in Power BI
35. (59:09) Create Line Chart
36. (01:00:00) Create Card
37. (01:01:00) Edit Interactions between visualizations
38. (01:02:50) Create “Fiscal Report” Dashboard
39. (01:05:32) Bookmark to save views of a Dashboard
40. (01:06:20) Create “Ave Last 12 Months” Dashboard
41. (01:06:37) DAX Measure for Average Transactional Revenue. See AVERAGEX Function to iterate at the transaction line item level.
42. (01:07:30) Visual of how we change the Filter Context to get dates for a full year backwards.
43. (01:08:25) CALCULATE & DATESINPERIOD & LASTDATE DAX Functions to calculate Measure for Rolling 12 Month Average for Transaction Level Data.
44. (01:12:08) Create “Question” Dashboard. Learn about Ask A Question feature.
45. (01:13:08) Publish Report to powerbi.com
46. (01:14:15) Edit at powerbi.com
47. (01:14:34) Publish to Web with Free Power BI Desktop version and allow public to review Report
48. (01:16:15)Publish and Share with Power BI Pro Account
49. (01:17:44) Source Data Changes and Refresh
50. (01:18:18) Summary

[@redherring4119]

You have no idea how many lives you are changing. Thank you so much for everything. My career has turned around because of you.

[@excelisfun]

Yes, that has been my goal for the past 14 years here at KZbin: provide free Excel and Data Analysis Education for the world : ) I am so glad that I can help you turn around! Keep clicking those thumbs ups on each video and comment when so inspired.

[@szpyrkowski]

I don't believe how can you both have so much knowladge&skills as well as present this in this super exciting way. Awesome job.

[@excelisfun]

That is what i have done for almost 20 years as a teacher and 11 years at KZbin. It is fun for me to try and make it fun for you!!!! Thank you, szpyrkowski , for your support to help this channel on each video that you watch : )

[@suannyuenfann6736]

I started and ended the day with you almost every day in the last 2 weeks. Thank you very much for creating such valuable content but free on KZbin.

[@excelisfun]

You are welcome! I am glad that the content helps, Xuan! But it is not free: I change a thumbs up for each video ; )

[@excelisfun]

Please help support these epic free education resources with comments, Thumbs Up and Sub : ) P.S. At 14:48.. It should be " IMPLICIT Measures will NOT show up if you download in Excel."

[@msantosh1220]

You dont need our support Infact we need your supported "Mike". I have been ur subscriber since last one year. Your excelisfun was a gamechanger for me Today I'm at commendable post in my organization it was all possible bcoz of your excel knowledge tat u have shares on KZbin 4 free. I'm still learning 4m ur video and any video released by you goes on my Facebook page so that ppl connected vid me also come know abt your videos. Thanks for sharing you have been a wonderfull teacher for me.👍

[@cynthiaelizabethgiron6802]

Excelent video!

[@liztrama]

OMG!! It took me one full day to watch this video and follow along with Mike step by step to complete this file. I had to stop and rewind the video many times to understand and complete the DAX formulas. I learned how to create a table, new columns , Dax formulas, different visualization with charts, cards, matrix, and many more. This was sure a comprehensive video. At the end of the day, I had a huge headache, but it was worth it. THANKS A MILLION MIKE!!! You make learning fun.

[@excelisfun]

Yes!!!!!!! Huge New Knowledge, minus the headache... Thanks for your support, Liztra : ) : )

[@suneelkokate5210]

Sir, I have seen many excel instructors but nobody is as efficient as you, Thank you for your great efforts.

[@excelisfun]

Thank you for the kind words! Out of curiosity, what is it about the instruction that is efficient for you?

[@excelisfun]

You are welcome for the efforts, Suneel! Thanks for your support : )

[@LeilaGharani]

Amazing! Thank you Mike for this super comprehensive and practical introduction.

[@excelisfun]

You are welcome, teammate! Go Excel KZbin Team!!!! : )

[@brianxyz]

Mike, when creating a calendar using DAX you can add in Quarter by using Format just like you did for Month. Quarter = Format(dDate[Date], "Q") Another way to prevent hidden date tables from being created is to turn off that functionality. Options and settings > Options > Current File: Data Load > uncheck Auto Date/Time under Time Intelligence

[@rodrigocustodio1955]

Thank you, Mike, for your outstanding classes. You are very talented for teaching, yet you are a very humble guy. your free classes here on youtube are better than paid classes.

[@excelisfun]

You are welcome, Rodrigo!!!!

[@sajidmuhammed1484]

Most comprehensive and all-in introduction to Power BI. Its a tour de force, highly recommended and must watch for beginners and intermediates too. What an achievement!

[@excelisfun]

Thanks for the kind words, Sajid!!!!! Tell all your friends and colleagues : )

[@pravinshingadia7337]

Aewsome effort Mike. Also love that you have timings documented so you can quickly refer to parts you wish to go through again. Your students are lucky to have someone like you!

[@excelisfun]

Glad that the video is helpful, and that the time hyperlinked table of contents is useful : ) Thank you for your consistent support on the videos that you watch, Pravin!!!

[@rodrigocustodio1955]

Thank you Mike, I speak in behalf of all Excel users that have benefited from your amazing, and outstanding videos.In Every single class, in every single lesson, you have these amazing energy in your voice and awesome delivery. My 10 years old daughter when heard you presenting another class said that you are somebody who enjoy what you do, very true remarks from my girl! All the best for you and your family, and as always, this is one more great video !

[@excelisfun]

I am glad to help! Thank you for your kind words, Rodrigo : )

[@Nguyenchihien90]

Most of my skills about power query,pivot,BI and other excel tricks are learned from Excel fun channel. Thank you very very much for your relentless effort of updating new knowledge about excel world.

[@excelisfun]

You are welcome for the relentless effort to help you and all of our other Excel/PowerBI Teammates learn power, fun and efficiency!!!! I look forward to your relentless effoct to click that Thumbs Up and comment on every video that you watch : ) Go Team!

[@emmafeng55]

Thanks heaps Mike!!! I learnt my Excel skills from your channel and three years later I start the Power BI learning journal from your channel!! You are so great. ❤️

[@excelisfun]

I am so glad to help you, Jing Feng!!! Thanks for your support on each video that you learn from with a comment and thumbs up, and of course your Sub : ) Those help me to further the goal of free education to the world : ) : ) Together, with my free education and your support on each video, we can make the world a better place!!!

[@emmafeng55]

ExcelIsFun Hi Mike, I have a question for power BI that bothers me few days and I can’t find a solution for it.I have created the last year year to date (LY YTD) figures and year to date (YTD) figures from original sales data in power BI using measures. And I have also created three customer groups based on the LY YTD and YTD using measures. I would like to place the groups in power BI slicer so the other users can simply choose the group that they want to see and the sales report will show. But looks like we can’t place measures in slicer. I have tried the below methods but none of them work: 1, create columns instead of measure for LY YTD and YTD. However, it’s not working as they appeared to have dependency issue. 2, using SWITCH functions tried to link the measures with the sales report, still not working. The demonstration video that I looked at only shows the total figure, but I would like to have the list of all the customers that under the selected group. 3, I’ve tried the VAR logictest but the similar issue as method 2. Do you have any suggestions? I’m not quite sure whether I’m on the right track to solve my issue but each method is so close to my expected result... really really appreciate your advise! 😊

[@excelisfun]

@@emmafeng55 I am not sure exactly without seeing a small replica of your larger model that can illustrate all the parameters in the problem. In general, if you want something in a slicer, you gotta put it is a table and put the table in the model with the correct relationship lines. If it was just customer group, then the customer attribute would go in Customer table. Maybe you need the LY YTD and YTD sales as amounts in column in customer table!?!?! If you can make a small model in Excel with your tables and customers and so on, amd give me an example of the final result, I am pretty sure I could figure it out... Can you do that?

[@emmafeng55]

@@excelisfun Hi Mike, yes i do tried to create the customer group in a new table and I'm not quite sure whether because my background linkage formula is incorrect so its not successfully link. If it's not too much trouble can I send you the small part of the data and you can have a look? May I have your email address? thanks a lot~~

[@excelisfun]

@@emmafeng55 not a small part of the data. Send a complete parallel but much smaller model that shows your situation, state what your model is, what the goal is, and an example of what the end result is (maybe a few examples of what the correct answer would be). Maybe I can back my way into the logic that way. I get 100s of correspondences each day, so unless I can understand what your situation is, the goal and what the end result should be, in less that one minute, it is unlikely that I can help. excelisfun at gmail : )

[@danieltoupin4949]

Wow, I really love how you show the material. Ultra Clear, with lots of explanation. Great job!

[@excelisfun]

Glad you like the ultra clear DAX fun!!!!

[@blackwhite2361]

Man I watched your Excel for Business Intelligence and I must say you are good. You present the material in a clear, concise and easy to understand way. You just earned a sub.

[@excelisfun]

Glad to help Black White : )

[@MohamedAhmed-no4rt]

I just passed 70-779 and these series of videos are very helpful to pass 70-778, thanks Mike

[@Pabloescobar-mp3xo]

Thank you for everything one word I can say to you may god pay your effort 🙏🏽

[@excelisfun]

You are welcome, Pablo!!!

[@danielwerner9543]

Mike you enthusiasm for you passion is inspiring.

[@mueez89]

I recently started learning some VBA. Writing formulas in steps is makes them much easier to read; especially when declaring variables inside of DAX it makes it super easy to come back and edit.

[@excelisfun]

Thanks for thought, Mueez!!!

[@excelisfun]

From our Teamate, pa beader, we want to Define the terms used in the video with more accuracy (In this video I used the term "Dashboard" incorrectly). 1) Report = Power BI File Created with Desktop that contains the Tabs (Pages), Data Sets and Data Model. 2) Each Report is connected to One Data Set. 3) Tab in Power BI File = a Page a set of visuals. 4) Dashboard = a place to pin visuals in Power BI Service website. A Dashboard can contain visuals from different Reports and Data Sets.

[@hussamalh8554]

Hi Mike: in PowerBI How do we calculate cumulative balance for financial data like balance sheet Asset/Liability accounts. in essence the calculation is Asset 1 balance in march is Balance beginning of year + accumulated transactions during the year on same account number. Example: Account 1211 Accumulated balance in July = balance as of 20xx/01/01 + All transactions booked on account 1211 up until end of July I couldn't solve this issue nor could i find solution online...is it possible for you to make video about it? it seems that many people has it, found in my search many questions but no concrete answer..

[@ronbrown1751]

GREAT VIDEO, Instruction and Instructor. I'm retired and still enjoy keeping abreast to the developments in the Data Analysis arena

[@excelisfun]

Thanks for the kind words, Ron!!!! It IS exciting with all these new tools! Thank you for supporting with those comments, Thumbs Ups and a Sub : )

[@DIGITAL_COOKING]

what else I notice first, if we add all notes created by mike we will get the biggest book about excel ever made second,...you find very useful exercises ( i try them especially for this series indeed I learned from them too ) thank you mike I owe you the excel knowledge :)

[@excelisfun]

Yes, that is 100% correct. That is 100% my intent!!!! The pdf notes for all my free classes at KZbin are lots of free books. I give away free videos, Excel files, books and practice problems for the world to learn from. I am trying to make the world a better place with free education for the world!!!! i just wish there would be more support for all this free education...

[@haloiamjass4181]

The most informative video I have ever seen in Power BI. It is a good knowledgable video.

[@excelisfun]

Glad the knowledge is helpful to you, jayashree! Thanks for your support on each video with your thumbs up and comments, and of course your Sub : )

[@excelisfun]

What sort of reports and dashboards are you making?

[@franciscoisaacs881]

Thank you, thank you , thank you. Paid for a course on Udemy 🤦‍♂️, the best things in life really are free . Anyone can attempt to teach but only a select few do it well, you sir are in a class of your own.

[@excelisfun]

A lot of the paid classes are not high quality. I am sorry about that, Francisco. But at least, you know now that I post free resources for the world here at KZbin. Tell all your friends, and pay for each "free" video with a comment and thumbs up, and a Sub too : )

[@grace071089]

Thanks a lot, Mike. Yours is the most helpful channel ever.

[@excelisfun]

You are welcome a lot, Lien Anh!!!! Thanks for your support with your comment, thumbs up and Sub : )

[@thodorisgakis7783]

Mike everything has been already written from others. Remarkable work as an instructor/tutor. I started from power querry lessons and moved forward, at this point I am grateful not only for these online courses but because you explain the way things are function. My learning key is based on understanding the concept before gain the experience (trials and errors) - you give us this knowledge in most of the times with fun! Thank you for all

[@excelisfun]

You are welcome, Thodoris!!!! Thanks for your support with your comments and thumbs ups!

[@cbaide100]

I felt that I had not completely grasped the knowledge this video is supposed to convey so I watched it a second and then a third time. Now I can say I have grasped completely all the knowledge Mike Girvin is transmitting via this video. By watching the video several times I also can appreciate all the time and effort put by Mike to shoot a video like this. Every detail to deliver a clear message is taken care of: zooming, panning, highliting text with different colors, differente shapes pointing to messages, pdf notes, etc. This is true for all the videos Mike uploads to KZbin. I feel compelled to say what an amazing job Mike G. does...and it is for free!. Thank you Mike, I admire you very much. I wish you and your family a very happy new year.

[@excelisfun]

Yes, indeed, it does take an immense amount of planning and executing and creating and inventing!!! The video and all the resources took 161.5 hours to create. .. I am so happy that you watched it a few times, because that is the intent. I try to put as much into one video and story, so it is a one stop shopping for those that want to learn the hows and whys : ) Thanks for your support on each vid you watch with those comments and Thumbs Ups, Carlos : ) : )

[@excelbear6860]

1 down. 45 more in the playlist to go. Thanks Mike!

[@excelisfun]

You are welcome, Excel Bear!!!

[@amerfarooq1142]

most comprehensive video, I suggest to see to learn

[@excelisfun]

Always glad to help with my videos : )

[@kss2066]

Bestest & most adorable guru and human being!

[@excelisfun]

You are welcome, KS S!!!

[@LongTimeTTFan]

Thank you so much, Mike. Your wisdom, your knowledge and above all, your spirit of ALTRUISM is exceptional and always inspiring.

[@excelisfun]

You are welcome! Thanks for your support and for your kind words : ) : )

[@hi2832]

This is the best end to end view of Power BI. Thanks a lot.

[@excelisfun]

Glad you like it! I do try to provide free education, end to end : ) Thanks for your support with your comment, thumbs up and of course your Sub, raheel : ) : ) : )

[@HachiAdachi]

One comment: You are calling your reports "dashboards", but it may be wise to call them "Reports" because "Reports" and "Dashboards" are distinctively different things in Power BI Service. It took me a long time to understand the difference at the start of my Power BI learning journey, and I thought it would be important to establish the terminologies especially if the audience tends to be at a beginning proficiency. Btw, MSPTA has been an awesome series, Mike! I always recommend your channel for those who want to teach Excel to themselves, and now I can do the same for Power BI.

[@excelisfun]

Now I am confused. I thought that the file was the "report", and each tab in the report was a Dashboard. Is that not correct?

[@excelisfun]

These terms are very important. I guess I made a mistake. I thought that the file was the "report", and each tab in the report was a Dashboard. Is that not correct? Is this more correct: 1) File = Report, 2) Tab = Tab, 3) Dashboard is a place to Pin particular pieces of Reports in online BI Service website ?

[@HachiAdachi]

I think you got it right in your other comment (referencing pa beader)! Thanks!

[@excelisfun]

@@HachiAdachi I am working on a new video based on your comment and pa's comment : ) Thanks for you two Teammates for helping me to get it more right : )

[@keepcalmuvlb5n]

I am a new bee to Power BI, ealier to this learnt Tableau. This is almost my first go at the videos. I am already in love with this play list. I am straight away starting with this series. Hope you will not dissapoint me. Liked :) Subscribed :) ;) :)

[@excelisfun]

I hope that I do not disappoint. Start at #1 and watch all the way through. Below each video are files, pdf notes and practice problems. Be sure to comment and thumbs up each video as a payment for this free education : ) Thanks for your support, Vijay!!!

[@niavras]

First thumbs up an after watch the video... every video so far was a treasure!

[@excelisfun]

Yes!!!! Thanks for your consistent support, kostas : ) : ) Together, with my free education and your support on each video, we can make the world a better place!!!

[@niavras]

@@excelisfun Sure Mike, that has to be the goal! To make our world a better place. And you offer much to this goal with your effort to make professional, rational, understandable videos for these wonderful tools (excel, power bi etc). Thanks once again.

[@excelisfun]

@@niavras Go Team!!!!

[@pabeader1941]

Just a quick note: Power BI uses the term Dashboard in a very specific way. It is a place to Pin particular pieces of Reports. What I find odd is you can only make use of it through the Power BI Service website. So you can't actually make Power BI Dashboards with the app. Not sure if that was confusing anybody else.

[@excelisfun]

These terms are very important. I guess I made a mistake. I thought that the file was the "report", and each tab in the report was a Dashboard. Is that not correct? Is this more correct: 1) File = Report, 2) Tab = Tab, 3) Dashboard is a place to Pin particular pieces of Reports in online BI Service website ?

[@pabeader1941]

A File created with Desktop = Report and Dataset A tab in a Report = Page A Dashboard is a place to pin visuals... Also, they make a point of noting that each Report(collection of Pages) is connected to one Dataset. That's where a Dashboard is a bit more flexible in that it's visuals can come from many different Datasets.

[@excelisfun]

@@pabeader1941 Thanks very much pa beader!!!!! I just pinned a comment to the top so your refined terms can help the Team!!!! Go Team : )

[@Bobby321go]

I bought a mug to drink to the greatness of this video. Cheers!

[@excelisfun]

Thank you very much, Robert : )

[@zhouyinwei2007]

Although part of the contents are already touched upon a bit in previous or other videos, still this one is complete and more insightful, really worth to spend the time and effort in this one, learn not only the operation method, tricks, but also more important, logical behind. Awesome course, really appreciated for sharing

[@excelisfun]

You are welcome! Yes, my classes are less about the flashy, and more about the technical formulas stuff and about the concepts and whys. I am glad that it all helps you, zhou!!

[@z058261]

Learnt alot from this takes an MVP expert to give you this level of intensive crash course teaching and it is free. Godsend.

[@cbaide100]

I just love Mike videos because he always finds a way to explain and illustrate concepts that otherwise would be difficult to understand. Thank you very much Excelisfun channel.

[@excelisfun]

You are welcome!!!! I HAVE to figure out a way to illustrate the difficult, or else a guy like me (not too smart) would never understand it either : ) Thank you very much for your support, Carlos!!!!

[@davidpellatt3501]

This is just another amazing and phenomenal video form Mike Girvin. There are golden nuggets at every turn, I would truly be lost without his training and expertise. Thank you so much

[@excelisfun]

You are welcome, David! For those gold nuggets, I only charge a comment and a thumbs up (and a sub too). Thanks for the payment, David Pellatt : )

[@timmybone13]

This video is amazing. Power BI has apparently gone through a few updates since it was made and a few of the buttons have been renamed or moved around, but I was still able to follow along. Particularly the NLP at the very end did a much better job of interpreting my input. Thank you so much for this video. What a great free tool!

[@excelisfun]

You are welcome, Tim!

[@phumzilendlebe2726]

Once again you never dissapoint... You are a great inspiration and awesome teacher to learn from. Most of what I know came from your lessons. Thanks you so much....

[@3danim8r1]

One more day in lockdown and learn one more tutorial, Quite similar to previous one as comparing in DAX but nice visuals. Thank you much for sharing.It's simply Greatt...

[@excelisfun]

You are welcome for the sharing during this difficult time in our world history!!!

[@DIGITAL_COOKING]

hi mike, I give you five stars for ddate table I remember that Isaw the same approach in one of your excel date function and formula videos ... great!!!

[@excelisfun]

Thanks for the five starts!!!!! Glad it is fun for you : )

[@panh4190]

Thanks sir for such an epic video. For me, dealing with date is the hardest part. For example, when analyse the retail sales, because of the difference between the weekdays and weekends in this year and last year, the sameperiod measure should not be used or elses Running total projection would therefore be distorted. I wish Excel would have the measures or formula to easily find the matching weekdays/weekends between diferrent years.

[@shafeekvariyathvallapil1277]

Excellent classes ... Please upload more about power bi

[@johnborg5419]

Power Pivot Video and practicing was fun last Week. This is another Challenge !!! :) DAX formula in a straight line view is much much more readable for me. Beautiful Staff. Thanks Mike :) :)

[@excelisfun]

Yes, John, we are hard core Excel Array Formula People and so we can read, but most DAX people use that formatting... : (

[@johnborg5419]

I respect that :) cause that's coding formatting and not formulas method. Anyway, this is great Fun. :)

[@excelisfun]

@@johnborg5419 It is fun either way : )

[@excelisfun]

@@johnborg5419 , BTW, DAX and Excel Spreadsheet formulas are "Formulas", even though other people may call it coding ; )

[@juanc9251]

These videos are life changing! Thanks excelsfun team!

[@excelisfun]

You are welcome for the life changing videos, JC!!!

[@adewaleoke2000]

The problem I have now is that I can't sub twice. Thanks Mike! for freely sharing your knowledge.

[@excelisfun]

I love that!!!!! You can Sub twice if you have multiple accounts ; )

[@excelisfun]

You are welcome for the free sharing of fun and efficinet knowledge! Thanks for your support, Adewale!!!

[@RobMichaels1]

An epic video indeed. It took me 4 days to work through the example myself as you showed step-by-step the entire process. It was worth every minute of time spent as always! Thanks.

[@excelisfun]

Glad you like it, Rob!!!! Much more to come : ) Thanks for your support on each video : )

[@PavanLalwani]

I am taking off tomorrow to watch this video :D

[@excelisfun]

That sounds like fun, Pavan! Thanks for your support : )

[@malcorub]

Me too, Excelisfun has inspired many of us to play hooky from work tomorrow.

[@excelisfun]

@@malcorub Nice!!! But hooky by you will give great benefits to your employer : ) ; )

[@ljubicar1987]

Can't find the words to compliment this and other videos from your channel, and the effort you put when trying to explain things. Thank you!👏 🤓

[@excelisfun]

The effort is worth it if it leads to more understanding : )

[@mattschoular8844]

Thanks Mike. Awesome again. Just like Die Hard 2, Die Harder... The sequel was as good as the original. This video is is as good, if not better than MSPTDA 15. Great work.

[@excelisfun]

Together they rock!!!!! Thanks for the great Die Hard simile, and thanks for the support, Matt!!!!!!

[@sequa74]

Indeed a very comprehensive Power BI video. Thanks a lot Mike

[@excelisfun]

You are welcome, sequa74!!! Thank you for your support with your comment, thumbs up and Sub : )

[@olubukola7895]

thank you for this excellent video Michael. I haven't stop watching. It is so detail, clear, relevant and on point. It is exactly what you called it -comprehensive example. You're such a great teacher - i know this as I've followed through your excel videos and learnt so much. Though it's a lot to follow and grasp from this, it is worth it. You made power BI fun and enjoyable for me. You just made it so easy and fun. I always look forward to listening and learning from you. Thank you so much. i highly recommend this video.

[@excelisfun]

You are welcome for the clear and to the point videos, Olu!!!!!

[@ahmedal-dossary4386]

What a video Mike..!!! Lots of world class tips and tricks that might take an individuals months to figure out and understand. I installed Nov update and didn’t see the new relationship view pop-ups. I had to go Microsoft page to figure this out. Thanks for raising this and directing me to the right channel. Continue changing the world as Power BI Desktop Does 🌷🌷

[@j.daniel7902]

Unbelievable !! This Guy is Goooooooood....

[@excelisfun]

Glad you like it, J. Daniel!!!

[@cmaman1]

Another Epic Video. Thank you, Mike 🌝🏆🥇

[@SyedMuzammilMahasanShahi]

Been waiting to hear from you for so long. Yet another EXCELlent video by amazing Mike. Thank you so much Mike.

[@excelisfun]

You are welcome so much! I have been waiting to post for so long!!!!! Thanks as always for your great support, Syed : ) : )

[@surajv]

Another great video. I see you tried to catch us out with Average Daily Gross Profit measure. but that made us think and create one rather than just following and copying.

[@crispylamp286]

You are just too good. I have been following along from excel. nice work God bless you

[@excelisfun]

Glad this helps you, Crispy Lamp!!!! BTW, cool name: "Crispy Lamp" ; )

[@thejebusite]

Thank you seems too simple of a word to express my gratitude for the effort, and work, you put into making this video, and all supporting documents. Amazing sounds a little better, but still falls short. I am exceptionally and perpetually thankful to you. Point and purpose of KZbin, right here!!!

[@excelisfun]

You are welcome! Thanks for your words. You choose great words, Morck!!! Thanks for the support on each video with those comments and thumbs ups, and of course your Sub : )

[@chrism9037]

Mike, just sat through this. Beyond epic!!! Great job

[@excelisfun]

Sat straight though? I hope you hit pause and tried some of the tricks! Thanks for the support, Chris : )

[@chrism9037]

@@excelisfun I sure did. Had the split screen going and stopped several times to make sure I was getting it, Awesome!

[@excelisfun]

@@chrism9037 Nice!!! Split screen... I still have not gotten there even though the default setup at my work is two screens for all employees because I am just too fast with the Alt + Tab to get to whatever window I want. One of these days I will have to upgrade : ) Glad it was awesome for you and thanks for your amazing support : )

[@williamarthur4801]

I'm with you, I find the formatting a bit confusing when you first come across it. I'm used to it now but still type my own stuff in a line but try to format if posting a question.

[@amerfarooq1142]

Excellent sir Mike You gave us superb fun to play numbers

[@gentle2005phir]

Starting music gives goosebumps, lecture addictive, you champ !!!

[@excelisfun]

Yes!!! Me too - I love the song and making this class : ) Glad you are liking everything, Gentle Raj!!! Thanks for your support on each video : )

[@NoShadowOfDoubt1]

This video, PDF files and work files are all amazing, truly ...amazing.

[@enriquedominguez9709]

Thank you Mike, great gift for Sunday, I will see it right now.

[@excelisfun]

Yes! Sunday fun!!!!! Thanks for the support, enrique!!!!!

[@ljubicar1987]

This was truly an epic video! It's so exciting when it comes to the data visualization power of BI.

[@excelisfun]

Truly. Interactive Publishable Visualizations are the best : )

[@joseblazquez2178]

I have said this before and will say it again: --Your work is fenomenal!!

[@excelisfun]

Glad it is "fenomenal" for you, Jose!!! Thanks for the support with your comment, Thumbs Up and Sub : )

[@victorcantu6461]

Thanks for the video. I am starting to immerse myself in Power BI and your videos are definitely helping me.

[@excelisfun]

Glad that are helpful!!!!

[@maheshallu6196]

Amazing, appreciate ur relentless efforts to update our skills.

[@excelisfun]

You are welcome, Mahesh!!!!! Thanks for your support : )

[@Sami-oy9le]

It is so amazing to see the power of Exel/Power BI! Thank you for sharing!

[@excelisfun]

You are welcome for the post, Samuil!!!

[@zt.5677]

Dear Mike, I was hoping that you still have this super Power BI video because I need to use Power BI in an SQL project. Thank you for still storing the video.

[@excelisfun]

You are welcome, M. SZ.!!! Here is an even more recent one: kzbin.info/www/bejne/aHvPYnp7hK17jaM

[@zt.5677]

@@excelisfun Great. Thank you!

[@Adurability]

Thank you for your selflessness, relentless effort

[@AdamZuk1982]

Another amazing material ! Thanks a lot.

[@excelisfun]

You are welcome a lot!!!!

[@davebowman5392]

Thank you MIke, was hoping this was coming!

[@excelisfun]

You are welcome, Dave! It just took so long... to create all the material... so I was hoping I could get it out too : ) Thanks for the support!

[@DIGITAL_COOKING]

Epic series (with bonus Epic video about power bi desktop)

[@excelisfun]

And... in this class as we move forward, we will move back and forth between Excel Power Pivot and Power BI Desktop : )

[@fabryespejo2697]

Gracias!! Por compartir tus conocimientos! Para mi sos el Maradona! Excel. Power query. Bi etc. Muchas gracias!!!

[@excelisfun]

You are welcome, fabry!!!!!!! Thank you for your support : )

[@althurmonang4645]

Insightful, and interesting from start until the end!

[@excelisfun]

Glad you like it, Althur!!!!

[@clairezhang7351]

Hi Mike, I can't thank you more for your help with Excel. It is very useful indeed. Wish you all the best.

[@excelisfun]

You are welcome, Claire!! Thanks for your support with your comment, thumbs up and Sub : )

[@davideferrari9333]

I thank you very much for all the shared classes. very very appreciated. in the homework instruction you suggest to calculate "Rolling 12-month Average for Transactional Sales". Actually, the results in the finished file calculate, in the "Rolling 12-month Average for Average Daily Sales". I hope could be useful

[@4sujik]

awesome video.. fantabulous teaching..Mr.Mike

[@excelisfun]

Glad you liked it all, 4sujik!!!!

[@13lila]

Food learning from great teacher,

[@johncatsicas101]

Thank you, Mike for your generosity in sharing your knowledge - you are good man and God bless you and your family. Merry Xmas

[@excelisfun]

You are welcome, John!!!! Happy Holidays to you and your family!

[@liztrama]

Mike makes learning fun. I just love the introduction music, it makes me feel to juju on the beat!!!

[@excelisfun]

Thanks for your support, Liztra, and now I am feeling the juju on the beat : )

[@bulentdemir2148]

Great work as usual, thank you so much.

[@excelisfun]

You are welco,e!!

[@keepcalmuvlb5n]

These are EPIC videos ....Salute You Mike

[@excelisfun]

Glad they are epic for you!!! Thanks for your support, Vijay!!!

[@ismailismaili0071]

the video that we all were waiting for. astonishing job brilliant ideas thank you so so much Mr. Mike.

[@excelisfun]

You are welcome so much, Ismail!!! Thanks for your amazing support : ) : )

[@msantosh1220]

Thanks Mike, this video was very informative and power packed vid quality knowledge. Few of thing shown in the video can be directly applied to my workoperation. Awaiting 4 these video was worthwhile and you again have show us tat your d best of all excel masters. Please keep up d good work

[@excelisfun]

I am glad that the content of the vid can be directly applied to your work operation!!! Thank you for the support, santosh, with your comment, Thumbs Up and Sub : )

[@TaxMentors]

excellent sir !! This is very simple and easy to understand !!

[@871340730]

Yet another EPIC video! Such rich content! Thank you Mike!

[@arreeclay7097]

Professor Mike I like the linear view of the formula.

[@excelisfun]

Me too. But you and I are in the minority : ( Thanks as always for your support, Arree Clay : ) : )

[@Mark-bc9ib]

really love the work you do here with these videos. your the go to guy for all my excel learning, tips and tricks

[@excelisfun]

You are welcome for the go to stuff, Mark!!!! Thanks for supporting on each video with your Thumbs Ups and comments : )

[@LuciusSullaFelix]

Once again excellent tutorial Mike! You’re videos are helping me to develop my data analytic skill set.

[@excelisfun]

That is why I post: to help people like you to learn and improve!!! I love to hear that it is helping : ) Please throw the help back this way, too, with those comments and Thumbs ups on each video that you watch : )

[@baselbargothi3410]

Thank you Mike for amazing videos and powerful effort to give us a free learning

[@excelisfun]

You are welcome, Basel! It is my goal to do so, and when I get feedback from viewers like you it makes it all worth it : )

[@fmartinez004]

I greatly appreciate your Power BI insructional video and have learned so much compared to other Power BI videos. I took note step by step and found that the Ave Daily Gross Profit measure was not covered in the Power Query editor fTransactions field and was not available when you started creating the Dashboard. So I created the DAX forumla looking at the 016-MSPTDA-Excel file for Ave Daily Gross Profit as shown below. Ave Daily Gross Profit = AVERAGEX( dDate,[Total Gross Profit] ) measure in Power Query but the Total COGS $267,510.50 had different numbers than what is shown in the video when adding it to the values field in the Dashboard. Is the excel fact sheet source data using slightly different numbers? Please address this!

[@ZAHIDHUSSAIN-ri5kg]

Mike just see the notification early in the morning...will watch tonight Many thanks for sharing!

[@excelisfun]

You are welcome for the share! Thanks for your support with your comment and Thumbs Up BEFORE you watch : )