OMG, I almost missed this masterpiece! I was scrolling through vids for my project and thought yours was just a quick rundown when I skipped to the end. But, something made me go back and check the process... and, dude, it's GOLD! Your thought process is insane! I'm literally memorized. No cap, your explanation is fire! You broke it down so smoothly, even a noob like me can understand. I'm totally bookmarking this for future reference.
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❤️
@@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.
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
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 😊
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
hey dude .... the homework was .... the bottom 3 "Chocolatiers" not overall employees ... so then the answer would be Dev Joshi, Anya Agarwal, Dev Agarwal.
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.
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
*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.
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?
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!!!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.
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.
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..
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
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.
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.
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
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.
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.
![How to build an Interactive HR Dashboard in Excel | HR Analytics in Excel [2024]](http://i.ytimg.com/vi/0IFYY7a5pAo/mqdefault.jpg)
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
this is my first daskbord in power bi , thanks chandoo sir ,🥰🥰
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.
OMG, I almost missed this masterpiece! I was scrolling through vids for my project and thought yours was just a quick rundown when I skipped to the end. But, something made me go back and check the process... and, dude, it's GOLD! Your thought process is insane! I'm literally memorized.
No cap, your explanation is fire! You broke it down so smoothly, even a noob like me can understand. I'm totally bookmarking this for future reference.
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
Thank you so much Sir! Please do more power bi reports for HR Professionals!!
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.
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 🙏🙏
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
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 !!
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.
Thanks for such a good teaching.
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
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
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.
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.
How you selected the salary,age, leave balance and named as staff
It is amazing.As a beginner ,it is very helpfull for me.Thanks a lot.
Thank you Chandoo, your real Goat in analyst .
Great tutorial from Chandoo. Many thanks for what you are doing to help people like me on this platform.
My pleasure
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 :)
Who’s Chandoo? Laddoo! Who’s laddoo?
😂😂😂😂 #k3g #Bollywood
You’re amazing, chandoo!!
Please make more advanced power bi projects!!
Could you pls share the way to connect Google sheet to power bi?
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??
To see Qualification Vs Salary, we can use Power pivot table
I am getting an error on the first measurement only where you directly created a column staff
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 ?
That's really amazing.
I am beginner PBI user and this is very helpful to me.
Thank you Sir.
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 :)
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
*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.
Thank you for the video, I felt good learning while watching and implementing the same.
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.
Instead of creating measure we can use count of empid for knowing how many people's are there ryt?
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.
Can we add this in our resume
Your content is amazing….i love it ❤️🔥❤️🔥
Its showing an error when we counting the headcount using staff variable .plz help in finding this.
Sir for education vs salary... Try with line chart.... It looks basic but gives better insight 😅😅
How do you integrate with the HRIS to see an up to date dashboard as well as history?
A beautiful dashboard but you should have slower it down when changes were made , it would have helped alot to understand the last bit
i cant find the datasets.could you please provide me the datasets
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.
Awesome course, practice make you intrest to learn more
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
Its showing an error when we counting the headcount using staff variable .plz help in finding this.
Thank you sir, you're explanation was very good,Please upload more and more video on trending technologies.
Dear Sir, i am not able to get cumulative headcount formula, how to get this
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?
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!!!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.
It was a great learning experience, Thanks Sir for your valuable effort.
So nice of you
Cumulative head count is not working how do you get this formula
The dedication to delivering quality content is truly commendable. A round of applause for hard work and creativity!
#TH-camGemchandoo
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.
Thanks Chandoo!
Many thanks for the amazing videos! how we can use the dashboard for multiple choices in one question please.
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 - th-cam.com/video/IR62y8Q_k-o/w-d-xo.html
How to mention this in our resume
😅great video Chandoo, thank you!
Glad you liked it!
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
Thank you and keep it up. I like it even more when we get different domain dataset and you walk through with us.
Cumulative formula is not working.. it's showing a single value for column date of join in table staff cannot be determined
Is it true that if we had thousands list of data, using excel would be facing difficulties?
Can u pls make a video on data analyst resume for freshers
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.
U have anything on azure architecture
why I got 6 answers when I filtered with name-top3?
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
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?
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
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.
Thanks for sharing Chandoo.
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
Sir can you make playlist on data analyst from basic to advance A to Z with power bi tableu
Sir please slow speed and please show your whole screen. Thank you sir❤
I am getting error for measure thing what to do
thank you. this video was very helpful
Its showing an error when we counting the headcount using staff variable .plz help in finding this.
Well done, my friend!
You are welcome :)
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.
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.
hi why didn't you remove the duplicates in name
There are 4 earners in bottom tables.
you are god sent
it takes my 45 mminutes to ddi what you did in last 2-3 minutes...but finally same look is coming
love from me
😀 More power to you ⚡
Thank you very much
3 lowest Chocolatier is Dev Agarwal, Anaya Agerwal, Dev Joshi (95)ID, Dev Joshi (131)ID
bingo...
very useful learning videos
Thanks Chandoo. :) :)
Excellent
nice video very helpful thanks a lot
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...
you are amazing sir
Cool Chandoo
Bottom 3 are
Anaya Agarwal - $51,100
Dev Agarwal - $51,100
Dev Joshi - $51,100
Dev Joshi - $51,100
Great job
The bottom 3 Earner of Chocolatiers :- Anaya Agrawal, Dev Agarwal, Dev Joshi, and Dev Joshi(131 employee number).
That is correct...
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
bottom 3 chocolatiers are
1. Anaya Agarwal - $51,100
2. Dev Agarwal - $51,000
3. Dev Joshi - $51,100
4. Dev Joshi - $51,100
The answer for the Bottom 3 are Ananya agarwal, dev agarwal, dev joshi