Dashboard & Reports Development for a Healthcare Payer



About 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.

Business need

The customer envisaged to build a dashboard and reporting tool capturing transactions, ePlan enrollments, customer utilization and revenue management.

Solution delivered

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

Business benefits

  • Helped the customer streamline its business operations and provide quality patient care
  • Improved cash flow and reduced delay in accounts receivable

Technology stack

  • Reporting Tools/Technology: SSIS/SSRS, Spago BI,Tableau

Let’s fast-track your next big idea

Recent Posts
Contact Us

If you’d like us to contact you, please fill out the form.

Not readable? Change text. captcha txt