Giter VIP home page Giter VIP logo

tamk-kol / sql-powerbi-hr_data_analysis-end-to-end Goto Github PK

View Code? Open in Web Editor NEW
0.0 1.0 0.0 562 KB

We'll build an HR database in SQL Server, import CSV data, and run queries for analysis. Then, we'll connect to Power BI, create visualizations, and build a dashboard. This end-to-end project will address HR's requests regarding healthy employees, non-smoker compensation, and absenteeism insights, all within the specified budget constraints.

License: MIT License

absenteeism analysis employee-management end-to-end end-to-end-project hr leave powerbi powerbi-desktop powerbi-report powerbi-visuals powerbidashboard powerbiservice sql sql-server sqlserver leaveanalysis

sql-powerbi-hr_data_analysis-end-to-end's Introduction

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

HR Dashboard

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.

    image

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:

image

Step 2:

image

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.

sql-powerbi-hr_data_analysis-end-to-end's People

Contributors

tamk-kol avatar

Watchers

avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.