Purpose This demo lets you analyse your workforce of support engineers. The data is based on a utilities company that has a number of field engineers, responding to different types of calls on locale at customer premises.
Data The data within the application is purely fictitious but based heavily on source systems seen at utilities clients.
Social Media Data Analysis
Analysis Below is some of the analysis that can be performed in the Workforce Management demo by sheet: Open Work Orders – The open orders sheet gives you an overview of your current open orders, broken down by workorder type and also provides a comparison between today and yesterday and a profile of the last seven days. There is also a geographical representation of the open orders, also categorized showing emergencies.
Social Media Data Analysis
Time Profiles – The Time Profile sheet gives you an overview of jobs by date, day and hour of the day.
Social Media Data Analysis
Emergency Orders – The Emergency Orders sheet provides an overview of Emergency category work orders and there geographical location.
Social Media Data Analysis
Utilisation – This sheet gives you a chart showing the overall activity and utilisation of your employees/workforce.
Social Media Data Analysis
Scorecard – This sheet lets us analyse employee performance by individual Employee and different types of work undertaken. It is also colour coded to let you see, at a glance, if they are performing better or worse than their peers / average.
Social Media Data Analysis
Shifts – Here you can get an overview of the employees and their jobs by Day. Selecting a day also splits the jobs geographically and gives you a chart of still open jobs.
Social Media Data Analysis
Job Reports – The reports sheets gives you detailed views of the Job data.
Social Media Data Analysis
Conclusion This application gives you an overview of what can be shown by loading your Workforce management data in to QlikView. Enabling geographical and time based analysis on standard and emergency workorders.