About this Course
That is the fifth course within the Google Knowledge Analytics Certificates. These programs will equip you with the talents wanted to use to introductory-level knowledge analyst jobs. On this course, you’ll discover the “analyze” section of the info evaluation course of. You’ll take what you’ve realized thus far and apply it to your evaluation to make sense of the info you’ve collected. You’ll learn to manage and format your knowledge utilizing spreadsheets and SQL that can assist you take a look at and take into consideration your knowledge in numerous methods. You’ll additionally learn how to carry out advanced calculations in your knowledge to finish enterprise aims. You’ll learn to use formulation, features, and SQL queries as you conduct your evaluation. Present Google knowledge analysts will proceed to instruct and offer you hands-on methods to perform widespread knowledge analyst duties with one of the best instruments and assets.
WHAT YOU WILL LEARN
Focus on the significance of organizing your knowledge earlier than evaluation with references to types and filters
Show an understanding of what’s concerned within the conversion and formatting of knowledge
Apply the usage of features and syntax to create SQL queries for combining knowledge from a number of database tables
Describe the usage of features to conduct fundamental calculations on knowledge in spreadsheets
SKILLS YOU WILL GAIN
- Spreadsheet
- Knowledge Evaluation
- SQL
- Knowledge Calculations
- Knowledge Aggregation
Syllabus – What you’ll study from this course
5 hours to finish
Organizing knowledge to start evaluation
Organizing knowledge makes the info simpler to make use of in your evaluation. On this a part of the course, you’ll study the significance of organizing your knowledge by way of sorting and filtering. You’ll discover these processes in each spreadsheets and SQL as you proceed to organize your knowledge for evaluation.
5 hours to finish
Formatting and adjusting knowledge
As you progress nearer to analyzing your knowledge, you’ll wish to have the info formatted and able to go. On this a part of the course, you’ll study all about changing and formatting knowledge, together with how SQL queries might help you mix knowledge. You’ll additionally discover out the worth of suggestions and help out of your colleagues and the way it can result in new studying which you can apply to your work.
5 hours to finish
Aggregating knowledge for evaluation
As a part of your evaluation, you’ll typically have to mix knowledge with the intention to achieve insights and full enterprise aims. On this a part of the course, you’ll discover the features, procedures, and syntax concerned in combining, or aggregating, knowledge. You’ll learn to do that from a number of cells in spreadsheets and from a number of database tables utilizing SQL queries.
11 hours to finish
Performing knowledge calculations
Calculations are one of many extra widespread duties that knowledge analysts full throughout evaluation. On this a part of the course, you’ll discover formulation, features, and pivot tables in spreadsheets and queries in SQL, all of which is able to assist together with your calculations. You’ll additionally find out about the advantages of utilizing SQL to handle short-term tables.
0 Comments