Power BI Dashboards - Non-Financial Data Analysis - FREE Download

[@MyOnlineTrainingHub]

Download the file used in the video here: www.myonlinetraininghub.com/workbook-downloads

[@abdullahazam1247]

Bundle of Thanks from the learners of Excel

[@prasadprabhakar1763]

I dont see the dataset file for this report

[@MyOnlineTrainingHub]

@@prasadprabhakar1763 Please follow the link above. Then read the instructions on that page.

[@samrajeh9076]

hello, which file ? you have list of files in the link and i tried to find the same name of the video in the link but i didn´t get it...

[@nurunnajwa3462]

@@samrajeh9076 Hi, you can download the Power BI Dashboards - School Data Analysis. It has the same data as in the video.

[@randaburaideh4905]

Out of all the Power BI tutorials I have been watching for a month, this one is literally the best! You are really good at this . Thank you

[@MyOnlineTrainingHub]

Wow, thanks!

[@mustavogaia2655]

I heve barely no use for that in my everyday, but this video is more entertaning than some movies I've seen recently.

[@juanlopez4033]

Not sure why you got 6 thumbs down but this is great. I was not able to get the map chart to mimic yours. Went to formatting and looked for states but no option available to select state. Just shows a picture of the whole world.

[@MyOnlineTrainingHub]

There's always going to be haters :-) I think you've selected the wrong map visual. There are two map visuals...it'll be the other one.

[@kankitpumcharern7274]

This is so simple and easy to understand. Only thing i need's how to determine what data I should put in to create a chart.

[@MyOnlineTrainingHub]

Glad it was helpful, Kankit :-)

[@markobe08]

you didn't get the error on 14:21 when using this syntax for setting list of numbers?

[@santiagogonzalez9797]

Hell dear Mynda, i would like to make you a question: Why to use dimensional tables instead of directly link the original tables (students, staff and schools) ?

[@MyOnlineTrainingHub]

Because it's better to have a many to one relationships where possible. If you related the fact tables to each other they would use many to many relationships.

[@santiagogonzalez9797]

@@MyOnlineTrainingHub OK Mynda, i forgot the golden rule for relational models (1 to many, not many to many). Thanks again!

[@graphguy]

Great to see work outside of financials. Sure business is a big consumer of BI, but there is a another world out there that uses it also.

[@MyOnlineTrainingHub]

Glad it was helpful :-)

[@s1ngularityxd64]

Awesome. So much inspiration. I tried to replace the hard-coded columnnames with a unique list of columnames in order to make it "dynamic", it works but now my query needs like 30min to load data - any tips? ☺ I would like to know what's going on in the backround. Do those drilldowns have so much workload?

[@MyOnlineTrainingHub]

Hard to say, but this thread has some Power Query performance tips: www.myonlinetraininghub.com/excel-forum/power-query/any-way-to-speed-up-really-slow-refresh-times-in-power-query

[@s1ngularityxd64]

@@MyOnlineTrainingHub Thank you so much

[@shoppersdream]

Thank you! I have watched only up to 14 minutes and it took me more than an hour. Your Screens were very blurred. I wish you had zoomed them. I could not even see when you created a blank query what did you enter =(2008..2018) I could not figure it out. It kept giving me errors. Looks like it is good stuff but it was no so blurred. Thanks

[@MyOnlineTrainingHub]

Sorry about that. It sounds like something up at your end as it shouldn't be blurred. This is an old tutorial now anyway, better to watch a more recent one like this: kzbin.info/www/bejne/kGPXaJ9ul5aojbc

[@ibrahimlucky3366]

Will the dashboard respond if the data source changes? or you have to build new dashboard anytime the data source changes. anyway thank you for the video

[@MyOnlineTrainingHub]

You can edit the data source to point at a new source and the reports will update accordingly as long as the new source has the same column headers etc.

[@ibrahimlucky3366]

@@MyOnlineTrainingHub Ok thanks a lot

[@joseluismartincenjor8409]

Mynda thank you very much, mind blowing professionalism in your videos. Two inquietudes though: - I've added up all the student numbers in the 2009-2018 Student *.csv files, and I come up with 47,2M? Maybe I'm adding the wrong data? - When I ask the first question about "sum of students", I get 309M instead of 66M. Any idea what I might have done wrong, probably relationships (I've also double checked these)? Definitely I'm doing something wrong ... Thanks for your help

[@MyOnlineTrainingHub]

Thanks, Jose! Keep in mind that this data is a snap shot of all staff at the end of each period. If you add it up you will get erroneous results.

[@ruzma]

@@MyOnlineTrainingHub and then? What do we have to do to get the 66M? I have exactly the same problem than Jose and I have followed what you did in your video. Also, in you PBI file, you have 5186 rows on the student table, where there is 5760 in the data files (csv) you posted. Maybe the problem is there?

[@Lin-nk4ph]

Thank you very much! I’ve just had the most valued 47 mins in the whole week by watching this video !

[@Kentucky-ev7bd]

This is ridiculous how awesome the potential is for this information. Just wow!! Great job!!

[@Kentucky-ev7bd]

You are seriously good. Right now I'm searching the web for an practice-based Excel / Power BI / Access tutorial to take me through simple to advanced concepts as I realized my skill-sets have been left in the 90's. From my first assessment of all the stuff out there, your programs and approach is the best so far. I really liked the data to executive reports approach with multiple pivots and whatever else in between, without the basic fundamental Learned more this way watching your than a dozen individual skill based programs. Very very nice! Thanks again!!

[@Kentucky-ev7bd]

Do you have a LinkedIn page I could share?

[@adriannacook313]

YOU ARE JUST AMAZING!!! I have been doing some research about power bi to see if it will help with the needs of my work, then I found your video, looooove this straight away! Thank you!

[@MyOnlineTrainingHub]

Great to hear you're excited about using Power BI :-)

[@hussammohamed9205]

hey its really awesome video can you please put link for CSV file because when i try to access SharePoint folder i got authentication error

[@chrisbenn]

Sorry but I do not understand... We are supposed to use the downloaded file instead of following what you do in the video? (Getting the data from the Sharepoint folder)?

[@MyOnlineTrainingHub]

Hi Chris, you can download the files and save them to your own SharePoint folder, or a folder on your PC/network where you can then reference them for practicing.

[@chrisbenn]

@@MyOnlineTrainingHub Ok... Thank you! :)

[@sandeepreddy7687]

Hi Mynda, Thanks for the Webinar. This webinar gave me enough confidence to start with power BI. However, when I was trying to check the downloaded files used in the Webinar the link was unable to open. Could you please check and sort it out. Thanks in advance.

[@MyOnlineTrainingHub]

Thanks, Sandeep. You need to enter your email address to reveal the download buttons on the file donwload page. Enjoy Power BI!

[@menthu3004]

Hi, I wonder why the staff column and the student column use decimals and not integers?

[@merryhongmei3461]

Hi, I cannot find the data of this video in the link you provided. could you please advise? Thanks!

[@abheetnigam]

What is the logic behing creating three seperate dim tables rather than directly going ahead , please explain if possible

[@MyOnlineTrainingHub]

Structuring your data in this way enables Power BI to more efficiently compress, aggregate and visualise your data. Dim tables allow you to significantly reduce the amount of data in your database.

[@Salmankth]

One of my favourite tutors of Power BI, super thanks for the videos!

[@calvinc851]

It always makes me chuckle to hear your dislike of pie and donut charts. Great video!

[@MyOnlineTrainingHub]

Glad you enjoyed it, Calvin :-)

[@geog272]

Thank you for the video. Could you demonstrate how to do YOY change with a datset like this? For example, what if you wanted to show the YOY change (as %) in number of students.

[@sigit3kuncoro529]

Hi... Tracy... Thx for your explained to us. God bless you. 😊

[@leonardbekker1524]

Absolutely brilliant! I learned so much in this video and it's persuaded me to pop to your website this evening to check out your PowerBI course. If this video is a reflection of what your course will be like then I'm going to enroll ASAP.

[@MyOnlineTrainingHub]

Great to hear, Leonard! Looking forward to teaching you a whole load more in my course.

[@snehasinghal2325]

You are definitely the best Trainer I have come across so far on KZbin !!

[@MyOnlineTrainingHub]

Wow, thank you!

[@gunesdemir4038]

Hi Tracy I have an question about your desktop file .I can not see data which you use the edit in power querry though I downloaded file

[@MyOnlineTrainingHub]

Hi Gunes, There are several files and folders in the zip file. Are you sure you extracted them all?

[@gunesdemir4038]

@@MyOnlineTrainingHub Yes I had the file you sharing in this video . Maybe I get again and carefull seesight 😇 Thanks .

[@balimarc1554]

HI Myanda, What version of BI do you use for it, Files asking new version of BI, Mine is 2018

[@MyOnlineTrainingHub]

I can't remember what version it was at the time of recording, but you should always use the latest version, especially since it's free to download.

[@nagch6401]

Such a wonderful session ...been searching for a good overview of PBI video for long now....best video I came acrosss....

[@nicolamasoero2512]

Hi! is it possible group data efficently in PowerBI without adding column or measures? For example by range of products: 0-10$ / 11-20$ / 21-30$ / >31$? And order them on an istogram maybe? Thanx for all your contents!

[@MyOnlineTrainingHub]

Hi Nicola, Yes, click on the ellipses in the visualisation gallery and search for a Histogram in the custom visuals list. There is one available from Microsoft. To modify the bin sizes, add your field to the visual fields and click on the drop down arrow beside the field name you want to group > choose 'New Group. I hope that points you in the right direction.

[@junaidmalik9593]

That was simply amazing !. i had never worked with data saved on share drive so that was one great experience! , i feel quite confident now . thanks so much for every thing but special thanks for doing it from scratch. u r my inspiration now :)

[@MyOnlineTrainingHub]

My pleasure! Have fun with Power BI :-)

[@vdn5716]

Waiting for your course on udemy...best work...Thanks

[@MyOnlineTrainingHub]

Thank you. My courses are available here: www.myonlinetraininghub.com/

[@geeves21312]

I do not have the "SHAPE" option under formatting for changing from USA to AUSTRALIA, as seen at 21:38.. was there an update? I noticed the layout from my recently-downloaded version of PowerBI Desktop is a bit different to what is shown in this video..

[@MyOnlineTrainingHub]

Yes, there have been many updates since this video was recorded. Power BI is updated monthly! That said, I have the latest version and 'Shape' is still there. I think you have inserted the filled map instead of the shape map. They are slightly different icons in the Visualizations pane. Hover your mouse over them to see their names. Select the Shape map.

[@jeanfortes9239]

Thank you for this wonerful video. may I know how did you add a count column? am doing the same, however, am getting a different result. :(

[@MyOnlineTrainingHub]

My pleasure, Jean! I'm not sure why you're getting a different result for your count. Is it possible that my count doesn't include the 2018 data yet, but yours does?

[@jeanfortes9239]

My fault. I forgot to place a count column. Now am done with my report. Thank you so much for your video, it is truly helpful 😊

[@angelayen4943]

Hi Mynda, Indeed it is a great webinar. I have learned so much. I have downloaded the file from your website to try it out myself. I notice that some of the setup in your Power BI file are different from those of mine namely for the map ie the colour scheme. In my Power BI, the selection of color does not have green. Also, for my Power BI, there is no section for Shape too. For the map I can't seem to find where is the button to remove the colour of the sea so that the map can stand out. Also, the filter, I can't seem to get the 2 pointer filter for the year but instead I get mosaic style for the filter. Is this something to do with Power BI pro or is there some setup I need to do in Power BI free version to get these functions like what you have in your Power BI?

[@MyOnlineTrainingHub]

Hi Angela, great to hear you're giving it a go yourself. It sounds like you may have chosen a different map visual. There are more than one, so you might want to check that.

[@angelayen4943]

Hi Mynda, where do I find the selection of different map visual? For the set of standard green colours, mine just doesn't have it, not even for the bar chart. Of course I can get green from the "custom color" but it is not the same. Do you know where I can go and get the set of standard green colours? Or is it something to do with the download and setup of Power BI - that I have a different data colour set and map layout? Thanks so much

[@chrisbenn]

Is there any way to use your layout of the user interface? :-) It seems so many things have been moved or/and changed? like, the "Ask a Question" button is not under the "Home" tab anymore but is under "Insert" and is renamed to "Q&A"? I hope... And I do not have the visualization "map" as you are adding in the video. I only have "Map", "Fill Map" and "ArcGIS Maps for Power Bi" Hope someone can help! It is really confusing! :-/

[@MyOnlineTrainingHub]

Hi Chris, I'm not aware of any way to roll back to earlier versions of Power BI unless you happened to keep a copy after downloading it, which I didn't, sorry. The changes to the interface are confusing, but this is the world of SaaS that we live in now. On the up side, we get the latest and greatest developments every month instead of every 3 years.

[@chrisbenn]

@@MyOnlineTrainingHub Thank you for the reply! :) Yes, I can see what you are saying. I was thinking it was a "saved work layout" or something that you can do in some programs! But I did not think it was updates that had changed the program! I was just having so much trouble figuring out the "equivalent" to the elements you used in the video but I think I got it "ok-ish" in the end! :) Really liked this video and what you thought me thought the video! :) Thank you!

[@imosam1230]

Hello, thank you as usual for your well concise and structured lessons. I have an issue with the 15th minute. Joining the year from the blank query to that of the school table. Please can you explain that further, or do I have to creat a query from the school table for the Dimdates. Because if I creat6 from the school's table, the year starts from 2009. Thank you

[@MyOnlineTrainingHub]

Not sure why I created the manual year list at 2008. The data starts in 2009, so creating a year table from the Schools table would be fine.

[@imosam1230]

@@MyOnlineTrainingHub Thank you

[@kenny89lvm]

Hey Tracy, was wondering if you could do a PowerApps in the future? Thanks! No one else quite explain it like you do :)

[@MyOnlineTrainingHub]

Thanks, Ken! Maybe ;-)

[@iqbalali8500]

Hey Mynda great dashboard, just one question..why your canvas area on BI looks much wider as compared to mine in laptop. I set page size as Width = 1400 and Height = 800, still your screen/canvas looks much wider, any tips.

[@MyOnlineTrainingHub]

I have a widescreen monitor at 1920 x 1080 resolution, so I can fit a lot into my screen.

[@abidurrahmanabir7745]

Dear can you plz share dataset? Waiting to hear from you.......

[@MyOnlineTrainingHub]

Please follow the link in the video description and then on that page, enter your email address to reveal the download links.

[@abidurrahmanabir7745]

@@MyOnlineTrainingHub Ohk Dear😢😔

[@petrospsichis9302]

Hi, unforunately I cannot find any downlodable file from this video. Can you please help ? Thanks

[@MyOnlineTrainingHub]

The link is in the video description. Please read the instructions on the page. If you don't see the download icon, try using a different browser.

[@michaeljans5971]

Hi Mynda, I love your tutorials a lott. For this one I can't download the files... '504 Gateway Time-out' is it posibble to download the files from anywhere else?

[@MyOnlineTrainingHub]

Hi Michael, I think our site was down for a short period. It's back now. Please try again.

[@michaeljans5971]

@@MyOnlineTrainingHub Hi Mynda, it works now! Thx!

[@Fiktage]

Thanks for the video! Your % of Total is not correctly displayed. And I have one question, how to manage Sort Order column you created by adding conditional column if we will have a total new item? Just simply add index?

[@MyOnlineTrainingHub]

Ah, yes I needed to fix the alignment so the % of Total header text is correctly displayed. If you added new sectors then you'd have to edit the query and add another nested 'if' statement to the conditional column formula.

[@samrajeh9076]

hi, put you import from the share point all the data of (schools, staffs, students) but in the excel files just i can upload one excel archive and i can´t do what you are doing in the first in dataset, so could you explain how to solve it ?

[@MyOnlineTrainingHub]

Getting data from SharePoint is explained here: www.myonlinetraininghub.com/get-data-from-onedrive-or-sharepoint-with-power-query

[@renasahmed5477]

Thanks Mynda for the great tutorial, A big thumb up.

[@chrispacho5043]

thx a lot for your guidance , very instructive, clear and common sense same time , good job !

[@DataBeach]

Impressive delivery. Thanks.

[@MyOnlineTrainingHub]

Glad you liked it!

[@DataBeach]

@@MyOnlineTrainingHub , I recently made a career switch to a role where I use Power BI for most of my deliverables. I've watched lots of videos on many channels. I must admit your delivery was straight, precise, easy to follow, detailed and refreshing. I learnt new things. I'll surely watch other videos on your Channel before the end of the week. Keep it up.

[@adriennwinter1202]

thank you for your support with Power BI

[@MyOnlineTrainingHub]

My pleasure, Adrienn :-)

[@juanlopez4033]

My PowerBi desktop is different from yours in that I see more icons on the menu. I cannot find "Ask A Question" icon in my menu / How can I get all the icons on the powerbi desktop menu?

[@MyOnlineTrainingHub]

Hi Juan, Power BI Desktop is updated every month, so the version you see in this video is likely to be a bit different to what you see in the latest version. You'll find Q&A on the Insert tab of the Power BI Desktop ribbon.

[@juanlopez4033]

@@MyOnlineTrainingHub Thank you. I couldn't figure out how to get the Q&A on the menu although I have latest version of the desktop. I think I just looked for the icon on right side of Visualizations section. But thank you, I really appreciate your prompt response.

[@Deepak_Singh1008]

Hello would appreciate you if you make a small video on Excel VBA iif function.

[@MyOnlineTrainingHub]

Noted.

[@deeperholiness996]

Can you put all your Power BI Teachings in a Textbook? I love your Teaching Methodology. This Teaching will reach far audience if powered by a Textbook as most people especially in the African Nation which is the new market have limited access to Internet. The Cost of Internet service is very high.

[@MyOnlineTrainingHub]

That's a great idea! I wish I had time to do that too :-(

[@jessicasoh1430]

Hello and thank you for the video, can't seem to access the thousand separator/properties in the relationship tab? Checked and it's not collapsed or hidden, help?

[@MyOnlineTrainingHub]

Hi Jessica, one way is to go to the table view > click on a numeric column. This will open the Column Tools tab in the ribbon where you can set the formatting.

[@jessicasoh1430]

@@MyOnlineTrainingHub Thank you! Amazing, trying to replicate this as part of my HR work

[@jueroe3753]

Thank you, very clearly stated, how can I ever repay you for that?

[@MyOnlineTrainingHub]

Please share it with your friends and colleagues, Jue :-)

[@serigamel]

I dont know how and why, but the Formatting option under Properties has suddenly gone missing after I changed the formatting for Staff at @18:08 and pressed enter

[@MyOnlineTrainingHub]

Not sure why that would be. Have you tried scrolling down to see that it isn't just hidden lower down in the pane?

[@chevasflorian4055]

Thanks for your video. It was very clear and useful. I would say that your channel is one of the few which provide good advice and top educational information. I going to see more videos. Bye.

[@MyOnlineTrainingHub]

Wow, thanks, Chevas!

[@sankeshsankesh.sawang196]

You are doing a great job for us thanks Maam

[@MyOnlineTrainingHub]

It's my pleasure :-)

[@johnborg5419]

Thanks Myndy. This video is an intensive course on its own!! Thanks Again : ) : )

[@MyOnlineTrainingHub]

You're so welcome!

[@wissemkhenissi2724]

It's a Great Job! Could we have/download a copy of this PBI work ! Thanks :)

[@MyOnlineTrainingHub]

The link to the download page is in the video description.

[@piyushdewan7102]

is it possible for you to share the CSV files?

[@MyOnlineTrainingHub]

The link to all of the files is in the video description.

[@dheerajsukhwal592]

I am getting a blank value in sector and bcoz of that my donut or pie charts r not getting separated by sector. Although i can see values in sector when i navigate to data tab.

[@MyOnlineTrainingHub]

Hi Dheeraj, it's difficult to troubleshoot in the video comments. If you want to post your question and file in our Forum we can try to help you further: www.myonlinetraininghub.com/excel-forum

[@thaonguyenphuong4580]

Thank you very much! Extremely useful and detailed!❤❤❤

[@MyOnlineTrainingHub]

Glad I could help 😊

[@thaonguyenphuong4580]

@@MyOnlineTrainingHub I have learnt a lot from your tutorials for the last 2 years. I try to download the school data files for my practice but I cannot. Could you please help?

[@harshalbonde9766]

Loved it! thank you.

[@MyOnlineTrainingHub]

Great to hear 😊

[@markobe08]

when I want to set list of numbers = (2008..2018) gives me "Expression.SyntaxError: Token RightParen expected." error...

[@MyOnlineTrainingHub]

You need curly braces around the dates like this: ={2008..2018} not parentheses.

[@merryhongmei3461]

Sorry, I got the file now. I thought I could get the raw data so when I am watching your video I can mimic you. the file I downloaded is not the data.

[@MyOnlineTrainingHub]

The raw data is included in the download file.

[@TheTravellingKat]

Thank you so much! Amazing webinar!

[@MyOnlineTrainingHub]

Glad you enjoyed it, Katt :-)

[@Crow2525]

Amazing resource. I love your videos.

[@mohamed.montaser]

why staff in the 2 bar charts one with percentage and one with actual value, i don't get it

[@MyOnlineTrainingHub]

Not sure which bar charts you're referring to, sorry. Perhaps you can download the Power BI file from the link in the video description and that will clarify the different charts.

[@godlikewings2314]

Excellent video 10/10. #qualitative data

[@MyOnlineTrainingHub]

Thanks so much!

[@nurulasyikin1895]

It really helps me. Thank you so much.

[@MyOnlineTrainingHub]

Glad to hear that!

[@SanjeevSingh-rj3bj]

Thank you for such a good explanation.

[@MyOnlineTrainingHub]

Glad it was helpful!

[@mihir325]

Excellent Videos as always.

[@sherlypuspita3055]

Hi Myanda , thank you very much . Love it !!

[@MyOnlineTrainingHub]

Glad you like it, Sherly :-) Have fun with Power BI!

[@Broadmoore]

Amazing. Thank you for this wonderful tutorial!

[@yulinliu850]

Thanks for sharing!

[@magieemballage19]

Merci beaucoup pour ce tuto

[@jamesdean2706]

Love it!, thank you.

[@sweenseli3399]

Unable to find the datasets for power bi

[@MyOnlineTrainingHub]

Follow the link in the video description (here it is again: www.myonlinetraininghub.com/workbook-downloads) and then read the instructions on the page. You'll find the Power BI files are towards the bottom of the page.

[@mayker7]

Thanks!

[@Nkraka]

Thank you so much

[@NanaDaisy-e1r]

brilliant，thank you for sharing this～～❤

[@MyOnlineTrainingHub]

Glad you liked it!

[@themightyvk]

Grt job.....

[@excelman8026]

nice video super

[@MyOnlineTrainingHub]

Thank you!

[@kama297]

Excellent, as always, thank you so much!

[@MyOnlineTrainingHub]

Thank you, Ka :-) Have fun with Power BI! Mynda

[@wajdimatoussi]

Thanks a lot