- Introduction to focus on integrity
- Why data integrity is important
- Balancing objectives with data integrity
- Dealing with insufficient data
- The importance of sample size
- Using statistical power
- Determine the best sample size
- Evaluate the reliability of your data
Beginner
Online
6 Weeks
Quick facts
particular | details | |
---|---|---|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
Course overview
The beginner-level Process Data from Dirty to Clean online course will help the students develop the skills required to be a data analyst. It is an online programme and thus does not limit the students with any time restriction. Students across the countries can apply for this course. The programme deals with the topics such as tools used in data analysis, cleaning and checking data using the spreadsheet and SQL.
The Process Data from Dirty to Clean certification course also helps the students gain information regarding data verification. The course is provided in association with Google. The programme is free for all the participants if they learn from it in the audit mode. Since it is a beginner level programme, it does not require any specific academic eligibility, except the basic understanding of mathematics.
The Process Data from Dirty to Clean certification programme can be completed in 23 hours. However, it can be pursued weekly according to the requirements of the student. At the end of the course, after the successful completion of all lessons and assignments, students get a chance to enjoy the benefits of professional certification.
The highlights
- Offered by Coursera
- Shareable professional certification
- 23 hours programme
- 6 weekly modules
- Audit mode is available
- Financial aid provided
- 7-day trial preview
- Beginners course
- Self-paced course
- Online learning
Program offerings
- Practice exercises
- Assignments
- Videos
- Quizzes
- Readings
- Peer feedback
Course and certificate fees
- Students can access the course for free in the audit mode.
- Students will be eligible to get a preview of the course if they decide to go for the trial mode option.
Process Data from Dirty to Clean fees details
Particulars | Fee Amount in INR |
Process Data from Dirty to Clean (audit only) | Free |
Process Data from Dirty to Clean - 1 month | Rs. 1,148 /- |
Process Data from Dirty to Clean - 3 months | Rs. 2,296 /- |
Process Data from Dirty to Clean - 6 months | Rs. 3,444 /- |
certificate availability
certificate providing authority
Eligibility criteria
Education
Candidates are expected to have the high-school level mathematical understanding to pursue this course.
Certification Qualifying Details
Students are required to purchase the certification course by making the payment of the quoted amount.
What you will learn
Upon the completion of the Process Data from Dirty to Clean training, students will be able to comprehend the following points-
- Students will be able to understand the tools and techniques used in the domain of data analysis.
- Candidates will gain an understanding of checking and cleaning the data through spreadsheets and SQL.
- Participants will get to know how to verify the results of the cleaning data in the Process Data from Dirty to Clean certification.
- Students will learn about data integrity along with the different types of integrity in the course.
- Candidates will learn about the basic SQL functions as well as queries.
- Students will understand the importance of data cleaning reports in the Process Data from Dirty to Clean programme.
- Participants will gain an understanding of how to report the verified data.
Who it is for
The Process Data from Dirty to Clean training is apt for the following people-
- Students who want to become a data analyst.
- Students who want to pursue a higher degree in the relevant field.
Admission details
The admission process of the Process Data from Dirty to Clean programme comprises of the following steps:
Step 1- Participants must visit the official webpage of Coursera.
Step 2- Candidates need to create an account on Coursera by clicking on the Join for free tab at the top right corner of the page.
Step 3- After creating the account, students need to enrol into the course by clicking on the enrol option on the page.
Step 4- Students will be asked to provide their credentials to enrol for the course.
Step 5- Students need to click on the Go to course on the redirected page to access the lessons.
The syllabus
Week 1: The importance of integrity
Videos
Readings
- Course syllabus
- More about data integrity and compliance
- Well-aligned objectives and data
- What to do when you find an issue with your data
- Calculating sample size
- What to do when there is no data
- Sample size calculator
- All about the margin of error
- Glossary: Terms and definitions
Practice Exercises
- Weekly challenge 1
- Test your knowledge on data integrity and analytics objectives
- Self-Reflection: Why pre-cleaning activities are important
- Test your knowledge on insufficient data
- Test your knowledge on testing your data
- Test your knowledge on margin of error
Week 2: Sparkling-clean data
Videos
- Clean it up!
- Why data cleaning is important
- Angie: Why I love cleaning data
- Recognize and remedy dirty data
- Data-cleaning tools and techniques
- Cleaning data from multiple sources
- Data-cleaning features in spreadsheets
- Optimize the data-cleaning process
- Different data perspectives
- Even more data-cleaning techniques
Readings
- What is dirty data?
- Common data-cleaning pitfalls
- Workflow automation
- Learning Log: Develop your approach to cleaning data
- Glossary: Terms and definitions
Practice Exercises
- Weekly challenge 2
- Test your knowledge on clean versus dirty data
- Hands-On Activity: Cleaning data with spreadsheets
- Test your knowledge on data-cleaning techniques
- Hands-On Activity: Clean data with spreadsheet functions
- Test your knowledge on cleaning data in spreadsheets
Week 3: Cleaning data with SQL
Videos
- Using SQL to clean data
- Sally: For the love of SQL
- Understanding SQL capabilities
- Spreadsheets versus SQL
- Widely used SQL queries
- Evan: Having fun with SQL
- Cleaning string variables using SQL
- Advanced data cleaning functions, part 1
- Advanced data-cleaning functions, part 2
Readings
- Using SQL as a junior data analyst
- SQL dialects and their uses
- Optional: Upload the customer dataset to BigQuery
- Optional: Upload the store transactions dataset to BigQuery
- Glossary: Terms and definitions
Practice Exercises
- Weekly challenge 3
- Hands-On Activity: Processing time with SQL
- Test your knowledge on SQL
- Hands-On Activity: Clean data using SQL
- Test your knowledge on SQL queries
- Self-Reflection: Challenges with SQL
Week 4: Verify and report on your cleaning results
Videos
- Verifying and reporting results
- Cleaning and your data expectations
- The final step in data cleaning
- Capturing cleaning changes
- Why documentation is important
- Feedback and cleaning
Readings
- Data-cleaning verification: A checklist
- Embrace changelogs
- Advanced functions for speedy data cleaning
- Glossary: Terms and definitions
Practice Exercises
- Weekly challenge 4
- Test your knowledge on manual data cleaning
- Self-Reflection: Creating a changelog
- Test your knowledge on documenting the cleaning process
Week 5: Optional: Adding data to your resume
Videos
- About the data-analyst hiring process
- The data analyst job-application process
- Creating a resume
- Making your resume unique
- Joseph: Black and African American inclusion in the data industry
- Translating past work experience
- Kate: My career path as a data analyst
- Where does your interest lie?
Readings
- CareerCon resources on YouTube
- Adding professional skills to your resume
- Adding soft skills to your resume
Practice Exercises
- Hands-On Activity: Build a resume
- Hands-On Activity: Adding skills to a resume
- Hands-On Activity: Adding experience to a resume
Week 6: Course challenge
Videos
- Get ready for the course challenge
- Congratulations!
Readings
- Glossary: Terms and definitions
- Coming up next ...
Practice Exercise
- Course challenge
Scholarship Details
Candidates who cannot pursue the course due to financial restraints can apply for the scholarship. Candidates who successfully complete the application process will get a positive response within 15 days.
How it helps
Students who apply for the Process Data from Dirty to Clean course will learn the aspects of data analysis. The course covers several topics such as tools to be used in data analysis, data verification, data reporting, etc. This beginner-level course helps the candidate prepare themselves for the job role of the data analyst. Students can apply for an internship or an introductory level job opportunity in the domain of data analysis.
If the students have access to the course subscription, they will get a professional certificate for the programme. The professional certificate has great value in the job market. It helps the candidate increase the weightage of their job profile. The Process Data from Dirty to Clean certification benefits those who want to get practical exposure in the industry by joining an internship or job opportunity.
Students can also use the certification to apply for a higher level of training in data analysis. The professionals from the relevant field can apply for the Process Data from Dirty to Clean certification course to gain some basic skills and brush up their concepts. The students who need a job can share the certification on their LinkedIn profiles and reach the maximum number of recruiters at once.
FAQs
The course can only be found on the Coursera platform.
The contents of the programme will take around 23 hours to get completed.
No, students will only be eligible to access the course modules, which does not include certification and graded assignments and quizzes.
Students do not have to pay any enrolment amount for the course.
No, students do not have to pay for the duration when they take a break from the course.
Students can share the certificate on professional platforms such as LinkedIn.
No, students can take up the course just by enrolment through the official page of the programme.
The Process Data from Dirty to Clean online course is offered by Google.
No, the course is applicable for all the interested students.
Articles
Popular Articles
Latest Articles
Similar Courses
Data for Better Lives A New Social Contract Self P...
The World Bank Group via Edx
Data for Better Lives A New Social Contract
The World Bank Group via Edx
Introduction to Data Analytics
Springboard
Data Analyst Career Guide and Interview Preparatio...
IBM via Coursera
Data Analytics in Sports Law and Team Management
SUNY via Coursera
Data Analytics for Lean Six Sigma
UvA Amsterdam via Coursera
Agile Analytics
UVA Charlottesville via Coursera
Getting Started with Data Analytics on Amazon Web ...
Amazon Web Services via Edx
Data Analytics in Accounting and Finance
The Hong Kong Polytechnic University, Hong Kong via Edx
Data Analytics Basics for Everyone
IBM via Edx
Courses of your interest
C++ Foundation
PW Skills
Data Science Foundations to Core Bootcamp
Springboard
User Experience Design And Research
UM–Ann Arbor via Futurelearn
Data Analysis with Excel for Complete Beginners
CloudSwyft Global Systems, Inc via Futurelearn
Artificial intelligence Design and Engineering wit...
CloudSwyft Global Systems, Inc via Futurelearn
Data Science Fundamentals on Microsoft Azure
CloudSwyft Global Systems, Inc via Futurelearn
Artificial Intelligence Projects
Great Learning
More Courses by Google
Fundamentals Training
Google Artificial Intelligence for JavaScript Deve...
Google via Edx
Coronavirus Powersearching
Google via Edx
Building No Code Apps with App Sheet Foundations
Google via Coursera
Introduction to Cloud Identity
Google via Coursera
CBRS Professional Training
Google via Coursera
Contact Center Artificial Intelligence Conversatio...
Google via Coursera
Understanding Your Google Cloud Costs
Google via Coursera
Developing a Google SRE Culture
Google via Coursera
Deploying SAP on Google Cloud
Google via Coursera