The dashboard was build in powerbi as an employee survey by HR to better comprehend the satisfaction of employees within the organisation. Each employee within each department was surveyed via phone, email, letter and website with this information collated into a csv file. This served as the data source for the visualisation for further analysis and record keeping by the HR team
The data model from the survey consist of the main table which contain the survey data information. The other tables connected to the main table consist of Survey type, Manager information, employee information, department (all of which have a primary key linked to the secondary key in the survey table) and master date table used to filter out certain time frames.
