Power BI Beginner Tutorial

[@octechperson]

I've looked at a lot of Power BI tutorials and this has been the only one that I've been able to sit down and watch for a straight hour without wandering or doing something else. I love the presentation of the material and I feel like I'm really learning along the way. Thank you!

[@LearnitTraining]

We are glad you were able to learn so much!

[@realsdsk]

What a godsend!!! I had to jump off of another tutorial because of the trainer's monotone voice and lack of interaction. You have your students dive right in and incorporate the learning as they go! Pleasant, undulating voice, perfect tempo...I'm enjoying all of it and will be back tomorrow and the next day etc. (partial days) until I complete the 20 hours.

[@dawnbrelsford8066]

that's encouraging and good to know. If I can't tolerate the sound of a trainer's voice...I can't watch the video, no matter how good the trainer is

[@rodnehmofan8242]

i just want to commend the instructor of this tutorial, you are by far the best KZbin tutor i am following. Thanks for sharing this to us, it is can help people in acquiring new skills

[@jacquelinetung]

Another great tutorial found on Learnit, heading to learn more, thank you! Another method if you cannot link the HTML file (34:00): Get Data, "From HTML" -> Choose the HTML file in the Exercise 1 folder, it will pop up a new window for the file, copy the table, then go back to "AllRegions" -> Power Query Editor -> right-click, "new query", choose "blank table" -> then paste the table of HTML file, rename it "Continents" -> Close & Load. It shall be ok.

[@LearnitTraining]

Thank you for the wonderful tip!

[@frederickzoreta6617]

Barely 1 hour into this course, and I am TOTALLY IMPRESSED! I wish I could've discovered your channel way before. I'm thanks for the amount of efforts and time that you put in presenting these courses for free. I surely look forward to all your Excel, VBA and Access courses.

[@LearnitTraining]

You are very welcome Frederick!

[@salvadorpatricio6453]

The thing that I value most in this tutorial is the transition from pivot tables to power BI. I am fond of pivot tables and this clearly explains the relationship and similarity in principle of pivot table to power BI. Well done Chelsea and thank you so much!

[@LearnitTraining]

Thank you for the kind words and support Salvador!

[@halletatube1981]

Where the hell have you been all these days?!?! Guys, you are so so Amazing and are by far better than most in class tutorials. How did I find you? Thank you so very much!! I will share it with all my friends!!

[@LearnitTraining]

Wow, thank you!

[@misteroz]

Found this tutorial to be amazingly clear, thorough and engaging - and I spent 15 years as a software trainer, so I know what great looks like!

[@LearnitTraining]

You're very welcome!

[@LoicBienaime]

What I really like with your course is that you don't go straight to PowerBI like most of the other courses. You go first by explaining how works PowerQuery, what we can make with it and ... you changed my life! Furthermore, this is so well explained! Thanks for the value you bring here!

[@k28]

I hate to sound pedantic or needy. I am so grateful for these! Just a quick tip: When screen recording and training, a higher resolution really helps clarify the smaller text. It would be more awesome if these were recorded in 1080p or even better; 1440p (or 4K :) )

[@JennySparkz]

Sooooo true

[@rashmirana7861]

The tutorial is good but the actual Power BI tool visualization stats only after 1:15:00, so you may want to skip to 1:15:00 if you are already familiar with Tableau.

[@catherineq4527]

I have lifelong experience with using Excel and want to use the latest data master tool - PowerBI. Thank you for making Power BI seems easy!

[@LearnitTraining]

You are welcome Catherine! We hoped you learned a lot!

[@MGHxxvi]

Thank you very much for your generosity. I am finished with you VBA Beginner and Advance and is starting with this one. Thank you from the Philippines.

[@LearnitTraining]

You're very welcome!

[@evavoskou9857]

Thank you for this tutorial. I would like to inform you that there are some mistakes to your files. For example, when I load the Employees file, the data type in column 'AveStPay' is Text, while it should be Whole number according to the video. That's why when I tried to create the visual, as you suggest, the calculable visualization type didn't appear as in the video. If anyone is confused, you can fix it by selecting the column 'AveStPay', go to column tools and finally select data type : whole number instead of text. Same for 'GrossPay' 2013, 2014, 2015.

[@oshushujoshua1557]

Thank you so so much for this information. Finally, I can breathe with ease. This part has been giving me a lot of concerns as my PowerBi couldn't replicate Chelsea's bar chart visuals. I thought the problem was due to the version of PowerBi I am using. Thanks to you, now I can continue with her tutorial.

[@oshushujoshua1557]

I am having issues trying to filter through the State to display the Actual and Projected Revenues of Regions in the United States excluding those of other countries. When I used the Page-level filters for the Region and clicked on the United States in State, this produced two sticks of bars and not a long bar chart consisting of the several Region in the United State. The issue is at 1:47:08 of the video. Please help. Thanks

[@ishitasaxena4245]

thank you so much kind human !!

[@RakshitDwivedi-pq8qc]

Chelsea Dohemann. You are literally my favourite KZbin person ever. i even search KZbin by typing your name to check for your tutorials. Took your VBA course earlier. Now i jumped from other PowerBI course on this channel to yours. Your voice, Your style of teaching is class apart.

[@LearnitTraining]

Wow, thank you!

[@hernanperez912]

I was here for the first five minutes and ended up watching the 2 hours video. Beautiful. Thank you very!

[@LearnitTraining]

Hope you enjoyed it!

[@houda.k1899]

@@LearnitTraining please the exercices file is not working

[@waynethurman2144]

I think this girl is one of the very best instructors I have ever experienced, university or elsewhere! :-)

[@LearnitTraining]

Thank you for the kind words Wayne!

[@kym.kdcchannel]

love this! the phase on how this tutorial is just perfect - not too fast, not too slow. love the voice as well - tone and pronunciations are all crisp! instructions were crystal clear! thanks!

[@LearnitTraining]

You are very welcome!

[@raminbarnet1]

Thank you, thank you, thank you , clear , short and sweet and no funny accents or annoying background music !

[@LearnitTraining]

Glad you liked it!

[@johnscott2964]

Figured it out. Data had names for Region and State interchanged. Renamed and it works.

[@wildtruffle418]

thank you! I was stuck with this

[@mauricevladminasarahmomopa7454]

Hello All, I almost never write comments on KZbin but I have to with this video!! It is great content and the instructor just does a great job!! Congrats to Learnit Training. Good learning to you all!!

[@LearnitTraining]

Thank you for watching and an extra big thank you for subscribing Maurice!

[@dataisfun4964]

Best beginner video so far on KZbin. Really appreciate

[@LearnitTraining]

Thank you Temidayo! We hope you learned alot!

[@syaoransakura8839]

I am already made two projects on power bi based on some KZbin tutorials. But look at this video just made me have more knowledge about the basics of power bi. It's good to know this channel. Thank you for your effort. And it's give me more idea for my visualization on my dashboard next time.

[@LearnitTraining]

Glad we could help!

[@eunheechoi3745]

The best tutoring videos. loved the voice and clear explanation. Please upload SQL and Tableau tutorials! :)

[@RomiOfficial]

I agree!!!!!!

[@chrishobley2783]

Agreed!

[@ujwalapatil2050]

Please upload tableau and SQL video as well. Really nice videos

[@surajnegi7469]

We can use sql rather than excel???? To modify data like this?? I have 2007 excel and it’s not have query. Please answer anyone

[@murtuzabhabhrawala9712]

Although I wasn't able to practice it myself since I could not login to Power BI this was still very helpful and easy to understand. Thank you for showing this for free.

[@LearnitTraining]

You are very welcome! You can get free access to Power BI here: powerbi.microsoft.com/en-us/

[@aegirmahrjn]

Your teaching is Amazing. Feels like having session in Classroom. Your voice make even virtual class sounds real.

[@LearnitTraining]

Thank you for the kind words, pradip!

[@lcallejas2000]

Excellent beginer tutorial for Power BI. Chelsea has a very nice voice and she is explains things very detailed. By far, one of the best tutorials I have ever taken from any program. Thanks guys from Learnit Training

[@LearnitTraining]

You're very welcome!

[@victorwestmann]

Is this still a good course to do to learn Power BI if we're in MARCH 2024? Love your content! Keep up the amazing high-quality courses.

[@LearnitTraining]

This is our more updated version: kzbin.info/www/bejne/m2e0dWuihZKgbKc We also have a new version coming out later this year

[@tinesifethoughts3453]

1:31:42 On the newer Power BI, the color saturation isn't in the same place. You must turn on Data colors in the format tab and then click on the "fx" next to Default color to change the divergence.

[@luqmanhakim7781]

Thanks for the good info ! I have been looking for this features

[@rishisaxena1476]

This needs to be pinned.

[@ishitasaxena4245]

thanks🙏

[@tikchyeoon8486]

thank you for the free training. no doubt, m 2 years late, but, is it still wonderful ..Blessing everybody. :)

[@LearnitTraining]

Our pleasure!

[@songokurah]

This is the best video I have come across on Power BI. Excellent video!

[@LearnitTraining]

Thank you so much for the kind words!

[@WOODY96910]

Best Power BI intro tutorial i've seen.

[@LearnitTraining]

Glad it was helpful!

[@normskie915]

I liked this tutorial a lot! Easy to understand and very helpful in explaining each feature/function. The voice over is also pleasant which is also a plus! Kudos!

[@almanamo6858]

What a GREAT tutorial Regarding linking the non available html file, you can use the same process, and give the internal link like: C:\Users\"Your User Name"\Downloads\Day 1 Workfiles\PowerBIData.html

[@LearnitTraining]

Thanks for the tip!

[@Twisterspi0]

This is an unbelievably well structured and explained tutorial. Thank-you so much for offering your time in making this.

[@LearnitTraining]

Thank you for subscribing! It helps tremendously!

[@giftomodu8878]

I love how this class was delivered. Really nice fir someone who just needs a quick recap! Loving the Instructor too... Great job!

[@LearnitTraining]

Glad you enjoyed it!

[@PingClapham]

Great tutorial for learning how to get data and normalize data, which is really important in order to avoid getting stuck right at the beginning .

[@LearnitTraining]

Glad it was helpful!

[@aashishkshah]

Thanks for an amazing video Chelsea!! I so much enjoyed it. Your style of detailing thru the concept and then quickly wrapping it again really helped condense the learning. Your "Go ahead and pause the video..." were followed like a rote. those periodic pauses and hands on really helps in understanding the features. I have worked on Tableau for a long time and wanted to learn Power BI too. I so so appreciate your efforts on creating this video starting with Power Query / Editor in Excel as it creates the context for users moving from Excel to Power BI.

[@chad_the_stud]

love this channels tutorials. Pace and the flow of their tutorials are just so on point that, i feel like i can learn anything with it. please keep up this great contents

[@LearnitTraining]

Thank you watching and a big thank you for subscribing Burak!

[@thatotlakedi5694]

@@LearnitTraining please advise on how I can resolve this. Some of the data such as living wage aren't calculable after loading the data into Power BI. They appear as countable data with no option to sum or average them. Please advise. Thanks!

[@richardcamilomorales1948]

Thank you so much LearnIt ... I started from scratch with you guys' Excel tutorials, and now I feel pretty confident with computing and I'm even starting to learn coding ... I would have never imagined it!!

[@LearnitTraining]

You are very welcome Richard! We are glad you go so much from our videos! Also thank you for subscribing!

[@mehaboob25shakir]

By the best video on PowerBI. Special thanks to the instructor. So calm & patient.... keep up the good work..... :)

[@LearnitTraining]

You are very welcome! Be on the look out for our new Power BI videos!

[@zorsat1]

Hi. Thank you for the introductory course. I find it interesting though it only gives a taste of Power BI and does not really provide a practical knowledge for doing Power BI afterwards. It does not explain the interface in a comprehensive way to enable users have a useful knowledge for continung on their own later on. It is just a taster and that is all. You need to learn lots of things later and properly. But if you have never heard of Power BI this is a good start. I definitely suggest taking a paid course version of this same group (Learnit Training) or use a good text book later. Good luck

[@LearnitTraining]

Hi Far Zor - We actually have the full class up for both our videos. Our updated video series was build to help you get certified in Power BI - Full playlist here: kzbin.info/aero/PLoyECfvEFOjaHaCUMLHed0krBFjavN6YT

[@obiterdictum3021]

I love the voice of this instructor, and more than those on the channel....

[@LearnitTraining]

Wow, thank you!

[@ernestosabatercalvet]

I am glad I found this tutorial, I really enjoyed the way content was explained, all pauses we were able to take advantage of.The only thing I am dealing with now is my Power BI app which I downloaded in Spanish, I can not find the color saturation format feature, will do some extra digging. THANKS!!!

[@spazeds]

This is a great beginner tutorial. Voice is clear, very nice and understandable. The exercise definitely help instills an understanding of Power BI.

[@dongzhang8442]

Clear voice, clear instructions. Thanks.

[@anikulapoidris8860]

I felt so fortunate and blessed to find this tutorial. Such a masterpiece of a lecture 💯

[@LearnitTraining]

Glad it was helpful!

[@zurcd42246]

Fantastic - your style and voice is just great! Thanks a million for a job very well done

[@hggffjggfg8121]

QqOqq

[@vishisbest]

Every video by you is amazing, I will make sure to share this with my LinkedIn followers

[@LearnitTraining]

Awesome, thank you!

[@jeffdegregorio7391]

Great course!! Bravo!! My copy of Power BI Desktop doesn't have Color Saturation (checked everywhere). Also, where is day 2, 3, and 4 Thanks

[@kuuuyajim]

I'm so thankful to have stumbled on your channel. Keep it up! 😉

[@LearnitTraining]

Will do Jimmy!

[@callofjudyy]

i love how you point out the little things like in a different version of excel, this is called option. or the one with the checkbox, that when u have a lower version it doesnt have that, u chose the outer type to match with the default of that. its very very thoughtful. cos u can get hang up on dat, but you explain every little detail. thank you. i hope u get a million subscribers

[@LearnitTraining]

Thank you so much callofjudy xx! Extra big thanks for subscribing!

[@kristinekonsmo8042]

This was very helpful, thank you for making it available.

[@LearnitTraining]

Glad it was helpful!

[@deepubranklin4738]

Thank you soo much, very clear and simplified explanation....

[@veryhealthy9962]

The very moment i heard the voice i knew it was the same instructor from vba, awesome!

[@suamaabiatar5625]

Amazing work on these. I have learnt alot.

[@LearnitTraining]

Glad you like them!

[@varinderkumar8565]

Web Source: Web Link wont work but the same HTML page is provided inside your Day 1 WorkFiles folder. If you are unable to fetch data from that HTML page for some reason, you can copy tha data whcih is a continent table and paste into an excel sheet and save it. and then instead of using the web path you can simply get dat from the newy saved sheet.

[@usmanjaji7825]

A very informative tutorial with a detailed explanation of each process. Could you kindly provide the videos for the remainder of the tutorial? Thank you

[@LearnitTraining]

Hi Usman! Thank you for watching and thank you for subscribing! Here is the playlist for all our PowerBI videos - kzbin.info/aero/PLoyECfvEFOjaHaCUMLHed0krBFjavN6YT

[@berndeckenfels]

Very well present, thank you (there are a few corrections which did not make it into editing, that needs some TLC)

[@rishabhsingla578]

I must say its really very good tutorial. As others have already commented, the pace and tone of the author in this video is too good and very comfortable to follow. Thank you so much for this great effort.

[@LearnitTraining]

You are welcome!

[@rishabhsingla578]

@@LearnitTraining Thanks. Need little help. At 1:20:24, AvgStatePay field is showing as calculable field with summation sign in your tutorial, but its not the case in my power BI. I have imported the same CSV file. When I am trying to change the data type to decimal number, it gives me error: We cant automatically convert data to decimal number type. Not sure what's the issue. Same issue with other numerical fields as well in Employee table.

[@LearnitTraining]

***The Link to the Exercise Files is in the Video Description**** Click on Show More and the link will appear Web Source: Web Link wont work but the same HTML page is provided inside your Day 1 WorkFiles folder. Just use the File Path to the HTML doc and you are Golden. Credit to Rajish Wagh for the tip! Step by step instructions for Web Source: Open file in Day 1 Workfiles folder called PowerBIData Copy web address Click New Query Scroll to From Other Sources Select From Web Paste Web address in URL space provided Click OK

[@dikshamittal3824]

Please provide the Geo tables so that I can use as a sample

[@asixtray]

Exercise files link not working

[@jm.6211]

The link isn't working. It says The site can't be reached. edit: I can finally access the files now. thank you so much! now i can follow along with the lesson.

[@manoyspeedbagal7093]

How do I download the exercise files. Do I need to unzipped the files? I appreciate your help. Thanks!

[@jm.6211]

@@manoyspeedbagal7093 you can just download the entire zipped files and extract the files after you've downloaded. At least that's what I did.

[@constantinnemec639]

Hi! when adding AveStatePay, GrossPay2013,14,15 (01:20:40), it does not show up as a calculable field...do you know why that could be? Thank you, great video!!

[@YahYaAlabrash98]

Thanks, Chelsea, for This Amazing Tutorial!

[@LearnitTraining]

You're so welcome!

[@jsandeepk]

I'd really like to see a similar course on Google Data Studio. I've been following your channel since long and I'm glad to admit it really helped me hone great skills. Thanks a lot!

[@LearnitTraining]

Thank you for watching Sandeep!

[@wangangcwayi9420]

I am actually on the 52nd minute and blown away. You go girl😘🤩

[@LearnitTraining]

Thank you so much Wanga!

[@utalent5966]

Excellent pace, qualitative explanation and really pleasant voice! Led me to the advanced tutorial

[@LearnitTraining]

Glad you liked it!

[@kashishkalra8238]

Thankyou so much for excellent Tutorial!!

[@LearnitTraining]

You're very welcome!

[@lucyliu6259]

Thank you so much for providing these Power BI tutories. They are just wonderful

[@CaribouDataScience]

Thanks, that was very helpful.

[@LearnitTraining]

You are very welcome!

[@jvarcen]

I am really enjoying the course. I found the exercise files, but how do I open the exercise files?

[@LearnitTraining]

Hi John - you would open them in Power BI

[@KiloEsquilo]

The explanation is clear (the voice is fantastic), at the right pace. Thanks for the exercise files

[@harshalpatil2111]

Congratulations to you as well .. such a nice explanations. I just pause all my other power BI channels, and now focusing on this only. also started working on my visualization.

[@LearnitTraining]

Hi Harshal! Want to thank you for all the kind comments and we really hope you are learning a lot!

[@olgalesinski1353]

Fantastic training! Great pace, pleasant voice, easy to follow.

[@LearnitTraining]

Thank you kindly!

[@RajishWagh]

Web Source: Web Link wont work but the same HML page is provided inside your Day 1 WorkFiles folder. Just use the File Path to the HTML doc and you are Golden.

[@LearnitTraining]

Thank you for the tip Rajish!

[@comfortabanga1927]

Thank you for for this. I found the html doc but how to I get the data to the query? Like, do I get it from file, from other sources,… I still can’t get data Please help🙏

[@cloudlink994]

@@comfortabanga1927 same here

[@cloudlink994]

@@comfortabanga1927 ok I got it. From file, jut pick workbook, and the change the file type to "all files", and choose the the last one.

[@comfortabanga1927]

@@cloudlink994 Thank you

[@jeremiahnggada9]

Thank you for this great tutorial. Please how can I get the student file for practice? Please help. Thank you

[@LearnitTraining]

Hi Jeremiah! The link to the exercise files is in the video description

[@jeremiahnggada9]

@@LearnitTraining Yes. Now I got it. Thank you

[@dymesmimi]

You did a fantastic job explaining.

[@derekboshard4641]

Thank you, this is a brilliant introduction to Power BI. I learned so much and I actually love working with it. It's thrilling to see data become more visually appealing!

[@LearnitTraining]

Glad it was helpful!

[@CaribouDataScience]

Excellent video! Is the next video the "Intermediate " (there is two Beginners)?

[@LearnitTraining]

Hi Caribou! We have 2 Power BI series. This videos taught by Chelsea were recorded in 2017. The videos taught by Trish were recorded in Q4 of 2021 and the updated version of this course

[@CaribouDataScience]

@@LearnitTraining Thanks for the clarification.

[@yosafatkurniawan4641]

Thankyou for this tutorial! Chelsea's really a great instructor that makes me understand quickly, also the contents are really good for the beginner to start.

[@LearnitTraining]

You are very welcome Yosafat! Thank you for watching!

[@jillbentley3448]

Great teaching tool, one thing so far though, I don't have the same visualization panel as the teacher, mine does not have "saturation" too bad, I love that feature

[@belindawise8034]

The "Color Saturation" is found via the Format tool within the Visualizations column, click on Data colors, and then click on the fx box. This will bring up the tools to add the saturation effect.

[@sethbadu965]

@@belindawise8034 Thank you!

[@nilijahan3807]

@@belindawise8034 Hi I have a same problem but my visualization column does not have any data color or color saturation I tried it to add more visualization but system ask me for power point account that I dont have it and I tried with my email address but it ask my company email address that I dont have it any other way that I can add this feature thank you

[@RASM1066]

@@belindawise8034 Thank you, very helpful!

[@starring709]

Thank you! I was able to follow everything. Everything was good!

[@rockyber123]

you have explained everything in very easy language. Awesome :D :D :D

[@LearnitTraining]

Glad you liked it!

[@D4rkm00r]

Hi Chlesea, i'm not sure if I was missing a step here but the day 1 'Employee' file was a text/csv not an Excel. I had to move it into Excel and convert the fields living wage, avestatepay, gross etc, into a calculable format. Great tutorial! Thank you so much.

[@elpet8727]

How did you do this?:)))

[@boazemuna6589]

Thank you very much for the excellence class

[@LearnitTraining]

You are welcome!

[@samiahmedal-hag5809]

Félicitations pour cet excellent tutoriel! La formatrice est d'un talent inégalable pour présenter et expliquer la leçon. C'est inné! Bravo! J'ai vraiment hâte de suivre les prochains tutoriels.

[@maryamalsulaiman3321]

Thank you so much for this informative video. I learned a lot from it :)

[@LearnitTraining]

You are very welcome!

[@ahammadgalib5810]

Thanks a lot Learnit. And, Chelsea Dohemann, you're awesome 😘

[@LearnitTraining]

Thank you! 😃

[@katb2577]

Great tutorial! It would be great if could share one with HR measures!!!

[@LearnitTraining]

Hi Kat B! You can definitely add those with you own data in Power BI

[@katb2577]

@@LearnitTraining thank you for the reply! The truth is that examples on how to calculate HR measures such as turnover would be very useful!

[@sarahbottomley4565]

Very helpful and informative. One issue I found was that under the Geography data set Regions and States were flipped. Therefore, when selecting state I got region. It caused a little confustion but I got it figured out. The other thing is that my modeling tab does not appear as demonstrated. I have yet to figure out what I need to turn on to get the data type field which would allow for the % and $ signs. Thank you.

[@36chethan]

Even i had bit problem thanks for pointing out as it helped me

[@odianosenmasade8150]

Please share the solution. I'm having a hard time figuring it out

[@Mantlead846]

This was great, thank you.

[@LearnitTraining]

You're very welcome!

[@malaikaisanga2494]

Well-done. I love your videos and how you teach

[@LearnitTraining]

Thank you very much!

[@justas4254]

As far as I have tried majority of data modeling can be done in Power query editor in Power BI and you dont have to use excel power query. And it would be good practice to divide table using Star Schema.

[@LearnitTraining]

Hi Justas! Yes, PowerBI updates weekly so some of the functions have changed drastically. We have a new Power BI series currently in production.

[@evacourtney7848]

Great video and thank you for the files!

[@LearnitTraining]

No problem!

[@barbarajackson9265]

very nice and easy to understand. Thank you!

[@LearnitTraining]

You are welcome!

[@punaschaprakash9471]

Great commitment ... learned very basics of Query editors, which is a life-saving task..Thanks a ton..keep up the great work

[@oshushujoshua1557]

Hello Chelsea, please what version of Power Bi did you use in this tutorial? I will appreciate it if you can share the version details with me. Thanks.

[@LearnitTraining]

This is definitely an older version of Power BI as Power BI updates all the time.

[@sulaimonalaniayansola7359]

Thanks for the training. I enjoy the coaching Please send me the link or direct me on how to get the practing student files. Thank

[@LearnitTraining]

Hi Sulaimon! The link to the exercise files is in the video description

[@ano1976]

Such a useful video. Thanks a lot

[@LearnitTraining]

You are welcome

[@mohammedelsakally540]

Thank you very much Chelsea for all your efforts done with this video, It is a really valuable tutorial video.

[@LearnitTraining]

You're very welcome!

[@RogerBurke]

Great course. Learning heaps. Great presentation

[@LearnitTraining]

Thank you Roger!