A Healthcare Software Company
Dynamic Data Warehouse for Reporting.
An 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
2nd Watch implemented a dynamic reporting and self-service analytics platform for customer reporting and data discovery.
The Outcome
The client now enjoys functioning dashboards that allows sales teams to communicate the software’s vision to both current and prospective customers.
01
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.
02
The Solution
With an iterative development approach, 2nd Watch 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. 2nd Watch then developed several dashboards in Power BI for customer reporting and data discovery.
03
The Outcome
2nd Watch produced multiple dashboards that allowed technical client resources to bridge the gap with 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