** DATA IS THE NEW CURRENCY! **
The purpose of this site is exhibit how I have utilized Power BI to extract actionable insights from historical data. Each project reflects a real-world problem encountered on a daily basis. I will leverage Power BI’s advanced features to demonstrate how you can gain access to the “story” that lies within your data.
Key skills demonstrated will include;
- Defining the “WHY” for analysis (e.g., why something happened, why it is important, etc.)
- Data Extraction, Transformation, and Load (ETL)
- Data Cleansing
- Data Modeling
- Descriptive Analytics
- Data Visualization (Dashboarding)
- Identifying actionable insight
Site Owner: Anderson Phillips III
#Project 1: Patient Appointment Analysis
Overview
Patient No-Shows permeate medical practices, across specialties, locations, and practice models. No-shows consistently cause problems for medical practices. Therefore, medical practices track their No-Show rates to realize the impact that No-Shows have on both their internal processes and bottom-line revenue.
There are many reasons why patients fail to make their appointments. However, there are demographic similarities across patients who no-show more consistently than others. This project analyzes medical appointments for a seven-month period (November 2015 – June 2016). Over 110,000 appointments are included in the underlying dataset. Factors under considerations include age, gender, alcoholism, diabetes, handicap, hypertension, patient’s location, scheduled appointment time, and whether the patient received an automated SMS appointment reminder.
Key Objectives
- Identify factors that are shared among patients who routinely no-show for appointments
- Determine the most important factor that contributes to whether a patient is a no-show for their scheduled appointment
- Provide suggestions to minimize the number of No-Shows
