BI Implementation for a Medical Provider of Mobile Diagnostic Imaging Services

BI Implementation for a Medical Provider of Mobile Diagnostic Imaging Services

Industry
Healthcare
Technologies
MS SQL Server

Customer

The end Customer is a US company that renders mobile X-ray, ultrasound, echocardiogram, EKG and bone density testing services to 800+ facilities.

Challenge

The end Customer needed to create reports and dashboards to enable a comprehensive analysis of their business performance, improve their business processes and, consequently, enhance customer service experience. Another challenge was to ensure that the reporting meets the requirements of the United States Department of Health and Human Services (HHS).

Solution

ScienceSoft’s BI implementation team started with creating a data warehouse based on Microsoft SQL Server. After that, the team delivered ETL from scratch (by loading available historical data), and then incremental ETL. For both ETL modes, ScienceSoft suggested using Microsoft SQL Server Integration Services. Two analytical cubes (6- and 12-dimensional) were created using Microsoft SQL Server Analysis Services. For user interface, Kyubit BI was selected. Finally, ScienceSoft’s team created reports and dashboards satisfying both the Customer’s needs and HHS’s requirements:

  • Utilization report and dashboard
  • Clinical outcome report and dashboard
  • Financial report
  • Order payments dashboardbi for mobile diagnostic company

Results

With the implemented reporting, the Customer is able to track the efficiency of provided services that allows streamlining their operations and optimizing business processes. As a result, the response time is quicker, unproductive time is reduced, and the clients benefit from enhanced customer service experience. What’s more, the UI component was built into the Customer’s practice management system to become its integral part.

Technologies and Tools

Microsoft SQL Server, Microsoft SQL Server Analysis Services, Microsoft SQL Server Integration Services, Kyubit BI.

Need help with a similar project?

Drop us a line, and our rep will contact you within 30 minutes to arrange an initial discussion.

More Case Studies

BI Implementation for 200 Healthcare Centers</a> </p> <p class="cs-description">ScienceSoft created software to help 200 US healthcare centers and retirement homes to process patient and medication data. Solution consists of Java application for management and reporting along with an analytical data warehouse to consolidate information from 200 databases.</p> <a href=https://www.scnsoft.com/case-studies/"https://www.scnsoft.com/case-studies/bi-for-200-healthcare-centers" class="btn btn-link-arrow btn-link-arrow--right cs-learn-more-btn"> LEARN MORE </a> </div> </div> <div class="cs-item-wrapper"> <div class="cs-image-container"> <a href=https://www.scnsoft.com/case-studies/"https://www.scnsoft.com/case-studies/aviation-insurance-software-development-outsourcing" class="cs-image-wrapper"> <img class="lazy cs-image" width="262" height="262" src=https://www.scnsoft.com/case-studies/"data:image/svg+xml;base64,CiAgICAgICAgICAgIDxzdmcgeG1sbnM9J2h0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnJyB2aWV3Qm94PScwIDAgMjYyIDI2Mic+CiAgICAgICAgICAgICAgICA8cmVjdCB3aWR0aD0nMjYyJyBoZWlnaHQ9JzI2MicgZmlsbD0nI2YyZjJmMicvPgogICAgICAgICAgICA8L3N2Zz4KICAgICAgICA=" data-src="/boss/images/173d1d69-4ecc-4643-9cca-6b450bfbffb9teaser---aviation-insurance.jpg" alt="Outsourcing of Web-based Software Development for Aviation Insurance"> </a> </div> <div class="cs-content"> <p class="cs-title accented-text"> <a href=https://www.scnsoft.com/case-studies/"https://www.scnsoft.com/case-studies/aviation-insurance-software-development-outsourcing">Outsourcing of Web-based Software Development for Aviation Insurance</a> </p> <p class="cs-description">During a 4-year outsourcing engagement, ScienceSoft’s team collaborated on the modernization of a 20-year-old legacy aviation insurance web application, replacing outdated non-maintainable technologies with moderns ones and optimizing its functionality.</p> <a href=https://www.scnsoft.com/case-studies/"https://www.scnsoft.com/case-studies/aviation-insurance-software-development-outsourcing" class="btn btn-link-arrow btn-link-arrow--right cs-learn-more-btn"> LEARN MORE </a> </div> </div> ">