This kind of videos are not available even in the paid courses. Thank you so much Chandoo for your amazing and insightful videos. As a teacher you are really amazing. Lots of love❤️
bottom 3 , Anaya Agarwal , Dev Agarwal, Dev Joshi..... Your all Videos are very informative. Thank you. I have recently started power bi and your your videos are really helping me a lot. Can you please make video on data modeling, bridge table 😊
hey dude .... the homework was .... the bottom 3 "Chocolatiers" not overall employees ... so then the answer would be Dev Joshi, Anya Agarwal, Dev Agarwal.
Home work exercise Bottom 3 are: Ananya Agarwal - $51,100 - Female Dev Agarwal - $51,000 - Male Dev Joshi- $51,100 - Male Btw thanks for the cool Homework:) loved working on it
@@chandoo_ I would like to learn the nuances and nitty gritties in making awesome dashboards ui and etc. Will your course teach me those skills? How is it different from all the great videos of yours on you tube? Also if we purchase the course do we get any live doubt clarification sessions?
My course offers at least 10x more content in a structured manner. Plus, I use different datasets in the course to show how to work with various business scenarios. While many of the popular dashboard techniques are covered in both my course and channel, in the course I also explain how to use bookmarks, drillthrough, adv. conditional formatting and multi-page report building. Unfortunately, no doubt clearing sessions though.
*HOME WORK ANSWERS* : Bottom 3 employees of "chocolatier" are ----- Anaya Agarwal, Dev Joshi ,Dev Joshi (another employee), Dev Agarwal. Thank u for the video anna.
Extremely useful! Thumbs up all the way! Easy to follow along, great length to not give up! Thanks! I liked how each Q/chart in a separate sheet - gonna start using that in xl.
Hi sir, I really love your videos! I'm currently without a job and I'd love to learn Power BI from you. But, honestly, your fees are too high for me right now. Is there any chance you could help me out? Your teachings mean a lot to me, and I'd be really grateful for any assistance you could offer. Thanks so much for considering my situation.
Great job!!!This dashboard is only for those employees who started and are still working in the company. And those co-workers who worked and left the company, how to include them? Staff growth trend over time to be correct.
This is awesome.. Learned a lot from this video. Just a suggestion - pls add one more slicer as dropdown and create measure MTD, YTD, QTD Lastweek, Today, Yesterday etc..
As usual chandoo bring such video for us, That is great thing. I have 1 question chandoo for doing formatting of charts could we apply format painter so after doing formatting for 1 charts we can apply it to rest of the charts.
Thank you very much for some good videos about Power BI. I still have some difficulties with calculating in Power BI. What do I use if I have a table consisting of work hours that people have registrered on projects and a table consisting of estimates of how many hours we estimated they will use and I want to compare the two? Also all the hours that have been registered is in single lines how can I sum all the hours employee A have registered on project A, B and so forth?
Hi @chandoo really nice video but pls next tym ensure to improve responsiveness of it. It annoys when it is not fit in mobile screen. BTW thanks dude for this nice explanation
Power BI has a separate mobile view option. In this video I don't show it as that is not relevant for my audience (of the report, not channel). I will make another video on creating mobile version of reports.
Bro I don't even know how to use excel ,, pls advise me how can I start , and can I ask you how do you speak fluent English in an crisp and clear tone with confidence
I chandoo sir, I would like to ask you a question that while creating a headCount=countrows(staff) there is no name with the staff in data table so how we got the headcount?.... please reply
There is a little bit of misconception in the title of this video as this is a Report built in PowerBI Desktop; not a dashboard which is only built in the Power BI Service
Is it possible to have 2 tables with a slicer for each, and a variance table created based on selection? Like Current Month with it's own slicer, Prior Month with it's own slicer, and a table for the variance between the two.
I called myself trying that, but when I added the slicer it controlled both tables. I couldn't add another slicer. I supposed I could do it with 2 different datasets, but I want to use the same dataset for both and have a variance table and chart. Have you ever seen/done anything like that? Thanks for the reply.
Question, I would like to know how to use cell reference in a way that I can build a config for Cisco switches. I have interface that I would like to build and copy into the running config. I have the interface in column A and going down in rows. But some the cell I reference go across the columns. Switchport mode access and spanning tree portfast….. When copy a section and paste it low the cell jumper up in number in relation to the amount I jumped down.
The bottom 3 Earner of Chocolatiers :- Anaya Agrawal, Dev Agarwal, Dev Joshi, and Dev Joshi(131 employee number) as the lowest Salary of the employees were the same I got more than 3 names. Let me know if I am right?. Thank you.
Pls help please......... 13:14 after add as new query, it didn't show the options same as his option, there is no remove duplicates even after add as new query you can see in top there is a new transform column is added but it didn't show up in my app, the layout is same before add as new query and after add as new query
Being in HR myself, I'm a bit underwhelmed by this video, because I know you can do so much more!! HR Analysts don't look at questions like "How many people's names start with A". I would have expected some analyses like what is the turnover rate by job category. What is the voluntary vs involuntary turnover rate. Etc. Also HR Analysts don't look at one source of data, they look at multiple sources of data. We could have analyses like what is the eNPS (employee net promoter score) from our last engagement survey, what has been our training expenses in the past year (or how many hours of training or development did we invest in such and such employee categories last year) etc.
Hi Nicolas.. great points. I have a turnover analysis dashboard video, combining data from different sources, training tracker and vacation dashboards already on the channel / my website. So I wanted to branch out a bit more and share few entry level concepts. Feel free to browse for those videos.
Chandoo - great video and appreciate your effort and dedication to sharing what you know. @nicolasturcotte-legare2242, looking forward to your first video.
@@3cpritch ha ha! I did laugh at your tongue-in-cheek comment. Indeed who am I to criticize, when I don't have a RUclips channel. If I did indeed have the time, I would like to start a RUclips channel, but unfortunately I don't... :( That is not to say I think I am better than Chandoo. Quite the opposite actually! I am here because Chandoo had been very instrumental in developing some key Excel and PowerQuery skills that I use every month. If this needs to be stated, I do appreciate very much your generosity, your authenticity, and your engagement Chandoo! ❤️
![Power BI for HR | How to Build an Interactive Dashboard & HR Data Analytics [2024]](/img/1.gif)
I sat down the whole video and implemented each and every step you did and I would really recommend others to do so. Thankyou sir.
Glad it helped!
can you send your project or send me your github
it takes my 45 mminutes to ddi what you did in last 2-3 minutes...but finally same look is coming
love from me
this is my first daskbord in power bi , thanks chandoo sir ,🥰🥰
This kind of videos are not available even in the paid courses. Thank you so much Chandoo for your amazing and insightful videos. As a teacher you are really amazing. Lots of love❤️
You're most welcome
Bottom Three Are:
1. Anaya Agarwal - $51,100
2. Dev Agarwal - $51,000
3. Dev Joshi - $51,100
4. Dev Joshi - $51,100
Amazing detailed videos Chandu Thanks for helping us out.
bottom 3 , Anaya Agarwal , Dev Agarwal, Dev Joshi..... Your all Videos are very informative. Thank you. I have recently started power bi and your your videos are really helping me a lot. Can you please make video on data modeling, bridge table 😊
Absolutely correct. Cheers !!
I have recently started using power bi and I really like the Way you explain things. I`ve learned a lot, Thank you very much for this one
Great to hear!
@@chandoo_ sir please share your WhatsApp number here when we need your help we will be chat with you in WhatsApp please help us 🙏🙏
great tutorial, just a suggestion for videos like this that don't use fast forward effect during applying any kind of effect in the dashboard
Hi As a part of Homework
The bottom 3 employee by salary are:
- Allene gobbert
- Husein augar
- virginia mcconville
hey dude .... the homework was .... the bottom 3 "Chocolatiers" not overall employees ... so then the answer would be Dev Joshi, Anya Agarwal, Dev Agarwal.
Home work exercise
Bottom 3 are:
Ananya Agarwal - $51,100 - Female
Dev Agarwal - $51,000 - Male
Dev Joshi- $51,100 - Male
Btw thanks for the cool Homework:)
loved working on it
Ananya Agarwal, Dev Agarwal and Dev Joshi is the bottom 3 Chandoo. I just changed the option from "Top" to "Bottom" in the filter by "Top N" options.
Extremely knowledgeable Chandoo for people starting out in Power BI. Thanks a ton!!! Implemented every step, it took like 1.5 hr.
Great to hear!
@@chandoo_ I would like to learn the nuances and nitty gritties in making awesome dashboards ui and etc. Will your course teach me those skills? How is it different from all the great videos of yours on you tube? Also if we purchase the course do we get any live doubt clarification sessions?
My course offers at least 10x more content in a structured manner. Plus, I use different datasets in the course to show how to work with various business scenarios. While many of the popular dashboard techniques are covered in both my course and channel, in the course I also explain how to use bookmarks, drillthrough, adv. conditional formatting and multi-page report building. Unfortunately, no doubt clearing sessions though.
*HOME WORK ANSWERS* :
Bottom 3 employees of "chocolatier" are ----- Anaya Agarwal, Dev Joshi ,Dev Joshi (another employee), Dev Agarwal. Thank u for the video anna.
Wonderful video. Just started following you for over a month now and your videos are really helpful...thank you for the wonderful videos.
You are welcome :)
Perfekt, very informative vedio,
Kindly make more theses types of vedioes for becoming a good business Intelligence-analytiker.
Thanks a lot 😊
Extremely useful! Thumbs up all the way! Easy to follow along, great length to not give up! Thanks!
I liked how each Q/chart in a separate sheet - gonna start using that in xl.
Happy to hear that :)
Hi sir, I really love your videos! I'm currently without a job and I'd love to learn Power BI from you. But, honestly, your fees are too high for me right now. Is there any chance you could help me out? Your teachings mean a lot to me, and I'd be really grateful for any assistance you could offer. Thanks so much for considering my situation.
it is good faculty
Thank you Chandoo, your real Goat in analyst .
Chandoo bro, as I want to add this project to my resume, please let me know what will be the description of this project. It will be really helpful.
Hi Chandoo,
for the homework,bottom 3 chocolatier include Anaya Agarwal, Dev Agarwal, Dev Joshi.
yes sir, same also my answer but dev joshi found 2 time how to resolve it??
Great job!!!This dashboard is only for those employees who started and are still working in the company. And those co-workers who worked and left the company, how to include them? Staff growth trend over time to be correct.
Sir for education vs salary... Try with line chart.... It looks basic but gives better insight 😅😅
Thank you for the video, I felt good learning while watching and implementing the same.
That's really amazing.
I am beginner PBI user and this is very helpful to me.
Thank you Sir.
This is awesome.. Learned a lot from this video.
Just a suggestion - pls add one more slicer as dropdown and create measure MTD, YTD, QTD Lastweek, Today, Yesterday etc..
Great idea. You can see how to do that in this video - ruclips.net/video/IR62y8Q_k-o/видео.html
Great tutorial from Chandoo. Many thanks for what you are doing to help people like me on this platform.
My pleasure
As usual chandoo bring such video for us, That is great thing. I have 1 question chandoo for doing formatting of charts could we apply format painter so after doing formatting for 1 charts we can apply it to rest of the charts.
Yes, definitely
It was great learning with you. thank you so much. Can you make a video about the power bi data analyst versus power bi developer?
Thank you sir, you're explanation was very good,Please upload more and more video on trending technologies.
Sir, please make a video on how u manage ur 24 hours to do this lot of stuff.. On time management.. How u make day more productive
Who’s Chandoo? Laddoo! Who’s laddoo?
😂😂😂😂 #k3g #Bollywood
You’re amazing, chandoo!!
Please make more advanced power bi projects!!
Many thanks for the amazing videos! how we can use the dashboard for multiple choices in one question please.
Thank you very much for some good videos about Power BI.
I still have some difficulties with calculating in Power BI. What do I use if I have a table consisting of work hours that people have registrered on projects and a table consisting of estimates of how many hours we estimated they will use and I want to compare the two? Also all the hours that have been registered is in single lines how can I sum all the hours employee A have registered on project A, B and so forth?
Thank you and keep it up. I like it even more when we get different domain dataset and you walk through with us.
Awesome course, practice make you intrest to learn more
A beautiful dashboard but you should have slower it down when changes were made , it would have helped alot to understand the last bit
It was a great learning experience, Thanks Sir for your valuable effort.
So nice of you
Hey friend what software program do you use to record what you do on PC screen and also to talk to and also save in video format ?
Hi @chandoo really nice video but pls next tym ensure to improve responsiveness of it. It annoys when it is not fit in mobile screen. BTW thanks dude for this nice explanation
Power BI has a separate mobile view option. In this video I don't show it as that is not relevant for my audience (of the report, not channel). I will make another video on creating mobile version of reports.
Thanks Chandoo!
Subscribed your channel the first time I saw a video a month back
Its showing an error when we counting the headcount using staff variable .plz help in finding this.
The dedication to delivering quality content is truly commendable. A round of applause for hard work and creativity!
#RUclipsGemchandoo
Thanks for sharing Chandoo.
Bro I don't even know how to use excel ,, pls advise me how can I start , and can I ask you how do you speak fluent English in an crisp and clear tone with confidence
I chandoo sir, I would like to ask you a question that while creating a headCount=countrows(staff) there is no name with the staff in data table so how we got the headcount?.... please reply
Thank you very much
Your content is amazing….i love it ❤️🔥❤️🔥
Its showing an error when we counting the headcount using staff variable .plz help in finding this.
Instead of creating measure we can use count of empid for knowing how many people's are there ryt?
thank you. this video was very helpful
Its showing an error when we counting the headcount using staff variable .plz help in finding this.
Sir please slow speed and please show your whole screen. Thank you sir❤
Sir can you make playlist on data analyst from basic to advance A to Z with power bi tableu
Is it true that if we had thousands list of data, using excel would be facing difficulties?
very useful learning videos
Could you pls share the way to connect Google sheet to power bi?
😅great video Chandoo, thank you!
Glad you liked it!
3 lowest Chocolatier is Dev Agarwal, Anaya Agerwal, Dev Joshi (95)ID, Dev Joshi (131)ID
bingo...
Excellent
How you selected the salary,age, leave balance and named as staff
sir, can u make vdo on, how to filter 50+ slicer names available in data and send mail automatic of each person on outlook mail
There is a little bit of misconception in the title of this video as this is a Report built in PowerBI Desktop; not a dashboard which is only built in the Power BI Service
Thanks for pointing that out.
Well done, my friend!
You are welcome :)
you are amazing sir
Is it possible to have 2 tables with a slicer for each, and a variance table created based on selection?
Like Current Month with it's own slicer, Prior Month with it's own slicer, and a table for the variance between the two.
Yes, It is possible. Create diff. tables and diff. slicers.
Further, you can go to format and edit interactions for each slicers.
I called myself trying that, but when I added the slicer it controlled both tables. I couldn't add another slicer. I supposed I could do it with 2 different datasets, but I want to use the same dataset for both and have a variance table and chart.
Have you ever seen/done anything like that?
Thanks for the reply.
Can u pls make a video on data analyst resume for freshers
Chandoo can I use it as a portfolio project for business analyst job?
Sure you can. Please do credit the source (this video and me) when you do that.
@@chandoo_ sure buddy.
nice video very helpful thanks a lot
Question,
I would like to know how to use cell reference in a way that I can build a config for Cisco switches. I have interface that I would like to build and copy into the running config. I have the interface in column A and going down in rows. But some the cell I reference go across the columns. Switchport mode access and spanning tree portfast…..
When copy a section and paste it low the cell jumper up in number in relation to the amount I jumped down.
Great job
How do you integrate with the HRIS to see an up to date dashboard as well as history?
Thanks Chandoo. :) :)
Dear Sir, i am not able to get cumulative headcount formula, how to get this
Cool Chandoo
Thank you so much.
You're welcome!
I am getting an error on the first measurement only where you directly created a column staff
Its showing an error when we counting the headcount using staff variable .plz help in finding this.
Can you help me with Cumulative headcount formula?
i am not getting it
It is explained in the video. Please pause and replay if needed.
The bottom 3 Earner of Chocolatiers :- Anaya Agrawal, Dev Agarwal, Dev Joshi, and Dev Joshi(131 employee number) as the lowest Salary of the employees were the same I got more than 3 names. Let me know if I am right?. Thank you.
Yes I also got the same output
You are right...
Cumulative formula is not working.. it's showing a single value for column date of join in table staff cannot be determined
Pls help please.........
13:14 after add as new query, it didn't show the options same as his option, there is no remove duplicates even after add as new query you can see in top there is a new transform column is added but it didn't show up in my app, the layout is same
before add as new query and after add as new query
The bottom 3 Earner of Chocolatiers :- Anaya Agrawal, Dev Agarwal, Dev Joshi, and Dev Joshi(131 employee number).
That is correct...
packing associate bottom-3 earners i create column measres Rank = RANKX(ALL('Hr_Data analytics'), 'Hr_Data analytics'[Salary], , ASC, Dense)
U have anything on azure architecture
There aare four entiries in bottom 3 earners of chocolatiers. is it to do with the name being the same?
Yes, I was a bit sloppy with the data creation and didn't realize the duplicates snuck in.
How to mention this in our resume
hey chando how to remove those headcount and job title labels from the visual? i just need only one title headcount by job title
I think are you are referring to "axis labels". You can remove them by going to axis settings.
i cant find the datasets.could you please provide me the datasets
The answer for the Bottom 3 are Ananya agarwal, dev agarwal, dev joshi
xin cảm ơn!
Being in HR myself, I'm a bit underwhelmed by this video, because I know you can do so much more!!
HR Analysts don't look at questions like "How many people's names start with A". I would have expected some analyses like what is the turnover rate by job category. What is the voluntary vs involuntary turnover rate. Etc.
Also HR Analysts don't look at one source of data, they look at multiple sources of data. We could have analyses like what is the eNPS (employee net promoter score) from our last engagement survey, what has been our training expenses in the past year (or how many hours of training or development did we invest in such and such employee categories last year) etc.
Hi Nicolas.. great points. I have a turnover analysis dashboard video, combining data from different sources, training tracker and vacation dashboards already on the channel / my website. So I wanted to branch out a bit more and share few entry level concepts. Feel free to browse for those videos.
Chandoo - great video and appreciate your effort and dedication to sharing what you know. @nicolasturcotte-legare2242, looking forward to your first video.
@@3cpritch ha ha! I did laugh at your tongue-in-cheek comment. Indeed who am I to criticize, when I don't have a RUclips channel. If I did indeed have the time, I would like to start a RUclips channel, but unfortunately I don't... :(
That is not to say I think I am better than Chandoo. Quite the opposite actually! I am here because Chandoo had been very instrumental in developing some key Excel and PowerQuery skills that I use every month. If this needs to be stated, I do appreciate very much your generosity, your authenticity, and your engagement Chandoo! ❤️
Let's not be petty. Let's be awesome.
why I got 6 answers when I filtered with name-top3?
1.Anaya Agarwal - $51,100
2. Dev Agarwal - $51,000
3. Dev Joshi - $51,100
4. Dev Joshi - $51,100
5.Lilyan Klimpt - $51,200
There are 4 earners in bottom tables.
hi why didn't you remove the duplicates in name
Can you do more of power query
Sure. I have plenty of videos on PQ. See the playlist - ruclips.net/video/PiFAa_jjaEI/видео.html
Fin ished watching
bottom 3 :
Ananya Agarwal
Dev Agarwal
Dev Joshi
I am getting error for measure thing what to do
Bottom 3 earning Chocolatier:
Anaya Agarwal
Dev Agarwal
Dev Joshi
Correct!
When you asked to subscribe, I unsubscribed and subscribed again.
Evadu ra ee extra gadu
Dev, Anaya and dev agarwal bottom 3 chocolatiers