Course of Information from Soiled to Clear

About this Course

That is the fourth course within the Google Information Analytics Certificates. These programs will equip you with the talents wanted to use to introductory-level knowledge analyst jobs. On this course, you’ll proceed to construct your understanding of information analytics and the ideas and instruments that knowledge analysts use of their work. You’ll discover ways to verify and clear your knowledge utilizing spreadsheets and SQL in addition to the way to confirm and report your knowledge cleansing outcomes. Present Google knowledge analysts will proceed to instruct and offer you hands-on methods to perform frequent knowledge analyst duties with the most effective instruments and assets.

Learners who full this certificates program might be geared up to use for introductory-level jobs as knowledge analysts. No earlier expertise is important. By the top of this course, it is possible for you to to do the next: – Learn to verify for knowledge integrity. – Uncover knowledge cleansing methods utilizing spreadsheets. – Develop primary SQL queries to be used on databases. – Apply primary SQL capabilities for cleansing and reworking knowledge. – Acquire an understanding of the way to confirm the outcomes of cleansing knowledge. – Discover the weather and significance of information cleansing stories.

WHAT YOU WILL LEARN

• Outline knowledge integrity just about sorts of integrity and danger to knowledge integrity

• Apply primary SQL capabilities to be used in cleansing string variables in a database

• Develop primary SQL queries to be used on databases

• Describe the method concerned in verifying the outcomes of cleansing knowledge

SKILLS YOU WILL GAIN

• Spreadsheet
• Information Cleaning
• Pattern Measurement Willpower
• SQL
• Information Integrity

Syllabus – What you’ll be taught from this course

Content material Score98%(149,258 rankings)

WEEK

1

5 hours to finish

The significance of integrity

As you begin fascinated about the way to put together your knowledge for exploration, this a part of the course will spotlight why knowledge integrity is so important to profitable decision-making. You’ll study how knowledge is generated and the methods analysts use to resolve what knowledge to gather for evaluation. And also you’ll uncover structured and unstructured knowledge, knowledge varieties, and knowledge codecs.

WEEK

2

6 hours to finish

Glowing-clean knowledge

Each knowledge analyst needs clear knowledge to work with when performing an evaluation. On this a part of the course, you’ll be taught the distinction between clear and soiled knowledge. You’ll additionally discover knowledge cleansing methods utilizing spreadsheets and different instruments.

WEEK

3

6 hours to finish

Cleansing knowledge with SQL

Understanding quite a lot of methods to wash knowledge could make an analyst’s job a lot simpler. On this a part of the course, you’ll try the way to clear your knowledge utilizing SQL. You’ll discover queries and capabilities that you should utilize in SQL to wash and remodel your knowledge to get it prepared for evaluation.

WEEK

4

2 hours to finish

Confirm and report in your cleansing outcomes

Cleansing your knowledge is a necessary step within the knowledge evaluation course of. Verifying and reporting your cleansing is a strategy to present that your knowledge is prepared for the subsequent step. On this a part of the course, you’ll discover out the processes concerned with verifying and reporting knowledge cleansing in addition to their advantages.