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!!
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!
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.
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.
i just want to commend the instructor of this tutorial, you are by far the best UA-cam tutor i am following. Thanks for sharing this to us, it is can help people in acquiring new skills
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.
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.
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.
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
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.
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.
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!
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 :) )
Chelsea Dohemann. You are literally my favourite UA-cam person ever. i even search UA-cam 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.
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!
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!
***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
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.
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
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.
I am already made two projects on power bi based on some UA-cam 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.
Hello All, I almost never write comments on UA-cam 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!!
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.
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.
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!
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
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.
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🙏
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!!
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 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!
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.
The Actual Revenue column used in the video by default had a data type; Whole Number. Whereas that in the dataset provided in the description link below has the data type for the same column and a couple of other columns- Difference and % Difference- to be Text.
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!!!
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
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: ua-cam.com/play/PLoyECfvEFOjaHaCUMLHed0krBFjavN6YT.html
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
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.
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.
with german versions of PBI and EXCEL in employees.csv the fields Grossplay...2013-2015 and living wages are not being interpreted as a currency or numbers but as text. Must be converted prior to import
So did I! Your comment helped me realise it wasn’t an issue with the data files we were given/my use of Power BI, so thank you. I’m from the UK so to resolve I went into Query Editor > extracted data after delimiter ‘$’ > close & applied. Then in the data tab under the modelling tab I selected data type as fixed decimal & format as $ English (United States) :)
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!!
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!
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 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.
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.
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.
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.
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
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.
@@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
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!
When I try to get the data from web (continents). I'm getting error. I was able to get the table earlier. Idk what's wrong. It was working before. Do you have any idea why this is happening?
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
Hi Usman! Thank you for watching and thank you for subscribing! Here is the playlist for all our PowerBI videos - ua-cam.com/play/PLoyECfvEFOjaHaCUMLHed0krBFjavN6YT.html
Please help me downloading Exercise Files from OneDrive. I am getting error as " Some files weren't downloaded. Maximum zip file size limit reached. Zip file size cannot be greater than 100 MB" when ever I download files from Day-2 Work files as File Size is more.
The Tuitorial is good. I have a small challenge with my employee table on BI it does not show the sigma sign-on Avestatepay and at the Grosspay 2013-15
The sheet from Table1 is identical to the GeographyAsia sheet at around 18:00 so I am uncertain what you mean by there is absolutely no reference to table between the two unless you were referring to the name itself. There seems to be a difference to be noted at this marker. Please clarify? Thanks.
After Appending GeoEurope and GeoNorthAmerica to GeoAsia, the final outcome does not include any entry for GeoEurope and GeoNorthAmerica. It only shows entries for GeoAsia and the rest are empty cells. However, it gives me a correct count of rows and columns. This happens after I have clicked close and load. In the Query Entry, all entries are visible but not after I have loaded it in. I can't get pass this
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!!
Wow, thank you!
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!
We are glad you were able to learn so much!
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.
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
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.
Thank you for the wonderful tip!
i just want to commend the instructor of this tutorial, you are by far the best UA-cam tutor i am following.
Thanks for sharing this to us, it is can help people in acquiring new skills
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.
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.
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.
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
thank you so much kind human !!
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.
Thanks for the good info ! I have been looking for this features
This needs to be pinned.
thanks🙏
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.
You are very welcome Frederick!
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!
Thank you for the kind words and support Salvador!
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 :) )
Sooooo true
Chelsea Dohemann. You are literally my favourite UA-cam person ever. i even search UA-cam 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.
Wow, thank you!
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!
You're very welcome!
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!
You are very welcome!
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!
You are welcome Catherine! We hoped you learned a lot!
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!
I was here for the first five minutes and ended up watching the 2 hours video. Beautiful. Thank you very!
Hope you enjoyed it!
@@LearnitTraining please the exercices file is not working
***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
Please provide the Geo tables so that I can use as a sample
Exercise files link not working
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.
How do I download the exercise files. Do I need to unzipped the files? I appreciate your help. Thanks!
@@manoyspeedbagal7093 you can just download the entire zipped files and extract the files after you've downloaded. At least that's what I did.
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
Thanks for the tip!
I think this girl is one of the very best instructors I have ever experienced, university or elsewhere! :-)
Thank you for the kind words Wayne!
Figured it out. Data had names for Region and State interchanged. Renamed and it works.
thank you! I was stuck with this
Thank you, thank you, thank you , clear , short and sweet and no funny accents or annoying background music !
Glad you liked it!
The best tutoring videos. loved the voice and clear explanation. Please upload SQL and Tableau tutorials! :)
I agree!!!!!!
Agreed!
Please upload tableau and SQL video as well. Really nice videos
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
Your teaching is Amazing. Feels like having session in Classroom. Your voice make even virtual class sounds real.
Thank you for the kind words, pradip!
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.
You're very welcome!
I am already made two projects on power bi based on some UA-cam 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.
Glad we could help!
Hello All,
I almost never write comments on UA-cam 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!!
Thank you for watching and an extra big thank you for subscribing Maurice!
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.
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.
You are very welcome! You can get free access to Power BI here: powerbi.microsoft.com/en-us/
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!
This is an unbelievably well structured and explained tutorial. Thank-you so much for offering your time in making this.
Thank you for subscribing! It helps tremendously!
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
You're very welcome!
Best beginner video so far on UA-cam. Really appreciate
Thank you Temidayo! We hope you learned alot!
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 .
Glad it was helpful!
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.
Thank you for the tip Rajish!
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🙏
@@comfortabanga1927 same here
@@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.
@@cloudlink994 Thank you
Clear voice, clear instructions. Thanks.
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!!
You are very welcome Richard! We are glad you go so much from our videos! Also thank you for subscribing!
I love how this class was delivered. Really nice fir someone who just needs a quick recap! Loving the Instructor too... Great job!
Glad you enjoyed it!
thank you for the free training. no doubt, m 2 years late, but, is it still wonderful ..Blessing everybody. :)
Our pleasure!
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
Thank you watching and a big thank you for subscribing Burak!
@@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!
This is a great beginner tutorial. Voice is clear, very nice and understandable. The exercise definitely help instills an understanding of Power BI.
This is the best video I have come across on Power BI. Excellent video!
Thank you so much for the kind words!
Best Power BI intro tutorial i've seen.
Glad it was helpful!
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.
The Actual Revenue column used in the video by default had a data type; Whole Number. Whereas that in the dataset provided in the description link below has the data type for the same column and a couple of other columns- Difference and % Difference- to be Text.
I felt so fortunate and blessed to find this tutorial. Such a masterpiece of a lecture 💯
Glad it was helpful!
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!!!
While loading csv file , columns like avg state pay and gross pay are not showing as calculable field
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
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: ua-cam.com/play/PLoyECfvEFOjaHaCUMLHed0krBFjavN6YT.html
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
Thank you so much callofjudy xx! Extra big thanks for subscribing!
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.
Very well present, thank you (there are a few corrections which did not make it into editing, that needs some TLC)
I love the voice of this instructor, and more than those on the channel....
Wow, thank you!
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.
Hi Justas! Yes, PowerBI updates weekly so some of the functions have changed drastically. We have a new Power BI series currently in production.
Fantastic - your style and voice is just great! Thanks a million for a job very well done
QqOqq
with german versions of PBI and EXCEL in employees.csv the fields Grossplay...2013-2015 and living wages are not being interpreted as a currency or numbers but as text. Must be converted prior to import
So did I!
Your comment helped me realise it wasn’t an issue with the data files we were given/my use of Power BI, so thank you.
I’m from the UK so to resolve I went into Query Editor > extracted data after delimiter ‘$’ > close & applied. Then in the data tab under the modelling tab I selected data type as fixed decimal & format as $ English (United States) :)
By the best video on PowerBI. Special thanks to the instructor. So calm & patient.... keep up the good work..... :)
You are very welcome! Be on the look out for our new Power BI videos!
The very moment i heard the voice i knew it was the same instructor from vba, awesome!
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.
This is our more updated version: ua-cam.com/video/e6QD8lP-m6E/v-deo.html
We also have a new version coming out later this year
Thank you soo much, very clear and simplified explanation....
Thank you so much for providing these Power BI tutories. They are just wonderful
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!!
The explanation is clear (the voice is fantastic), at the right pace. Thanks for the exercise files
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!
Glad it was helpful!
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.
You are welcome!
@@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.
Excellent pace, qualitative explanation and really pleasant voice! Led me to the advanced tutorial
Glad you liked it!
I am actually on the 52nd minute and blown away. You go girl😘🤩
Thank you so much Wanga!
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.
You are very welcome Yosafat! Thank you for watching!
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.
Even i had bit problem thanks for pointing out as it helped me
Please share the solution. I'm having a hard time figuring it out
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.
How did you do this?:)))
Great commitment ... learned very basics of Query editors, which is a life-saving task..Thanks a ton..keep up the great work
Every video by you is amazing, I will make sure to share this with my LinkedIn followers
Awesome, thank you!
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
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.
@@belindawise8034 Thank you!
@@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
@@belindawise8034 Thank you, very helpful!
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!
Thank you for watching Sandeep!
Fantastic training! Great pace, pleasant voice, easy to follow.
Thank you kindly!
Thank you! I was able to follow everything. Everything was good!
You did a fantastic job explaining.
When I try to get the data from web (continents). I'm getting error. I was able to get the table earlier. Idk what's wrong. It was working before. Do you have any idea why this is happening?
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
Hi Usman! Thank you for watching and thank you for subscribing! Here is the playlist for all our PowerBI videos - ua-cam.com/play/PLoyECfvEFOjaHaCUMLHed0krBFjavN6YT.html
color saturation filter didn't include in my powerbi.where can i find
its the best video for learning power bi
Glad you liked it!
Why does the Power BI I loaded not have a color saturation display as a choice to manipulate?
Please help me downloading Exercise Files from OneDrive. I am getting error as " Some files weren't downloaded. Maximum zip file size limit reached. Zip file size cannot be greater than 100 MB" when ever I download files from Day-2 Work files as File Size is more.
Amazing work on these. I have learnt alot.
Glad you like them!
This was very helpful, thank you for making it available.
Glad it was helpful!
Can you help how to download data for GeoAsia, Europe and NorthAmerica data?
Thank you very much Chelsea for all your efforts done with this video, It is a really valuable tutorial video.
You're very welcome!
Pretty good especially for starter beginners.
Do you need prior excel knowledge for this?
I'm so thankful to have stumbled on your channel. Keep it up! 😉
Will do Jimmy!
Thankyou so much for excellent Tutorial!!
You're very welcome!
Thanks, that was very helpful.
You are very welcome!
I add the "shape map" and then add State as the location. It shows me a completely grey map of the USA. What am I doing wrong?
The Tuitorial is good. I have a small challenge with my employee table on BI it does not show the sigma sign-on Avestatepay and at the Grosspay 2013-15
Hi - Where are the exercises to follow along?
Thank you very much for the excellence class
You are welcome!
Thanks, Chelsea, for This Amazing Tutorial!
You're so welcome!
Dear Chelsea,
Thank you so much for your amazing tutorial. I really enjoy it and love it .
Thank you so much.
Nice one Chlesea.
You're so welcome!
The sheet from Table1 is identical to the GeographyAsia sheet at around 18:00 so I am uncertain what you mean by there is absolutely no reference to table between the two unless you were referring to the name itself. There seems to be a difference to be noted at this marker. Please clarify? Thanks.
Thank you so much for this informative video. I learned a lot from it :)
You are very welcome!
After Appending GeoEurope and GeoNorthAmerica to GeoAsia, the final outcome does not include any entry for GeoEurope and GeoNorthAmerica. It only shows entries for GeoAsia and the rest are empty cells. However, it gives me a correct count of rows and columns. This happens after I have clicked close and load. In the Query Entry, all entries are visible but not after I have loaded it in. I can't get pass this
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