POWER BI Tutorial From BEGINNER to Pro Level - HR Power BI report - Power BI Desktop

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.

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 YOUTUBE CHANEL, you can reach out to us here via WhatsApp at [phone] 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.

Get colors for your dashboard design:

Watch other Excel animated dashboards

I teach this Excel Dashboard Fully Free!

Some Amazing Free Excel Dashboards for you, keep watching!

Making a Dynamic Dashboard in EXCEL excel VBA dashboard excel dashboard example

Excel Dashboard with a Search Bar

Excel Dashboard you have never seen or created before

Smart Excel Function Tricks for Business

Excel Dynamic Dashboard for Business

Excel Dashboards and workbooks with secured login

Awesome Visual Excel Dashboard

Excel Dashboard School

Free Sales Excel Dashboard

On this Youtube 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 YouTube.

This dashboard is an EXCEL DASHBOARD EXAMPLE or An excel CHANNEL for Dashboard Inspirations.

To create dynamic Inventory management or store management in excel (No VBA)
#makingadynamicdashboardinexcel
#vba #excelvba #datawithdecision #pivotTable #excel #msexcel #exceldashboard #excelpivottable #excel
#exceldashboard

[nckpgyg]

That's amazing sir, but where is the tutorial to make the navigation? I 've ever seen it yet sir in this video

[barma]

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.

[TaufiqCandra]

OMG, totally fell in love with the vidoes. I learned so much from these videos. Thanks for providing such an insighful tutorials!

[willywales]

You are too good to be ignored.Thank you for all you do

[labidisafa]

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.

[sfikiht]

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, "").

[TaofiqAdeyemo-si]

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

[neffect]

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!

[faith_oseghale]

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?

[SamyyyK]

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 :)

[TosinMalate]

Thanks so much for this tutorial, it was clear, precise and well detailed. Can you please guide on how the navigation section was created?

[nagmafariyal]

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.

[AlexanderOriginal]

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!

[rochellerobinson]

Another great tutorial, looking forward to the next in the series.

[shamaislam]

Super Boss!👏 i learnt a lot from you..
Respect you from India..🙏

[olisaemekaaghabuilo]

Very good instruction with nice creativity

[mansourbenlameur]

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 job.

[lakshay]

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?

[amoleoluwaferanmi]

Sir, please can you explain how you did the excel part again because what I have isn't the same with yours?

[amanyelkolaly]

Amazing explanation pleas make video about navigation page