MS SQL Power BI Data Analysis Portfolio Project | Beginner to Expert | Power BI Dashboard

#powerbi #sql #excel #dataanalysis #dataanalytics #portfolioproject
This project dives deep into the realm of data analysis using SQL and Power BI to uncover important human resource insights that can greatly benefit the company.

Whether you’re an experienced data analyst or a beginner, this project will guide you with the necessary hands-on knowledge on a real-life data analytics project.

Featuring eye-catching dashboards offer crucial HR metrics like employee turnover, diversity, recruitment efficacy and performance evaluations. These help HR professionals make informed decisions and strategic workforce planning.

Website: https://www.hisdataproject.com/

⭐ Download data and other files from:
https://github.com/kahethu/hr_data
This includes MS word, PDF, SQL queries, power BI file.

This is the date/time link promised in the video -
https://www.mssqltips.com/sqlserverti...

Data Cleaning & Analysis:
This was done on SQL server 2022 involving
• Data loading into SQL server & inspection
• Data cleaning and analysis
• Presenting the data in Power BI

CHAPTERS:
0:00 Explore the data in excel
2:26 How to load data into SQL Server
5:31 Cleaning data in SQL for analysis
15:05 Questions to be answered for human resources
16:14 What's the age distribution in the company?
21:56 What's the gender breakdown in the company?
23:08 How does gender vary across departments and job titles?
24:50 What's the race distribution in the company?
25:56 What's the average length of employment in the company?
27:13 Which department has the highest turnover rate?
31:58 What is the tenure distribution for each department?
33:12 How many employees work remotely for each department?
33:34 What's the distribution of employees across different states?
34:32 How are job titles distributed in the company?
35:19 How have employee hire counts varied over time?
39:11 How to build a dashboard on Power BI


➖➖➖➖➖➖➖➖➖➖➖➖➖
Related keywords: data analyst project, data analyst project for beginners, data analyst portfolio project, data analysis project, data analyst projects for resume, data science project, data analyst excel project, excel tutorial, excel tutorial for beginners, end to end project for data analyst, excel project for data analyst, excel project, report in excel, dashboard in excel, data analyst portfolio project, power bi tutorial ,power bi desktop tutorial ,power bi tutorial for beginners ,power bi desktop ,power bi dashboard ,power bi training ,power bi demo ,power bi for beginners ,power bi dashboard tutorial ,power bi tutorial for beginners excel ,power bi ,tutorial ,desktop ,dashboard ,excel ,microsoft excel ,power bi vs tableau ,tableau vs power bi ,mspowerbi ,Power BI Pro ,PowerBIPro