This project involves the creation of a relational database using Microsoft Azure and MySQL, followed by data extraction and transformation using PowerBI. The primary goal of this project is to analyze salary data by department and gender and create an insightful report.
- Microsoft Azure: Used for creating and hosting the relational database.
- MySQL: The relational database management system used for storing and managing data.
- PowerBI: Employed for data extraction, transformation, and report creation.
-
Database Creation:
- Utilized Microsoft Azure to set up and host a relational database.
- Designed and structured the database to store relevant employee data.
-
Data Extraction:
- Extracted data from the MySQL database using PowerBI.
-
Data Transformation:
- Transformed the extracted data to prepare it for analysis.
- Conducted data cleansing and formatting as needed.
-
Report Creation:
- Used PowerBI to create an interactive report focused on salary analysis.
- Key Insights:
- Despite male and female employees working similar hours on average, there is a gender-based salary disparity, with male salaries tending to be higher.
- The "Headquarters" department boasts the highest average salary among all departments.
- The analysis reveals that salaries in the United States surpass those in Europe.
You can access the full report here.
Feel free to explore the report for a more detailed analysis of salary data by department and gender.