Having worked in various capacities for TriTender and Procure Wizard over a number of years, TriTender came to us with a unique requirement. They have an online portal that allows their customers to enter data.
The requirement was to create an Excel dashboard that their customers could download from the portal, that took the raw data entered into the system and turned it into an interactive Excel dashboard.
We created a solution whereby we put an empty Excel file on the server, and whenever a customer requested the analysis, we populated it with the raw data and let the customer download it. When the customer opens the file for the first time the analysis runs to produce the dashboard.
The solution is versatile and allows for the changing of the format and structure of the source data and runs quickly and efficiently to produce an aesthetically pleasing output.The interactive nature of the dashboard allows the user to take control of the data and analyse it however they choose.