FacePro

About this course

The course "Process Data from Dirty to Clean" is part of the Google Data Analytics Professional Certificate, designed for beginners and can be completed in approximately 21 hours with flexible scheduling.

Course Content Includes Four Key Modules:

Data Integrity and Types
- Define different types of data integrity and identify risks to data integrity.
- Understand the importance of data integrity in analysis.
Data Cleaning Techniques
- Apply basic SQL functions to clean string variables in a database.
- Learn methods to handle missing data and outliers.
Data Transformation and Standardization
- Transform and standardize data to meet analysis requirements.
- Utilize tools and functions to automate data cleaning processes.
Practical Application and Case Studies
- Engage in hands-on projects to apply data cleaning and transformation techniques.
- Analyze real-world datasets to reinforce learning outcomes.

Skills You Will Gain After the Course:

Data Cleaning and Transformation
SQL Proficiency
Data Integrity Assessment
Problem-Solving in Data Analysis

Completing the course provides you with a professional certificate from Google, which can be added to your LinkedIn profile or resume.

Syllabus

[{"itemType":"task","number":"1-1","title":"Introduction to data exploration","result":"","resultStatus":"","lock":false,"status":"unpublished","taskId":"635","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"03:38","activityEndTime":"","fileStorage":"local","isTaskTryLookable":0},{"itemType":"task","number":"1-2","title":"Data Types And Structures","result":"","resultStatus":"","lock":false,"status":"unpublished","taskId":"630","isOptional":"0","type":"text","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"","activityEndTime":"","fileStorage":"","isTaskTryLookable":0},{"itemType":"task","number":"2-1","title":"Bias, Credibility, Privacy, & Ethics","result":"","resultStatus":"","lock":false,"status":"unpublished","taskId":"636","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"01:20","activityEndTime":"","fileStorage":"local","isTaskTryLookable":0},{"itemType":"task","number":"2-2","title":"Data Responsibility","result":"","resultStatus":"","lock":false,"status":"unpublished","taskId":"631","isOptional":"0","type":"text","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"","activityEndTime":"","fileStorage":"","isTaskTryLookable":0},{"itemType":"task","number":"3-1","title":"All about databases","result":"","resultStatus":"","lock":false,"status":"unpublished","taskId":"637","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"02:24","activityEndTime":"","fileStorage":"local","isTaskTryLookable":0},{"itemType":"task","number":"3-2","title":"Database Essentials","result":"","resultStatus":"","lock":false,"status":"unpublished","taskId":"632","isOptional":"0","type":"text","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"","activityEndTime":"","fileStorage":"","isTaskTryLookable":0},{"itemType":"task","number":"4-1","title":"Feel confident in your data","result":"","resultStatus":"","lock":false,"status":"unpublished","taskId":"638","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"00:53","activityEndTime":"","fileStorage":"local","isTaskTryLookable":0},{"itemType":"task","number":"4-2","title":"Organize And Project Data","result":"","resultStatus":"","lock":false,"status":"unpublished","taskId":"633","isOptional":"0","type":"text","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"","activityEndTime":"","fileStorage":"","isTaskTryLookable":0},{"itemType":"task","number":"5-1","title":"Manage your presence as a data analyst","result":"","resultStatus":"","lock":false,"status":"unpublished","taskId":"639","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"01:03","activityEndTime":"","fileStorage":"local","isTaskTryLookable":0},{"itemType":"task","number":"5-2","title":"Engage In The Data Community","result":"","resultStatus":"","lock":false,"status":"unpublished","taskId":"634","isOptional":"0","type":"text","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"","activityEndTime":"","fileStorage":"","isTaskTryLookable":0}]

Teacher

Course features

Video(5)

Text(5)

Latest updates

No updates found