ไม่สามารถเล่นวิดีโอนี้
ขออภัยในความไม่สะดวก
End to End Data Analysis Project | HR Analytics Power BI Project 🚀
ฝัง
- เผยแพร่เมื่อ 16 ส.ค. 2024
- 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/...
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.co...
#codebasics #dataanalytics
Hello Sir, thank you for bringing up this series. I made Power BI projects with your help and i got a job. Eternally grateful!!
Just wanted to ask you that after completing project, should I directly mention it in resume or I need to publish it somewhere?
Yeah, same doubt!
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.
@@nidhitiwari3110 Alright, thank you!!
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
we are not aware that the finale is real HR but the projects that you summarize and drive solution is awesome
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...
Worked in Recruitment for 11+ Years... Now doing Data Science MS. This will help me a lot.
Definitely
@@codebasics Is it fine to use some of these projects on my resume?
I am already upskilled in data analytics but I can't get interview calls and I was thinking to replace my existing projects which are simple and don't carry solution of business problems.
Amazing Project I enjoyed doing this simple yet effective HR analysis Project. 👏🏼👏🏼
CAN YOU PROVIDE THE GITHUB LINK OF YOUR PROJECT
The use case is amazing,learnt new concepts, like unpivot, function etc.
A complete BI course for data analytics required........ ❤❤❤
Wow... thank you and amazing content video end to end data analysis /HR Analytic Power bI Project....godbless
Thank you so much for your kind words
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.
13:05
13:20
13:20
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.
I followed this and created a project along with it. I understood a lot. Thanks
if you use Alt Shift Down Arrow in the formula bar, it will paste the above line of text (expression).
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.
This is amazing! If you could also share the content in a text format with step-by-step instructions, that would be fantastic.
It's a Useful video that made some knowledge in power bi
Thankyou Very Much Sir
Very excited for HR project
👍🏼 It uses a real data set from my software and data company AtliQ. This project can add a lot of weight to your resume!
Absolute masterclass....
Thank you very much for sharing with us such valuable knowledge.
I am excited
Excited ........😍💫
Eagerly waiting 😌
u do so much for community. thank u
Amazing Project! I enjoyed working on this. However, it would have been even better if the presenter had specified clearly which options he was selecting during the visualization creation part.
Screen is not fully visible sometimes when he is selecting options example at 55:40
57:25 is not clear as well
great share
Thanks you sir
Please do more projects on market research and analytics
It's really helpful sir thank you very much ☺️
Awaiting project on investment banking trade support, kyc Or corporate action
.
Thankyou..plz bring some project in Healthcare domain..
Thank you 🙏🏻 🎉❤
Interesting client and consultant rapport
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 .
@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.
Please create a shipment analysis project
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.
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
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?
how i select the two colum pls
Sir please make
A video on health care analytics project
AMAZING
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!
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
Sir can you do a project about public health awareness campaign in data analytics
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)
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?
Great suggestion. I will make a note of this and build more end to end videos with diverse set of technologies!
Stuck at 36:50,I also deleted the 'Changed Type' but still have both errors in that col, please help me to find errors
Even me
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
Multiple employees are working in the same day ,
@@mohamedredachair5834 so it should have been mentioned as number of working hours Ina quarter..but thanks for the explanation
can i upload this on linkedin mentioning you also ?
i great project
But can we make the excel file three and save each sheet of the month on a new excel work and then load it on power bi and append then unpivot it instead of the long process
great project thanks, I dont understand why we created a parameter, could you explain > many thanks
Still not cleared what use of parameter😢
Great video! May i use this in my portfolio? thanks!
amazing project , but hema-nand voice isn't that clear
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.
my date is 4/05/22 and your date is 4-05-23 how to change this as this throws error
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?
I have the same question
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)
is it only me, or is there any one who didn't understood a thing once he started using dax
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
can this be used as capstone final year project as well ?
In Measure tools section 45:59 ,dax language next line not working problem its show syntax error
Shift + enter
Can i add this project to my github profile?
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
You'd need to delete the "data type changed" step as he explained in the video
Can you tell me how we can do data prediction from grAphs we got ??
Where can I get those data sets ??do wrk along wit uh guys to hve more practice .
Kindly ny one who can tell me about the problem of output in google colab, not showing output after executing code
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.
If everyone includes this project on their resume, it will look the same. What if recruiters find out that we are copying projects from TH-cam? 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.
You can make customizations. Use slightly a different problem statement in the HR domain, change the color theme, etc.
Thank you!@@codebasics
@@codebasics will note this
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 😕😵💫
Can you please conduct a resume project for Data Science
Yup. That is already in the plans!
@@codebasics Great. Thank you
bro create one community ...
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?
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.
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?
39:34 we all are smiling here
44:15 How to create measure table?
Home >> enter data ;)
Data analytics course ke liye Intel i3 processor laptop support krega ki nhi pls suggest 🙏
Sir what reality of iT sector current resession😢... their is no job... courses are increased but their is no job..... please tell reality.....
Can i understand it if have never used power bi?
I have hands on in python excel and sql for analysing data.
Yes you can do this project even if you have not used power bi.
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.
I got the same issue...did u solved it..?if Yes ,please explain to solve this
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
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
6/Dec/23
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.....
"Thanos Thakur" xD
pbix file access denied.....how to download the pbix data
This is video that is uploaded again
We made a single video out of the entire playlist that I had previously
@@codebasics okay okay
Btw resume project are really good
Hoping that you bring more resume projects in the future
Where can I get that dataset
I am unable get the query at 48:17 it is showing The expression specified in the query is not a valid table expression why it shows like that could any one help me this is my query
Total Working Days =
VAR totaldays = COUNT('Final Data'[Value])
VAR nonworkdays = CALCULATE(COUNT('Final Data'[Value]),'Final Data'[Value] IN {"WO","HO"})
RETURN totaldays-nonworkdays
Sir can i add this project to my resume?
can anyone share the project docs
can someone tell why did he arranged the date in the rows
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.
actually i am also stuck here, even after deleting that change type the error not resolved in my system
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.
Hello
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]
DATA SOURCE K LEA V LOGIN WOW
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]
yes same error please help
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
in your present days you didn't take into account the other attendance types - the present days measure is not correct
25:12
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
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