Microsoft Power BI Beginner to Intermediate Course: 4+ Hours Data Visualization Training

[@SimonSezIT]

✅ 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 ➡kzbin.info?list... ✅ Check out our free video playlist for Data Visualization 👉kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU ✅Power BI Tutorials for Beginners video playlist 👉 kzbin.info/aero/PLzj7TwUeMQ3i17tx3uoTc6xf9X7Nl2U-s ✅ Microsoft Excel Beginner's Training here 👉 kzbin.info/aero/PLzj7TwUeMQ3iZHn4cv_fZagWSN8tubU9Z ✅ Data Analysis using Microsoft Tools here 👉 kzbin.info/aero/PLzj7TwUeMQ3jiDSWwQjtVvHqT09XdYFMi

[@sel4sie]

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.

[@Cosmogh]

@@sel4sie Same here. I have been waiting for days. 😮‍💨

[@robertrunoziva9470]

Enjoyable

[@robertrunoziva9470]

Done

[@more2life741]

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.

[@SimonSezIT]

Glad you think so! Thanks for visiting our channel to watch it :-)

[@chidiebereonyike883]

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.

[@SimonSezIT]

Glad you found the resource helpful! 🤩

[@folashadeolaitan6222]

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.

[@folashadeolaitan6222]

You explain things so well, thank you for the opportunity to learn from you. Now, i have a full understanding of the guage visualization 😃

[@SimonSezIT]

You're welcome and thank you for the kind words! ☺

[@adebukolaadebiyi3784]

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

[@zouhir2010]

I love this woman The way she explains. Her voice. The content. Everything just wonderful. Thanks a lot

[@TlholoN]

ASHBY IS THE BEST!!! WHAT A TEACHER! WHAT A PASSION! THANKS, ASHBY!!♥️♥️♥️

[@SimonSezIT]

I'm glad you enjoyed it. Thanks for watching! 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

[@MrJrhzues]

COMPLETELY HUMBLED BY YOUR TEACHINGS, TRULY APPRECIATE THIS AS AN AUTODIDACT, MATERIAL LIKE THIS IS GOLDEN.

[@blogtonight1698]

Why are you SHOUTING!

[@FairyLilly1]

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

[@SimonSezIT]

You're very welcome! 😊

[@helmetofsalvationjudah]

The explaination is at just the right pace and precise explaination to make me understand

[@SimonSezIT]

Glad you enjoyed it. Thanks for watching! 🙂 We have additional free tutorials for various data analysis tools and services here 👉 kzbin.info/aero/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2

[@rosisneupane]

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.

[@lize.6122]

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.

[@SimonSezIT]

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 👉 kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

[@VladimirKozomara]

THis is one THE BEST clasess for PBI :-) I put it in Category of Chris Dutton .. or maybe better. Thanks Deborah !

[@PetracheStefan]

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 .

[@JamesNjanjo]

Excellent tutorial, kindly include a video for calculated for calculated measures....

[@johntriple]

An intermediate and an advanced course after that course would be very much appreciated

[@jambaraz7641]

Amazing work, thank you so much, i'm gonna put in my bookmarks

[@SimonSezIT]

Awesome, thank you! We have additional free tutorials for various data analysis tools and services here 👉 kzbin.info/aero/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2 For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZbin Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzbin.info ♥️ We appreciate your support!

[@miguelsegura7976]

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

[@davemason2604]

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

[@wupsje1]

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!

[@MrDananjaya123]

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 ?

[@blogtonight1698]

It is really annoying when firstly they change presenters, and secondly when the steps are not reproducable.

[@BenDieselBasicAutomotive]

Another significant learning that I can apply to our office work!....

[@SimonSezIT]

Thanks Ben Diesel Basic Automotive, we are happy the training is something you can use at work ;-)

[@djotorregosa9928]

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.

[@RabahRabah-sm8ry]

so far it is the most valuable tutorial ! I recommand it !

[@SimonSezIT]

Glad you are enjoying the training. 😀

[@howtogeek5661]

Best tutor ever, thank you very much

[@SimonSezIT]

You're welcome and thanks for the kind comments 🙂 We have additional free tutorials for various data analysis tools and services here 👉 kzbin.info/aero/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2 For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZbin Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzbin.info ♥️ We appreciate your support!

[@balogunolajide7204]

Nice tut, please how are the unitcost calculated in the merged Sales table, from from the 4 Sales dataset ?

[@rosisneupane]

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

[@simbiatajibola]

How did u find ur way 1:55:18 around it later? Or did u abandon it? coz i have the same issue

[@soumyajitsarkar2372]

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.

[@SimonSezIT]

Thanks for the kind comments 🙂

[@TimothyUdeh]

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?

[@karlpacchio]

The data file shown on 1:48:55 is not available in the course files folder. Could you re-share it?

[@mint9121]

Amazing course, thank you!

[@rachapronpant.757]

I subscribe and be the one of your email subscriber!! Please do the beginner - intermediate - advanced cilps for powerbi, Thank you so much

[@WidneshHA]

This is beginner to intermediate course

[@zxu-zv2yy]

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

[@ayushkumarjha9921]

I just completed Excel tutorial and now I'm here.

[@SimonSezIT]

Hope you enjoyed it! Thanks for watching! 🙂

[@xvader9445]

Yes!!!!! Will there be handouts????

[@SimonSezIT]

We have free exercise files to download and follow along with the class.

[@axxxxxx7346]

Really thanhs for the speakimg slovly.

[@SimonSezIT]

You are very welcome! Thanks for watching 🙂 We have additional free tutorials for various data analysis tools and services here 👉 kzbin.info/aero/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2 For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZbin Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzbin.info ♥️ We appreciate your support!

[@brianligat9493]

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?

[@SimonSezIT]

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.

[@cahimanshugupta1475]

Great video for beginner.

[@SimonSezIT]

Glad you think so! 😊

[@tarun.vishwakarma1954]

That's training is really good for us...... Thank you for that 😊

[@SimonSezIT]

My pleasure 😊

[@dennisdolecheck6721]

Very helpful. Thank you😊

[@SimonSezIT]

You bet!

[@majidramzan6702]

Thanks

[@SimonSezIT]

Welcome

[@ommm4169]

Thank you for the video, the exercise has not be sent to my email.. can you if it is technical issue or not

[@TheRobarbie]

Where are the tutorials on how to create the DAX measures? Really shocked this is not included in a Beginner/Intermediate course.

[@blogtonight1698]

Looks like they selectively read feedback too!

[@blogtonight1698]

So how did you get the KPI Measures table?

[@Mhmod48]

could you share what tool you are using to make this arrow 25:45

[@emalori1136]

I love your accent 😀

[@sushilnayak8184]

Excellent this is really nice

[@SimonSezIT]

Thank you! Cheers!

[@MacdonaldAbai]

Helpful video thanks alot

[@SimonSezIT]

Glad it was helpful! 😊 Thanks for watching.

[@fatihmarik1778]

products and merge1 cannot merge there is some problem and your most table is different you shared

[@OpeyemiOlasunkanmi-mv1pz]

Excellent job sir

[@SimonSezIT]

Thanks for watching our training, Opeyemi Olasunkanmi 😀

[@arungupta8444]

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

[@tsxplora5420novraineneos]

I love this training🤗

[@SimonSezIT]

Glad we could help!

[@HarshPatel-fb2wi]

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??

[@maheryasir1698]

can you find the answer for this query?

[@hayatibrahim4615]

I am merging salestable product coloumn with product table product column but result comming null, how to solve this

[@ikpethaInnocent]

Thank you

[@melodyLiang-cf9ww]

Please teach how to create measure!

[@SimonSezIT]

Thanks for the suggestion. Stay tuned for more learnings from Simon Sez IT!

[@zxu-zv2yy]

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.

[@MegaAbgt]

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.

[@Omojesse]

After merging my queries in power query, my ID keeps giving "null" values instead of numbers.

[@nguyenphuong3836]

Thank you so much

[@SimonSezIT]

You're most welcome, Nguyen Phuong

[@bourgeois5345]

hello dear , i appreciate you cours , but we can not see well. your screen is white

[@SimonSezIT]

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.

[@georgekouroumpatzakis5509]

When i m importing the data i have several more columns but i dont get the '' amount'' column.

[@someonehale8801]

3:57:05

[@thephalcon]

Is this Full course

[@ClaraMaguma]

Where is the sales folder

[@dangthanhnhan3189]

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.

[@dangthanhnhan3189]

It's been proceed when I used fuzzy matching. But Why didn't it work without fuzzy matching?

[@hbkhan9669]

I cont use because power bi need microsoft company or school registerd account

[@leonellopes1414]

The "amount" column value comes in text form for me. Can someone help me?

[@krzysiek3719]

Replace values in this column from '.' to ',' before converting them

[@lindad1418]

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

[@mohammedjulhasnain5575]

Change Regional settings as the UK from File> Option & Settings > Option > Regional Settings

[@tobilobaomotola]

how can power BI be installed on macbook

[@SimonSezIT]

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.

[@tobilobaomotola]

@@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 🙏🏻

[@AlifKhan-hj4ty]

No Exercise file send to my mail

[@ajayisamuel7207]

PLEASE WHO CAN PROVIDE ME WITH THE DATA USED?

[@SimonSezIT]

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! KZbin Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzbin.info ♥️ We appreciate your support!

[@BenDieselBasicAutomotive]

Wow...

[@mach489i]

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?

[@gregn5389]

Presenter doesn't explain what BI stands for

[@SimonSezIT]

Power BI is a business intelligence tool as defined in the video description.

[@deshn21]

Great tutorial and great tutor! Keep it up!

[@SimonSezIT]

Thanks a lot!

[@donadams3313]

Can never download the free course exrcise files???

[@SimonSezIT]

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.

[@donadams3313]

@@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

[@donadams3313]

anybody else having problems downloading free excercises? hit reply button...thanks

[@rachidbelhenini1708]

Thank you

[@SimonSezIT]

You're welcome