CFO dashboard in BGE visualizes the productivity and efficiency of the crew members based on a number of jobs completed on a daily basis. It provides the user an ability to view the count of jobs by various job status like “Completed”, “Pending” and “Cancelled”. It displays the metrics based on the time taken by the crew members to complete any particular job through simple clicks. The charts/graphs are generated from the history of data from last 4 years.
Business Challenge
- BGE used to maintain its 4 years data of based on the status like “Completed”, “Pending” and “Cancelled” to check crew’s performance in an excel sheet.
- It is difficult for the business users to understanding and make critical business decisions.
- It is tedious to maintain the day wise snapshot of data for each work order completed in the field.
Continue Reading
How Avasoft Helped?
- AVASOFT proposed a solution by designing a QlikView dashboard with different filters.
- This dashboard facilitates the business user to see all the four years data by simple clicks and with quick response.
- This helps business users to understand the status of jobs, the severity of jobs, crew performance and actions performed to complete the job.
- We managed the snapshot of day wise job completion report in a data model, by following the Qlik’s best practices.
Teck Stack
Value Additions to Customer
- Provided the required data in a user-friendly and intuitive manner.
- Provided data-driven smart search to the users, to perform the search in a flexible way.
- Support users with enough information to make faster business decisions.
- Educate business users about the usage of reports to support with business analysis.
- Provided quick reference manual for navigating through the dashboard.