Context: A new SaaS start-up company is interested in expanding its team. Between January 2021 and April 2021, the organization hired employees for roles across many departments. With diversity as one of the core values of the company, the team has decided to work with a vendor to develop an employee HR dashboard to visualize their employee data.
Note: Please note that the use of names in my database is purely for illustrative purposes and does not imply any endorsement or affiliation with them.
Purpose: To demonstrate SQL and Power BI skills through a mini project visualizing employee data.
The ER Diagram shows the relationships among the tables and entities used for connection and joining the tables in SQL. The raw data is represented in the Employee_data.xlsx file.
The SQL queries in the SQL_HR_Dashboard.sql executes the joins among the tables to combined into one table. It is then then exported into an Excel file which is used to be uploaded into the Power BI software to visualization. In addition, the remaining queries are used to display the following:
- Show all employee first and last name as well as their ID and the department they belong in
- Show the count of employees in each department
- Show total salary per department
Evaluation: After developing the Power BI dashboard, it is important to validate the data to ensure its accuracy and completeness with comparing the SQL queries to the results of the dashboard. In addition, it is important to communicate the insights with the stakeholders and present ideas and recommendations based on their requirements. For example, if the company is interested in understanding how much of their finances are going towards salaries, they can use this dashboard to compare it across different departments. The stakeholder may also provide further recommendations and feedback to improve the dashboard and its functionality.