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
Back
© 2021 Next Generation Health Analytics