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.
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
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.
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.
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.
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.
0 Comments