Healthcare It Decoded - Data Visualization

Tableau Charts Edition

What you'll learn

Understand the End to End Data Analysis Workflow

Create different charts using various Healthcare datasets

Demonstrate knowledge of creating simple charts like Scatter plot using Healthcare Data

Demonstrate knowledge of creating complex charts like Sankey Chart using Healthcare Data

Requirements

No specific experience required.

Description

Are you Interested in learning how to create some basics charts in Tableau using Healthcare data? Yes, then look no further. This course has been designed considering various parameters. I combine my experience of over twenty years in Health IT and more than ten years in teaching the same to students of various backgrounds (Technical as well as Non-Technical).In this course you will learn the following:Understand the Patient Journey via the Revenue Cycle Management Workflow - Front, Middle and Back OfficeThe Data Visualization Journey - Moving from Source System to creating ReportsAt present I have explained 27 Charts using TableauSankey Chart | Unit Chart | Trellis Chart | Heatmap | Donut Chart | Bullet Chart | Bump ChartScatter Plot | Sunburst Chart | Waffle Chart | Diverging Bar Chart | Funnel Chart | Grid MapHexBin Map | Pareto Chart | Quadrant Chart | Bar in Bar Chart | Correlation Matrix | Butterfly ChartPlum Pudding Chart | Petal Chart | Step Chart | Marimekko Chart | Dumbbell Plot | Jitter PlotSparkline Bar Chart | Calendar ChartHealthcare Datasets to create the above charts.Most of the Charts use their Unique Dataset, I have listed a few of the datasets used belowCDC Wonder Dataset around Cancer.FDA Adverse Reactions Data, from FDA Adverse Event Reporting System (FAERS)Nursing Homes Penalty Data from CMS.Length of Stay Data from AustraliaCanada - Hospital Cost ages 0 to 75 plusHospital Readmissions DataUCI (University of Irvine) Datasets National Health and Nutrition Examination Survey - Blood Pressure DataChronic Disease Indicators from CDCCDC Alcohol DeathsIndoor & Outdoor Patients treated in Haryana**Course Image cover has been designed using assets from Freepik website.

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Hospital Patient Journey

Lecture 2 Point of Care OPD

Lecture 3 Point of Care IPD

Lecture 4 Admissions & Financial Counseling

Lecture 5 Appointment to Registration

Lecture 6 Medical Transcription & Coding

Lecture 7 Insurance Eligibility

Lecture 8 Overview of Codes & Standards

Lecture 9 Back Office

Section 3: Data Visualization - The Journey

Lecture 10 Understanding the Source Systems

Lecture 11 Extract the Data

Lecture 12 Transform the Data

Lecture 13 The Logical Data Model

Lecture 14 Load the Data

Lecture 15 Insights & Foresights

Lecture 16 A Quick Recap

Lecture 17 Download the Resources

Section 4: Sankey Chart

Lecture 18 Download the CDC Wonder Dataset

Lecture 19 Basics and About the dataset

Lecture 20 Sankey Chart - Understanding the Logic

Lecture 21 Sankey - Creating the base in Tableau

Lecture 22 Sankey - Creating the base in Tableau Part 2

Lecture 23 Sankey - Left & Right hand side

Lecture 24 Sankey - Putting it all together

Section 5: Unit Chart

Lecture 25 Download the data for the Unit Chart

Lecture 26 Unit Chart Overview & Data

Lecture 27 Unit Chart My Tableau Repository

Lecture 28 Unit Chart in Tableau Part 1

Lecture 29 Unit Chart in Tableau Part 2

Section 6: Trellis Chart

Lecture 30 Download the WHO Dataset & Tableau Formulas File

Lecture 31 Trellis Chart Overview & Data Used

Lecture 32 Creating the Trellis Chart in Tableau

Section 7: Heat Map

Lecture 33 Download Heatmap Data

Lecture 34 HeatMap Overview

Lecture 35 Create Heatmap using the Measles Dataset in Tableau

Lecture 36 Heatmap - Covid Dataset Overview

Lecture 37 Creating Heatmap in Tableau using the Covid Dataset

Lecture 38 Heatmap - BRFSS Website Overview

Lecture 39 Heatmap - BRFSS Alcohol Consumption Data Overview

Lecture 40 Create Heatmap In Tableau using the BRFSS Data

Section 8: Donut Chart

Lecture 41 Download the data for Donut Chart

Lecture 42 Donut Chart Overview & Data

Lecture 43 Donut Chart Payer Breakup

Lecture 44 Donut Chart Payer Correction

Lecture 45 Donut Chart Using Specific Question from Data

Section 9: Bullet Chart

Lecture 46 Download the data and Tableau formulas for Bullet Chart

Lecture 47 Bullet Chart Overview & Data

Lecture 48 Creating the Bullet Chart in Tableau

Section 10: Bump Chart

Lecture 49 Download the data for the Bump Chart

Lecture 50 Bump Chart Overview and Data

Lecture 51 Bump Chart in Tableau - Nursing Home Penalties

Lecture 52 Bump Chart in Tableau as Heatmap - Nursing Home Penalties

Section 11: Charts Quiz Part 1

Section 12: Scatter Plot

Lecture 53 Download the data for the Scatter Plot

Lecture 54 Scatter Plot Overview & Data

Lecture 55 Scatter Plot Prostate Cancer

Lecture 56 Scatter Plot Matrix

Section 13: Sunburst Chart

Lecture 57 Download the data for the Sunburst Chart

Lecture 58 Sunburst Chart Overview & Data

Lecture 59 Creating a Sunburst Chart in Excel

Lecture 60 Sunburst Chart in Tableau - Part 1

Lecture 61 Sunburst Chart in Tableau - Part 2

Lecture 62 Sunburst Chart in Tableau - Part 3

Section 14: Waffle Chart

Lecture 63 Download the data for the Waffle Chart

Lecture 64 Waffle Chart Overview & Data

Lecture 65 Waffle Chart in Tableau - Part 1

Lecture 66 Waffle Chart in Tableau - Part 2

Section 15: Diverging Bar Chart

Lecture 67 Download the data for the Diverging Bar Chart

Lecture 68 Diverging Bar Chart Overview & Data

Lecture 69 Diverging Bar Chart using Maternity Mortality Data

Lecture 70 Diverging Bar Chart using Obesity Data

Section 16: Funnel Chart

Lecture 71 Download the data for the Funnel Chart

Lecture 72 Funnel Chart Overview & Data

Lecture 73 Funnel Chart in Tableau

Section 17: Grid Map

Lecture 74 Download the data for the Grid Map

Lecture 75 Grid Map Overview & Data

Lecture 76 Grid Map in Tableau

Section 18: HexBin Map

Lecture 77 Download the data for the Hexbin Map

Lecture 78 HexBin Map Overview & Data

Lecture 79 HexBin Map Medicare Data USA

Lecture 80 HexBin Map vs Normal Map

Lecture 81 HexBin Map Australia LOS

Section 19: Pareto Chart

Lecture 82 Download the data for the Pareto Chart

Lecture 83 Pareto Chart Overview & Data

Lecture 84 Pareto Chart Tableau Part 1

Lecture 85 Pareto Chart Tableau Part 2

Section 20: Charts Quiz Part 2

Section 21: Quadrant Chart

Lecture 86 Download the data for the Quadrant Chart

Lecture 87 Quadrant Chart Overview & Data

Lecture 88 Quadrant Chart in Tableau Part 1

Lecture 89 Quadrant Chart in Tableau Part 2

Section 22: Bar in Bar Chart

Lecture 90 Download the data for the Bar in Bar Chart

Lecture 91 Bar in Bar Chart Overview & Data

Lecture 92 Bar in Bar Chart - Part 1

Lecture 93 Bar in Bar Chart Part 2

Lecture 94 Bar in Bar Chart Part 3

Lecture 95 Bar in Bar Chart Part 4

Section 23: Correlation Matrix

Lecture 96 Download the data for the Correlation Matrix

Lecture 97 Correlation Matrix Overview & Data

Lecture 98 Correlation Matrix in Tableau

Section 24: Butterfly Chart

Lecture 99 Download the data for the Butterfly chart

Lecture 100 Butterfly Chart Overview & Data

Lecture 101 Butterfly Chart in Tableau

Section 25: Plum Pudding Chart

Lecture 102 Download the data for the Plum Pudding Chart

Lecture 103 Plum Pudding Chart Overview & Data

Lecture 104 Plum Pudding Chart Template - 1

Lecture 105 Plum Pudding Chart Template - 2

Section 26: Charts Quiz Part 3

Section 27: Petal Chart

Lecture 106 Download the data for the Petal Chart

Lecture 107 Petal Chart Overview & Data

Lecture 108 Petal Chart Part 1

Lecture 109 Petal Chart Part 2

Lecture 110 Petal Chart Part 3

Lecture 111 Petal Chart Part 4

Section 28: Step Chart

Lecture 112 Download the data for the Step Chart

Lecture 113 Step Chart Overview & Data

Lecture 114 Step Chart in Tableau

Section 29: Marimekko Chart

Lecture 115 Download the data for the Marimekko Chart

Lecture 116 Marimekko Chart Overview & Data

Lecture 117 Marimekko Chart Part 1

Lecture 118 Marimekko Chart Part 2

Section 30: Dumbbell Chart

Lecture 119 Download the data for the Dumbbell Chart

Lecture 120 Dumbbell Chart Overview & Data

Lecture 121 Dumbbell Chart By Country

Lecture 122 Dumbbell Chart By Continent

Section 31: Jitter Plot

Lecture 123 Download the data for the Jitter Chart

Lecture 124 Jitter Plot Overview & Data

Lecture 125 Jitter Plot in Tableau

Section 32: Sparkline Bar Chart

Lecture 126 Download the data for the Sparkline Bar Chart

Lecture 127 Sparkline Bar Chart Overview & Data

Lecture 128 Sparkline Bar Chart in Tableau

Section 33: Calendar Chart

Lecture 129 Download the data for the Calendar Chart

Lecture 130 Calendar Chart Overview & Data

Lecture 131 Calendar Chart Covid Vaccinations

Lecture 132 Calendar Chart Covid Deaths

Section 34: Charts Quiz Part 4

Section 35: Reference List

Lecture 133 Detailed List for Reference

Beginners curious about create basic Charts in Tableau using Healthcare Data,Health IT Professionals,Healthcare/Hospital Management Professionals