Dashboard & Reports Development for a Healthcare Payer
t the Client
The customer is a leading provider of secure electronic payment processing solutions and self-service patient payment portals for hospitals and physician groups.
The customer envisaged to build a dashboard and reporting tool capturing transactions, ePlan enrollments, customer utilization and revenue management.
ALTEN Calsoft Labs’ proposed solution for dashboard development employed a three fold pronged approach consisting of “Manage – Analyse – Report”.
- Manage: ETL transformations using SSIS
- Extracting payments and patient data from multiple customer Dbs
- Transforming and cleansing the payments and patient data
- Loading data into data warehouse tables
- Analyze: SSAS is used for slice, dice and drill down analysis
- Report: SSRS and SpagoBI are used to create the static, drill down reports, and dashboards
- Tableau is used for slicing & dicing and representing the data in various graphical charts
- Helped the customer streamline its business operations and provide quality patient care
- Improved cash flow and reduced delay in accounts receivable
- Reporting Tools/Technology: SSIS/SSRS, Spago BI,Tableau
Let’s fast-track your next big idea