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

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

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

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

Data Acquisition and Preparation

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

О курсе

Learn how to acquire, clean, and prepare datasets for analysis through this comprehensive course in the Data Analytics Skill Path. You will develop critical competencies including connecting to prepared datasets and relational databases, importing and exporting data between common flat file formats, handling missing or duplicate values, identifying and correcting data quality issues, performing data type conversions, summarizing dataset characteristics, and designing validation rules to ensure accuracy and consistency. Through hands-on practice with Power BI, Python, and MS SQL Server, you will transform raw data into clean, analysis-ready datasets. This course combines expertise from Edureka, Google, and the University of California San Diego, providing multiple perspectives on data acquisition and preparation. You will progress from establishing data connections to cleaning and transforming data, validating results, and reading and manipulating datasets in Python. The curriculum balances theoretical understanding with practical exercises, preparing you to confidently manage and prepare data for real-world analytics projects. Perfect for aspiring data analysts and learners seeking strong skills in data acquisition, cleaning, and preparation using both programmatic and business intelligence tools.

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

Data ValidationPower BIData IntegrationBusiness IntelligenceData CleansingData CollectionData ProcessingData ManipulationData QualityData TransformationMicrosoft SQL ServersExploratory Data AnalysisData EthicsVerification And ValidationData ModelingData PreprocessingData Import/Export

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

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

01Personalize your learning path1 материалов

Lesson

Personalize your learning pathЗадание
02Data Connectivity With Power BI26 материалов

Introduction to Power BI

Course IntroductionЧтениеRequirements for Installing Power BI DesktopЧтение

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

Professionals from the Industry

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

Data Acquisition and Preparation
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 16.3 ч

8 модулей

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

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

Часть программы вашего университета
Power BI LicensesЧтение
Building Block of Power BIЧтение
Basics of Power BIЧтение
Power BI TutorialЧтение
Installation of Power BI Desktop and ServiceВидео
Practice Quiz: Introduction to Power BIЗадание

Data Connection with Power BI

Problem Statement: Resources & Required FilesЧтениеProblem StatementЧтениеProblem DescriptionВидеоInserting DataВидеоApplying Data RecordsВидеоAdjusting the dataВидеоPerforming Basic OperationsВидеоConnecting with Power BIВидеоVisualizing the DataВидеоCreating Reports ВидеоFormatting DashboardsВидеоDate and Time FeaturesЧтениеOverview of Power BI ServiceЧтениеPractice Quiz: Connecting with Power BIЗадание

M functions - DirectQuery Connection

GatewayВидеоInstalling GatewayВидеоM - Functions ВидеоDeep Dive in M - FunctionsВидео
03Skill Assessment 13 материалов

Lesson

Practice for Data ProfilingЗаданиеLearner Expectations for AssessmentЧтениеCheckpoint 1 of 3: Data ProfilingЗадание
04Clean Your Data27 материалов

The challenge of missing or duplicate data

Clean your Data: Resources & Required FilesЧтениеWelcome to Clean your Data ModuleВидеоMethods for handling missing data ВидеоData deduplication with PythonЧтениеAnnotated follow-along guide: Work with missing data in a Python notebookЛабораторнаяWork with missing data in a Python notebookВидеоRemy: A day in the life of a data professionalВидеоActivity: Address missing dataЛабораторнаяExemplar: Address missing dataЛабораторнаяTest your knowledge: The challenge of missing or duplicate dataЗадание

The ins and outs of data outliers

Account for outliersВидеоProtect the people behind the dataЧтениеIdentify and deal with outliers in PythonВидеоReference guide: How to handle outliersЧтениеTest your knowledge: The ins and outs of data outliersЗадание

Change categorical data to numerical data

Sort numbers versus namesВидеоLabel encoding in PythonВидеоOther approaches to data transformationЧтениеReference guide: Data cleaning in Python ЧтениеTest your knowledge: Changing categorical data to numerical dataЗадание

Input validation

The value of input validationВидео Input validation with PythonВидеоIdentify: Python functions for cleaning dataPLUGINActivity: Validate and clean your dataЛабораторная Exemplar: Validate and clean your dataЛабораторнаяTest your knowledge: Input validationЗадание

Review: Clean your data

Glossary termsЧтение
05Skill Assessment 23 материалов

Lesson

Practice for Data CleaningЗаданиеLearner Expectations for AssessmentЧтениеCheckpoint 2 of 3: Data CleaningЗадание
06Verify and Report on Cleaning Results16 материалов

Manually cleaning data

Verify and report resultsВидеоConfirm data-cleaning meets business expectationsВидеоStep-by-Step: Verification of data cleaningЧтениеVerification of data cleaningВидеоData-cleaning verification checklistЧтениеTest your knowledge on manual data cleaningЗадание

Document the cleaning process

Capture cleaning changesВидеоEmbrace changelogsЧтениеSelf-Reflection: Creating a changelogЗаданиеWhy documentation is importantВидеоFeedback and cleaningВидеоAdvanced functions for speedy data cleaning: ResourcesЧтение

Module challenge

Glossary terms from the module ЧтениеGlossary and CitationЧтение
07Reading Data in Python8 материалов

CSV and JSON Files

CSV & JSON FilesВидеоReading CSV & JSON FilesВидеоProcessing Structured Data in PythonВидеоLive-Coding: JSONВидеоReview: CSV and JSON FilesЗадание

Simple Statistics

Extracting Simple Statistics From DatasetsВидеоSimple Statistics: Live-CodingВидеоReview: Simple StatisticsЗадание
08Skill Assessment 33 материалов

Lesson

Practice for Data Validation and TransformationЗаданиеLearner Expectations for AssessmentЧтениеCheckpoint 3 of 3: Data Validation and TransformationЗадание
Advanced functions for speedy data cleaningЧтение
Test your knowledge on documenting the cleaning processЗадание