• 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

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

Assignment #1: Resume Prep
Let's kick off by dusting off that resume. Lets prep this resource to be a great sales tool to communicate your value.

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 #2: Portfolio Prep
Create a working document where you can share your data problem-solving skills with future employers.

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

• Identifying your data
• Profiling the data
• Describing distributions numerically: mean, median & standard deviation
• Graphical representations of data: histograms & bar charts
• Best practices for data presentation

What are the preliminary phases of data analysis? You’ll learn how to import data into Excel and tackle 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
• Pivot tables, charts, data profiling & limitations of Excel

Assignment #3: Job Search Approach
Get familiarized with the current job market and start targeting your unique value to a few key jobs.

Learn the ABCs of profiling, building visuals – understand what’s hidden within the numbers. We'll dive into the essentials in Tableau and Power BI.

• Identifying your data 
• Profiling your data
• Building visuals 
• Best practices for data presentation 

Assignment #4: Descriptive Statistics and Data Visualization
Utilize descriptive statistics and data visualization techniques to interpret and communicate healthcare data effectively.

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 & limitation of t-tests
• Interpreting t-test results 
• Using T-tests the right way 

Assignment #5: Understanding Two-Sample T-Tests for Health Outcomes (Quiz)

Unlock the power of ANOVA and other advanced statistical methods to unearth meaningful differences between multiple groups in healthcare datasets. 

• T-tests review
• Chi-square test overview
• ANOVA test overview
• Introduction to regression
• When to use each method

Assignment #6: Advanced Statistical Methods (Quiz)

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 #7: Regression Analysis Using Tableau/Power BI (Optional)
Utilize Tableau to conduct regression analysis on patient outcome data related to diabetes, presenting findings in a visually compelling format.

Let's play detective with data. 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
• Demo: Tableau & Power BI

Assignment #8: Investigating Relationships in Hospital Length of Stay Tableau or Excel
Analyze relationships between variables using patient hospital length of stay data, gaining insights into healthcare trends and outcomes. 

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: Question-Driven Research Design (Quiz)

Get the lowdown on quality healthcare and how to measure it like a pro. 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

Assignment #10: Evaluating Healthcare Quality Improvement Initiative (Quiz)

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 (Optional)
Transform healthcare data into compelling narratives that resonate with diverse audiences.

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

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

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: Resume and Portfolio Additions
Delve into the transformative potential of artificial intelligence in healthcare analytics, exploring its implications and applications.