image
The Ultimate Drawing Course Beginner to Advanced...
$179
$79
image
User Experience Design Essentials - Adobe XD UI UX...
$179
$79
Total:
$659

Description

The most commonly available and widely used type of data in healthcare is claims data. Claims data is sometimes also called billing data, insurance data or administrative data. The reason why claims data is the most large scale, reliable and complete type of big data in healthcare is rather straightforward. It has to do with reimbursement, that is, the payment of health care goods and services depends on claims data. Healthcare providers may not always find the time to fill in all required paperwork in healthcare, but they will always do that part of their administration on which their income depends. Thus, in many cases, analyzing healthcare claims data is a much more pragmatic alternative for extracting valuable insights.
Claims data allows for the analysis of many non-biological elements pertaining to the organization of health care, such as patient referral patterns, patient registration, waiting times, therapy adherence, health care financing, patient pathways, fraud detection and budget monitoring. Claims data also allows for some inferences about biological facts, but these are limited when compared to medical records.
By following this course, students will gain a solid theoretical understanding of the purpose of healthcare claims data. Moreover, a significant portion of this course is dedicated to the application of data science and health information technology (Healthcare IT) to obtain meaningful insights from raw healthcare claims data.
This course is for professionals that (want to) work in health care organizations (providers and payers) that need to generate actionable insights out of the large volume of claims data generated by these organizations. In other words, people that need to apply data science and data mining techniques to healthcare claims data.
Examples of such people are: financial controllers and planners, quality of care managers, medical coding specialists, medical billing specialists, healthcare or public health researchers, certified electronic health records specialist, health information technology or health informatics personnel, medical personnel tasked with policy, personnel at procurement departments and fraud investigators. Finally, this course will also be very useful for data scientists and consultants that lack domain knowledge about the organization of healthcare, but somehow got pulled into a healthcare claims data project.
The instructor of this course is Dennis Arrindell, MSc., MBA. Dennis has a bachelor’s degree in Public Health, a master’s degree in Health Economics and a Master’s degree in Business Administration.
Upon completion of this course, students will be able to contribute significantly towards making healthcare organizations (providers and payers) more data driven.
What this course is NOT about:
- Although we will be applying some important statistics and machine learning concepts, this course is NOT about statistics or machine learning as a topic on itself.
- Although we will be using multiple software tools and programming languages for the practical parts of this course, this course is NOT about any of these tools (Excel, SQL, Python, Celonis for process mining) as topics on themselves.
Who this course is for:
This course is for professionals that are involved with healthcare providers and health insurers that need to generate actionable insights out of the large volume of claims data generated by these organizations. Examples are: financial controllers and planners, quality of care managers, medical coding specialists, medical billing specialists, healthcare or public health researchers, certified electronic health records specialist, health information technology or health informatics personnel, medical personnel tasked with policy, personnel at procurement departments and fraud investigators. Finally, this course will also be very useful for data scientists and consultants that lack domain knowledge about the organization of healthcare, but somehow got pulled into a healthcare claims data project.

What you'll learn

In this course, you will learn and practice, how to transform raw healthcare claims data into valuable knowledge and actionable insights.

Requirements

  • You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
  • No previous design experience is needed.
  • No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures
Expand All Sections
1-Introduction
4
1.1-Welcome to the course
1.2-Claims Data Defined
1.3-Why analyze healthcare claims data
1.4-Who this course is for
2-Theory of Healthcare systems
4
2.1-The four functions of any healthcare system
2.2-The three key actors in claims data
2.3-Vertical integration of healthcare system functions
2.4-Healthcare systems quiz
3-Healthcare provider payment systems
7
3.1-Introduction to healthcare provider payment systems
3.2-Fee-for-service
3.3-Capitation
3.4-Bundled payments
3.5-Global budgets
3.6-Summary of healthcare provider payment systems
3.7-Healthcare provider payment systems
4-Theory of claims data
4
4.1-The two core challenges for healthcare payers
4.2-Fact tables and dimension tables
4.3-Authorisation signals
4.4-Theory of claims data quiz
5-Merging healthcare claims data
3
5.1-Introduction to merging data
5.2-Merging data from a data warehouse
5.3-Merging an episode of care
6-Higher level categorization
8
6.1-Introduction to higher level categorization
6.2-Consult the data dictionary
6.3-Consult the dimension tables
6.4-(Re)Discover the underlying logic of codes
6.5-Use existing hierarchies of (inter)national coding systems
6.6-Ask a domain expert
6.7-Summary of higher level categorization
6.8-Higher level categorization quiz
7-Relevant resources for this course
1
7.1-Get all relevant resources here
8-Basic exploration of healthcare claims data
14
8.1-Getting started with the practice dataset
8.2-Basic filtering of data in Excel
8.3-Introduction to pivot tables
8.4-Working with a pivot table in Excel
8.5-Selecting aggregations in a pivot table
8.6-Grouping by date in a pivot table
8.7-Using a pivot table to create and control a chart
8.8-Introduction to vertical lookup
8.9-Vertical look-up part 1: Exploring the look-up table in Excel
8.10-Vertical look-up part 2: Applying the function
8.11-Vertical look-up part 3: Filling down the results
8.12-A note on filling down in Excel
8.13-Vertical look-up part 4: Finalizing the dataset
8.14-Benefit of introducing categories in claims data
9-Extract, Transform and Load (ETL) from the data warehouse using SQL
15
9.1-Background information about the practice data warehouse
9.2-Relational data schema
9.3-A note about the new Big Query Interface
9.4-Getting started with Google Big Query
9.5-Access the Medicare dataset in the new Big Query interface
9.6-Introduction to SQL in Google Big Query interface
9.7-Writing a simple SQL script to extract healthcare claims data
9.8-Merging data using SQL
9.9-Visualizing the data in Big Query
9.10-Calculating the age of the patient at the time of knee replacement
9.11-Confirming the correct code using the where clause and a regular expression
9.12-Inspecting the compatibility between the tables
9.13-Concatenate and cast data to allow compatibility
9.14-Create a subquery
9.15-Date difference function to calculate age
10-Absolute and relative comparisons
5
10.1-Absolute and relative comparisons
10.2-Using a 100% Stacked column chart for relative comparisons
10.3-Using percentages for relative numbers
10.4-Per capita calculations using distinct count
10.5-Using distinct count for relative comparisons in Excel
11-Process Mining with healthcare claims data
24
11.1-Introduction to process mining
11.2-Benefits of process mining with healthcare claims data
11.3-Process mining tools
11.4-Warning! Please read this word of caution before using Celonis
11.5-Getting started with Celonis Free Plan
11.6-Configure the dataset for process mining
11.7-Update 27 October 2024: New Celonis Interface
11.8-How to upload data in Celonis using an example dataset
11.9-Introduction to process mining with Celonis part 1
11.10-Introduction to process mining with Celonis part 2
11.11-Discover patient pathways using process mining (part 1)
11.12-Discover patient pathways using process mining (part 2)
11.13-Isolate a sub process by focussing on the sub process spider activity
11.14-Introduction to specifying a sequence order
11.15-Theory of sequence order when dealing with identical timestamps
11.16-A note about specifying a sequence order
11.17-Manipulating the raw data to specify a sequence order (part 1)
11.18-Manipulating the raw data to specify a sequence order (part 2)
11.19-A note about concatenation
11.20-Confirm the correct sequence in a new process map
11.21-Detect anomalies by comparing the processes of different providers
11.22-Moving from process mining to statistics and machine learning
11.23-Process mining quiz
11.24-Process mining assignment
12-Proxy diagnosis and cohort analysis
8
12.1-A note about proxy diagnosis and cohort analysis
12.2-Proxy diagnosis
12.3-Method for obtaining a proxy diagnosis
12.4-Why use a subquery for proxy diagnosis
12.5-Querying healthcare consumption of diabetics using a proxy diagnosis
12.6-Identify insuline users (diabetics)
12.7-Use identified diabetics to capture their full episode of care
12.8-Capture the episode of care for patients undergoing a total knee replacement
13-Tidying healthcare claims data
7
13.1-Introduction to tidy data
13.2-Tidying healthcare claims data with Excel
13.3-Converting the target variable to a binary field with Excel
13.4-Getting started with Google Colab
13.5-Tidying healthcare claims data with Python
13.6-Converting the target variable to a binary field with Python
13.7-A note about metric selection
14-The Cost-Effectiveness Index
3
14.1-The Cost-Effectiveness Index (Theory)
14.2-The Cost-Effectiveness Index (Practice with Excel)
14.3-Creating the Cost-Effectiveness index with ChatGPT
15-Predicting consumption events
9
15.1-Introduction to this section
15.2-Preparing the data for logistic regression with Python
15.3-Performing logistic regression
15.4-Evaluating the performance with a confusion matrix
15.5-Using a different categorization logic as input for logistic regression (part 1)
15.6-Using a different categorization logic as input for logistic regression (part 2)
15.7-Using a different categorization logic as input for logistic regression (part 3)
15.8-Considerations for advanced machine learning practitioners
15.9-Applying logistic regression with different metrics
16-Using Large Language Models (ChatGPT) to analyze data
5
16.1-Using ChatGPT advanced data analysis to conduct logistic regression
16.2-Process Mining with ChatGPT
16.3-Using the Phyton library PM4PY in ChatGPT
16.4-Using a Custom GPT to help interpret graphs
16.5-Using ChatGPT to create the cost-effectiveness index
17-Detecting irregularities and possible fraud
21
17.1-Introduction to this section
17.2-Preparing the data for unsupervised machine learning
17.3-Applying Principal Component Analysis
17.4-A note about the Python code
17.5-Applying K-Means clustering
17.6-Calculating the distance from the nearest cluster
17.7-Combining the machine learning outputs with the original claims data
17.8-Exporting the machine learning output to a csv file
17.9-Prepare for case by case analysis guided by the machine learning output
17.10-Explore the different clusters (part 1)
17.11-Interpret and rename the different clusters
17.12-Compare the healthcare providers by patient clusters (part 1)
17.13-Compare the healthcare providers by patient clusters (part 2)
17.14-Example of absolute versus relative data
17.15-Analyzing the distance from nearest cluster (part 1)
17.16-Analyzing the distance from nearest cluster (part 2)
17.17-Analyzing the distance from nearest cluster (part 3)
17.18-Identifying red flags (part 1)
17.19-Identifying red flags (part 2)
17.20-Inspecting the red flag indivual patients on a case-by-case basis (part 1)
17.21-Inspecting the red flag indivual patients on a case-by-case basis (part 2)
18-Performance tracking (compare defined targets with actual performance)
18
18.1-Introduction to performance tracking with healthcare claims data
18.2-Method part 1: Harmonizing the actual data with the targets
18.3-Method part 2: Merging the two tables
18.4-Method part 3: Feed the data into a business intelligence dashboard
18.5-Trivia: Using compound/composite keys rather than multiple join keys
18.6-Practice performance tracking with claims data
18.7-Exploration of the business intelligence dashboard
18.8-Visually inspecting the targets table
18.9-Uploading the target table in the data warehouse
18.10-Preparing the raw claims data for aggregation using SQL (part 1)
18.11-Preparing the raw claims data for aggregation using SQL (part 2)
18.12-Aggregating the raw claims data using SQL
18.13-Creating a subquery containing the actual performance
18.14-Joining the subquery with the uploaded table
18.15-Calculating the percentage realized
18.16-Saving the output as a new table in the data warehouse
18.17-Feeding the output into the business intelligence dashboard
18.18-Creating the business intelligence dashboard
19-Value-based healthcare and health outcome indicators
9
19.1-Introduction to value-based healthcare and health outcomes
19.2-Introduction to types of health outcome indicators
19.3-Patient reported health outcomes
19.4-Biological health outcome indicators
19.5-Adverse health episodes as outcome indicators
19.6-Aftercare signals as a health outcome indicator
19.7-Mortality as a health outcome indicator
19.8-Merging different types of health outcome indicators
19.9-Challenges with value-based healthcare and health outcomes
20-A Framework for Analyzing and Communicating Healthcare Claims Data
1
20.1-A Framework for Analyzing and Communicating Healthcare Claims Data
21-Conclusion
2
21.1-Final words
21.2-Bonus lecture: learn more about Process Mining