Thanks for the feedback @sam.mckay ,
I modelled the data into 4 dimension tables (employees, consultations, interviewers and date) and one fact (interviews).
The dims were simple however there was additional modelling for the fact table. It was modelled so that there was just one interview per row
Enjoyed the modelling part of the project and adhering to best practice as much as possible here.
I didn’t use many measures at all just some simple counts and filters.
The design I have tried to keep clean and uncluttered whilst still showing all of the necessary insights and including all of the relevant data and breakdowns by location and job role etc.
The top section of the report shows data across both interviews and offers comparisons and the lower section is filterable by interview number and allows you to drill into the data.
I would have liked something more advanced for the sentiment chart or a more exciting way to display it but i was falling short with my DAX and decided to settle on simply creating a score that is count of happy - count of unhappy.
Cheers!