✅ Download the free course exercise files to follow along ➡www.simonsezit.com/power-bi-beginner-to-intermediate-course-files/ 🔥Check out our FREE 300+ hour training course playlist here ➡ua-cam.com/users/playlist?list... ✅ Check out our free video playlist for Data Visualization 👉ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html ✅Power BI Tutorials for Beginners video playlist 👉 ua-cam.com/play/PLzj7TwUeMQ3i17tx3uoTc6xf9X7Nl2U-s.html ✅ Microsoft Excel Beginner's Training here 👉 ua-cam.com/play/PLzj7TwUeMQ3iZHn4cv_fZagWSN8tubU9Z.html ✅ Data Analysis using Microsoft Tools here 👉 ua-cam.com/play/PLzj7TwUeMQ3jiDSWwQjtVvHqT09XdYFMi.html
I have provided my email address to get the practice files, but, I have still not received the practice files. I have checked my spam folder and there is nothing there.
I don't know if its Ashby Voice but the calmness in the approach of teaching and explaining things makes it so very easy to understand and follow up. I have learned a whole lot from your lectures on different courses and thanks a Bunch to Simon and Ashby for all these.
I really appreciate this tutorial..Thanks a lot. I would also really appreciate of we can get the missing videos of how Deborah calculated the DAX Measures. There were some missing steps that we didn't get to see
I joined really late, almost towards the end and I learnt some very amazing things i didn't know how to do in PowerBI before; i am thrilled with the navigation buttons and condition formatting. Thank you for the knowledge.
This is a great resource and for those complaining about skipped parts, if you did the beginner section, you can work on your queries to match that of Debby at 1:49:00. Thank you to the organizers.
I'm glad you enjoyed it. Thanks for watching! 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Excellent tutorial, I am an absolute beginner and learning so I can move forward in my career, this has significantly benefit me. Going to practice and practice until all this becomes second nature to me. Thank you
Glad you enjoyed it. Thanks for watching! 🙂 We have additional free tutorials for various data analysis tools and services here 👉 ua-cam.com/play/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2.html
What's the point in making a 4 hour tutorial when the viewers can't even follow throughout the video. There are some sections missing between 01:44:00 - Splitting and Merging Columns and 01:48:55 . The files in 2nd module are not even present in the exercise files. It's so frustrating to leave the course after watching 2 hours.
Watching this course for 30 minutes in already. This guys has some passion in his voice and gives me the vibe that Bear Grylls is delivering this training :D .
I can't thank you enough for your tutorials. I have immensely benefitted from your works and would like to say, God bless you. I hope to contact you for private coaching at a later time.
Thank you so much for your kind words! I'm glad my tutorials have been helpful to you. 😊 🔥Check out our FREE 300+ hour training course playlist here 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
I really love how you present such complicated subject in an easy and concise manner. Is it possible to have a tutorial on how to present a comparative table of MTD, YTD, PYD and variance analysis like the Income Statement? Would appreciate it much.
Awesome, thank you! We have additional free tutorials for various data analysis tools and services here 👉 ua-cam.com/play/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! UA-cam Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining ♥️ We appreciate your support!
Very good course, just feels like the beginner part was left started, like the course is chopped in the middle and they start again with intermediate content from scratch at 1:35:08
Always watch your vids and they are well presented. I was following along with the second part of the course where debbie was doing the tutorial but I think there are some sections missing between 01:44:00 - Splitting and Merging Columns and 01:48:55 - Troubleshooting Relationship Issues the file looks completely different with Product Id and Location ID added to the main file but cannot see how this was done
I am also a bit sad that those parts are missing, especially the key measures! Generally I am grateful for the videos being uploaded on a free platform, alongside tutorial files, thanks @SimonSezIT!
I am about to watch the video, do you think that there are parts missing in the video where I might get stuck in the middle because last time also I got stuck watching the Power BI beginner course by Debby due to something missing in between after the 1st part of it, what do you think ?
You're welcome and thanks for the kind comments 🙂 We have additional free tutorials for various data analysis tools and services here 👉 ua-cam.com/play/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! UA-cam Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining ♥️ We appreciate your support!
why is there a skip between first and second module? There are some sections missing between 01:44:00 - Splitting and Merging Columns and 01:48:55 - Troubleshooting Relationship Issues the file looks completely different with Product Id and Location ID added to the main file but cannot see how this was done
To properly complete the tutorial you have to go to their site and subscribe for monthly or whatever plan you prefer, it's not really a complete tutorial here. That being said, whatever given here is helpful and thanks for that.
Hello, thank you Simon. Your video is great! However, i wanted asking, i noticed that the data-set used by the 1st instructor is different from that of the 2nd instructor who's a female. The data-set for the 1st instructor is available for download but not that of the 2nd instructor. Pls can you help with this or make clarifications?
Wow, thanks! Glad it was helpful. 🤩 Unfortunately no Sat Nav voiceovers, but a number of other courses on our channel and on our website are taught by Deb. So for more excellent teaching, please do check them out.
You are very welcome! Thanks for watching 🙂 We have additional free tutorials for various data analysis tools and services here 👉 ua-cam.com/play/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! UA-cam Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining ♥️ We appreciate your support!
Hi Simon, this is really good, I have watched a couple of times, but i have a question and try to find the solution; how can I sort out category's value per specific month while maintaining other periods'' value as well? It seems Power BI only can sort out by total if keep every single month's value. It would be much appreciated if you can provide some guidance.
Thank you. Are you seeing a blank white screen? Maybe you can try refreshing the page to see the video. Also, to ensure the best video experience, set the video playback quality to 1080p HD. Click on the gear icon ⚙ located in the bottom right corner.
Hello, Sir! I have used data with Combine and Transform data in power query and then close & apply. When I used card and drag the order I'd then it was showing 40K, instead of 1.22 M like yours. Even though I have combined data it is showing data of only 2016. Can you please help me with this??
Hi Sir, if there is a set of different Excel files and there are steps applied to them, like merge, combine and group, and there is an update in one/many Excel files in terms of values and it is not possible to update each and every column value, in this cane how can we replace the Excel file/files (keeping the same file name) so that the all the steps can/will be applied as it is after file replacement
When I initially load Sales and then put it as SalesPrep and close and apply I keep getting errors but I did the exact thing as the instructor. It says its the date column however the date column has the correct data type. Confuse
Is there anybody has the issue like me: The selection matches 0 of 1220615 rows from the first table? This occurs when I am in the step of merging products from Merge1 and Products table.
As far as I know, Power BI Desktop is not supported on Mac devices at the moment. Power BI Service is a cloud-based version that may be accessible using a Mac but with less functionalities as the desktop version.
@@SimonSezIT can I start from there then, I mean using the cloud based version because as of now, I don’t have access to Microsoft Windows and I really want to follow along on your power BI beginners to intermediate course….. By the way, I really must commend your effort on your contents….you taught me how to use excel, now I use it to analyze my data and tell compelling stories at work. I built a playlist from your contents on tools needed on data analytics pathway. A really big thank you 🙏🏻
Thanks for watching! You can download the course files here 👉www.simonsezit.com/power-bi-beginner-to-intermediate-course-files/ For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! UA-cam Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining ♥️ We appreciate your support!
This is so annoying. The course is not complete There are huge gaps between the beginner and intermediate tutorials. Why upload this video if it incomplete?
Hi Don. Sorry to learn about this issue. I tested the download and it worked. The file is a zip file, so check to ensure it's not getting blocked from some type of security or firewall.
@@SimonSezIT Ah i was supposed to recieve and email from you folks explaining how to get information...but hey guess what...never happened...yes I checked all spam etc...shazam none at all. If you cannot provide free information why one would even bother getting your product...Pathetic at best
✅ Download the free course exercise files to follow along ➡www.simonsezit.com/power-bi-beginner-to-intermediate-course-files/
🔥Check out our FREE 300+ hour training course playlist here ➡ua-cam.com/users/playlist?list...
✅ Check out our free video playlist for Data Visualization 👉ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
✅Power BI Tutorials for Beginners video playlist 👉 ua-cam.com/play/PLzj7TwUeMQ3i17tx3uoTc6xf9X7Nl2U-s.html
✅ Microsoft Excel Beginner's Training here 👉 ua-cam.com/play/PLzj7TwUeMQ3iZHn4cv_fZagWSN8tubU9Z.html
✅ Data Analysis using Microsoft Tools here 👉 ua-cam.com/play/PLzj7TwUeMQ3jiDSWwQjtVvHqT09XdYFMi.html
I have provided my email address to get the practice files, but, I have still not received the practice files. I have checked my spam folder and there is nothing there.
@@sel4sie Same here. I have been waiting for days. 😮💨
Enjoyable
Done
I don't know if its Ashby Voice but the calmness in the approach of teaching and explaining things makes it so very easy to understand and follow up. I have learned a whole lot from your lectures on different courses and thanks a Bunch to Simon and Ashby for all these.
Glad you think so! Thanks for visiting our channel to watch it :-)
I love this woman
The way she explains.
Her voice.
The content.
Everything just wonderful.
Thanks a lot
I really appreciate this tutorial..Thanks a lot. I would also really appreciate of we can get the missing videos of how Deborah calculated the DAX Measures. There were some missing steps that we didn't get to see
I joined really late, almost towards the end and I learnt some very amazing things i didn't know how to do in PowerBI before; i am thrilled with the navigation buttons and condition formatting. Thank you for the knowledge.
You explain things so well, thank you for the opportunity to learn from you. Now, i have a full understanding of the guage visualization 😃
You're welcome and thank you for the kind words! ☺
This is a great resource and for those complaining about skipped parts, if you did the beginner section, you can work on your queries to match that of Debby at 1:49:00. Thank you to the organizers.
Glad you found the resource helpful! 🤩
ASHBY IS THE BEST!!! WHAT A TEACHER! WHAT A PASSION! THANKS, ASHBY!!♥️♥️♥️
I'm glad you enjoyed it. Thanks for watching! 🙂
🔥Check out our FREE 300+ hour training course playlist here 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Excellent tutorial, I am an absolute beginner and learning so I can move forward in my career, this has significantly benefit me. Going to practice and practice until all this becomes second nature to me. Thank you
You're very welcome! 😊
COMPLETELY HUMBLED BY YOUR TEACHINGS, TRULY APPRECIATE THIS AS AN AUTODIDACT, MATERIAL LIKE THIS IS GOLDEN.
Why are you SHOUTING!
The explaination is at just the right pace and precise explaination to make me understand
Glad you enjoyed it. Thanks for watching! 🙂
We have additional free tutorials for various data analysis tools and services here 👉
ua-cam.com/play/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2.html
What's the point in making a 4 hour tutorial when the viewers can't even follow throughout the video.
There are some sections missing between 01:44:00 - Splitting and Merging Columns and 01:48:55 .
The files in 2nd module are not even present in the exercise files. It's so frustrating to leave the course after watching 2 hours.
An intermediate and an advanced course after that course would be very much appreciated
Watching this course for 30 minutes in already. This guys has some passion in his voice and gives me the vibe that Bear Grylls is delivering this training :D .
I can't thank you enough for your tutorials. I have immensely benefitted from your works and would like to say, God bless you. I hope to contact you for private coaching at a later time.
Thank you so much for your kind words! I'm glad my tutorials have been helpful to you. 😊
🔥Check out our FREE 300+ hour training course playlist here 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
THis is one THE BEST clasess for PBI :-) I put it in Category of Chris Dutton .. or maybe better. Thanks Deborah !
Excellent tutorial, kindly include a video for calculated for calculated measures....
I really love how you present such complicated subject in an easy and concise manner. Is it possible to have a tutorial on how to present a comparative table of MTD, YTD, PYD and variance analysis like the Income Statement? Would appreciate it much.
Amazing work, thank you so much, i'm gonna put in my bookmarks
Awesome, thank you!
We have additional free tutorials for various data analysis tools and services here 👉
ua-cam.com/play/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
UA-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining
♥️ We appreciate your support!
Very good course, just feels like the beginner part was left started, like the course is chopped in the middle and they start again with intermediate content from scratch at 1:35:08
so far it is the most valuable tutorial ! I recommand it !
Glad you are enjoying the training. 😀
Another significant learning that I can apply to our office work!....
Thanks Ben Diesel Basic Automotive, we are happy the training is something you can use at work ;-)
Always watch your vids and they are well presented. I was following along with the second part of the course where debbie was doing the tutorial but I think there are some sections missing between 01:44:00 - Splitting and Merging Columns and 01:48:55 - Troubleshooting Relationship Issues the file looks completely different with Product Id and Location ID added to the main file but cannot see how this was done
I am also a bit sad that those parts are missing, especially the key measures! Generally I am grateful for the videos being uploaded on a free platform, alongside tutorial files, thanks @SimonSezIT!
I am about to watch the video, do you think that there are parts missing in the video where I might get stuck in the middle because last time also I got stuck watching the Power BI beginner course by Debby due to something missing in between after the 1st part of it, what do you think ?
It is really annoying when firstly they change presenters, and secondly when the steps are not reproducable.
Nice tut, please how are the unitcost calculated in the merged Sales table, from from the 4 Sales dataset ?
Best tutor ever, thank you very much
You're welcome and thanks for the kind comments 🙂
We have additional free tutorials for various data analysis tools and services here 👉
ua-cam.com/play/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
UA-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining
♥️ We appreciate your support!
Yes!!!!! Will there be handouts????
We have free exercise files to download and follow along with the class.
I just completed Excel tutorial and now I'm here.
Hope you enjoyed it! Thanks for watching! 🙂
why is there a skip between first and second module?
There are some sections missing between 01:44:00 - Splitting and Merging Columns and 01:48:55 - Troubleshooting Relationship Issues the file looks completely different with Product Id and Location ID added to the main file but cannot see how this was done
How did u find ur way 1:55:18 around it later? Or did u abandon it? coz i have the same issue
To properly complete the tutorial you have to go to their site and subscribe for monthly or whatever plan you prefer, it's not really a complete tutorial here.
That being said, whatever given here is helpful and thanks for that.
Thanks for the kind comments 🙂
Amazing course, thank you!
Hello, thank you Simon. Your video is great! However, i wanted asking, i noticed that the data-set used by the 1st instructor is different from that of the 2nd instructor who's a female. The data-set for the 1st instructor is available for download but not that of the 2nd instructor. Pls can you help with this or make clarifications?
The data file shown on 1:48:55 is not available in the course files folder. Could you re-share it?
I subscribe and be the one of your email subscriber!! Please do the beginner - intermediate - advanced cilps for powerbi, Thank you so much
This is beginner to intermediate course
Great video for beginner.
Glad you think so! 😊
I really love your training, but I still have a question : how to add the new period's data to the existing published Power BI report? Thank you
Very clear and best explanations I have found. Nice to be UK rather than US or Indian for a change :) Can Deb do the voice for my sat nav?
Wow, thanks! Glad it was helpful. 🤩 Unfortunately no Sat Nav voiceovers, but a number of other courses on our channel and on our website are taught by Deb. So for more excellent teaching, please do check them out.
That's training is really good for us...... Thank you for that 😊
My pleasure 😊
Really thanhs for the speakimg slovly.
You are very welcome! Thanks for watching 🙂
We have additional free tutorials for various data analysis tools and services here 👉
ua-cam.com/play/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
UA-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining
♥️ We appreciate your support!
Very helpful. Thank you😊
You bet!
Where are the tutorials on how to create the DAX measures? Really shocked this is not included in a Beginner/Intermediate course.
Looks like they selectively read feedback too!
Thank you for the video, the exercise has not be sent to my email.. can you if it is technical issue or not
Excellent job sir
Thanks for watching our training, Opeyemi Olasunkanmi 😀
Excellent this is really nice
Thank you! Cheers!
Please teach how to create measure!
Thanks for the suggestion. Stay tuned for more learnings from Simon Sez IT!
Thanks
Welcome
Hi Simon, this is really good, I have watched a couple of times, but i have a question and try to find the solution; how can I sort out category's value per specific month while maintaining other periods'' value as well? It seems Power BI only can sort out by total if keep every single month's value. It would be much appreciated if you can provide some guidance.
I think it is the Calculate sum formula with Filter in it with the specific month. So other filters wont modify this specific duration's value.
hello dear , i appreciate you cours , but we can not see well. your screen is white
Thank you. Are you seeing a blank white screen? Maybe you can try refreshing the page to see the video. Also, to ensure the best video experience, set the video playback quality to 1080p HD. Click on the gear icon ⚙ located in the bottom right corner.
Helpful video thanks alot
Glad it was helpful! 😊 Thanks for watching.
So how did you get the KPI Measures table?
I love your accent 😀
I love this training🤗
Glad we could help!
could you share what tool you are using to make this arrow 25:45
products and merge1 cannot merge there is some problem and your most table is different you shared
Hello, Sir!
I have used data with Combine and Transform data in power query and then close & apply.
When I used card and drag the order I'd then it was showing 40K, instead of 1.22 M like yours. Even though I have combined data it is showing data of only 2016.
Can you please help me with this??
can you find the answer for this query?
Hi Sir, if there is a set of different Excel files and there are steps applied to them, like merge, combine and group, and there is an update in one/many Excel files in terms of values and it is not possible to update each and every column value, in this cane how can we replace the Excel file/files (keeping the same file name) so that the all the steps can/will be applied as it is after file replacement
Is this Full course
I am merging salestable product coloumn with product table product column but result comming null, how to solve this
Thank you
Thank you so much
You're most welcome, Nguyen Phuong
After merging my queries in power query, my ID keeps giving "null" values instead of numbers.
When i m importing the data i have several more columns but i dont get the '' amount'' column.
Where is the sales folder
I cont use because power bi need microsoft company or school registerd account
When I initially load Sales and then put it as SalesPrep and close and apply I keep getting errors but I did the exact thing as the instructor. It says its the date column however the date column has the correct data type. Confuse
Change Regional settings as the UK from File> Option & Settings > Option > Regional Settings
Is there anybody has the issue like me: The selection matches 0 of 1220615 rows from the first table? This occurs when I am in the step of merging products from Merge1 and Products table.
It's been proceed when I used fuzzy matching. But Why didn't it work without fuzzy matching?
The "amount" column value comes in text form for me. Can someone help me?
Replace values in this column from '.' to ',' before converting them
how can power BI be installed on macbook
As far as I know, Power BI Desktop is not supported on Mac devices at the moment. Power BI Service is a cloud-based version that may be accessible using a Mac but with less functionalities as the desktop version.
@@SimonSezIT can I start from there then, I mean using the cloud based version because as of now, I don’t have access to Microsoft Windows and I really want to follow along on your power BI beginners to intermediate course…..
By the way, I really must commend your effort on your contents….you taught me how to use excel, now I use it to analyze my data and tell compelling stories at work. I built a playlist from your contents on tools needed on data analytics pathway.
A really big thank you 🙏🏻
3:57:05
No Exercise file send to my mail
PLEASE WHO CAN PROVIDE ME WITH THE DATA USED?
Thanks for watching!
You can download the course files here 👉www.simonsezit.com/power-bi-beginner-to-intermediate-course-files/
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
UA-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining
♥️ We appreciate your support!
Wow...
This is so annoying. The course is not complete There are huge gaps between the beginner and intermediate tutorials. Why upload this video if it incomplete?
Presenter doesn't explain what BI stands for
Power BI is a business intelligence tool as defined in the video description.
Great tutorial and great tutor! Keep it up!
Thanks a lot!
Can never download the free course exrcise files???
Hi Don. Sorry to learn about this issue. I tested the download and it worked. The file is a zip file, so check to ensure it's not getting blocked from some type of security or firewall.
@@SimonSezIT Ah i was supposed to recieve and email from you folks explaining how to get information...but hey guess what...never happened...yes I checked all spam etc...shazam none at all. If you cannot provide free information why one would even bother getting your product...Pathetic at best
anybody else having problems downloading free excercises? hit reply button...thanks
Thank you
You're welcome