POWER BI Tutorial From BEGINNER to Pro Level - HR Power BI report - Power BI Desktop
ฝัง
- เผยแพร่เมื่อ 8 พ.ย. 2024
- Power BI video tutorial from beginner to advanced level. This is a Power BI video tutorial from a beginner to a professional level using Power BI Desktop.
Get the full Power BI class here: cutt.ly/c0kUQ3E
Learn DAX with projects here : www.shorturl.a...
Download the data used in this video here and template example: drive.google.c...
Download and install Power BI Desktop here: powerbi.micros...
Part-1 here: • POWER BI Tutorial From...
For the HR Report/Dashboard full tutorial check out the Power BI playlist: • Power BI Reports and D...
This power BI tutorial will take you to the Power Query environment where we can have our data transformed and then load it to the Power BI module for further analysis and perfect visualization.
In this Power BI Video tutorial, we will create HR using a report/dashboard with very dirty and rough data we got in CSV. Power Query will help you make the data clean and easy to use for analysis.
Power BI will help you create advance reports and dashboards. To create interactive and advanced reports and dashboards.
Subscribe and turn on the Bell icon for quick notification every time I drop a new video.
To master Microsoft Excel Dashboard and Data Analytics, using Excel subscribe, go to the home page of this channel to find 100s
of our videos on Excel Dashboards.
TO SUPPORT this TH-cam CHANEL, you can reach out to us here via WhatsApp at +234 810 6090 365 With your supports we can create more quality videos.
I can help you create your Business dashboard or any form of the dashboard with Excel or Power BI.
For Business Inquiry: send WhatsApp message to +234 810 6090 365 or send mail to officialdatawithdecison@gmail.com
Get colors for your dashboard design:
coolors.co/pal...
Watch other Excel animated dashboards
Watch part-1 of Beginner's Guide to Animated Excel Dashboards here: • Beginner's Guide to An...
Watch part-2 of Beginner's Guide to Animated Excel Dashboards here: • Beginner's Guide to An...
I teach this Excel Dashboard Fully Free!
Some Amazing Free Excel Dashboards for you, keep watching!
Use a new Excel Take a Tour Now | Create friendly Dynamic Excel Dashboards and Templates: • Use a new Excel Take a...
Making a Dynamic Dashboard in EXCEL excel VBA dashboard excel dashboard example
• Making a Dynamic Dashb...
Excel Dashboard with a Search Bar
• EXCEL DASHBOARD DESIGN...
Excel Dashboard you have never seen or created before
• Dynamic Dashboard in E...
Smart Excel Function Tricks for Business
• INTERACTIVE EXCEL PROJ...
Excel Dynamic Dashboard for Business
• How to Create Sales Da...
Excel Dashboards and workbooks with secured login
• HOW to make an EXCEL D...
Awesome Visual Excel Dashboard
• ANALYZING and VISUALIZ...
Excel Dashboard School
• BUSINESS ANALYSIS usin...
Free Sales Excel Dashboard
• MICROSOFT EXCEL DASHBO...
On this TH-cam channel, we create beautiful excel dashboard templates, all our modern excel dashboard designs will best suit your personal use or aid your company in times of analytics.
we have used a little VBA to garnish some part of our dashboard to make it stand out from the rest of the excel dashboard you had ever seen on TH-cam.
This dashboard is an EXCEL DASHBOARD EXAMPLE or An excel CHANNEL for Dashboard Inspirations.
th-cam.com/users/datawi...
For more wonderful Dashboard go here: / datawithdecision
Like my page on Facebook: / data-with-decision-105...
Enjoy free Excel Dashboard Course here: • Excel Dynamic Dashboar...
To create dynamic Inventory management or store management in excel (No VBA)
Click here: • Build Inventory Manage...
#makingadynamicdashboardinexcel
#vba #excelvba #datawithdecision #pivotTable #excel #msexcel #exceldashboard #excelpivottable #excel
#exceldashboard
Watch part-1 here: th-cam.com/video/0BKlUySopU4/w-d-xo.html
waiting for the part-3 in HR Dashboard series where you can teach Navigation and developing 3rd screen. If already available please comment the link here
Thank you for the great work you have put in. Waiting for the part 3 of this series for the navigation from one screen to another per se . It is highly expected. Thank you
@Data with Decision Thank you for the great work you have put in. Waiting for the part 3 of this series for the navigation from one screen to another per se . It is highly expected. Thank you
Just make the default color for the button corresponding to the page mentioned in the button@@KarthikArji
That's amazing sir, but where is the tutorial to make the navigation? I 've ever seen it yet sir in this video
th-cam.com/video/cFZtUzABOa8/w-d-xo.html
So, if you're struggling with High Rated & Low Rated
Here's the help.
First create a new measure and use this formula.
High Rated Count = COUNTROWS(FILTER('HR Analytics Data', 'HR Analytics Data'[Performace Rating] = "High Rating"))
&
Low Rated Count = COUNTROWS(FILTER('HR Analytics Data', 'HR Analytics Data'[Performace Rating] = "Low Rating"))
After creating these two measures create 2 more new measures and follow this.
% High Rated = DIVIDE([High Rated Count], COUNTROWS('HR Analytics Data'), 0.01)
&
% Low Rated = DIVIDE([Low Rated Count], COUNTROWS('HR Analytics Data'), 0.01)
You're welcome, happy learning :)
Thank you
OMG, totally fell in love with the vidoes. I learned so much from these videos. Thanks for providing such an insighful tutorials!
🙏
Thank you, Sir. The part about finding duplicates could be more transparent. In fact, in my understanding, duplicate means promotion=retrenchment=1. As we have the same employee names in the promotion table and retrenchment table, to find a duplicate, you should sort by name the two tables and find where promotion=retrenchment=1.
Thanks, Kader. There are many ways to do things in Power BI. Thanks for connecting with Data with Decision.
To get a more accurate amount of duplicates, this is the formula - =IF(COUNTIF($A$2:$A$73, B2)>0, "Y", "N") in column c (assuming Promotion is A & Retrenchment is B). Then after this, on column D, insert this formula, =IF(C2="Y",B2,"").
Hello, do you mean we have more than that number?
thank u, it's so helpful
Thanks a lot brother
@@TaofiqAdeyemo-s3i yes we should have 54 :)
Hi, thank you for sharing...Please, at 12:13 on the Excel worksheet, what you had after some minutes is quite different from the main one...
How did you achieve that?
Thank you for this video. i think there is a mistake and it's me misunderstanding.
you want to look for employees that are going to be promoted and retrenched at the same time. in the sheet that you have the employee's lists isn't the same ( for promotion you have only the list of employees to be promoted), for the retrenched you have the list of all employees ( 0 for employee to be retranched and 1 for employee that are not going to), it means that the order of employees for both list isn't the same. So, in order the see if an employee belongs to both the promoted list and retrenched list we have to test if he is going to be retrenched = 1 and then if we find him name in the promoted list then he belongs to the list.
yes and the employee names that he got is not going to be retrenched nor promoted
You are too good to be ignored.Thank you for all you do
Nice having you on the channel
very nice work, I've follow you in the part1 and i make-it very easy....thank u. I'll begin this second part and i hope to finalize-it as the 1 part.....good job.
Thanks 🙏
Part 2 is again the amazing one❤🎉thank you so much sir for this wonderful section. I tried to add the navigation button but could craft cool navigation buttons like u did i mean the style of ur navg buttons.. I'll be glad if u let us kw how u did that.
Thank you very much for the Tutorial. My question is that , in my PowerBI table, I noticed that the people who are not due for promotion still showed up but with value "0" but in your own they were not there
Super Boss!👏 i learnt a lot from you..
Respect you from India..🙏
Full respect for you.
HI, great video and explanation. just the excel for promotion and retrenchment people excel lists, the source are different from what you have. can you upload an updated version. Thank you very much!
Thanks so much for this tutorial, it was clear, precise and well detailed. Can you please guide on how the navigation section was created?
th-cam.com/video/ovQ9czcvotk/w-d-xo.html
Hello, thanks a lot for these videos, they have helped me a lot :) I just have a question: when you created the list of "will be retrenched at 8:40 minute, as you can see there are ones and zeros, ones for employees who are gonna be retrenched and zeros for those who keep on service, so that means when you downloaded this list to excel actually you took all employees, could be there a mistake with that procedure? besides, when you try to find duplicates in excel you use the if function, wouldn´t be more appropriate to find them using the vlooup function?, because in the way you are using the if function just compares cell by cell instead all the range that we need look for. Thanks so much!
I'm so thankfull to u that u mentioned this oversight by sir at 8:41 .. Since no body was mentioning it I thought may be I'm thinking it in wrong way. 😂
After taking only the values which are 1 from both the. Csv files, I got 4 names? Is that right?
@@nagmafariyal8982 you must have 54 names in duplicate , so 54 people can be promoted an be retrenched at the same time
we coould find the list of employees who are going to be promoted and retrenched by using filter
at 12:17 we can clearly see entry #5 Abram Q Keffer has no corresponding duplicate value, hence "N" . But suddenly at 12:24 it changes to "Y' for duplicate value. Can you explain how did this magic happen?
I used IF and AND functions to find the answers on Due for Promotion and Will be retrenched columns. Cause think about it, if you have employees due for promotion and will be retrenched set to 1, it makes no sense, so something should be done about those employees, if you have employees due for promotion set to 1 and will be retrenched set to 0, then those the ones that will be promoted. That's basically the logic I used.
Also leave both column that gives 1 and 0 for cross checking.
@@braulioandre2918plzz explain this
Sir, please can you explain how you did the excel part again because what I have isn't the same with yours?
I also have the same issue as well as others and I do not see where any answer has been given.
Amazing content I must say but I have a question, how did you link the three sheets together and you were able to navigate through the pages?
Is bookmarking
@@datalab365 Thank you. I will look into that.
Just finished it. Really helpful and insightful tutorial. Great job!!
Thank you.
im getting error in performance rating sir
Another great tutorial, looking forward to the next in the series.
Thanks
Their are no duplicate values . How to proceed with nxt steps. If we consider that column with 1's and 0 its providing yes for some columns. The problem is the retrenchment have more entries than problem. The missing rows are come up like duplicate indicating y
Very good instruction with nice creativity
Thanks.
Amazing explanation pleas make video about navigation page
I will.
You can subscribe to our new Data Analytics channel:th-cam.com/video/4qx-SJc1Xsk/w-d-xo.htmlsi=7Y1SpDxXXz9Qpdw
This is one of the best tutorial i have seen. You had very good and important examples needed. I shared as well.I really appreciate the effort. I watched like watching a movie. At times looking at subs. , 😀Thanks a lot ❤
Thank you
Thanks for this great work. Please, I need help getting the IF command you input in the command getting the duplicates.
How do i calculate the high rating and low rating for the measures
Nice tutorial but where is the navigation button how you make it ???
Will do that in my next upload
You have done an excellent work, and I have learnt alot, can you post the link for part 3?
Thanks and contiune the good work
Sure
@@datalab365 any hope for the lonk of the part 3?
@@davidenwelumnwa7008 I might, if I don't I would make up for that in another dashboard. Thanks for the engagement.
thank you so mush can you explain how do you make the navigation please
Can you please watch this video. I will teach it in the remaining parts. th-cam.com/video/ovQ9czcvotk/w-d-xo.html
th-cam.com/video/ovQ9czcvotk/w-d-xo.html which the video, I will make a video in the series on how to create it
@@datalab365 ok thank you so much for your efforts
Awesome video. Thanks for helping us
🙏
hello , and thanks for your good présentation , where can i find the part 3 of this presentation ??? marc from france
Thank you so much for the amazing work. However, cannot see the last bit of putting all the icons together part, would you post that in some near future? Many thanks
You find the solutions in this project. Watch this Full Power BI Course (Power BI Desktop & DAX): th-cam.com/play/PLwIcJx1aSL1QP_6xAGDK6EViMGq9ysrc2.html
@@datalab365 Thank you so much, so insightful!
Hey can u please mention the video which helped you to put the item together. Mention the video name
@12:21
Why should we look for yes values?
Why have you changed few values by yourself which was not shown in the video?
Sorry !
Sir can you help with how to make navigation ?have you made any video for that?
I will make a video for that. Noted. Thanks.
@@datalab365 btw the dashboard is beautiful.its helping beginners like me to make new projects through your videos.Have a great day😁
@@datalab365 Hi, waiting for the part 3 video. Please I request you to create it ASAP.
Thank you for another great session. In your subsequent uploads, could you please include a situation where there isn't a 100% match when merging queries and how to deal with it !
Okay, hope you were able to download the practice file?
@@datalab365 I did and followed all your steps bro. On standby for the more amazing stuff from your channel
@@Ayuk1 I agree. The duplicate formula did not work. it was all N. Not sure why.
First, let me commend you for your attention to details, it’s 100. In this video, you didn’t show how you created the home, action and detail slicer and how it slices through the dashboard. Give me any of your video where it demonstrated. I have been trying it but am mixing things up.
Thanks for this. How did you create the navigation panel?
I will soon make a video for it
@@datalab365alright! Thank you. Will be expecting
📢Hey, I want know how to find Employees that will be getting severnce benefit in power bi itself instead of using excel. Please tell me
Follow our new channel.
You can subscribe to our new Data Analytics channel:th-cam.com/video/4qx-SJc1Xsk/w-d-xo.htmlsi=7Y1SpDxXXz9Qpdwj
Hi, thank you for the video.
I have a doubt, for adding total employees in each department, I am getting the total number of employees designated for each department. For eg. if the total employees are 200, I am getting 200 in each department. What should I do about it?
hi, can you make a tutorial on how you curated the navigator tab?
Sure.
what is mean, the cahrt for employee by over time? yes for what and no for what?
Yes: over time
No: not over time.
bro please tell me how to add button
Everything is fine sir but what he had done ? What problem he found or what decision he made?
Can you pelase explain how to do the navigation tab ??
Sure, would make a video for that
hi loved the video.
can you share the part 3 as well?
The class ends at part 2.
You can watch this. Improve your Power BI Report/Dashboard: th-cam.com/play/PLwIcJx1aSL1Soc0ONtg8wGG78QyVM9iEb.html
@@datalab365 I wanted to know more about how you made navigation in this particular template
hello sir , can you just clarify in this video how % high rated and % low rated has been created as in previous 1st video it was not shown.
thankyou
ya just repeat same logic ho jayega
Hiii can you please explain how did you make the navigation part please i can’t find it in the video
This will help: th-cam.com/video/uP3VpcT69Y8/w-d-xo.html
please how did get the duplicates "Y" and "N" first there were all "N" then the video was cutoff ??
Please, How did you do the home? Cuz it"s not shown in the video
Learn from here: Watch this Full Power BI Course (Power BI Desktop & DAX): th-cam.com/play/PLwIcJx1aSL1QP_6xAGDK6EViMGq9ysrc2.html
can u show how did u create the navigation as a dot ?
Follow this class: th-cam.com/video/rBuQmKgL5UE/w-d-xo.html
I will teach there.
@@datalab365 sure, thank you
Thanks
Sir my dout is ,How do you to set 12:21 to 12:24 i can't understand it....plz explain me
Thought i was the only one who thought something was amiss there.. I hope he can kindly explain what happened
Even i couldn't follow, the instructor skipped the vedio i guess.
Same here, I found out that there is no duplicate between promotion and retrenchment employees
I got stuck there too. I think he just manually changed some of the names in the first column, so that there would be some duplicates, so I did the same
@@luquest_9438 i realized that my duplicates were totally different from that of the instructor... he had duplicates whose name began with A... mine were at the bottom
Thank you
you are welcome Ravi
not able to find the dataset you have used to create dashboard.
Is on a drive 🔗 link in the comment section
How can I get d data in csv for practice. It's difficult for me to download the data below
waiting for final part
A new tutorial is coming up for that.
After this how to save in to excel
You can do that in power bi service
Hello @data with descison is there a part 3 of this training? The last video in this playlist states "1 unavailable video is hidden"
No part 3.
I will be uploading Power BI Analytics tutorials soon
@@datalab365 Please confirm the part 3 is out as i can't find it.
Thnx your sharing documents
Thanks
how you did navigation, i can't find any video. can you share me link or tell me
Same here please, I would appreciate
This will help th-cam.com/video/A92tlBccwMs/w-d-xo.html
do you have the video explaning page navigation?
Kindly check out our other power bi videos.
@@datalab365 Which one to be specific please? That navigation of this HR series is the concluding part of this tutorial. Thank you
I Think that what you have done in Excel is not a good practice to find the duplicate , that may imply error , you have find only 6 people in duplicate but in fact there are 54
😭
there is a problems with the employees that are due for promotion and will be retrenched ,
Abram Q Keffer
Alanna L Tyrell
Akiko S Godby
Agnes Blow those employees are neither due for promotions nor will be retrenched
can anyone explain ??
Will do something similar to this on our new channel.
You can subscribe to our new Data Analytics channel:th-cam.com/video/4qx-SJc1Xsk/w-d-xo.htmlsi=7Y1SpDxXXz9Qpdwj
You have explained so well.. I gone through Part1 and 2. Can I have part 3 video link please..
Is just 2 parts.
@@datalab365 eagerly waiting for part 3. Bookmarks and other stuff is not covered in part 2, hope you will release the part 3 soon.
0. If for someone formula from 12:10 doesn't work check this:
=IF(A3=B3;"1"; "0")
or if you have other excel language translate ,,IF" to your native word meaning English "if". For Polish it is 'jeżeli" so in polish lang. Excel formula should be:
,, =JEŻELI(A2=B2;"1"; "0") "
,, =IF(A2=B2;"1"; "0") " will DO NOT work
Part 3 bro?
It’s very clear the Tutor did manually type some names in the Remove duplicates part because if we Pause the video at 12.51 and look over to the Promotion Column First Value= “Adelaide L Harrop “ and then match it with Employee name Retrenchment column value in cell 10 we see the same name Adelaide L Harrop and to which the find duplicates column says “N”.
Quite funny.
Brother, there is no manual name typing, everything is dynamic.
@@datalab365 Don't think people watching your videos to learn are fools... It's very much evident that the video was edited and those values were manually typed.. You can go back on your video, pause it at 12.51 and refer the 2 column and see for yourself the Duplicate name in column 1 and column 2 being same , just the cell no.s are different which obviously IF function will never be able to give back the result as duplicate as it will only refer values in cells of same row...
And mind you there were 54 duplicate values( when the names of both column are put in one single column and then remove duplicate option is utilised.
Unfortunately TH-cam doesn't allow screenshot to be uploaded otherwise i would have given a evidence of how where you are wrong and deliberately not accepting it...
@@datalab365 The first part of your video on this Report was no doubt Superb . But in this part almost all people who have commented did face issues in Excel Duplicate part which can only be possible if some editing has been done in the sheet but obviously not made public..
I did read a few comments where the
1. end result was different to what you got and so on.....
@@soodvarun20 I will urge you to watch the excel version to see how I made everything, it will help.
I use a formula to determine everything
@@datalab365 So i think you used the If(And) function to get the names.
But it only returns the names as Duplicate if the name in column 1 ( Row 2) is same as name in Column 2(Row 2).
On contrary it gives the result as Not Duplicate if the same in Column 1(Row 2) is present in Column 2 (Row 3).
On the final note the function used if( and) function gives a list of 4 employees, names of which are totally different to what you got obviously through some manually typed names in the list that's why the video is obviously edited at that stage .
where is part 3 please put link in comment ..its totally incomplete dashboard..there is no navigation part
If you missed any part please watch this: Watch this Full Power BI Course (Power BI Desktop & DAX): th-cam.com/play/PLwIcJx1aSL1QP_6xAGDK6EViMGq9ysrc2.html
Top❤
🙏
hi sir im getting performance high rating low error plze expla
Something might be wrong with your DAX code, watch it over again.
No sir i checked more time
@@jayashree4745 type your DAX Code here let me see what happens
High emp rating=calculate ([total emp], 'hr analytical data'[performance Rating]="High rating")
@@jayashree4745 check the datatype of your performance rating to make sure is a text.
Add filter function after [total emo]
Calculate([total emo],
Filter(hr analytics data[ performance rating ] ="High rating"
)
Hello, anyone to help please , at 8:40 I am getting similar Employee names in both tables -due to promotion and Retrenchment. @Data with Decision
Please can anyone help with the column name used from the HR Analytics Data to calculate the High or Low Rated in the new measure.
Performace rating
Excel part is confusing. We have the same names in promotion and retrenchment.
If one persons name appeared in the two.... Is best for the management to decide whats best for the employee.
Remember, retrenchment is not a healthy moment in an organization.
It can comes at a point when you got due for promotion.
I got 54 duplicates, what did I do wrong
I need employs excel data
Hello sir , can you just clarify in this video how % high rated and % low rated has been created Because when i am trying to show this visual it shows :
MdxScript(Model) (19, 57) Calculation error in measure 'All Measures'[High Rated]: DAX comparison operations do not support comparing values of type Integer with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values.
Please Tell me.
Create measures for high and low rated first then branch out to calculate the percentages.
That is you will have to divide either high rating or low rating by the total employees using the divide function.
Hope this is clear, let me know if I can assist further.
part-3 ?
Am i the only one facing problem in excel sheet ? #data_mismatch
do reply if anyone know the solution.
Background Music is very Annoying
Sorry, please.
Hello, can you teach me how to format table like this?
You can take our full power bi course and learn everything you need to learn: www.udemy.com/course/power-bi-data-analytics-course-and-dashboards-creation-2022/