SQL-PowerBI-HR Data Analysis-End-to-End

HR Request to Data Analysis Team:

1. Provide a list of Healthy Individuals & Low Absenteeism for our healthy bonus program - Total Budget USD 1000.

2. Calculate a Wage Increase or annual compensation for Non-Smokers for: Insurance Budget of USD 983.221 for all Non-Smokers.

3. Create a Dashboard for HR to understand Absenteeism at work based on the approved wireframe.

   

Project Overview:

1. Build a Database
2. Develop SQL Query
3. Perform Analysis
4. Connect Database to Power BI
5. Build a Dashboard

Installation:

1. Microsoft SQL Server: To create and manage the database.
2. Power BI Desktop: To create and visualize the dashboard.

Steps:

1. Set up the database:

a. Create a new database in Microsoft SQL Server.

b. Import the CSV files from the Data folder into the database using the SQL scripts provided in the SQL folder.

2. Run the SQL queries:

a. Open the SQL Server Management Studio.

b. Connect to the database you created.

c. Execute the SQL scripts in the SQL folder to clean, transform, and analyze the data.

Step 1:

Step 2:

3. Create the Power BI dashboard:

a. Open Power BI Desktop.

b. Connect to the database you created.

c. Import the data from the database.

d. Create visualizations and dashboards using the data.

e. Save the Power BI report file (.pbix) in the Power BI folder.