Power BI Dashboard from Start to End (Part 1)| HR Dashboard | Beginner to Pro | Power BI Project

[@sandeepa8755]

mark by words, in next couple of years you will be one of the best youtubers for Data Analysts and Data Science career related programs, keep going bro , hats off to your patience detailed reports detailed understanding with nice creative dashboards. All the best.

[@datatutorials1]

Looking forward to that Thank you so much for your appreciation

[@abidurrahmanabir7745]

I agree with you 💯

[@ayushmisra4925]

I am so thankful for people like you, please give us live paid projects

[@adioby]

I am really impressed by your tutorial that I find so clear and well explained. I learned a lot from it.

[@robroszk]

Thanks for this video! One of the BEST vids i have seen out there! Thoroughly complete and encompasses most critical topics needed to build a good DB in PowerBI. Was surprised to see thumbs down on a video such as this-Do they not realize they are getting FREE INSTRUCTION and subject matter that many would pay thousands of dollars (happily) to obtain?

[@datatutorials1]

Thank you for such kind words ❤️

[@shaonimitra1949]

@@datatutorials1 I am a beginner in power BI. I would say this is one of the best videos I have ever watched for data analytics. Please make more videos like this.. Everything is clear and well explained.

[@TheEliteTutorials]

Your channel deserves to be subscribed. Amazing tutoring on Powe BI. Thanks.

[@Ayesha_siddiqah]

incredible job done by you sir, very well explained, thank you very much. great teacher for me to learn power bi as a fresher your channel helped me a lot.

[@bipinjoshi2265]

Thank you sir because of your dashboard videos I have a new job of MIS analyst

[@datatutorials1]

So glad to heard that, best of luck for new journey 😃

[@bipinjoshi2265]

Thankyou sir

[@motivationQuotationo]

Hi Bipin is it possible to connect with you. You can send you email here.

[@motivationQuotationo]

Or your IG, WhatsApp

[@motivationQuotationo]

Thanks

[@abidurrahmanabir7745]

Complete the Projects according to your instruction Brothet... Keep it up❤️❤️

[@CopyRightScapper-lc7yx]

Thanks for sharing the data and solution, that is the best think humanly possible!!!

[@jagdeeshs4618]

Hi bro i am new to Power BI..u r really amazing...video is very clear and Informative...

[@Ak-io7fl]

Please make more power Bi projects You videos are realy helpfull

[@datatutorials1]

Sure

[@senthil27win]

You are best Tutor, please provide more videos to train us..Appreciate your efforts brother

[@christygrace2426]

Your HR analytical skills most definitely!

[@yogeshchakre4642]

Great Presentation and Colour Coding....... it's so Simplistic yet very Informative and Interactive Dashboard........ Great 👍

[@datatutorials1]

Glad you liked it

[@shatakshijha5268]

Ap kisi ke bhi query ka message ka reply to kr ni rahe ho ...jinse apne good feedback ke liye request ki h bas unke message pr thanku bol rahe ho sirf very bad

[@datatutorials1]

No that is not the case, I reply to queries which aren’t discussed in video, and mostly I cannot type the answer when its too long to explain issues you have. Let me know what is your issue?

[@kdineshkamal_kdk]

Thank you for explaining so nicely , I tried developing it and it worked well 😊

[@phannhan4440]

I really appreciate that, clear explanation. could I have some advice from you? if you have various ages, how do you create an age band in the power query?

[@digitalatit7324]

under sort age section 36:01.....when i am creating the conditional column with respect to the age , i am only getting 5 and 1 .....in the output even though the changed the data type from text to whole number...can anyone help me out with that

[@datatutorials1]

It is case sensitive column, make sure you add value correctly that are same in data set

[@digitalatit7324]

@@datatutorials1 Still getting the same result

[@datatutorials1]

Send me your workbook on [e-mail]

[@madeshwaran5448]

Hi please make a practical vidro on extract transform load and data migration with some big data sets.

[@datatutorials1]

Definitely 👍🏻

[@rolivhuwamatshavha3816]

What are the common data cleaning tasks in Power BI, and how can I remove duplicates efficiently? How can I change data types for columns in Power BI to ensure accurate visualizations? I need to rename columns in Power BI to make them more user-friendly. What's the best approach to do this?

[@datatutorials1]

Watch my data cleaning video kzbin.info/www/bejne/d4jGnpyvp8Zqp9Usi=K8w_n5gRvN_2Hpmg

[@TheBurker]

Really good videa. New to Power BI and learned a lot from it. Thanks.

[@datatutorials1]

Glad you liked ✨🙂

[@sharathraja8299]

Thanks for the video, learnt something knowledgeable

[@Vedika_Subramaniam]

that Attrition count is not coming in my data properly...its showing like either complete yes or else no

[@monicajoshi4936]

Is your problem solved of attrition, if yes can u share how ???

[@deeraa1921]

Learned new things. Nice video

[@datatutorials1]

Glad you liked it ✨

[@Mahanthesh.]

Great explanation for beginners......thank you so much sir

[@carlogilardo9957]

Hi mi friend, please more video like that, full project in power bi. I need it, and my frien i've spent 3 days lookink for a good tutorial in which dataset are shared and also the explanation is clear, i found only you. Please go ahead with this content, i will share your profile as well. thanks a lot bro

[@iftekharkhan6318]

This video is best. kindly make video on powerbi basic to advanced level please as soon as possible

[@kessgift6814]

hi, please I can't find category label. I'm trying to rename the text like you did

[@ManishRaj-io4bg]

i love your way to explain step by step

[@anitagodwin34]

Great Explanation Keep it up very easy to Understand

[@rashminaiyyer9703]

Great explanations for beginners 👍

[@mounikaannem2768]

hi i am not getting the attrition count I have followed the same steps but after creating new column I am only getting 0 as value please help me. i applied conditional column as same as you but i am geeting zeros

[@papiyamistry1168]

Attrition count whole column showing 0 , m trying to its so many tyms bt ans not coming, also i tried to change the whole no in data typ bt ans shows always 0 ,plz give me the solution who have exact knowledge, how to get whole column correct ans .

[@technicalAlam97]

Ha bhaii ho hi nai rha hai

[@What_hr_does]

i wanted to know if there are different versions of power bi..bcz how you converted the decimals into number into average age column it's not coming up in mine's..help me out please

[@maheshrathod204]

hi i am not getting the attrition count I have followed the same steps but after creating new column I am only getting 0 as value please help me

[@aimalkhan9682]

Change the data type to whole number

[@jazzzhuu825]

after we finished doing this.. should we delete all the sheet we used before? or we should always open all that sheet while we do presentation?

[@dullestower8773]

Columns O & P in your spreadsheet don't seem to have column headings. Please advise!

[@dullestower8773]

Maybe -2 and 0 are meant to be the column headings? Please confirm.

[@679karthic]

31.40 - we can just copy and paste the old pie chart and just change to bar chart will give all the same background..!!

[@PremKumarM]

Let's say we have 3 hr data files for year 2020 2021 2022.. want to see trend of attrition every year.. pls have a video on that in power bi to view trends with multiple files...

[@sajidmomin9206]

YOU can merge three files into one file using append option in power bi and then analyse according to year

[@monicajoshi4936]

You are also getting same pop-up like text can't be converted to whole numbers, do u want to continue. How u managed to get it correctly.

[@maheshsthapa6406]

Hi I have a query how to use month wise attrition data where It also shows active employees month wise and attrition %

[@swetasnigdhasamantray417]

Am not able to find out the data set link. Can you please help me to get the dataset link.

[@shrikantbadge3978]

You are marathi., I understand from your accent. Thanks great video.

[@chetanshinde3154]

Thanks, this really help in a lot way. Request your help to know how to calculate the product-wise price difference MTD, QTD, YTD for same period current year & same period for last year

[@VishalMakwana-b1h]

After adding the employee count in card, it's aligned to left only, how can i make centrally aligned?

[@iliariano3126]

Hello, I need urgently PowerBI 12/18/2023 2.124.1052.0. MS has deleted the download. Plz help! Thx!

[@suneethasivudu9892]

Thank u for giving this good video and great explanation

[@datatutorials1]

Thanks for your support ✨🙂

[@vivekkapil4571]

Very nice explained 😊great thanks for your efforts 🎉

[@datatutorials1]

Glad you liked it ✨

[@abhisheksinghbisht1528]

greeting.. I am getting an error while calculating attrition rate "The SUM function only accepts a column reference as an argument."...Please help

[@TheeGirl-]

How can I show my skills in sql along with this project? I was thinking I could use sql to find the attrition count and attrition rate. What do you think?

[@datatutorials1]

That’s great, the video on sql is already created, see my Data Analyst Portfolio Project playlist

[@TheeGirl-]

Thank you!

[@lakmina2002]

in Excel sheet i dont see any column (-2, age, daily rate, distance from home etc ) but after aload to power bi i can see it , can some one tell how those fields came

[@joanarun1]

Thankyou!!!!!!!!!!!!!!!!!! All I can support you by add this channel to my list and giving a like.......

[@krimlinturhks4651]

Very informative.

[@manishrai265]

how to sort CF age Band using DAX

[@datatutorials1]

You can do a manual sort using a column by creating a measure

[@monicajoshi4936]

Did you get how to sort. If yes share the steps

[@manaswithamanu2200]

Hello sir , after applying the conditional column in attrition count iam getting all are zeros not showing yes is 1 no is zero

[@NixonBranch]

For calculating Attrition you should create a Measure instead of calculating column. Very nice explained great thanks for your efforts .

[@lost-frequency]

How would you calculate it?

[@swethashankar1856]

Where is "Undo" Option in Power Query Editor ?

[@swethashankar1856]

Sir, In the Bar chart after changing the "Sort Axis" to CF_age band and changed to ascending also, but still I could see the "Under 25" bar as last column that is not sorted in ascending order in my trial action, could you please support to resolve it ? Orelse any other method to do the bars in a right order ?

[@monicajoshi4936]

My attrition column is showing zero, video nice but my answer is coming wrong. Can you detect the error

[@saibalmukherjee3301]

Very good sir..but sir not able to download the report that you given..

[@chandu-3976]

Can you please tell the source of the data as to which this attrition rate is for which particular company or industry ?

[@mousumidutta1090]

At 11.55 my data are in summation number not in words. What to do

[@prachi-k2y]

AI enhances user experience in digital platforms by personalizing recommendations, which keeps users engaged and satisfied.

[@preciouskadiri9506]

CAN WE MAKE A DASH BOARD IN EXCEL WITH THIS PLEASE IF YOU CAN

[@datatutorials1]

It’s already created, see video on my channel

[@preciouskadiri9506]

@@datatutorials1 i meant if we can follow you till we get the same dashboard?

[@ranjeethkumar3257]

sir in attrition i have tryed to conditional colum in that i havedid as you did bot i am gettimg only zeros

[@afremjames3989]

Can you prepare recruitment dashboard

[@kufrefrank6991]

Nice tutorial Well understood. Thank you

[@ColleenSalami]

How did you total the employee count ?

[@datatutorials1]

Sum of employees count

[@jamoliddinsodikov7311]

The SUM function only accepts a column reference as an argument. why it keep saying when i do same thing??

[@prasadgauda8223]

Bro close the first column with a close bracket before adding another Sum..

[@annnuthegaming8629]

Hi, Iam a beginer. I tried to create this dashboard. But when iam sorting this ageband, An error occured like 'circular Dependency detected'. Can you please hlp.

[@datatutorials1]

Are you using sort by steps mentioned in video

[@afeezoloko3423]

Thank you so much for the great explanation, it is really helpful

[@datatutorials1]

Thanks keep supporting ✨

[@Wissou_]

Thank you so much for this helpful turorial

[@sanjeevkumarjalwal5255]

The values of under 25 and over 55 is visible in Chart Please

[@hareshprajapati1300]

Thank you very much for sharing your knowledge

[@rayyanzaidi3323]

amazing video bro

[@datatutorials1]

Glad you enjoyed

[@santoshnayak3346]

Can we have one for environment health and safety

[@datatutorials1]

Sure will try

[@MrTactics26]

Great video thank you!

[@kantiramp2805]

While sign up, asking professional mail id, not personal, what to do

[@datatutorials1]

No need to sign up

[@Knowledge_Gain_Earn]

Thanks for sharing this calculation

[@Just_Ibrahym]

Awesome video. Please could you help with the link for PowerPoint design for the background. Thank you

[@shai3004]

I cannot see column tools tab for sorting columns. Does it need paid version? P.S. Nice explanation, and your voice is really soothing.

[@louismercier5719]

Great tutorial !

[@ojasagnihotri8198]

Hy, I am having a problem in sorting through CF_age band, as after completing this process and applying it in the column graph, it is sorting through number of employees instead of the newly created Age Sort column.

[@siddevil4938]

@datatutorials1 am facing the same issue, please help

[@hellozindgi9162]

when i double click in visualization area it is not showing any visual window where i can write the dimension , measure and type of chart we need. what to do now to resolve it?

[@sohitsingh8664]

Could you please elaborate this I think I can help you

[@passionhdshorts_11]

from where u get this data , from kaggle or any other

[@magielukumay]

Good teacher😊

[@markalex9385]

sir im getting output as 0 in attrition count im working on it from last 3 days, can u plz help me out of this problem!

[@datatutorials1]

The conditional formula is case sensitive, are you writing yes and no correctly

[@pulakkabir2276]

I am using Mac, can u tell me how to use the full version of power bi on Mac? I tried parallel but it was 2 week trial version only

[@datatutorials1]

Install VMware Fusion and then install windows OS in this instance.

[@EMMANUEL-gv4mg]

@datatutorials1 : Hello my friend, thank you very much for this very well explained video. I have a question about filters, towards the end of the video, I did not understand what these different filters are, when you click on a visual/format/edit interactions? Please can you explain? With thanks in advance

[@sharonstephen3953]

I tried to make this, but not getting attrition cout is in 1 and 0 , it's getting complete 1 or 0 . What to do

[@aishakhanzada3165]

i'm facing same problem did you find solution?

[@asmaab4078]

Very good job..keep up the good work

[@AnuReddy_]

Why is my attrition showing 0 in all column

[@ankitrawat9369]

Data is not downloading what should I have to do

[@michelleferretto8141]

New subscriber!

[@SankarKanyadhara]

Boss you are great and like god

[@chitraalexander]

Am also trying this video my attrition count also showing 0 how to solve it pls tell me.

[@shazim6088]

My requirement is to add a pop up for every cell in the matrix you have created, can we do that? not a dynamic tool tip, but a pop up with detailed view which can be exported

[@mallikadhingra8052]

What is this dashboard showing?

[@datatutorials1]

HR attrition analysis

[@apandit24]

Hi, thank you for a great explanation. The HR Data.xlsx sheet is seen as a view-only sheet on Drive. It cannot be Down-loaded and so cannot be uploaded to Power Bi. Also inputting the link in Bi (Downloading via the web) does not yield the files stated. It shows the background or coding etc files. How can we D/Load the data file into Power Bi to create the dashboard? Thank you again.

[@datatutorials1]

Click on the file and then click on the download option

[@Use.For.Daily.]

​@@datatutorials1 sir, data file is not working to download . Plz give us it to eassyer.

[@Use.For.Daily.]

​@@datatutorials1it's open like a docs file as image.

[@EMMANUEL-gv4mg]

@@datatutorials1 Hello my friend, thank you very much for this very well explained video. I have a question about filters, towards the end of the video, I did not understand what these different filters are, when you click on a visual/format/edit interactions? Please can you explain? With thanks in advance

[@satishshinde8768]

Thankyou sir ❤

[@user-innovativehub780]

Very well good sir 👍☺️