HNG HIRE DATA MODEL

BUILDING AN HNG HIRE DATA MODEL AND HIRING STATISTICS DASHBOARD

The project involves creating a data model for HNG Hire, implementing it in MySQL, and building a Power BI dashboard to display hiring statistics.

To achieve this objective, sample data was created in the absence of actual data on candidates, and used for this project. Based on the understanding of the business requirements of HNG Hire, the data model to be built should be able to track candidates, hiring processes, and employers, including details like candidate status, interview details, and job roles.

Thus, a star schema data model was utilized in designing the data model in question, with a hiring fact table and seven dimension tables (candidates, employers, job roles, stack, status, location, date).

The database was then populated with the sample data generated for this purpose, connected to Power BI, and a dashboard built using Power BI shows the hiring statistics such as available people per stack, interviewed candidates, hired candidates, and a status overview. Key insights include the distribution of candidates across different statuses such as candidates for hire, hired candidates, candidates still in interview, etc.

The key constraint with this simple project is the unavailability of data to feed the database. However, the data model built should serve the purpose intended which is to help HNG Hire track its candidate pool of talents being considered for prospective job placements into available hiring companies both locally and worldwide.

Detailed report on this project is available below or on Github