Customer Success Story

A dashboard for medical billing and collections

At a Glance

nThrive Global is a center of excellence that supports delivery and augments capabilities of nThrive revenue cycle management solutions for providers and payors, including Patient Access, Coding, and Accounts Receivable services. Specifically for payors, we provide a one-stop solution using end-to-end, integrated pre- and post-adjudication workflow tools that turn your data into information, while dramatically improving quality, profitability and customer service.

logo
Client

Health Care

Industry

Healthcare eLearning

Services

UX/UI Design
Web Development

The Challenge

Create a way to access the data without the use of SSH tunnel and VPN’s. To fetch data from LRS database via MySQL into Power BI to generate dynamic reports.

challange

Our Solution

We have used Dataflow which was the new data modelling capability provided in Power BI Services to directly load data from the server into the cloud and then use the Power BI Dataflow connector in the Power BI Desktop to fetch data directly from that. This solves the problem of providing the access via SSH tunnel/VPN.

image

Education Command Center

This is the overview dashboard of all the activities trends in the selected date range to get the overview of different entities.

image

Usage Detail

This is the detail view of all the activities/course name over the period of time to get prior values and growth % based on it.

image

Client Details

This is the detail view of all the clients over the period of time to get the top and bottom clients details with their usage behavior.

image

Comparison Analysis

This is done to compare between two different aspects(Client, Activity and Course name) of the data in a single page view to compare them based on different date filters to predict things accordingly.

image

Client Size Analysis

This is a useful page to compare similar entities with each other to see the behavior of large, medium and small size clients based on different attributes.

image

Answer Level Details

This report helps in analyzing the behavior of all the courses/activities to see the trend or wrong and correct attempts to particular questions. This help in sorting the issue of why a particular thing is being attempted incorrectly most of the time. By this, we can update our courses approach to a more advance and better way.

The Process

We used agile methodology to build a data model in Power BI services only with the help of Dataflow to connect with Power BI Desktop to generate reports. Publishing the reports back to the Power BI services and set of a scheduled refresh with the help of On- Premise Gateway.

infograph
Recent Work
A dashboard for medical billing and collections

nThrive Global is a center of excellence that supports delivery and augments capabilities of nThrive revenue cycle management solutions for providers and payors, including Patient Access, Coding, and Accounts Receivable services.

View Case Study
mbj-logo
Recent Work
Full-scale BI platform design and visualization

Millennia simplifies and streamlines the patient financial experience by communicating with patients early, informatively, and often through our proven patient engagement platform and team of highly-trained support specialists.

View Case Study
 wipit-logo