healthcare Data Analysis

Project Goals

Track current status of patient waiting list

Analyze historical monthly trend of waiting list in Inpatient & Outpatient categories

Detailed specialty level & age profile analysis

Data Scope

2018 - 2021

Metrics Required

Average & Median Waiting List

Current Total Wait List

Views Required

Summary Page

Detailed Page for Granular Analysis

Steps followed

Step 1 : requirement gathering(business requirement) a-Identify Stakeholders establish point of contact To ask for clarifications and clarify your doubts

b-Understand Business Objectives meeting and communications c-High Level Data Study :Data Sources, Column Description, Data Type, Volume / Frequency & Data Quality d-Define Scope document KPIs,Time lines, Expectations

Step 2 : Data work through

Step 3 : Data collection

Step 4 : Data cleaning / quality check

Step 5 : Data modeling

Step 6 : Design blueprint snap :

Step 7 : DAX calculation

Step 8 : dashboard lay outing

Step 9 : charts development and formatting

Step 10 : dashboard/report development

step 11 : Add Interactivity & Navigation

Step 12 : insight generation