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.
Ce cours fait partie de la Spécialisation Health Information Literacy for Data Analytics
Analytical Solutions to Common Healthcare Problems
proposé par
Programme du cours : ce que vous apprendrez dans ce cours
Semaine
12 heures pour terminer
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.
8 vidéos (Total 61 min), 1 lecture, 1 quiz
8 vidéos
Course Introduction4 min
Module 1 Introduction3 min
Provider Profiling10 min
How to Make Fairer Comparisons Using Risk Adjustment6 min
How Risk Adjustment is Performed8 min
Patient Safety: Measuring Adverse Events7 min
Super-Utilizers of Health Resources10 min
Fraud Detection10 min
1 lecture
A Note From UC Davis10 min
1 exercice pour s'entraîner
Module 1 Quiz30 min
Semaine
22 heures pour terminer
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.
7 vidéos (Total 51 min), 1 quiz
7 vidéos
Clinical Identification Algorithms (CIA)9 min
HEDIS and AHRQ Quality Measures7 min
Analytical Groupers6 min
Open Source Groupers - Grouping Diagnoses and Procedures7 min
Open Source Groupers - Comorbidity, Patient Risk, and Drugs8 min
Commercial Groupers10 min
1 exercice pour s'entraîner
Module 2 Quiz30 min
Semaine
33 heures pour terminer
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.
6 vidéos (Total 49 min), 1 quiz
6 vidéos
Analytical Processes and Planning10 min
Data Mining and Predictive Modeling - Part 16 min
Data Mining and Predictive Modeling - Part 26 min
Extracting Data for Analysis10 min
Transforming Data for Analytical Structures11 min
1 exercice pour s'entraîner
Module 3 Quiz30 min
Semaine
45 heures pour terminer
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.
7 vidéos (Total 49 min), 1 lecture, 2 quiz
7 vidéos
Solving Analytical Problems with Risk Stratification8 min
Risk Stratification: Variables, Groupers, Predictors8 min
Risk Stratification: Model Creation/Evaluation and Deployment of Strata9 min
Medicare Claims Data - Source and Documentation8 min
Final Tips to Help Understand and Interpret Healthcare Data8 min
Course Summary2 min
1 lecture
Welcome to Peer Review Assignments!10 min
1 exercice pour s'entraîner
Module 4 Quiz30 min
Enseignant
Brian Paciotti
Healthcare Data ScientistResearch IT
À propos de Université de Californie à 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.
À propos de la Spécialisation Health Information Literacy for Data Analytics
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.
Foire Aux Questions
Quand aurai-je accès aux vidéos de cours et aux devoirs ?
Une fois que vous êtes inscrit(e) pour un Certificat, vous pouvez accéder à toutes les vidéos de cours, et à tous les quiz et exercices de programmation (le cas échéant). Vous pouvez soumettre des devoirs à examiner par vos pairs et en examiner vous-même uniquement après le début de votre session. Si vous préférez explorer le cours sans l'acheter, vous ne serez peut-être pas en mesure d'accéder à certains devoirs.
À quoi ai-je droit si je m'abonne à cette Spécialisation ?
Lorsque vous vous inscrivez au cours, vous bénéficiez d'un accès à tous les cours de la Spécialisation, et vous obtenez un Certificat lorsque vous avez réussi. Votre Certificat électronique est alors ajouté à votre page Accomplissements. À partir de cette page, vous pouvez imprimer votre Certificat ou l'ajouter à votre profil LinkedIn. Si vous souhaitez seulement lire et visualiser le contenu du cours, vous pouvez accéder gratuitement au cours en tant qu'auditeur libre.
Quelle est la politique de remboursement ?
Une aide financière est-elle possible ?
D'autres questions ? Visitez le Centre d'Aide pour les Etudiants.
Coursera propose un accès universel à la meilleure formation au monde,
en partenariat avec des universités et des organisations du plus haut niveau, pour proposer des cours en ligne.
© 2019 Coursera Inc. Tous droits réservés.
