Healthcare IT Decoded - Data Visualization using Tableau

Explore the outpatient department workflow from front office to diagnosis, lab and radiology tests, and pharmacy prescription, highlighting the patient journey in the OPD setting.

Explore how to define a logical data model by identifying KPIs, distinguishing master and transactional data, and aligning business analyst and technical teams before creating the database.

Load healthcare data after extraction and transformation, with the data model built in parallel with cleaning, using tools like Informatica Express, Mirth, Cloverleaf, and Rhapsody to support healthcare data standards.

Recap the patient journey from identifying source systems to extracting, transforming, and loading data, building logical and physical models, and deriving insights with Tableau or Power BI.

Create a Tableau Sankey dashboard by arranging the base, age, and race on opposite sides, removing labels and tooltips, and adding a bold 'Sankey Chart' header to emphasize deaths.

Create a unit chart in Tableau that uses symbols to proportionally represent hospital admissions. Use CMS readmissions data to visualize conditions like heart failure and COPD.

Access the My Tableau Repository and its Shapes folder to add and reload custom icons for the marks tab, using them in hex maps or unit charts.

Create a unit chart in Tableau to visualize hospital readmission reduction data by state, using calculated fields for calls and discharges, with icon shapes, colors, and labels.

Create heatmaps in tableau using the covid 19 global data csv, exploring weekly deaths by country or region with color-coded bars to compare trends.

Analyze BRFSS alcohol consumption data to build a heatmap in Tableau, filtering for 18–24 year olds who drank in the past 30 days, across 2001–2010, and removing duplicates.

Create an interactive heat map in Tableau to visualize alcohol consumption by location and year, using filters for topic, response, and age group, and customize colors for clear interpretation.

Explore how to create and interpret a donut chart in Tableau, using national health expenditures data, with filters for payer, service, age group, and gender to avoid double counting.

Demonstrates building a donut chart in Tableau, applies filters on age group, gender, and services to exclude total values, ensuring accurate payer data like Medicaid.

Explore bullet charts that compare two values with a reference line and target line, using AHRQ inpatient discharge data by age groups, visualized in Tableau.

Create a bullet chart in Tableau by building calculated fields for 2019 and 2020 discharges, then use dual axis, gantt, and bar options to compare values.

Create a bump chart in Tableau to visualize nursing home penalties by state, focusing on fine amounts, using table calculations to rank states and reverse the y-axis.

Learn to convert a bump chart into a heatmap in Tableau, using square marks and color cues to visualize nursing home penalties by state and quarter.