End to End Data Analysis Project | HR Analytics Power BI Project 🚀

In this end-to-end data analytics project, we will take a REAL dataset for employee presence from a company called AtliQ and perform data analysis in Power BI. We invited an HR from AtliQ Technologies who conveyed her requirements and we built a Power BI dashboard for her to help her with employee insights. This project is perfect for your data analyst resume as it is built on a real dataset (and not the toy dataset).
Input Excel and output pbix files can be downloaded from here: codebasics.io/resources/resum...
Timestamps ✨
0:00 Introduction
2:38 Understanding the HR Requirements
10:55 Gathering and Transforming Data
43:03 Creating Matrix using DAX
58:35 Dashboarding
1:27:21 Closing
Other data analytics projects
===================
Sales insights with Power BI: • Power BI Project For B...
Sales insights with Tableau: • Tableau Project For Be...
Personal finance dashboard: • Power BI Data Analytic...
Pinali Mandalia: / pinali-mandalia
Do you want to learn technology from me? Check codebasics.io/?... for my affordable video courses.
Need help building software or data analytics/AI solutions? My company www.atliq.com/ can help. Click on the Contact button on that website.
🎥 Codebasics Hindi channel: / @codebasicshindi
#️⃣ Social Media #️⃣
🔗 Discord: / discord
📸 Dhaval's Personal Instagram: / dhavalsays
📸 Codebasics Instagram: / codebasicshub
🔊 Facebook: / codebasicshub
📱 Twitter: / codebasicshub
📝 Linkedin (Personal): / dhavalsays
📝 Linkedin (Codebasics): / codebasics
🔗 Patreon: www.patreon.com/codebasics?fa...
#codebasics #dataanalytics

[@ShittheswaranSelvakumar]

here i have to appreciate Mr.Dhaval patels explanation now and then... it help sme a lot to understand the things better as abeginner.. Thank you Dhaval sir.. You are understanding the pulse of the beginners...

[@inderpanda]

Amazing Project I enjoyed doing this simple yet effective HR analysis Project. 👏🏼👏🏼

[@manzarhussian9699]

This is amazing! If you could also share the content in a text format with step-by-step instructions, that would be fantastic.

[@user-wi1be7cg7z]

The use case is amazing,learnt new concepts, like unpivot, function etc.

[@shajahanmohammed3321]

we are not aware that the finale is real HR but the projects that you summarize and drive solution is awesome

[@jyotisingh1671]

This is an amazing Project, I was looking for some such project. I must say, the way Mr. Dhaval has explained every lil thing now and then... that's really helpful in understanding concepts.

[@javshah105]

Thank you very much for sharing with us such valuable knowledge.

[@pawan17oct]

Worked in Recruitment for 11+ Years... Now doing Data Science MS. This will help me a lot.

[@codebasics]

Definitely

[@nidhitiwari3110]

Hello Sir, thank you for bringing up this series. I made Power BI projects with your help and i got a job. Eternally grateful!!

[@gautamsharma6225]

Just wanted to ask you that after completing project, should I directly mention it in resume or I need to publish it somewhere?

[@This_is_am]

Yeah, same doubt!

[@nidhitiwari3110]

In my case, just mentioning on resume helped. However, if you want to give it a more polished look, you can publish it and then provide the link on the resume for the HR to see it.

[@gautamsharma6225]

@@nidhitiwari3110 Alright, thank you!!

[@gauraavthakurr]

Congrats Nidhi, may i know what job role you got? and what type of question where asked. a detail reply would be beneficial to us all. I'm a fresher looking for a job so help me. Thank you

[@FoziaSidhu0005]

A complete BI course for data analytics required........ ❤❤❤

[@SohailKhan-hd8gz]

It's really helpful sir thank you very much ☺️

[@miguelhermar]

This is amazing! Thank you for putting this out. You all rock :) Could you also do the same with financial data where you focus on credit risk or something similar? It'd be so helpful.

[@sizzusharma9138]

13:05

[@sizzusharma9138]

13:20

[@sizzusharma9138]

13:20

[@ishtdeepsingh1693]

Thank you for this detailed videos, but could you also be able to share a word file about the learning, outcome, questions you implemented while making the projects

[@roohifarha6204]

Eagerly waiting 😌

[@karthikv]

u do so much for community. thank u

[@adilfaizanrazvi929]

Excited ........😍💫

[@MessayaFoureal]

this project is good and it covers everything important but my challenge was following along you its hard to figure out id you're a beginner cause there's many times I was lost and I had to figure out how and when was this step taken and yeah was a bit great challenge I can say. thank you a lot.

[@indiawallah95]

Sir what reality of iT sector current resession😢... their is no job... courses are increased but their is no job..... please tell reality.....

[@readerisleader12]

Very excited for HR project

[@codebasics]

👍🏼 It uses a real data set from my software and data company AtliQ. This project can add a lot of weight to your resume!

[@gopinathperiyasamy9896]

It's a Useful video that made some knowledge in power bi

[@AbhishekGupta-te3fe]

I am excited

[@justinbieber063]

Thank you 🙏🏻 🎉❤

[@amidardovillarente]

Wow... thank you and amazing content video end to end data analysis /HR Analytic Power bI Project....godbless

[@codebasics]

Thank you so much for your kind words

[@applepeel1662]

Please do more projects on market research and analytics

[@lipaacharjee9083]

Sir, If you can bring details road map or course about People Analytics, or if you can suggest us something, that would be wonderful. Regards

[@inspiringlife_upskills]

@Codebasics- thank you for sharing this project, it really helped and cleared most of the doubts. However, could you please check that why you didn't consider the unique days count instead you took total days which include duplicates as well? Request you to please reply.

[@anishv8723]

can this be used as capstone final year project as well ?

[@user-qv8qs1uu7o]

Can we model this data into facts and dimensions like calendar table, dim_name and Fact_Data ? Because when I tried to create Dim_Name it showed me the following error: Formula.Firewall: Query 'FactData' (step 'Merged Queries') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.

[@Vaibhav-lb1rr]

AMAZING

[@Littlescribers]

Hi CodeBsics,(In video 54:32/1:36:03) I got an error, can you please help me to resolve that. ERROR : "The value for 'WFH Count' cannot be determined. Either the column doesn't exist, or there is no current row for this column" while calculating present days.

[@irfanlink4u786]

Great work ! , My one query is regarding duplicate step , should we not reference query instead duplication. any change in source data should reflect on source data. Guide please!

[@vishnuprabhakar7327]

Thankyou Very Much Sir

[@user-rs1uo1du2f]

I did understand everything till Gathering and Transforming Data, but the part about "creating a matrix using Dax" is unclear.Do you have any videos on that to?

[@swastikaggarwal221]

Can you tell me how we can do data prediction from grAphs we got ??

[@abdallahkriaa]

how i select the two colum pls

[@amnasarwar1793]

Kindly ny one who can tell me about the problem of output in google colab, not showing output after executing code

[@vikrantgarale7451]

Thankyou..plz bring some project in Healthcare domain..

[@chalanatyjostna2229]

HI,,, I am trying to follow along but when i expand the table at the end i am only getting june data but not others

[@captainchannel8210]

Sir, Lets say I have Excel file for next months July, Aug etc. I want to automate it in my dashboard. So to automate it. I mean you have skipped it in the video.. can you elaborate a bit for understanding.

[@manishchavhan3019]

Data analytics course ke liye Intel i3 processor laptop support krega ki nhi pls suggest 🙏

[@KarthikaKarthika-vq5sp]

sir i have been trying so many ways to connect the power bi with the sql server but it dosen't work always said this connection recquired one or more connection i tried many ways it dosen't work please anyone help me with this issue

[@user-xb2lz4eh4o]

great share

[@louisadibe3189]

Interesting client and consultant rapport

[@samuelm5766]

Sir can you do a project about public health awareness campaign in data analytics

[@nsrohith6889]

hello sir, thank you bringing up this series could you please help me i am lokking for real time project with sql and powerbi and resume prepation kindly help on this asap.

[@readerisleader12]

Sir please make A video on health care analytics project

[@mikasaackerman-lf2tw]

Please create a shipment analysis project

[@pragadagopinadh7578]

Hi Sir, I have started my plan to study in usa, As I am from mechaniical background .... but i want to study my masters in CS or DS .........WHICH ONE IS BETTER SIR 😕😵‍💫

[@jimmyxrs]

Great video! May i use this in my portfolio? thanks!

[@chandrahasreddy1295]

Thank you for this video during the running of video at 36:44 how Hemanand sir solve that error at that time screen got blurred I couldnot follow that error properly can you just clarify my doubt .Apologize for this comment

[@MrMajidparvez]

Thanks you sir

[@trucker03]

great project thanks, I dont understand why we created a parameter, could you explain > many thanks

[@applepeel1662]

Can i add this project to my github profile?

[@Angel-pj2qk]

Awaiting project on investment banking trade support, kyc Or corporate action .

[@user-fp2oy5gn4r]

can i upload this on linkedin mentioning you also ?

[@pranathiadepu9785]

Hello Sir! I have a Dataset, and I'm asked to create a dashboard by using any visualization tool. I need Your help in understating the Dataset. The Dataset consist of currency and destination from where the product has been purchased. The currency is in USD and the destination consists of different countries. So how can I transform the Data into different countries' currencies?

[@Tiwari-p]

Still not cleared what use of parameter😢

[@PrajwalSSJA]

Hello, can anyone help me with this problem mentioned below Whenever I choose the date column, automatically the date hierarchy gets selected, even I uncheck auto time setting in the options.....

[@miguelhermar]

Hello, thank you for putting this out. I'm a bit confused by an insight that was explained in the video. When Hemanand did the calculation for the WFH% he made an interpretation that was different from the one I had done. He said that that 14.20% meant that on a given day if the company had 100 employees, around 15 of them would be working from home. Whereas my initial interpretation was that on average each employee worked 15% of the time from home during that month. Can someone explain what are the differences between these two explanations? what would be the appropriate calculations for each one of them?

[@jcespedes0]

I have the same question

[@ivonman5277]

hi, the 2 card 14.20% represents the number of employees WFH on a day out of the total employees present and formula for this is same as used in the video 2 statement for that you can just click on person's name in the table visual and see the updated values in the (card visulasition)

[@shatirdimag1011]

my date is 4/05/22 and your date is 4-05-23 how to change this as this throws error

[@hydrogoalpicker1542]

Sir can i add this project to my resume?

[@rtgknightz]

Suggest a budget pc build. My idea is : i5-13600K or ryzen 5 7600X , 13500INR motherboard, 3000INR (8*2=16GB)Ram, 500GB Nvme M.2 SSD,650W power supply, 60Hz monitor, 500 INR keyboard mouse set, *NO GPU*. confused between ryzen and intel. Softwares to be used are: Anaconda, Android studio(app development) , power bi. No 3D modelling ,no video editing , no graphical work and no Gaming .

[@kitakamidesign3186]

Hi, does anyone know why is it at 1:19:19 the matrix shows the month of June instead of April as we didn't select June in slicer and didn't filter anything?

[@gunny.6000]

The matrix does show data of all the months. Notice when he unselects the slicer from June, the horizontal scroll bar in the matrix expands. You can then scroll the bar to view the data of other months as well.

[@abhijeetgupta729]

At 35:58 We added one col as GetData for the function and we got an error also, at 36:50 we deleted the one step that is "changed type". can you explain this part? by deleting we got perfect tables then! saw 2 time but didn;t understand. I am Aspiring Data Analayst at learning phase.

[@h1permonth723]

actually i am also stuck here, even after deleting that change type the error not resolved in my system

[@h1permonth723]

hi bro, i have understood that the get data function created based on Template data set and that template data set applied by worksheet filter, so worksheet filter is Apr 2022 but the other sheets does not have Apr 2022 data columns. so here get data function we are invoking for original dataset and if you observe the change type 1 it is the step had power query with april column data that is the reason it got error for remaining sheets. i think i have answered correctly.

[@BeingDevanshGupta]

can someone tell why did he arranged the date in the rows

[@madadallahbhatti2023]

Stuck at 36:50,I also deleted the 'Changed Type' but still have both errors in that col, please help me to find errors

[@juverianishath6310]

Even me

[@aishwaryapattnaik3082]

Sir please could you kindly create advanced end-to-end projects in SQL and Power BI, focusing on insurance and healthcare domains for resume building?

[@codebasics]

Great suggestion. I will make a note of this and build more end to end videos with diverse set of technologies!

[@user-er5rv7ls3t]

An error occurred in the ‘GetData’ query. Expression.Error: The key didn't match any rows in the table. Details: Key= Item=Apr 2022 Kind=Sheet Table=[Table] how to slove this error

[@Craeson1]

You'd need to delete the "data type changed" step as he explained in the video

[@pythonenthusiast9292]

Can i understand it if have never used power bi? I have hands on in python excel and sql for analysing data.

[@codebasics]

Yes you can do this project even if you have not used power bi.

[@pawzone4134]

is it only me, or is there any one who didn't understood a thing once he started using dax

[@ahsanshareef3303]

Plz explain how number to days are in 4k since the data is only for 3months..what am I missing? Thanks a lot..great work thanks

[@mohamedredachair5834]

Multiple employees are working in the same day ,

[@ahsanshareef3303]

@@mohamedredachair5834 so it should have been mentioned as number of working hours Ina quarter..but thanks for the explanation

[@MAKILANK-su4pr]

In Measure tools section 45:59 ,dax language next line not working problem its show syntax error

[@Suhi__JS]

Shift + enter

[@soundaryalakshmivenkatesan5311]

Can you please conduct a resume project for Data Science

[@codebasics]

Yup. That is already in the plans!

[@soundaryalakshmivenkatesan5311]

@@codebasics Great. Thank you

[@user-lg5jf1oq1d]

Quick Insight : If you are organizing team lunch, organize it on the the lowest presence day so that presence % goes high 😝(Because nobody wants to miss free lunch)

[@kirtinishad915]

If everyone includes this project on their resume, it will look the same. What if recruiters find out that we are copying projects from KZbin? I hope there won't be any issues. I am creating projects to enhance my job applications. Also, could you suggest alternative ways to develop projects without copying from others? Please reply.

[@codebasics]

You can make customizations. Use slightly a different problem statement in the HR domain, change the color theme, etc.

[@kirtinishad915]

Thank you!@@codebasics

[@TheAmazingmayowa]

@@codebasics will note this

[@subhg]

39:34 we all are smiling here

[@kakamoora7874]

bro create one community ...

[@atharvas1833]

44:15 How to create measure table?

[@lizk9963]

Home >> enter data ;)

[@Vishal-kt5vv]

"Thanos Thakur" xD

[@sanjaksumadh9499]

amazing project , but hema-nand voice isn't that clear

[@inderpanda1]

6/Dec/23

[@lizk9963]

in your present days you didn't take into account the other attendance types - the present days measure is not correct

[@supernova2858]

This is video that is uploaded again

[@codebasics]

We made a single video out of the entire playlist that I had previously

[@supernova2858]

@@codebasics okay okay Btw resume project are really good Hoping that you bring more resume projects in the future

[@user-er5rv7ls3t]

An error occurred in the ‘GetData’ query. Expression.Error: The key didn't match any rows in the table. Details: Key= Item=Apr 2022 Kind=Sheet Table=[Table]

[@aditibankar4941]

25:12

[@souadzaoui7148]

Hello

[@amit6204]

Why!? I mean why? Its old video i hsve lready completed this project way back! Please do some new project logo ko course k naam pe chuutya mt bna bhai

[@MS_VENOM64]

I dont know, dudes. I think crypto and all these ICOs are just a bubble. Well, crypto is good for transfers and so on, but I dont engage in trading and staking either. Its too risky. My friend recently lost $5000 there. I invest crypto in real business

[@adityakarki8742]

Hemanand sir should quit teaching , he's very poor at telling and expressing the problem... English mei thik se nhi samjha pare ho to Hindi mei bol kar bata do sir... Dhruv sir you're a good teacher I took your paid SQL course and I'm fully satisfied with that and due to that I took this power bi project but I think I wasted my time and data

[@codebasics]

Hindi dubbing coming soon - only @codebasics Hindi. - Team Codebasics

[@nischalsingh3002]

such a crap video....bro no even properly showing which tool he is clicking or which button he is pressing.....the font size is also too small to understand what is happening

[@anime_xo9593]

Move for cloud computing dumies , reality of this job is scary after gpt4 and gtp enterprise , and becoming data scientist is gonna take u re next 3 yrs to 5 yrs and if u re aim is just to earn somehow it's not the option at all for you better move to cloud computing - Cybersecurity or computer Network related .. don't kill you're time cz just bcz of demand people are been crazely doin this .

[@codebasics]

I believe if you prepare with data professional 2.0 mindset (which is using AI tools to boost your productivity) then job prospects are even brighter for data professionals. I have made a separate video on this, please check that out. You can search using "will AI replace data analyst job" in youtube. Also I do not see any special advantage that cybersecurity or computer network professionals have compared to data professionals. Those things can also be automated. In fact data professionals require a lot of softskills (such as domain understanding, communcation etc.) and some of these things can not be replaced by AI (at this stage at least)

[@HealthisW]

Hello Sir, I am doing short term course data science in India and which is acceptable in USA.

[@t.o.m.b9844]

The Error that we got in the 36th minute after removing the 'changed type' column, i am getting something else as an error and am unable to rectify it, i have provided below the error , kindly suggest me with a suitable solution. An error occurred in the ‘GetData’ query. Expression.Error: The key didn't match any rows in the table. Details: Key= Item=Apr 2022 Kind=Sheet Table=[Table]

[@shatirdimag1011]

yes same error please help

[@t.o.m.b9844]

recheck your sets in the power query, i did it again without even changing the series of the tasks, i got it right this time @@shatirdimag1011

[@pragadagopinadh7578]

Hi Sir, I have started my plan to study in usa, As I am from mechaniical background .... but i want to study my masters in CS or DS .........WHICH ONE IS BETTER SIR 😕😵‍💫