Project Details
Our client needed an application that was available to executives via desktop or mobile web browser, so they could see their client’s data in a yearly sales/performance view.
This company, like many others, maintains data in multiple formats and locations which makes it difficult to see their client’s performance and trends at different levels such as company, division, market, and facility. Much of the data is financial in nature, thus requiring a high level of security.
Since much of this data lies within multiple systems and locations, assembling reports to provide insights that were needed, required manual intervention and multiple days to assemble. Add to this the potential for inaccuracy, and it became a daunting, regular task for an individual to complete.
We partnered with our client to design and build a custom data dashboard application as well as back-end processes to acquire the data from multiple systems and display it in an easily accessible and understandable format.
Because this was a complex undertaking with many stakeholders and a divergent vision, our approach was to first develop a rapid prototype to help clarify and align expectations and ensure all parties would be pleased by the final product.
After earning approval to build the custom application, we employed the use of scheduled cloud processes to migrate the data to a local application-specific database. The processes were scheduled to run on a daily basis and acquire data from multiple locations such as a data warehouse, Salesforce, and Smartsheet spreadsheets. During the acquisition processes, granular data was also used in complex calculations for displaying data in a more understandable way. In addition, granular data such as client contacts, site addresses/locations, mission statement, and other non-KPI related data were included to allow for the “big picture” view of the client, and ease of access when individual staff information was needed.
With the consolidating of data from multiple systems into a single data source, our client was able to see their executive level sales and contact related data in a consolidated and concise way, and access it quickly.
The automated data dashboard eliminated risk of human error and reduced the time required to manually create reports from days to seconds.
