Thank you for the UA-cam training, btw, I did try to go to your link for downloading the file (data) but I don't see any file to download. Can you point me specifically where the files (data) to download located? Thank you, I really appreciate it!
I completely agree. While other courses are good too, many tend to focus more on the specific functionalities. The way Mynda steps you through the analysis and how each function applies to it makes the video easy to follow and the tool's capabilities easier to understand.
Don't usually comment. Had to for this video. This is the best visual analytics tool learning video I have seen so far. Hands down. You ma'am, are brilliant.
I've watched many videos about Power BI and had problems of understanding them, then wanted to give up learning, but finally I found this tutorial, and I'm very thankful to you. It is really cool that we have such kind of people like you in the world.
Great presentation; comprehensive yet very clear, in just around 52 minutes you covered lots of subjects which could have lasted days in a typical seminar; rating this 5 star. Thanks prof. blessings.
Wow, Power BI blew me away. I heard Power BI and Tableau many times and this is my first really seeing how it works. I work with SSRS, SQL, Access, Excel etc for many years and never seen anything like this. Thank you for the excellent tutorial.
@28:54 for those trying to create Postcode, Suburb, Country column and the map isnt still behaving, you can use: Postcode, Suburb, Country = Regions[Postcode]&", " &Regions[Suburb]&", "&Regions[State]&", Australia" instead of: Postcode, Subrub, Country = Regions[Postcode]&", "&Regions[Suburb]&", Australia" . It takes care of the earlier error encountered in making the previous dashboard. Hope this helps.
The data category for Postcode, Suburb, Country as Postal code did not work for me. But then I tried the data code as place. And it worked!! Thank you Mynda for the good work.
Just finished the follow along and built the Dashboard.. then managed to publish to the web. One of the best curated and paced software tutorials I've seen.
I recently got a task at work, where I had to create a dashboard for tracking trends and user adoption. I have zero experience with PowerBI and actually had a pretty tough time finding my ways, but your video really simplified things, while covering a wide array of different topics. I thoroughly enjoyed it and im now working through this task like nothing else - very well done.
I have to say your webinars are far and away the most comprehensive, concise and erudite on the web that I have seen to date. You have amazing presentation skills and the content is absorbing, exciting and easily understood. Thank you so much for sharing your gifts
I was genuinely riveted Mynda! I am a data lover by nature who has been using access for 25 years now... I am blown away by the power, the immediacy and the dynamicity of these visualizations of complex data. One question though, (if you don't mind), is there a facility to enter data by the use of forms? And may I add, I hope you will be broadcasting more stuff as your tutorials are truly engaging... Well done Ma,am!
Thanks for doing such videos Mynda, i worked on MSBI(SSIS/SSRS), but now trying to improvise and move on to Power BI. Really liking this subject of visualisation , your video is amazing and learners like me who want to switch and change the domain can understand easily and work thoroughly watching these.
Great tutorial. You cover a lot of great topics and get users up and building quality dashboards in no time. Some videos might be shorter, but they tend to skimp on the underlying data parts that you cover very well. Thank you.
I have watched a lot of demos of various BI products. This is the best presentation and demo I have seen. You are a great presenter, and you chose great examples to demonstrate the qualities of Power BI. That play button on the bubble chart was a "Wow!" moment. Thanks for packing so much into 50 minutes!
Because at that point in the video I hadn't included all of the data, but you have imported all of the files so you get the total that I get when I import the last CSV file into Power BI. If you go towards the end of the video you'll see my card also says $3.18M
@@nelcypatriciapineda you need to go to the page linked to in the video description. On that page you need to enter your email address to reveal the orange download icons.
@@nelcypatriciapineda if you downloaded the file then you have both the .pbix and .xlsx files as they're in the zip file you downloaded. Did you open the zip file?
I'm new to Power BI and this is a really useful presentation with hands-on demo together with clear and precise instructions. Just what is needed to those that hit the ground running! Extremely useful and thank you for creating such content.
thank you, great explanation.. i have questions : 1. could we get or sign up the power BI account using personal email ? i've been try but microsoft request the work email address. 2. can i updated/refresh power BI data form excel file that stored in personal computer thank you
1. you need a work email. If you don't have one you can sign up for a Microsoft 365 trial which comes with an email address you can use for the sole purpose of creating your account. You can let the trial expire and you will still have your Power BI account. 2. Yes, but you need to install the personal gateway. I cover this in my Power BI course: www.myonlinetraininghub.com/power-bi-course
In just under 1 hour we could do so much. Eyoo!! Thank you Mynda. You are flying the Oz and PowerBI flags super high. Excellent Tutorial! I could not take my eyes off the screen for a second. I was action-packed. Like watching the kangaroos sparing without harming each other. God bless you Mynda.
Hi Mynda, thank you for this tutorial. When I do the first visual which is the KPI I get the value 3,183,870 instead of the 2,420,554 that you get. I have done it three times now and I still get the same value. Can you please let me know if there's something I'm missing.Thank you.
I suspect you have uploaded all of the data, whereas I keep one month back and load it at the end of the video to illustrate how you can update the reports.
I'm your Fan in just 10mins. this is super informative, so easy to understand, your vocabulary is really simple and straight forward to understand. I got every doubt clarified in this video as you have explained it so easy language. thanks a lot for making such a simple but effective video. A big Fans now
Hi Mynda..I can't thank you enough for all the knowledge that you have shared..that too for free. These are priceless. You are an amazing soul. May Lord bless you loads.
Excelente video, empecé a ver el video teniendo absolutamente nada de conocimientos de Power BI y ahora estoy fascinado, nuevo subscriptor! muchas gracias.
Thank you so much for the video i just have one question, when i made my Sales/Goss profit by FY Qtr my graphic is sorted by sales (decreasing) and not by FYQtr it starts xith 2017 Q1 and i have 2016 Q3 and 4 in the midlle? can you help me Please ?
In the Nov 2019 Power BI release, the Color Saturation field was removed from Fields list. You now need to go under Format / Data Color / Conditional Formatting to change colors. Color saturation option doesn't appears for two measures. It just appears for only one measure. Please let me know if it does.
Awesome tutorial, Thank you so much for this! I have a problem with PostCode, Suburb, Country = 800, Darwin, Australia. It shows me location in South America. Data category for this column is Place, Postal Code doesn't work unfortunately. Can someone help me, please.
You can print to PDF and PowerPoint, but the visuals themselves cannot be exported to Excel. However, you can export the data model and then work with it in Excel using Excel charts etc.
Excellent explanation of the Power BI visualization course and by far the best video about this tool on UA-cam. Thank you very much. This has been much appreciated.
Hi Mynda, when you were concatenating State with country in Data section to rectify the map visualisation , is the same as using tranform data option? I am confused whether transforming data in power query is same as editing/creating measures in Data section below the report section in Power BI
Hi Nayan, You can concatenate the columns in Power Query or in the Power Pivot modelling side of Power BI. However, transforming data in Power Query is not the same as editing/creating measures simply because you can't create measures in Power Query. Think of Power Query as the data preparation phase and Power Pivot as the modelling and measures phase.
Such wonderful voice with a distinguished accent of yours! Thank you very much! You speak so clearly that makes impossible to not pay attention to you! Finally just like Einstein once said "If you can't explain clearly what you know, you don't know enough!" or something like that :)
Hello..really thanks for this webinar..just wanted to know whether this content is sufficient for giving an interview on power bi or do I refer to more content..actually, I have to develop my career in Power bi and I am at starting phase
My pleasure, Paresh! You probably need more experience with Power BI than just one dashboard to succeed in an interview, but this is a great starting point. If you'd like to get your Power BI skills up to speed, please consider my course: www.myonlinetraininghub.com/power-bi-course
Madam, Can you please make videos on below topic in Power BI, It will be more helpful to me. Your demonstration is awesome and I could follow in easy understanding way than any other video instructor. Many thanks for your effort madam Correlation Matrix Chart Waffle Chart Regression Analysis Text Analysis ( Word Cloud) Row Level Security Data Security Data Accuracy Data Quality Data Cleansing (Text, Numbers) Text and Number Parsing ( Column and Row wise)
Great video, thank you so much, I have a question though. What can I do for the color saturation in "sales by state and manager" bar chart for the GP(%)? In newer versions, color saturation is not available in that format...conditional formatting that someone proposes confuses me a bit. Can you help? thank you
Glad you enjoyed the video. Conditional formatting has changed a bit since this video was recorded. You can see up to date instructions here: docs.microsoft.com/en-us/power-bi/visuals/service-tips-and-tricks-for-color-formatting#conditional-formatting-for-visualizations
Hi Mynda, although this video was upload few years back now I have the chance to finally use it. Thank you for the step by step explanation which are very helpful for me. Great session!
Hello, its a nice video, learning a lot, I have one question, the Excel file included on the description its very different from the one shown on this video, for example the managers tab doesnt appear in this excel file is there something that im missing?
Well, it's a vast topic, but simply put, a relationship is made between two fields that contain the same data, preferably one side/table having only one instance of the value (the dim table) and the other side/table having many instances (the fact table). If you'd like to learn more, please consider my courses: www.myonlinetraininghub.com/power-bi-course
Thanks, Yaakov! Power BI has Power Query and Power Pivot built in. You use Power Query to get and clean your data. Use Power Pivot to model it; create relationships between the tables and write custom DAX measures, then report on the data in Power BI visuals.
No, Power BI won't suggest a chart for you. Excel will though through their 'Suggested Charts' tool, so you could always take an extract of your data and try it in Excel first ;-)
Hat's off to you Mam, the way you demonstrated the product is really outstanding. Thanks for sharing and giving a quick introduction about the Power Bi tool. Really You changed my perception and the way of thinking towards data analysis. Thank you so much 🙏
The dim tables can be created automatically (to a degree) with Power Query i.e. based on fact tables in your model. This article explains the importance of star schema and should address your question: docs.microsoft.com/en-us/power-bi/guidance/star-schema
Do you have the Excel file for the retail analysis data used? I figured it would be in the "myonlinetraininghub" link but all I have is a Slicers Inside Out guide.
You answer my questions before I think of them, just what I'm looking for! I have found the right place in the maze of less practical information, thank you, you're brilliant :-)
Hi Mynda is there something extra in POWER BI that u can do which is not possible in excel in case you are using Power query, power pivot and pivot charts and tables in excel. Is Power Bi useful because of large data handling capabilities than excel is this the only advantage in Power Bi
Hi Sunil, there's loads extra Power BI can do that Excel can't, but handling big data isn't one of them because both tools use Power Pivot to store the data. You can see a pros and cons comparison of Excel vs Power BI on my course page (link below) under the FAQs number 2: www.myonlinetraininghub.com/power-bi-course
Hi Thank you very much for explaining so nicely. I loved doing along with the video. I got a problem though. I had data for the states of India. on the map the locations are ambiguous. I used your tip too. Still only one state is being shown in America. How do i fix it?
Thank you for these amazing videos on visualisations ... It helped me a lot to get more creative on dashboards. I learnt new topics and these videos helped me improve my skills... Highly recommend these videos !!!
You're welcome! I suspect the field you've used in the play icon is not suitable i.e. you need a numeric field in here and the data type needs to be set accordingly.
Download the file used in the video here: www.myonlinetraininghub.com/workbook-downloads
You are unbelievable this is so so so good THANKS YOU
Do you have video tutorial for creating calculated columns? Or do i have to take the course?
Thanks!
Thank you for the UA-cam training, btw, I did try to go to your link for downloading the file (data) but I don't see any file to download. Can you point me specifically where the files (data) to download located? Thank you, I really appreciate it!
Why did use use add columns instead of creating measures? Is there something you wouldn't be able to do if you used measures?
I've tried following along with multiple PowerBI trainings on UA-cam. This one is far and away the most informative and easiest to follow along with.
I completely agree. While other courses are good too, many tend to focus more on the specific functionalities. The way Mynda steps you through the analysis and how each function applies to it makes the video easy to follow and the tool's capabilities easier to understand.
Don't usually comment. Had to for this video. This is the best visual analytics tool learning video I have seen so far. Hands down. You ma'am, are brilliant.
I've watched many videos about Power BI and had problems of understanding them, then wanted to give up learning, but finally I found this tutorial, and I'm very thankful to you. It is really cool that we have such kind of people like you in the world.
Great presentation; comprehensive yet very clear, in just around 52 minutes you covered lots of subjects which could have lasted days in a typical seminar; rating this 5 star. Thanks prof. blessings.
Thank you. You are absolutely right. I didn't realise the quality was on 360...now I change to HD much better and I enjoyed greatly your teaching. :)
Wow, Power BI blew me away. I heard Power BI and Tableau many times and this is my first really seeing how it works. I work with SSRS, SQL, Access, Excel etc for many years and never seen anything like this. Thank you for the excellent tutorial.
Great to know you enjoyed the video. Have fun with Power BI :-)
@28:54 for those trying to create Postcode, Suburb, Country column and the map isnt still behaving, you can use: Postcode, Suburb, Country = Regions[Postcode]&", " &Regions[Suburb]&", "&Regions[State]&", Australia" instead of: Postcode, Subrub, Country = Regions[Postcode]&", "&Regions[Suburb]&", Australia" . It takes care of the earlier error encountered in making the previous dashboard. Hope this helps.
Thanks for sharing, Robert. Or just categorize the field as 'Place'. That also works.
Thanks! I'm a beginner. I saved it for future reference. 😇
Thanks, I got stuck on that!!
The data category for Postcode, Suburb, Country as Postal code did not work for me. But then I tried the data code as place. And it worked!! Thank you Mynda for the good work.
Great to hear, Nazmus!
Just finished the follow along and built the Dashboard.. then managed to publish to the web. One of the best curated and paced software tutorials I've seen.
Wow, great work. Glad you found it so helpful. Have fun with Power BI.
Wow, it's an amazing introduction! You helped me years ago with Excel dashboards and now this. Glad to have found you here. Thanks a lot!
My pleasure, Bob :-)
I recently got a task at work, where I had to create a dashboard for tracking trends and user adoption. I have zero experience with PowerBI and actually had a pretty tough time finding my ways, but your video really simplified things, while covering a wide array of different topics. I thoroughly enjoyed it and im now working through this task like nothing else - very well done.
Wow, so pleased to hear that, Alexander!
Brilliant and easy to understand! Heading to play with my data now! Thank you so much!
so impressive and perfection in teaching methodology💯
So pleased you think so 🙏
Excellent webinar .... gave a lot of insight into Power BI in such a short time.
OMG. She is too excellent in doing this. So simple way to teach with all that easy to kick start. Salute to you lady.
You're too kind, Mudasir!
I have to say your webinars are far and away the most comprehensive, concise and erudite on the web that I have seen to date. You have amazing presentation skills and the content is absorbing, exciting and easily understood. Thank you so much for sharing your gifts
Wow, thank you, Greyam! I'm delighted you enjoy them :-)
I was genuinely riveted Mynda! I am a data lover by nature who has been using access for 25 years now... I am blown away by the power, the immediacy and the dynamicity of these visualizations of complex data. One question though, (if you don't mind), is there a facility to enter data by the use of forms? And may I add, I hope you will be broadcasting more stuff as your tutorials are truly engaging... Well done Ma,am!
Thank you so much! It’s simply amazing. Can’t wait to get started
My pleasure, Alex! Have fun with Power BI, it's truly amazing :-)
Thanks for doing such videos Mynda, i worked on MSBI(SSIS/SSRS), but now trying to improvise and move on to Power BI. Really liking this subject of visualisation , your video is amazing and learners like me who want to switch and change the domain can understand easily and work thoroughly watching these.
Great to hear 🙏
Great tutorial. You cover a lot of great topics and get users up and building quality dashboards in no time. Some videos might be shorter, but they tend to skimp on the underlying data parts that you cover very well. Thank you.
I have watched a lot of demos of various BI products. This is the best presentation and demo I have seen. You are a great presenter, and you chose great examples to demonstrate the qualities of Power BI. That play button on the bubble chart was a "Wow!" moment. Thanks for packing so much into 50 minutes!
Thanks for your kind words! Great to know I wowed you with the bubble chart. Have fun with Power BI.
Thanks a lot for this! One of the most helpful tutorials I have come across online
Thanks, Ayan :-) glad you found it helpful.
Madam, your demonstration is amazing on Power Bi and Excel. More Videos on Power BI, regression, word cloud, text analysis. And Excel charts ........
Thank you! I have a long list of tutorials on my to-do list already, so there's always more coming :-)
Why am I getting $3.183.870 M when I do the step at 14:33? I downloaded the file and followed step by step.
Because at that point in the video I hadn't included all of the data, but you have imported all of the files so you get the total that I get when I import the last CSV file into Power BI. If you go towards the end of the video you'll see my card also says $3.18M
@@MyOnlineTrainingHub Dear i haven't been able to find the data set in the link. Can you please let me know where can i find it? Thanks in advance
@@nelcypatriciapineda you need to go to the page linked to in the video description. On that page you need to enter your email address to reveal the orange download icons.
MyOnlineTrainingHub Thanks! I already did it and downloaded all the files. But the one call retail_analysis_webinar.xlsx i couldn’t find it.
@@nelcypatriciapineda if you downloaded the file then you have both the .pbix and .xlsx files as they're in the zip file you downloaded. Did you open the zip file?
Am in the process of trying to learn Power BI ... this is one of the best videos I've found so far! Great content ... THANK YOU!!!!
Glad it was helpful, Darryl!
I have a bachelor in management and they certainly didn't teach this in my courses.
Love your clear and in-depth walk-through video, and cool and calm voice.
Glad you enjoyed it, Judy!
Thank you so much Mynda
You are most welcome 😊
One of the best videos on power bi...in just one video u covered EdX entire course on powerbi
:-) thanks, Rahul!
I'm new to Power BI and this is a really useful presentation with hands-on demo together with clear and precise instructions. Just what is needed to those that hit the ground running! Extremely useful and thank you for creating such content.
Glad it was helpful, Gayan!
concise but very useful. Thanks Mynda.
You're so welcome!
Great webinar. Will definitely do your course.
Thanks, Simone! Look forward to showing you more of Power BI's treasures in my course :-)
wonderful clear non intimidating introduction with 2 easy to understand useful samples.
Glad you think so!
thank you, great explanation..
i have questions :
1. could we get or sign up the power BI account using personal email ? i've been try but microsoft request the work email address.
2. can i updated/refresh power BI data form excel file that stored in personal computer
thank you
1. you need a work email. If you don't have one you can sign up for a Microsoft 365 trial which comes with an email address you can use for the sole purpose of creating your account. You can let the trial expire and you will still have your Power BI account.
2. Yes, but you need to install the personal gateway. I cover this in my Power BI course: www.myonlinetraininghub.com/power-bi-course
In just under 1 hour we could do so much. Eyoo!! Thank you Mynda. You are flying the Oz and PowerBI flags super high. Excellent Tutorial! I could not take my eyes off the screen for a second. I was action-packed. Like watching the kangaroos sparing without harming each other. God bless you Mynda.
:-) thanks for your kind words, Abram! So glad you enjoyed it. Have fun with Power BI.
Excellent Video...Clear and Easy presentation...I cannot thank you enough.
So pleased you found it helpful, Yishak!
Best Power BI guide I've found
Wow, thanks, Mike!
@@MyOnlineTrainingHub You're welcome
Getting more knowledge in power bi with short period of time.
Great to hear!
Hi Mynda, thank you for this tutorial. When I do the first visual which is the KPI I get the value 3,183,870 instead of the 2,420,554 that you get. I have done it three times now and I still get the same value. Can you please let me know if there's something I'm missing.Thank you.
I suspect you have uploaded all of the data, whereas I keep one month back and load it at the end of the video to illustrate how you can update the reports.
I'm your Fan in just 10mins. this is super informative, so easy to understand, your vocabulary is really simple and straight forward to understand. I got every doubt clarified in this video as you have explained it so easy language. thanks a lot for making such a simple but effective video. A big Fans now
Thanks for your kind words :-)
Thank you for sharing your knowledge. Please keep posting more courses. We're all learning.
Mynda I'm a babe in power bi, but this webinar is terrific. I had an idea about this powerful tool. Thank you 🙏
Glad you found it helpful, Arturo!
Hi Mynda..I can't thank you enough for all the knowledge that you have shared..that too for free. These are priceless. You are an amazing soul. May Lord bless you loads.
You're most welcome, Kausiek!
Hands down the best PowerBI tutorial i have been exposed to. Easy to understand and follow! Superb.
Wow! Thanks for your kind words, Kayode :-) Please share it with your co-workers too. Mynda
How did you change your background to black color ?
Excelente video, empecé a ver el video teniendo absolutamente nada de conocimientos de Power BI y ahora estoy fascinado, nuevo subscriptor! muchas gracias.
Muchas gracias, Miguel!
Thank you, I don't feel like a power bi clueless guy anymore
This is spot on. Don't usually comment as well. Thanks for this.
Awesome presentation. Loud and clear.
Thanks, Kimberry :-) Great to know you enjoyed it.
Its like you are my coach... moving on from excel to Power BI and Tableau... love data ! Thank you !
I love your tutorials 🥰🥰🥰🥰🥰
Thank you 🙏
Very fluid. You must have been using this tool for a while now. Awesome presentation!
Thanks, Denis! I hope you enjoy Power BI.
Wonderful Video Thumbs Up. Instant Learning and Start Up
Glad it was helpful!
What a great presentation. Thank you for sharing.
Glad you enjoyed it, Gerald!
Thank you so much for the video i just have one question, when i made my Sales/Goss profit by FY Qtr my graphic is sorted by sales (decreasing) and not by FYQtr it starts xith 2017 Q1 and i have 2016 Q3 and 4 in the midlle? can you help me Please ?
You need to set the 'sort by' for the quarter field in the modelling.
In the Nov 2019 Power BI release, the Color Saturation field was removed from Fields list. You now need to go under Format / Data Color / Conditional Formatting to change colors.
Color saturation option doesn't appears for two measures. It just appears for only one measure. Please let me know if it does.
Excellent Introduction to Power BI. thanks you.
Glad you found it helpful, Linda. Have fun with Power BI.
... U're one of a kind Ms. Treacy ... a Legend! ThanQ for sharing your valuable experience ... much appreciated.
You are most welcome :-)
Very helpful video! Thank you.
Great video !!! Very easy to follow along and easily understood. Thank you
Glad it was helpful!
Awesome tutorial, Thank you so much for this!
I have a problem with PostCode, Suburb, Country = 800, Darwin, Australia. It shows me location in South America. Data category for this column is Place, Postal Code doesn't work unfortunately. Can someone help me, please.
One of the best BI tutorials I've seen👌
Thanks! Have fun with Power BI 😊 and please share the video with your co-workers.
Awesome explaination, now I can create basic dashboards and look cool with it...
Great to hear! Have fun with Power BI 😉
Great dashboard, but can it be transported to Excel by any chance? otherwise, it is of no use to the senior management due to unfamiliarity.
You can print to PDF and PowerPoint, but the visuals themselves cannot be exported to Excel. However, you can export the data model and then work with it in Excel using Excel charts etc.
MyOnlineTrainingHub - thanks
Excellent explanation of the Power BI visualization course and by far the best video about this tool on UA-cam. Thank you very much. This has been much appreciated.
Thanks for your kind words!
This is the type of content I was looking for. It's very informative and easy to follow. One can learn a lot from watching and listening to her.
Thanks for your kind words, Julia. Glad you found it useful.
I totally concur with Ahsan Asaad's comment.
Thank u for the video , also I try to do it but I face a problem with the chart it automatically being filtered to descending order
My pleasure :-) You can change the sort order in the visual.
Hi Mynda, when you were concatenating State with country in Data section to rectify the map visualisation , is the same as using tranform data option? I am confused whether transforming data in power query is same as editing/creating measures in Data section below the report section in Power BI
Hi Nayan, You can concatenate the columns in Power Query or in the Power Pivot modelling side of Power BI. However, transforming data in Power Query is not the same as editing/creating measures simply because you can't create measures in Power Query. Think of Power Query as the data preparation phase and Power Pivot as the modelling and measures phase.
@@MyOnlineTrainingHub Great, got it thank for you very much
Such wonderful voice with a distinguished accent of yours! Thank you very much! You speak so clearly that makes impossible to not pay attention to you! Finally just like Einstein once said "If you can't explain clearly what you know, you don't know enough!" or something like that :)
Thanks so much for your kind words, Celio! Enjoy Power BI :-)
Thank you for uploading this magnificent profile on UA-cam
My pleasure 😊
Hello..really thanks for this webinar..just wanted to know whether this content is sufficient for giving an interview on power bi or do I refer to more content..actually, I have to develop my career in Power bi and I am at starting phase
My pleasure, Paresh! You probably need more experience with Power BI than just one dashboard to succeed in an interview, but this is a great starting point. If you'd like to get your Power BI skills up to speed, please consider my course: www.myonlinetraininghub.com/power-bi-course
Madam,
Can you please make videos on below topic in Power BI, It will be more helpful to me.
Your demonstration is awesome and I could follow in easy understanding way than any other video instructor. Many thanks for your effort madam
Correlation Matrix Chart
Waffle Chart
Regression Analysis
Text Analysis ( Word Cloud)
Row Level Security
Data Security
Data Accuracy
Data Quality
Data Cleansing (Text, Numbers)
Text and Number Parsing ( Column and Row wise)
Great video, thank you so much, I have a question though. What can I do for the color saturation in "sales by state and manager" bar chart for the GP(%)? In newer versions, color saturation is not available in that format...conditional formatting that someone proposes confuses me a bit. Can you help? thank you
Glad you enjoyed the video. Conditional formatting has changed a bit since this video was recorded. You can see up to date instructions here: docs.microsoft.com/en-us/power-bi/visuals/service-tips-and-tricks-for-color-formatting#conditional-formatting-for-visualizations
@@MyOnlineTrainingHub Thank you a lot!
Hi Mynda, although this video was upload few years back now I have the chance to finally use it. Thank you for the step by step explanation which are very helpful for me. Great session!
You are so welcome!
Hello, its a nice video, learning a lot, I have one question, the Excel file included on the description its very different from the one shown on this video, for example the managers tab doesnt appear in this excel file is there something that im missing?
Thanks, Guillermo. Please check the file again. There is one tab called 'Dim Tables' that contains 4 tables, one of which is the 'Managers' table.
It's so so nice that you are also creating Power BI content! Thank you so much!
You're most welcome, Lorena!
what should be the criteria to create relationships in modelling
Well, it's a vast topic, but simply put, a relationship is made between two fields that contain the same data, preferably one side/table having only one instance of the value (the dim table) and the other side/table having many instances (the fact table). If you'd like to learn more, please consider my courses: www.myonlinetraininghub.com/power-bi-course
Great videos. When should I use powerbi, and when should I use powerquery/ powerpivot/excel for visuals?
Thanks, Yaakov! Power BI has Power Query and Power Pivot built in. You use Power Query to get and clean your data. Use Power Pivot to model it; create relationships between the tables and write custom DAX measures, then report on the data in Power BI visuals.
Love the way you present. It's amazing, comprehensive and informative instructions. Thanks a lot!
So nice of you, Anatalia! Please share the video with your co-workers too.
Thank you so much. It helps a lot to understand Power BI
Glad it helped! Have fun building your own Power BI reports :-)
hye, what if we dont know what is the suitable chart to use? does power bi can easily recognize which chart is the best?
No, Power BI won't suggest a chart for you. Excel will though through their 'Suggested Charts' tool, so you could always take an extract of your data and try it in Excel first ;-)
Hat's off to you Mam, the way you demonstrated the product is really outstanding. Thanks for sharing and giving a quick introduction about the Power Bi tool. Really You changed my perception and the way of thinking towards data analysis. Thank you so much 🙏
i want ask whether we we have manaully make dim tables and what should be the criteria
The dim tables can be created automatically (to a degree) with Power Query i.e. based on fact tables in your model. This article explains the importance of star schema and should address your question: docs.microsoft.com/en-us/power-bi/guidance/star-schema
Very involving and amazing explanation! Nice job!
Thank you!
Once again, very well explained. Well done Mynda. Thank you
Cheers, Mika!
Excellent overview! Thank you!
Thank you!
I want to say a lot of things to you... it's perfect, it's amazing... Thank you! God bless you!
Wow, thank you!
Thank you Mynda... Its going to help me a lot...
Great to hear!
Did you use SQL to organise the tables from raw data? Have you got a video for that please? Excellent work.
No, I didn't use SQL. I used Power Query to get the data from the files, as shown in the video.
Excellent and thanks a lot for this step by step guide on PowerBI. This gives me a lot of confidence to start learning.
Great! Have fun with Power BI :-)
Do you have the Excel file for the retail analysis data used? I figured it would be in the "myonlinetraininghub" link but all I have is a Slicers Inside Out guide.
Hi Sean, The link to the page where you can download the files is in the video descrciption.
Thank you so much for sharing this video. Excellent and Very useful for beginners.
You answer my questions before I think of them, just what I'm looking for! I have found the right place in the maze of less practical information, thank you, you're brilliant :-)
You are most welcome :-)
I love your videos. It's like you know exactly what is needed. ON POINT!!!! 100 Points!!!! THANK YOU!!!!
Thanks so much 😊
Hi Mynda is there something extra in POWER BI that u can do which is not possible in excel in case you are using Power query, power pivot and pivot charts and tables in excel. Is Power Bi useful because of large data handling capabilities than excel is this the only advantage in Power Bi
Hi Sunil, there's loads extra Power BI can do that Excel can't, but handling big data isn't one of them because both tools use Power Pivot to store the data. You can see a pros and cons comparison of Excel vs Power BI on my course page (link below) under the FAQs number 2: www.myonlinetraininghub.com/power-bi-course
Hi Thank you very much for explaining so nicely. I loved doing along with the video. I got a problem though. I had data for the states of India. on the map the locations are ambiguous. I used your tip too. Still only one state is being shown in America. How do i fix it?
You're welcome, Shruthi. Did you try setting the location field/column to 'Place'?
Yes I did it. Then I did trying to create "postcode""Suburb"and "Country" column like Robert wrote. I got all points in India. Thank You.
Thank you for these amazing videos on visualisations ... It helped me a lot to get more creative on dashboards. I learnt new topics and these videos helped me improve my skills... Highly recommend these videos !!!
Wonderful to hear!
Thank you so much for the insightful video. I am unable to use play axis option, it show
ing some error while i am adding quarter attribute.
You're welcome! I suspect the field you've used in the play icon is not suitable i.e. you need a numeric field in here and the data type needs to be set accordingly.
@@MyOnlineTrainingHub Thanak You, now it's working fine.
Thank you. Easy to Understand
Glad to hear that, Bisrat!
Thanks this is the best course that I have watched about visualisation
Thanks for your kind words! Glad it was helpful 😊