Healthcare software company reporting
Ollion enhanced this healthcare software company with a dynamic, easy-to-support reporting architecture for improved sales and self-service data analytics access.
Overview
THE CHALLENGE
A healthcare software company wanted to increase application sales but didn’t have a reporting software application that allowed for efficient data discovery via a front-end BI tool.
THE SOLUTION
Ollion implemented a dynamic reporting and self-service analytics platform for customer reporting and data discovery.
THE OUTCOME
The client now enjoys functioning dashboards that allow sales teams to communicate the software’s vision to both current and prospective customers.
The challenge
Our healthcare software client had a semiannual reporting software application that did not allow for adequate or efficient data discovery via a front-end BI tool. To increase application sales, our client needed a reporting architecture that allowed for single or multi-tenancy and the dynamic customization of reporting measures. The solution also had to be easy for our client’s internal team to support and implement going forward. The resulting platform needed to integrate with a BI tool that would allow users self-service access to data discovery and reporting analytics.
The solution
With an iterative development approach, Ollion built a business intelligence and analytics platform with a data warehouse architecture that utilized C# scripts embedded in SSIS to dynamically manipulate the ETL. This architecture provided a mechanism for our client’s customers to create the dynamic measures without our client having to make changes to the software or reporting architecture. Ollion then developed several dashboards in Power BI for customer reporting and data discovery.
The outcome
Ollion produced multiple dashboards that allowed technical client resources to bridge the gap to business stakeholders and secure company-wide buy-in of the solution. The functioning dashboards allow sales teams to communicate the software’s vision to both current and prospective customers.
Our solution provided the following:
- Embedded analytics and reporting exposed to healthcare providers directly from the company’s SaaS application
- Ability to easily scale the dynamic measure logic via simple additions as the product matures, making it easier to support and expand going forward
- Drill-down dashboards for self-service data discovery and analytics
- Six-month snapshot report of processing time reduced from two days to 30 minutes
- Daily data availability, in addition to the six-month snapshot report
- Road map of future development work to integrate all enterprise information into single-source data warehouse
