Data Analyst Project For Beginners (HR Analytics): 3 – Data Gathering & Transformation
YouTube | UCh9nVJoWXmFb7sLApWGcLPQ
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: https://blog.crossjoin.co.uk/2018/07/09/power-bi-combine-multiple-excel-worksheets/
Input Excel and output pbix files can be downloaded from here: https://codebasics.io/resources?utm_source=description&utm_medium=yt&utm_campaign=description&utm_id=description
HR Data Analytics playlist: https://www.youtube.com/playlist?list=PLeo1K3hjS3uuVQccZa7yFwK3ltoGQOWbM
Other data analytics projects
===================
Sales insights, power bi: https://www.youtube.com/playlist?list=PLeo1K3hjS3uva8pk1FI3iK9kCOKQdz1I9
Sales insights, Tableau: https://www.youtube.com/playlist?list=PLeo1K3hjS3usDI9XeUgjNZs6VnE0meBrL
Personal finance dashboard: https://www.youtube.com/watch?v=pqSoCa2NGj4
Do you want to learn technology from me? Check https://codebasics.io/?utm_source=description&utm_medium=yt&utm_campaign=description&utm_id=description for my affordable video courses.
Need help building software or data analytics/AI solutions? My company https://www.atliq.com/ can help. Click on the Contact button on that website.
🎥 Codebasics Hindi channel: https://www.youtube.com/channel/UCTmFBhuhMibVoSfYom1uXEg
#️⃣ Social Media #️⃣
🔗 Discord: https://discord.gg/r42Kbuk
📸 Instagram: https://www.instagram.com/codebasicshub/
🔊 Facebook: https://www.facebook.com/codebasicshub
📱 Twitter: https://twitter.com/codebasicshub
📝 Linkedin (Personal): https://www.linkedin.com/in/dhavalsays/
📝 Linkedin (Codebasics): https://www.linkedin.com/company/codebasics/
🔗 Patreon: https://www.patreon.com/codebasics?fan_landing=true
source
