Paarth Parrekh

Hire Me

Paarth Parrekh

B2B

Healthcare Analytics

Modernizing Medicare to provide better care and smarter spending

Overview

About the project

The Healthcare Industry wanted to build an online platform for physicians & healthcare advisors to report & track performance efficiently thereby decreasing administrative burdens.

My Role:

User Research, Interaction, Data Visualization, Power Bi

Duration:

Jun 2020 - Dec 2020

In 2017, 73% of hospitals were penalized by the govt. due to their inability to report data

about the quality of service provided to the patients. Tracking this data can prevent

penalties and ensure that better care is provided.

Create a performance data reporting system to reduce the

overall administrative burdens for physicians and advisors

The Challenge

I collaborated with the researchers and domain experts in the team to understand our core users, their environment, and majors tasks to accomplish. We interviewed few participants and gathered data on their current workflow and major challenges. This data helped us in finding opportunites to solve the problems.

User Research

Interviews & Observations

Performance Scorecard and KPI Monitoring :

To create a comprehensive performance scorecard that tracks key performance indicators (KPIs) related to patient care, physician performance, and healthcare facility operations.

2. Financial Analysis and Cost Management :

To analyze healthcare expenditures, revenue streams, and cost drivers associated with patient care and administrative operations.

Patient Segmentation and Population Health Management:

Create dynamic patient cohorts and population health dashboards to monitor health outcomes, disease prevalence, and healthcare disparities across different patient groups.

Operational Efficiency and Resource Optimization:

Implement operational dashboards in Power BI to monitor resource utilization, patient flow, and healthcare facility capacity in real-time.

some of the strong use case to implementing on power bi

User Testing &

Evaluation

Wireframing &

Prototyping

Brainstorming

different ideas

Identifying pain points

of users

Stakeholder

interviews

Understanding the

context (MIPS)

User Testing &

Evaluation

Wireframing &

Prototyping

Brainstorming

different ideas

Identifying pain points

of users

Stakeholder

interviews

Understanding the

context (MIPS)

Data Cleaning

User Research

Identifying key features

Brainstorming

different ideas

Power Bi Visual's Implementation

The Process

User Research

Interviews & Observations

The users of this tool are Healtcare Advisors. It acts as an internal consultant and resource to a health organization with the goal of driving improvement in quality, cost efficiency and patient satisfaction. They gather, compile and analyze clinical reports, identify gaps / strengths & make appropriate

recommendations for corrective actions.

Who are the users?

Target Audience

Users mainly use MS Excel

spreadsheets to enter data

& frequently edit values in

the tables to compare their

scores.

Users want to see the results

in a concise and visual

format which is easy to

understand, share with

stakeholders.

QIAs' want to quickly find

and organize relevant data

and practises from several

others in the list.

Due to the complexity of

calculations they often fail to

complete & deliver

meaningful analytics on time.

Users want to see the results

in a concise and visual

format which is easy to

understand, share with

stakeholders.

Users mainly use MS Excel

spreadsheets to enter data

& frequently edit values in

the tables to compare their

scores.

QIAs' want to quickly find

and organize relevant data

and practises from several

others in the list.

Due to the complexity of

calculations they often fail to

complete & deliver

meaningful analytics on time.

Research Insights

Understanding the user

After conducting interviews and observations I created user personas with information about their behaviors,

technologies used, pain points & their needs.

After conducting interviews and observations I created user personas with information about their behaviors, technologies used, pain points & their needs. View Persona

MS Excel

Journal

Gmail

24%

14%

51%

11%

Other

Tools Currently Used

Reporting Data

Recommending

Percentage

Calculating Results

Organizing Data

Analyzing Results

Most Time Consuming Tasks

10%

15%

17%

22%

Problem Space

Issues Found

1. Long reports and high error rates

3. Organizing & searching data in reports

2. Tedious process to analyze the data

4. Time consuming calculations in Excel

How might we empower Healthcare advisor to gather, compile and analyze the clinical reports, so that they can quickly make appropriate recommendations for corrective actions?

Refraining the problem statement

Information Architecture

User flow diagrams

Brainstorming

Sketching initial ideas

Brainstorming

Sketching initial ideas

Wireframing

Iterating user interface

As we moved on to designing the interface of the application, I wireframed all the UI screens and conducted an

intial user testing session.

As we moved on to designing the interface of the application, I wireframed all the UI screens and conducted an intial user testing session.

Version 1

Dashboard

All Reports

Create Report

Scorecard

Providers

Contact

Create New Report

20 May 2017

Edit

Scorecard

View All Reports

View All Scorecards

6-7-14

100

200

300

400

500

12-8-15

6-18-15

1-1-16

16-4-16

12-12-16

5-20-17

ACI

Quality

CPIA

1-6-16

CPIA

Quality

ACI

Compare Scores

Recenty created

10 Jan 2017

Edit

Scorecard

Recenty created

ISSUES

Repetitive links and buttons on dashboard

Not showing scores of report

Version 2

Dashboard

MIPSight

All Reports

Create Report

Scorecard

Providers

Contact

Harriet Becker

6-7-14

100

200

300

400

500

12-8-15

6-18-15

1-1-16

16-4-16

12-12-16

5-20-17

CPIA

Quality

ACI

Compare Scores

Select Assessment

Recenty Created Assessment

10 Jan 2017

ABC Childrens Hospital

Edit

Scorecard

10 Jan 2017

XYZ Childrens Hospital

Edit

Scorecard

10 Jan 2017

PQR Childrens Hospital

Edit

Scorecard

10 Jan 2017

ABC Childrens Hospital

Edit

Scorecard

ISSUES

Long dashboard page with too much data

Users probably switch between 2-3 reports

Version 3

Report error

Contact

Providers

Scorecard

Create new report

All reports

Dashboard

kyle@kyleledbetter.com

Kyle Ledbetter

20 May 2017

Edit

Scorecard

Recenty created

15 August 2017

Edit

Scorecard

Recenty created

10 Jan 2017

Edit

Scorecard

Recenty created

6-7-14

100

200

300

400

500

12-8-15

6-18-15

1-1-16

16-4-16

12-12-16

5-20-17

CPIA

Quality

ACI

Compare Scores

Dashboard

All Reports

Create Report

Scorecard

Providers

Contact

ISSUES

Side navigation leaves less space for long tables

Scores are the not user’s first priority

MIPSight Web App

A customizable web-based application which can record data, generate scorecard and conduct what-if analysis to save time and provide meaningful insights.

1. Financial Dashboard

A Financial dashboard shows all the important data related to patients expenditure on basis of the treatment and diseases. Admin users can quickly view, edit and compare financials from different reports.

2. Manage Doctors Reports

All the reports are saved and organized
automatically by the date created. Doctors
can search sort and filter the reports based
on their date, score and by own name

3. View Report

In these individual reports, users can add,

edit, search, and import data in the tables.

They can also generate scorecards of the

reports in real time.

3. View Report

In these individual reports, patients data can be import and edit and can see the difference. They can also update based on health insured and non insured treatment

4. Scorecard

A scorecard visualizes the report to show

meaningful insights such as indivual

performance, top providers, and overall

score which can be downloaded anytime by

the administrators.

4. Scorecard

A scorecard visualizes the report to show

meaningful insights such as indivual

performance, top providers, and overall

score which can be downloaded anytime by

the users.

Conclusion

Overall Impact

The web app is currently used by Health Advisors to guide 15,000+ clinicians across

universities, health systems and independent provider-practices in major of the domestic states

This tool is helping healthcare institutions to save thousands of dollar and increasing the quality of patient care by

incentivising the performance of physicians, providers etc.

This tool is helping healthcare institutions to save thousands of dollar and increasing the quality of patient care by incentivising the performance of physicians, providers etc.

Learnings from this project

Handling Missing Values
Implementing DAX for Analysis
Dynamic Visualization Control
Implementing Row Level Security
Report Publishing and Sharing
Scheduling Data Refresh
Best Practices in Power bi Implementations

What’s your story? I’d love to hear it.

Hire Me

Home

Projects

Blogs

Know about my availability ?

Medium

mr.parekhparth@gmail.com

What’s your story? I’d love to hear it.

Hire Me

Home

Projects

Blogs

Know about my availability ?

Medium

mr.parekhparth@gmail.com

What’s your story? I’d love to hear it.

Hire Me

Home

Projects

Blogs

Know about my availability ?

Medium

mr.parekhparth@gmail.com

What’s your story? I’d love to hear it.

Hire Me

Home

Projects

Blogs

Know about my availability ?

Medium

mr.parekhparth@gmail.com

4. Scorecard

A scorecard visualizes the report to show

meaningful insights such as indivual

performance, top providers, and overall

score which can be downloaded anytime by

the users.

3. View Report

In these individual reports, users can add,

edit, search, and import data in the tables.

They can also generate scorecards of the

reports in real time.

3. View Report

In these individual reports, users can add,

edit, search, and import data in the tables.

They can also generate scorecards of the

reports in real time.

3. View Report

In these individual reports, users can add,

edit, search, and import data in the tables.

They can also generate scorecards of the

reports in real time.

2. Manage Reports

All the reports are saved and organized

automatically by the date created. Users

can search sort and filter the reports based

on their date, score and edit history.

1. Dashboard

A dashboard which shows all the important

& frequently used features at one place to

navigate faster. Users can quickly view, edit

and compare scores from different reports.

Information Architecture

User flow diagrams

Wireframing

Iterating user interface

As we moved on to designing the interface of the application, I wireframed all the UI screens and conducted an intial user testing session.

Defining Patterns

Design Style Guide

High Fidelity

Visual Design

Conclusion

Overall Impact

The web app is currently used by Quality Improvement Advisors (QIA) to guide 15,000+ clinicians across

universities, health systems and independent provider-practices in major of the domestic states

This tool is helping healthcare institutions to save thousands of dollar and increasing the quality of patient care by incentivising the performance of physicians, providers etc.

The Challenge

Create a performance data reporting system to reduce the overall administrative burdens for physicians and advisors

In 2017, 73% of hospitals were penalized by the govt. due to their inability to report data about the quality of service provided to the patients. Tracking this data can prevent penalties and ensure that better care is provided.