Delivered remotely for an NZ operator; we support US and international teams the same way.
Problem
NZI required an enterprise app for collecting, collating, and reporting on claims analysis data that could be further analysed in-house using familiar tools.
Solution
Built a web app for data collection via a browser interface, feeding into Excel via SQL DB connectivity. VBA automation processed and presented the data as pivot summaries and trend charts, leveraging Excel's familiar interface for the analysis team.
Outcome
A full-stack enterprise solution built around Excel — giving analysts powerful reporting without retraining staff on new software.
Technologies
- Excel
- VBA
- SQL DB
- Web App
- Charting
Want something similar?
Tell us what you are doing manually and we will scope a practical Excel or spreadsheet solution.
Send an enquiry