Tutorial used

Files

Goals:

Sharpen skills in Power BI

HR Request to Team

Provide a list of healthy individuals and low absenteeism for our healthy bonus program

Total budget $1,000

Calculate a wage increase or annual compensation for non-smokers

Insurance budget of $983,221 for all non-smokers

Create a dashboard for HR to understand absenteeism at work based on an approved wireframe

Pipeline:

1. Build a database
2. Develop SQL query
3. Perform analysis
4. Connect to Power BI
5. Build a dashboard (wireframe)

Skills used/learned:

Microsoft SQL Server Management Studio

Excel

Microsoft Power BI

SQL

Journal