Company
Kenmore Air
Industry
Seaplane Airliner
Offering
Dashboard-as-a-Service
Impact
A commercial aviation company needed assistance to gain insight from their data. The regional airline spent hours or even days manually compiling data. Their data was not centralized, crippling their ability to find and correlate information. These issues led to the client operating in a reactionary versus proactive mode.
During the initial consultation, Wimmer Solution’s data team examined the airline's systems and identified and uncovered hidden issues.
The Wimmer team proposed a fusion of two of our service offerings: Dashboard-as-a-Service (to build the initial reports requested), and Vision Workshop (to determine the full scope of the airline's reporting needs).
The Wimmer team began by conducting a current state analysis to determine the health and efficiency of the client’s different data systems. Next, Wimmer took the client's internal team through the Vision workshop.
Ultimately, through the Vision Workshop, Wimmer Solution’s data experts revealed 48 reporting needs and consolidated these into a prioritized roadmap of 18 different reporting initiatives that delivered value.
Throughout the exercise, the data team identified several important insights missing from the client’s reporting systems. The team then centralized data and built two dashboards. The data for these dashboards were contained in Excel spreadsheets and third-party systems. The data models and dashboards were built within Power BI.
With the information contained in these dashboards, the client was able to move from a reactive to a proactive process, enabling them to take timely action on the information.
By fusing the service offerings together, the Wimmer Solutions team was able to develop a roadmap of initiatives to achieve a higher degree of efficiency in their reporting processes and fulfill the client's immediate need by building out two of the dashboards.
This has resulted in the following:
