К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Transform, Analyze, & Healthcare Data · LearnSpace
Назад в каталог
courseraЗдоровье

Transform, Analyze, & Healthcare Data

Курс от Coursera
Начальный≈ 2.8 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

Healthcare professionals are drowning in data, but few know how to transform it into life-saving insights. This Short Course was created to help data analysts accomplish the critical task of preparing clean, reliable healthcare datasets that drive informed clinical decisions. By completing this course, you'll be able to standardize date formats across patient admission records, eliminate dangerous duplicate entries that could compromise care quality, and seamlessly merge clinical codes with reference tables to create comprehensive patient profiles that healthcare teams can trust. By the end of this course, you will be able to: • Apply text functions to reformat date values into a standard format • Analyze datasets to identify and remove duplicate records • Apply lookup functions to retrieve data from a reference table This course is unique because it focuses specifically on Excel-based healthcare data scenarios that mirror real clinical environments, using authentic medical datasets and industry-standard formatting challenges that you'll encounter in practice. To be successful in this project, you should have a background in basic Excel operations and familiarity with healthcare data concepts.

Навыки, которые вы освоите

Data TransformationData AnalysisAnalytical SkillsData QualityData IntegrityHealth Information ManagementData CleansingSpreadsheet SoftwareClinical Data ManagementMicrosoft ExcelMedical RecordsExcel FormulasData WranglingData MappingHospital AdmissionsData IntegrationData ManipulationPatient Safety

Программа курса

3 модулей · 19 учебных материалов

01Module 1: Apply Text Functions for Date Formatting7 материалов
Why Date Standardization Saves Lives in HealthcareВидеоExcel Text Functions for Healthcare Date StandardizationЧтение Essential Text Functions: TEXT, VALUE, and SUBSTITUTEВидео Standardizing Patient Admission Dates Step-by-StepВидео

Учитесь у экспертов

Professionals in the Industry

Преподаватель курса

Transform, Analyze, & Healthcare Data
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 2.8 ч

3 модулей

Язык: Английский

Субтитры: Арабский, Французский, Итальянский, Бразильский португальский, Корейский, Немецкий, Пушту, Испанский, Дари, Японский

Часть программы вашего университета
Applying Text Functions to Complex Healthcare Date ScenariosDIALOGUE
Healthcare Date Standardization ChallengeЗадание
Text Functions for Date Formatting AssessmentЗадание
02Module 2: Analyze Datasets for Duplicate Removal6 материалов
Why Duplicate Records Create Patient Safety EmergenciesDIALOGUEExcel Duplicate Analysis Techniques for Healthcare DataЧтение COUNTIF Functions and Conditional Formatting for Duplicate DetectionВидео Step-by-Step Duplicate Detection in Patient RecordsВидеоHealthcare Patient Data: Duplicate Record Detection & Quality AssuranceЛабораторная Duplicate Record Analysis and Removal Knowledge CheckЗадание
03Module 3: Apply Lookup Functions for Data Retrieval6 материалов
When Missing Reference Data Delayed Critical CareВидеоHealthcare Data Integration with Excel Lookup FunctionsЧтениеIntegrating Patient Records with Medication Reference DataЧтение Clinical Reference Integration ProjectЗадание Excel Lookup Functions for Data Retrieval Knowledge CheckЗаданиеHealthcare Data Analytics Final Assessment Задание