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.
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.
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 !
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!!
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 !!!
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
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!
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 :)
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!
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.
@@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.
@@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 Hi Mynda, I didn't figure out how to upload my file, So I will try rephrase my question, each month, there will be over 100 items purchase as products materials. and in order to analyses the trend, power BI is used for the analysis of each month's data ; there would be multiple sort options to be needed, first, data will be sorted by months, then we would like to sort out the items by value in the current period to focus on the top 20 or 50 ones; and review their trends from the highest value item to the lower value ones; hope this is better to understand. The question is POWER BI can only sort out items by all periods' accumulated total value, and cannot sort the items out per any single period's value. Thank you
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 👍
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.
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: ua-cam.com/video/QKgS3hrrmvw/v-deo.html This is the same issue you're having, except for thousand separators.
@@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
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.
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
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.
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.
I studied Power BI for 5 months using a course I paid $40 a month for. This video is everything one needs to know about this application. I feel... flabbergasted.
Hi Mynda,This tutorial is really helpful, but because I am from Indonesia, the use of commas for thousand separators is a bit different since here we use "." instead of ",". So, there are some challenges when getting data, and I have to manually change it first in the CSV file. Overall, thank you for the tutorial!
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.
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!!!
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!
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 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.
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
Great to hear you liked this tutorial. Please read the 'READ ME FIRST' file you downloaded in the zip file with all the data files. This will explain why your numbers aren't the same and how to fix 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.
Thank you for explaining the reports in an eloquent manner. I downloaded the files and created the reports side by side watching your video. I had a bit of problem with the date ... turns out I have to set the date format to English (Australia), irrespective of what region you are in. I am in Canada
My pleasure, Gaurav. If you read the notes in the file called 'read me first' included in the zip file you downloaded you'll see an explanation for the date issue.
@@MyOnlineTrainingHub I did refer to the other video. U said change type to Ur local country date format one so I changed to English (canada) but it still captures till 12th Jan cause the format doesn't change. But don't worry about it, I figured out eventually that the it has to be for Australia country type only. Also, I watched the revenue analysis video. That was awesome too!
All of a sudden, I feel woefully inadequate! LOL! Have some studying to do, I believe. Fantastic video on how to put all that together and on to the server. Thank you for the enlightenment! :)
Also while importing "Actual data" in colomn "Date" PowerBI sometimes places the whole sring, e.g. "1/01/2020,Administration,External Labor,United Kingdom,""1,754"". In the same time most of data importing well.
Thank you for this tutorial, it was really explanatory and I tried to replicate it with the file. I still have a long way to go to become an expert and your tutorials have been helping with that 🙂
This is a very good workdone.I love it, i decided to practice your tutorials step by steps but it appears using the inbuilt AI Q&A to display the Chart on Actual vs Budget as gauge returns a blank chart.Any help?
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
Hie Mynda, I was tasked to learn Power bi and your video was my first stop. I am very happy with your training, its exceptional. I got stuck the on line charts graphs around (17mins). I can not seem to get the line chart to appear in months, it only appears in days and years. Could you assist me? Thanks
Great to hear. Not sure what's up with the line chart, but I suspect the date hierarchy ins't correct in the axis field. Perhaps try building it again.
@@MyOnlineTrainingHub I started everything from scratch and I am still having the same problem. Did you update your data? I noticed when placing the commas in your actual column (11.12mins), your starts from March whereas mine from January. My gauge reading of the actual vs budget is 145m ranging from 0 to 289 which is far different from yours. By the way I re downloaded the files, so now I more confused, could you please help me figure out the error? thanks
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.
Thank you for this wonderful video, it helped me a lot, can you put the database in the description to practice the manipulation using the exact data, because i can't find any data online
Great work u save lot of time i saw lot of report they take more then one hour to make and learn nothing to much 😂 your work is outstanding there i want to ask your that how much time require to make expert in power b.i from zero to expert.your reply will be valuable for us.
So pleased my video was helpful 😊 how long to become a Power BI expert is different for each person because it depends on your existing experience, how quickly you learn, and most importantly, how much work you put into practicing. It could take anything from a few months of intensive training to years. I’d err on the side of years for most people 😉
@Ian-gf8id Glad it was helpful! @sadeghvn2331 great to hear you're planning on learning Power BI. You can take my course here: www.myonlinetraininghub.com/power-bi-course All my course members have support from me personally allowing them to ask questions and get help while they're learning and implementing the techniques in their own work.
Hi dear, can u define some most important visual, that how to use correctly or where should we put actual, budget, %ach in which axis or legend in kpi card, line, column, area, card(new), etc. I have learned so much from your videos i need some more basic skills to make my actual vs sales presentation.
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.
Thanks so much for your kind words and support, Jin!
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.
Wow, thanks for your kind words, Victoria!
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 !
Congratulations on your success with Power BI, Diana! Great to know I could help.
Congratulations!!!
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!!
Thank you so much, Rodion! 😃
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 !!!
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
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!
Glad it was helpful!
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 :)
Awesome, thank you, Catalin!
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!
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.
@@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.
Very clean, no repetition and many interesting hints included. Will look for more complicated topics explained in this channel. Good job! Thanks!
Glad you liked it 😊
This is the clearest and most simplest training instructor I've seen. Really love her content. Please keep it up! :D
Wow, thank you! 🥰
@@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 :)
Wow! Congratulations on your success!
Hi Mynda. Looks like a great training. Looking forward to walking through it in depth with the data files. Thanks for sharing. Thumbs up!!
Thanks for your support, Wayne!
@@MyOnlineTrainingHub pls share the link to download
I have bookmarked this Video for future learning. I am a beginner in PowerBI. Thank you for the lovely illustration
Glad it was helpful!
One of the best starting videos for new PBI users. Thanx a lot, Mynda!
Glad you enjoyed it!
Thank you for getting back to me , Mynda. Let me figure out how to upload the file. You have a good day！
No worries. And you 😊
@@MyOnlineTrainingHub Hi Mynda, I didn't figure out how to upload my file, So I will try rephrase my question, each month, there will be over 100 items purchase as products materials. and in order to analyses the trend, power BI is used for the analysis of each month's data ; there would be multiple sort options to be needed, first, data will be sorted by months, then we would like to sort out the items by value in the current period to focus on the top 20 or 50 ones; and review their trends from the highest value item to the lower value ones; hope this is better to understand. The question is POWER BI can only sort out items by all periods' accumulated total value, and cannot sort the items out per any single period's value. Thank you
This is amazing. So simple to follow and execute, even with what I’d characterize as moderate (at best) Excel skills. Thank you!
Glad it was helpful!
I learned so much ... thank goodness its the weekend so I can relax and reflect on it
Great to hear!
Excellent tutorial. Appreciate your approach to pacing and content leveling, thanks!
Great to hear :-)
@@MyOnlineTrainingHub share with me some files or books to use
If you want to learn, watch this video. Thank you Mynda, you are superb at what you do.
Thanks for your support, Jamie! 😊
I'm Abdulai from Ghana
How do I access your documents to practice ma'am
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 👍
Glad you enjoyed it, Saleh!
Your videos are the gold standard. UA-cam should direct everyone to you and save a lot of wasted time elsewhere!
Thanks so much 🙏
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.
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: ua-cam.com/video/QKgS3hrrmvw/v-deo.html This is the same issue you're having, except for thousand separators.
@@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
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.
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
So happy to read that! Thank you for your kind words of support 😊
No question but only a thank you for your continued services!
I appreciate 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.
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.
I don't usually like to comment, but when I do it's for an amazing tutorial like yours. Excellent presentation!
Wow! Thank you, Mesfin 😊
most clear and clean tutorial. no non sense straight to the point and topic. i loved it
Thanks so much!
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.
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.
@@MyOnlineTrainingHub Thank you, please keep educating us.
this is one of the best tutorials i have watched
Wow! Thanks so much 😊🙏
Mam, Your explanation is very clear and one of the best video on Power BI and excel in UA-cam thank you .
Wow, thanks so much, Vijay!
the best power bi presentation and expanation I have witnessed so far !
Wow, that's awesome to hear!
You taught me power query now you're up to this... TYSM. You're amazing.
Thanks so much 😊
Wow ... nice tutorial and very smart lady ❤❤❤❤❤
Thanks so much 🙏
I studied Power BI for 5 months using a course I paid $40 a month for. This video is everything one needs to know about this application. I feel... flabbergasted.
So pleased this video was helpful to you!
Half-way in, great so far! Thank you
Awesome to hear 😁🙏
Love the way you present these..
Thanks so much!
Very concentrated and effective course
Glad you think so!
Thank you for this free course!
Our pleasure!
The IA is stunning!
The IA?
@@MyOnlineTrainingHub Inteligencia Artificial - IA, jajaja that happens to me sometimes
Oh, we call it AI in English :-)
Simply perfect! Thanks a lot Mynda!
Thanks so much 🙏😁
Hi Mynda,This tutorial is really helpful, but because I am from Indonesia, the use of commas for thousand separators is a bit different since here we use "." instead of ",". So, there are some challenges when getting data, and I have to manually change it first in the CSV file. Overall, thank you for the tutorial!
In that case, you can use Change Type > Using Locale as explained here in the context of dates: ua-cam.com/video/QKgS3hrrmvw/v-deo.html
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.
Great to hear, Maiara!!
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!!!
You are so welcome, Muhammad!
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!
Great to hear, Bob! Have fun with Power BI :-)
Madam you rocks . GOD BLESS YOU 👌😊
Thanks so much 😊
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.
Great to hear! DAX to come 😉
@@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.
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
This video helped my learning so much. Thank you.
Awesome to hear 😊
Thanks Mynda for this amazing video
I followed all steps but the numbers aren't the same.
Great to hear you liked this tutorial. Please read the 'READ ME FIRST' file you downloaded in the zip file with all the data files. This will explain why your numbers aren't the same and how to fix it.
How I wish you had more Power BI videos!!
Working on it :-)
Simply the best. Better than all the rest!
You will get me a raise 😂
Glad I could help 😉
The decomposition tree is new to me..very helpful.
Could you do an analysis for a snagging company or construction data sets❤❤
Glad it was worth your while. I don't have any construction datasets, unfortunately.
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.
Glad you found it helpful!
very informative tutorial, clear and simple, thank you
Glad it was helpful!
Thank you for explaining the reports in an eloquent manner. I downloaded the files and created the reports side by side watching your video. I had a bit of problem with the date ... turns out I have to set the date format to English (Australia), irrespective of what region you are in. I am in Canada
My pleasure, Gaurav. If you read the notes in the file called 'read me first' included in the zip file you downloaded you'll see an explanation for the date issue.
@@MyOnlineTrainingHub I did refer to the other video. U said change type to Ur local country date format one so I changed to English (canada) but it still captures till 12th Jan cause the format doesn't change. But don't worry about it, I figured out eventually that the it has to be for Australia country type only. Also, I watched the revenue analysis video. That was awesome too!
There must be a mismatch with your locale settings in PQ. Glad you got it working though.
Really help me so much. Thank you so much. Looking for advance Powerbi from you soon. A Million thank you to you
Happy to hear that!
Thank you! Clear, concise and extremely knowledgable presentation
Glad you liked it 😊
Thank You So Much. Its very helpful
Glad to hear that 😊
Thanks that was very useful
Glad to hear, Naveen!
This is so good
I’m following right now.
Watched through and now I’m following with the dataset. Amazing
Thank you
Awesome to hear!
very clear explaination and good teaching method !
Thanks so much, Mua!
awesome clear explanations
Glad you think so!
Thank you for amazing training!
So pleased you enjoyed it!
Keep going... Great training.
Thank you, I will :-)
All of a sudden, I feel woefully inadequate! LOL! Have some studying to do, I believe. Fantastic video on how to put all that together and on to the server. Thank you for the enlightenment! :)
😁Glad it was helpful!
You got a subscriber here. Excellent work !!
Awesome, thank you!
Excellent tutorial Mynda - many thanks
Glad you liked it 😊
Mynda is super lady her explanation is amazing ...Keep making more dashboard please . I am biggest biggest fan
Thanks for your kind words, Gagan!
Waou, I am amazed by the clarity of your explanation. Thank you for the excellent job you put in here!!
Thanks so much!
you're a GOD
Glad you enjoyed my video!
This is amzing..nice pace, short and concised. I learned a lot is so short time! Thank you!
You're most welcome!
Also while importing "Actual data" in colomn "Date" PowerBI sometimes places the whole sring, e.g. "1/01/2020,Administration,External Labor,United Kingdom,""1,754"". In the same time most of data importing well.
That's odd. You should be able to specify the delimiter on import.
Excellent JOB
Thank you so much 😀
Thank you for this tutorial, it was really explanatory and I tried to replicate it with the file. I still have a long way to go to become an expert and your tutorials have been helping with that 🙂
Great to hear!
wow... awesome
Thanks 🥰🥰🥰🥰🥰🥰
Thank you 😊
This is a very good workdone.I love it, i decided to practice your tutorials step by steps but it appears using the inbuilt AI Q&A to display the Chart on Actual vs Budget as gauge returns a blank chart.Any help?
Thanks so much! I'd say it doesn't know which fields to put in the value and target fields.
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
Great to hear it was helpful, Venkat! Have fun with Power BI :-)
Very educative video for beginners like me. ❤❤
Glad it was helpful!
Thanks for sharing! Could not find your Intro to Power BI video on YT. Do you mind letting me know the title of the recording? Cheers
This is my most recent an intro to Power BI video.
Hie Mynda, I was tasked to learn Power bi and your video was my first stop. I am very happy with your training, its exceptional. I got stuck the on line charts graphs around (17mins). I can not seem to get the line chart to appear in months, it only appears in days and years. Could you assist me? Thanks
Great to hear. Not sure what's up with the line chart, but I suspect the date hierarchy ins't correct in the axis field. Perhaps try building it again.
@@MyOnlineTrainingHub I started everything from scratch and I am still having the same problem. Did you update your data? I noticed when placing the commas in your actual column (11.12mins), your starts from March whereas mine from January. My gauge reading of the actual vs budget is 145m ranging from 0 to 289 which is far different from yours. By the way I re downloaded the files, so now I more confused, could you please help me figure out the error? thanks
@@Nolan_the_Sir were you able to resolved this issue? I have the same problem, kindly help if you have. Thanks
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.
Great to hear, Marc!
Aloha - This works great !!! Thank you
Great to hear!
thank you teacher
You’re welcome 😊
Thank you for this wonderful video, it helped me a lot, can you put the database in the description to practice the manipulation using the exact data, because i can't find any data online
The link to the data is in the video description. Follow the link and then read the instructions on the download page.
always awesome Mynda! thank you.
Glad you enjoyed it!
Top notch video. Thank you
Glad you liked it 😊
Great work u save lot of time i saw lot of report they take more then one hour to make and learn nothing to much 😂 your work is outstanding there i want to ask your that how much time require to make expert in power b.i from zero to expert.your reply will be valuable for us.
So pleased my video was helpful 😊 how long to become a Power BI expert is different for each person because it depends on your existing experience, how quickly you learn, and most importantly, how much work you put into practicing. It could take anything from a few months of intensive training to years. I’d err on the side of years for most people 😉
You are an amazing trainer thank you
You're most welcome!
Superb tutorial - very clear and informative.
Pardon. I'm looking for a person to practice with.
Can I ask you for it? I'm gonna start learning Power Bi right now.
@Ian-gf8id Glad it was helpful!
@sadeghvn2331 great to hear you're planning on learning Power BI. You can take my course here: www.myonlinetraininghub.com/power-bi-course
All my course members have support from me personally allowing them to ask questions and get help while they're learning and implementing the techniques in their own work.
Amazing, you are so clean and clear, thanks!
Glad it was helpful!
Hi dear, can u define some most important visual, that how to use correctly or where should we put actual, budget, %ach in which axis or legend in kpi card, line, column, area, card(new), etc.
I have learned so much from your videos i need some more basic skills to make my actual vs sales presentation.
I'll think about putting a data visualisation course together. In the meantime, I recommend any of Stephen Few's books.
Simply amazing.!
Glad you think so!
I really appreciate your methodical and thoughtful steps that you showed in the video.
Glad it was helpful!
Hi Mynda, You are a Super Pro. Liked the coaching to the fullest. Will subscribe to view all your videos . Thanks a ton.
Awesome! Thank you!
You are doing great! Thank you so much!
Glad you liked it 😊
Is there possible to find and download data included in the video? Great tutorial!
Yes, you'll find the link in the video description.
Very Informative video. It helped with my university assignment. :)
Great to hear 😊
Awesome, thank you very much!
Glad it helped!
You have helped me in understanding power bi . Thank you so much
My pleasure 😊
Thank you Mynda
My pleasure!
Thank you So much for the wonderful Presentation!
So nice of you, Suneetha!
Great course! Thanks for sharing
My pleasure!