This course, the fifth in the Google Data Analytics Certificate, focuses on equipping learners with essential skills for introductory-level data analyst roles. Through a series of comprehensive modules, students will explore the "analyze" phase of the data analysis process and gain proficiency in organizing, formatting, and aggregating data as well as performing data calculations.
Upon completion of this course, learners will be well-prepared to apply for introductory-level jobs as data analysts, even with no previous experience. The course's hands-on approach, coupled with guidance from current Google data analysts, ensures that students are equipped with practical skills and best tools and resources for common data analyst tasks.
Certificate Available ✔
Get Started / More Info
This course consists of comprehensive modules that cover organizing data, formatting and adjusting data, aggregating data for analysis, and performing data calculations. Students will learn essential skills for analyzing and making sense of data using spreadsheets and SQL.
This module focuses on organizing data to begin analysis. Students will gain an understanding of the importance of organizing data before analysis and learn about sorts, filters, and sorting in spreadsheets and SQL. They will also have hands-on activities to apply their knowledge and test their understanding through module challenges.
The formatting and adjusting data module guides students through the process of formatting and adjusting data, including converting data in spreadsheets, transforming data in SQL, and combining multiple pieces of data. They will also learn about conditional formatting, manipulating strings, and advanced spreadsheet tips and tricks.
In this module, students will learn about aggregating data for analysis, including preparing for VLOOKUP, using JOINs effectively, and understanding COUNT and COUNT DISTINCT. They will also gain proficiency in using VLOOKUP, queries for JOINS, and subqueries to aggregate data. Hands-on activities and module challenges will reinforce their learning.
The performing data calculations module covers common calculation formulas, functions and conditions, working with pivot tables, and embedding simple calculations in SQL. Students will also explore elements of a pivot table, data validation, and working with temporary tables. Hands-on activities and tests will solidify their understanding.
This specialization equips learners with the skills to proficiently use Tableau software for professional data visualization, organizing and combining data, creating...
Design Thinking and Predictive Analytics for Data Products is a comprehensive course that delves into the fundamental concepts of statistical learning and predictive...
Mastering Software Development in R Capstone is a comprehensive course that focuses on building advanced skills in R programming through a hands-on capstone project....
Troubleshooting and Solving Data Join Pitfalls is a self-paced lab in the Google Cloud console. Learn to use BigQuery to explore datasets, troubleshoot duplicate...