In this course, we’re going to go over analytical solutions to common healthcare problems. I will review these business problems and you’ll build out various data structures to organize your data. We’ll then explore ways to group data and categorize medical codes into analytical categories. You will then be able to extract, transform, and load data into data structures required for solving medical problems and be able to also harmonize data from multiple sources. Finally, you will create a data dictionary to communicate the source and value of data. Creating these artifacts of data processes is a key skill when working with healthcare data.
This course is part of the Health Information Literacy for Data Analytics Specialization
Offered By
About this Course
Offered by

University of California, Davis
UC Davis, one of the nation’s top-ranked research universities, is a global leader in agriculture, veterinary medicine, sustainability, environmental and biological sciences, and technology. With four colleges and six professional schools, UC Davis and its students and alumni are known for their academic excellence, meaningful public service and profound international impact.
Syllabus - What you will learn from this course
Solving the Business Problems
In this module, you will explain why comparing healthcare providers with respect to quality can be beneficial, and what types of metrics and reporting mechanisms can drive quality improvement. You'll recognize the importance of making quality comparisons fairer with risk adjustment and be able to defend this methodology to healthcare providers by stating the importance of clinical and non-clinical adjustment variables, and the importance of high-quality data. You will distinguish the important conceptual steps of performing risk-adjustment; and be able to express the serious nature of medical errors within the US healthcare system, and communicate to stakeholders that reliable performance measures and associated interventions are available to help solve this tremendous problem. You will distinguish the traits that help categorize people into the small group of super-utilizers and summarize how this population can be identified and evaluated. You'll inform healthcare managers how healthcare fraud differs from other types of fraud by illustrating various schemes that fraudsters use to expropriate resources. You will discuss analytical methods that can be applied to healthcare data systems to identify potential fraud schemes.
Algorithms and "Groupers"
In this module, you will define clinical identification algorithms, identify how data are transformed by algorithm rules, and articulate why some data types are more or less reliable than others when constructing the algorithms. You will also review some quality measures that have NQF endorsement and that are commonly used among health care organizations. You will discuss how groupers can help you analyze a large sample of claims or clinical data. You'll access open source groupers online, and prepare an analytical plan to map codes to more general and usable diagnosis and procedure categories. You will also prepare an analytical plan to map codes to more general and usable analytical categories as well as prepare a value statement for various commercial groupers to inform analytic teams what benefits they can gain from these commercial tools in comparison to the licensing and implementation costs.
ETL (Extract, Transform, and Load)
In this module, you will describe logical processes used by database and statistical programmers to extract, transform, and load (ETL) data into data structures required for solving medical problems. You will also harmonize data from multiple sources and prepare integrated data files for analysis.
From Data to Knowledge
In this module, you will describe to an analytical team how risk stratification can categorize patients who might have specific needs or problems. You'll list and explain the meaning of the steps when performing risk stratification. You will apply some analytical concepts such as groupers to large samples of Medicare data, also use the data dictionaries and codebooks to demonstrate why understanding the source and purpose of data is so critical. You will articulate what is meant by the general phase -- “Context matters when analyzing and interpreting healthcare data.” You will also communicate specific questions and ideas that will help you and others on your analytical team understand the meaning of your data.
Reviews
- 5 stars61.90%
- 4 stars28.57%
- 3 stars4.76%
- 2 stars4.76%
TOP REVIEWS FROM ANALYTICAL SOLUTIONS TO COMMON HEALTHCARE PROBLEMS
Very informative. Would have preferred more practical examples on data analysis
Very good, although I would suggest the Health Informatics as a starting course
Excellent material and a great introduction to data analytics!
About the Health Information Literacy for Data Analytics Specialization
This Specialization is intended for data and technology professionals with no previous healthcare experience who are seeking an industry change to work with healthcare data. Through four courses, you will identify the types, sources, and challenges of healthcare data along with methods for selecting and preparing data for analysis. You will examine the range of healthcare data sources and compare terminology, including administrative, clinical, insurance claims, patient-reported and external data. You will complete a series of hands-on assignments to model data and to evaluate questions of efficiency and effectiveness in healthcare. This Specialization will prepare you to be able to transform raw healthcare data into actionable information.

Frequently Asked Questions
When will I have access to the lectures and assignments?
What will I get if I subscribe to this Specialization?
Is financial aid available?
More questions? Visit the Learner Help Center.