Healthcare Data Analysis 2 Using SQL and Excel
Welcome and Course Structure
2 lessons
Course Description and Structure
Your 90-day Plan
Week 1: General Healthcare and Data Concepts
1 lesson
- Objectives: Understanding General Healthcare and Data Concepts
Week 1 - Part I: General Healthcare Background and Processes
11 lessons
- Reading: General Healthcare Concepts
Healthcare Data Analytics Glossary- Reading: Gaining Understanding of your Data
- Videos and Explanations
- Common Data Pitfalls ("CDP")
- Category 1: Intake and input errors arising from missing and or incorrectly entered data
- Category 2: Duplication errors
- Category 3: Patient matching errors
- Category 4: Formatting errors
- Testing Your Knowledge: Concepts and Application
- Lab 1.1 - Hands-On Exercises
Week 1 - Part II: Healthcare Data Concepts and Performing Analyses
1 lesson
- Lab 1.2 - Hands-On Exercises
Week 2: Patients, Plan Coverages and Processes
1 lesson
- Objectives: Patients, Plan Coverages and Processes
Week 2 - Part I: How Eligibility and Enrollment Processes Work
16 lessons
- Reading: Part I: How Eligibility and Enrollment Processes Work
- Reading: Gaining Understanding of your Data
- Videos and Explanations
- Common Data Pitfalls ("CDP")
- CDP Problem 1: Intake errors arising from missing and or incorrectly entered data from enrollment forms
- CDP Problem 2: Incorrectly identifying beneficiaries having similar beneficiary names.
- CDP Problem 3: Patient misidentification errors
- Testing Your Knowledge: Concepts and Application
Testing Your Knowledge- Lab 2.1 - Hands-On SQL Exercises – Payer Perspective
Quiz 1- Hands-On SQL Exercises – Provider Perspective
- Homework: Week 2 - Part I
SQLHomework- The Wrap: Summary and Accomplishments
Chat about E&E
Week 2 - Part II: Working with Membership Tables and Performing Various Analyses
3 lessons
- Lab 2.2 - Hands-On SQL Exercises
- Homework: Week 2 - Part I (copy)
- Reading: Part I: Applying Eligibility and Enrollment Processes Work
Week 3: Revenue Cycle and Billing Processes
1 lesson
- Objectives: Understanding Revenue Cycle and Billing Processes
Week 3 - Part I: How Revenue Cycle Processes Work
4 lessons
- Reading: Part I: Understanding Revenue Cycle Processes – General Concepts and Data
- Reading: Gaining Understanding of your Data
- Videos and Explanations
- Common Data Pitfalls ("CDP")
Week 3 - Part II: Working with Revenue Cycle Tables and Performing Various Analyses
1 lesson
- Videos and Explanations
Week 4: Claims Payment Processes
1 lesson
- Objectives: Understanding Claims Payment Processes
Week 5 Provider Processes
1 lesson
- Objectives: Understanding Provider Processes
Week 6: Course Review, Use Cases and Capstone Project
1 lesson
- Objectives:
Conclusion and Suggested Courses:
2 lessons
- Review of your 90-day Plan
- Suggested Courses and Resources