DATA ANALYSIS IN HEALTHCARE

• Excel basics
• Navigation and interface
• Functionality
• Practical applications

• Pivot tables
• VLookup
• Conditional logic

• Uploading data
• Table creation and management
• Statistical adjustments
• Chart representations

• Uploading data
• Dimensions vs. measures
• Creating visualizations
• Creating dashboards

We’re kicking things off with some introductions, sorting out any logistical stuff, and getting you pumped for the awesome journey ahead. Let's make this class the best one yet.

• Instructor introduction
• General housekeeping rules
• Course & assignments overview
• Q & A

Our first lesson begins! We'll explore the current state of healthcare in the United States and discover how advanced analytics are revolutionizing the industry. Understand patterns behind healthcare data and gain insights that could shape the future of medicine.

• Harnessing healthcare data for insights
• Defining the Triple Aim
• Analyzing healthcare data: importance and interpretation
• Types of healthcare analytics: descriptive, diagnostic, predictive, prescriptive

From decoding HIPAA to uncovering the process of healthcare fraud detection, this class will equip you with the knowledge and insights you need to navigate the intricate web of data governance within organizational landscapes.

• Importance of HIPAA and healthcare data confidentiality
• Identifying protected health information (PHI)
• Role of data governance in healthcare data protection
• Ethical applications of advanced analytics in healthcare.
• Detecting healthcare fraud

Assignment #1: The Intersection of Healthcare & Analytics
Delve into real-world healthcare scenarios, tackling data security breaches and policy slips to ignite a passion for healthcare analytics within your team.

What are the preliminary phases of data analysis? Let's roll up our sleeves and get Excel-lent at making informed decisions. You’ll learn how to import data into Excel, tackling everything from data cleaning to merging different sources.

• Healthcare data sources
• Excel data importation & data cleaning
• Handling missing data
• Data management techniques
• Merging & joining data sources

(Optional) Assignment #2: Exploring Healthcare Data in Excel
Harness Excel's power to analyze healthcare data, uncovering insights that drive informed decision-making in healthcare settings.

Learn the ABCs of descriptive statistics, charts, and figures – understand what’s hidden within the numbers. We'll dive into data types, spot patterns, and paint pictures with stats that speak volumes.

• Common data types definition
• Identifying statistical patterns
• Describing distributions numerically: mean, median & standard deviation
• Graphical representations of data: histograms & bar charts

Assignment #3: Exploring Descriptive Statistics & Data Visualization
Learn to interpret and communicate complex healthcare data effectively using descriptive statistics and data visualization techniques.

Take another step toward turning data into insights that shine. Examine additional advanced charts, pivot tables, and data presentation, learning the ropes of visual storytelling.

• Identifying your data
• Using pivot tables & charts
• Using different chart types
• The limitations of Excel 

(Optional) Assignment #4: Advanced Data Analysis with Excel
Elevate your data analysis skills in Excel with advanced techniques tailored for healthcare analytics applications.

Learn in practice! We’ll be deciphering whether two means truly stand apart in significance and relevance. Master conducting t-tests and emerge with a newfound confidence in statistical comparisons.

• T-test basics
• Assumptions for t-tests
• Two-sample & paired t-test
• Longitudinal data analysis with t-tests
• Interpreting t-test results

Assignment #5: Understanding Two-Sample T-Tests for Health Outcomes
Evaluate health outcome data using two-sample t-tests, gaining a deeper understanding of statistical analysis in healthcare contexts.

Unlock the power of ANOVA to unearth meaningful differences between multiple groups in healthcare datasets. Dive into hypothesis testing and categorical creation, paving the way to insightful data analysis.

• ANOVA
• Creating categories
• Stating hypotheses
• ANOVA for three or more groups
• Longitudinal data: ANOVA

(Optional) Assignment #6: Exploring Analysis of Variance (ANOVA) in Patient Visits
Investigate patient visit no-show rates using ANOVA, uncovering valuable insights for improving healthcare services.

Let's play detective with data! Discover if variables in healthcare data are secretly BFFs or just casual acquaintances. We'll navigate scatterplots, correlation, and even dip our toes into regression – all with a sprinkle of data magic using Tableau.

• Exploring relationships and patterns
• Scatterplot and correlation
• Introduction to regression
• Demo: Tableau

Assignment #7: Investigating Relationships with Patient Diabetes Data
Analyze relationships in patient diabetes data, gaining insights into healthcare trends and outcomes.

Ready to dig deeper into regression analysis? From fitting lines to making predictions, we'll explore single and multiple regression techniques, tackling practical applications and case studies along the way. Let's crunch some numbers.

• Single linear regression & multiple regression essentials
• Model fitting & evaluation
• Result interpretation & prediction
• Incorporating multiple predictors
• Handling multicollinearity & interactions
• Practical applications

Assignment #8: Regression Analysis Using Tableau Dashboard
Utilize Tableau to conduct regression analysis on patient outcome data related to diabetes, presenting findings visually.

Another practical session! Explore the nitty-gritty of different sampling designs, learn how to tailor them to specific scenarios, and uncover the secrets behind effective research design.

• Question-driven research
• Sampling
• Different types of sampling designs
• Research design
• Causal inference based on research design

Assignment #9: Designing a Research Adventure
Design and implement a research study, applying healthcare analytics principles to real-world scenarios for actionable results.

Get the lowdown on quality healthcare and how to measure it like a pro. After all, in today's healthcare landscape, data-driven decisions are the name of the game. We’ll touch on KPIs, metrics, and optimizing patient care & organizational performance.

• Defining healthcare quality and value
• Understanding measures, metrics, and indicators
• Exploring the role of key performance indicators (KPIs)
• Achieving performance goals in healthcare organizations
• Case study: The Health Catalyst Data Operating System at Texas Children's Hospital

(Optional) Assignment #10: Understanding Healthcare Quality & Measurement Methods
Explore healthcare quality and measurement methods, understanding their impact on patient care and operational efficiency.

Transform boring data into stories that resonate with your audience and leave a lasting impact. We'll explore how to weave compelling narratives, jazzing up numbers, and leaving stakeholders hanging on your every chart.

• Optimal data visualization techniques & information presentation methods
• Essential report background details
• Tailored communication strategies for stakeholders
• Case study: Data-driven surgery enhancements at Mayo Clinic
• Demo: Power BI

Assignment #11: Mastering Data Storytelling Techniques
Transform healthcare data into compelling narratives that resonate with diverse audiences, enhancing data-driven decision-making.

AI is transforming patient care. Discover effective strategies for leveraging these technologies in healthcare analytics. We'll explore cutting-edge trends, real-world case studies, and discuss the exciting possibilities AI holds.

• Defining AI
• Revolutionizing patient care with AI solutions
• Harnessing Generative AI in healthcare analytics
• Case study: Palliative Connect by Penn Medicine
• Discussion: Exploring AI's role in healthcare data analytics

(Optional) Assignment #12: Impact of Artificial Intelligence in Healthcare Analytics
Delve into the transformative potential of artificial intelligence in healthcare analytics, exploring its implications and applications.

Final session! Learn how to ace job interviews, adapt to shifting roles, and showcase your skills with finesse, all while soaking up invaluable insights from our industry experts.

• Career guidance
• Job role adaptation
• Aptitude demonstration
• Industry insights with a guest speaker

Assignment #13: Nurse Attrition Executive Briefing
Analyze nurse attrition data to develop executive-level insights and strategies, addressing critical workforce challenges in healthcare.