Data Analyst Project For Beginners (HR Analytics): 3 - Data Gathering & Transformation
Вставка
- Опубліковано 4 вер 2022
- In this video, you will learn how to gather and transform data using Power Query. Power Query is a feature in Power BI which will help you collect and transform the data the way you want. We have our data in excel and in multiple sheets with different column headers. This is a special case and you will see how Hem, the data analyst googles the solution. You will also see the kind of challenges a data analyst may face in real-time and how they approach those problems.
Link to Chris Webb’s Blog: blog.crossjoin.co.uk/2018/07/...
Input Excel and output pbix files can be downloaded from here: codebasics.io/resources?...
HR Data Analytics playlist: • Data Analyst Project F...
Other data analytics projects
===================
Sales insights, power bi: • Power BI Project For B...
Sales insights, Tableau: • Tableau Project For Be...
Personal finance dashboard: • Power BI Data Analytic...
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
📸 Instagram: / codebasicshub
🔊 Facebook: / codebasicshub
📱 Twitter: / codebasicshub
📝 Linkedin (Personal): / dhavalsays
📝 Linkedin (Codebasics): / codebasics
🔗 Patreon: www.patreon.com/codebasics?fa...
![Lp. Последняя Реальность #107 РОДНОЙ ДОМ [Финал] • Майнкрафт](http://i.ytimg.com/vi/IK3QKzKUlHM/mqdefault.jpg)
Do you want to learn technology from me? Check codebasics.io/? for my affordable video courses.
You guys taking Edtech of India to different levels...Superb keep on
My biggest take away from this session is whenever you see dates in different column make them in 1 column and instead of getting over exicted by looking at dashboards on youtube I must focus more on Data Cleaning skills .
Heamanand Sir really have High quality knowledge Thank you sir for taking out time and recording this session.
I love how he pays attention to small details like renaming all columns at the same step so it won't be many repeated steps..Thank you so much
where is the data? i could not find it.
@@borhanbarvj i am also unable to find the excel file ...can anyone please help
it was heavy for me.....but i digested it ....thanks you sir for such awesome content
Very well explained. hats off to the efforts of you guys.
Thankyou so much guys
Thanos Thakur, Jarvis Singh 🤣🤣🤣🤣
Well, I have learnt some new things. Thank you Codebasics.
@codebasics Thanks for this amazing series I learned a lot.. But in every session sir Hemanad's voice not so pretty much clear as sir Dhaval voice. For better voice quality I use headphones, also increase the volume, and then my ear and head feel pain. Sir kindly resolve this issue if possible. Thank you.
14:50
thank you sir for this tip
I don't know what I would do without it 🌹
Very beautiful explanation sir 😀
Thats what's am looking for ....thanks guyz
Thank you for such an amazing effort to bring up the content. This is awesome for those who want to understand the entire process from the start.
i am not getting datsets of hr analytics
Hello sir... I'm not able to find the Excel sheet ... When I click on given link of input dataset I land to your code basic page and than not getting can u please tell me from where I get the dataset
Hi Dhaval sir, you tried many things new & different this time, but I am really having bad learning experience because of a few things that i want you to know-
1.I am watching the video at 720p but the main power bi screen still is blurry.
2. The first step of data analysis - understanding the data, what we have, and what are flaws in data like missing data- is completely skipped in this video.
3. Terminologies could have been explained better,..
and last
4. HR ke face se hi lgra unko kuch khaas samajh ni aa raha, not her fault, step thode high ke hain
I really enjoy the way you used to teach.
I Feel The Same
same
@@raveenathakur1176 Try Forage virtual intership projects 👍🏻
@@AkashSharma_12 Try Forage virtual intership projects
Those who are facing issues in Hemanad voice, they can use subtitle for better understanding.
may be this is most important video
I have a doubt here, when calculating total present days we should also consider half sick leave, and remaining half's also right and one more doubt when calculating present days, are we calculating whole days. not individual person. could please give response to this sir
learnt lot of things
Why did deleting ChangeType step didn't give any future error?? Is it because all column type were already text type?
What was the necessity of parameter here, I don't understand?
We added the column by invoked function. we have applied that parameter on filtering rows of template, which we are not loading.
sir i didn't get change type option in applied steps ,when we filtered the rows , can u please tell me why this happens? and one more thing sir i wouldn't be able to select columns i don't know why please help
The file is not downloadable
shows same error
I tried getting data from Bi also but it is not downloadable
Sir I am facing an expression error of column 'AtliQ' of the table wasn't found. After 21:56 Pls explain this 🙏
This is wow!
The same data if got in separate excel files instead of sheets.
I tried working but getting errors .
Can anyone give some insight!
Thanks so much for this series. But l don't see video 2. Is there non?
How is the client engagement bar calculated?
The excel download link is not responding ...can any one help me with this please?
Genuine feedback, Hemanand Sir is knowledgeable but he is clearly not able to communicate what he wants to say in a flow, which makes it hard to concentrate and follow along.
Instead Dhaval Sir should be the one explaining.
I cant find the excel sheet for practice, the link takes me to PDFs. any help?
Excellent Work, would like to recommend to increase font size if possible
Can someone help me to download this Excel sheet for practice couldn't able to do that
@codebasics I got this error-----An error occurred in the ‘GetData’ query. Expression.Error: There weren't enough elements in the enumeration to complete the operation.
Details:
[Table. Please tell me how I can overcome this error.
Done till now.. tomorrow will complete other sessions 🐊
Bro Itna Accha koi pdhata h kya .... Great Stuff
Let us know where i can enrolled in the course
@codebasics I watched the session carefully, I think there is no need to transform the data of the excel file 🤷🏻♂️because it is already in the right format which we required to understand.
sir, after loading the data it is showing only one months data. kindly help me. I followed each and every step and practiced
how do i get the excel sheet
Can we gather and transform data on excel rather than power query in Power BI?
i watched all the videos and very impressed. Please the dataset link for downloading is not responding, can reset it please i really want to practice this Hr Analytics thanks
sir after creating new parameter
it show empty in Filtered Rows
and show message
Expression.Error: There weren't enough elements in the enumeration to complete the operation.
Details:
[Table]
in Removed Errors
can get any solution for this problem ?
even i have same doubt, if you get solution can you share here
Did you got the solutions ??
we got this error because by default it's not text format in the parameter so Apr 2022 was changing to 01-04-2022, that's why we're getting the error. set it to text format in parameter and type Apr 2022 it works. Hope this helps
@@gowthamr7147 Yes after changing it works
@@neharokade7392 glad it helped 😃
Dhaval sir, please take a feedback, please don't include Hemanand sir in your videos, he might have super knowledge but he is not able to communicate with the audience. He is not even able to speak clearly. Even to speak a sentence his pitch goes up n down, which eventually disturbs the whole flow. He is not even able to clearly explain what he wants to say. Please consider this feedback.
Legit, I was thinking why wasn't any one pointing this out.
It is a struggle to follow along due to this.
I didn't think so he just made sure she will understand it well so there is up and down in communication but in others video they make sure everything will be perfect in editing
After watching it so many times ii am not getting what he is trying to do and how he is doing. he was so unclear. I can bet on this pinali didn’t even get a word from this neither I.
@@prernaagupta688True AF!
Upload some tableau Dashboards also , POWER BI is complicated imo
I got rid of the employee codes, since they are not unique. Some are shared between more than one employee
How we can select two columns at a time while unpivot other columns
using ctrl button
I'm not able to automate error is coming can you provide solution
An error occurred in the ‘GetData’ query. Expression.Error: The key didn't match any rows in the table.
Details:
Key=
Item=June 2022
Kind=Sheet
Table=[Table]
Sir! gating this error
please did you figure it out, having same error
i got it buddy , just select :- fx GetData--> go to formula bar above and expand it --> find #"Apr 2022_Sheet" --> and paste this instead of that line #"Apr 2022_Sheet" = #"Filtered Rows"{0}[Data] .. i just replaced some value with zero but you can copy paste my entire line it should work.
did you figure it out?
@@oluwajuwonadenugba4575
excel file not in link
HR k facial expressions se lag raha k usko kuch samajh ni aarha
hemanand is the goat change my mind
How did filter row option popped up?
Click on gear sign beside the filtered rows step in applied steps column on the right
I had to watch it twice to understand what's happening...
at 26:14, even after deleting the command,i am getting error on the function
where is the dataset brother?
Thanks for all the awesome content . Could'nt ask for more. Just a constructive feedback, the screen was blurry and the font size was too small for my bad eyes.
raw data not opened , plz look into it
Can I get dataset
Why use parameter here?
I did no understand the parameter part. Why we did it
To make the filter(Choosing Apr 2022 data sheet from all the available sheets) dynamical parameter is used here. Next time when there would be new data sheet in this wordbook, you don't need to come to power query again to filter one sheet to make all the transformation, if you filter the step using the parameter.
AFTER FILTERING ROWS BASED ON PARAMETER:-
Expression.Error: There weren't enough elements in the enumeration to complete the operation.
Details:
[Table]
While creating the Parameter Worksheet ensure to make type= text and enter the current value as Apr 2022. Doing this should work
getting same error
@@ayushrana1401 thanks man type= text helped
Please maintain quality content.
i agrre... look how chandooo power bi courses work...so clear.. i lost intrest and moved on..
Voice is too low of two participants....
video is not clear to follow along..
why u guys cant test the voice of each person..trainer voice is low...intrest reduces by time
I can't learn anything becase i want to zoom to 75% and see where you are clicking and you not teaching to viewers you were focused on the clients sorry but its really wasted my time
bhai itne ads dekh k pagal ho gya me
HR seems to be least intrested, 🤣
Boaring 😔
Too much complicated n two much backsteps