Analyze Data to Answer Questions
Here in Analyze Data to Answer Questions, you’ll learn how to use formulas, functions, and SQL queries as you conduct your analysis. Current Google data analysts will continue to instruct and provide you with hands-on ways to accomplish common data analyst tasks with the best tools and resources.
About this Course
This is the fifth course Analyze Data to Answer Questions in the Google Data Analytics Certificate. These courses will equip you with the skills needed to apply to introductory-level data analyst jobs. In this course, you’ll explore the “analyze” phase of the data analysis process. You’ll take what you’ve learned to this point and apply it to your analysis to make sense of the data you’ve collected.
You’ll learn how to organize and format your data using spreadsheets and SQL to help you look at and think about your data in different ways. You’ll also find out how to perform complex calculations on your data to complete business objectives.
Learners who complete this certificate program will be equipped to apply for introductory-level jobs as data analysts. No previous experience is necessary.
By the end of this course, you will:
- Learn how to organize data for analysis in Analyze Data to Answer Questions
- Discover the processes for formatting and adjusting data.
- Gain an understanding of how to aggregate data in spreadsheets and by using SQL.
- Use formulas and functions in spreadsheets for data calculations.
- Learn how to complete calculations using SQL queries.
What You Will Learn
- Discuss the importance of organizing your data before analysis with references to sorts and filters
- Demonstrate an understanding of what is involved in the conversion and formatting of data
- Apply the use of functions and syntax to create SQL queries for combining data from multiple database tables
- Describe the use of functions to conduct basic calculations on data in spreadsheets
Skills You Will Gain
- Spreadsheet
- Data Analysis in Analyze Data to Answer Questions
- SQL
- Data Calculations
- Data Aggregation
Syllabus
WEEK 1
5 hours to complete
Analyze Data to Answer Questions: Organizing data to begin analysis
Organizing data makes the data easier to use in your analysis. In this part of the course, you’ll learn the importance of organizing your data through sorting and filtering. You’ll explore these processes in both spreadsheets and SQL as you continue to prepare your data for analysis.
9 videos (Total 38 min), 7 readings, 7 quizzes
WEEK 2
5 hours to complete
Analyze Data to Answer Questions: Formatting and adjusting data
As you move closer to analyzing your data, you’ll want to have the data formatted and ready to go. In this part of the course, you’ll learn all about converting and formatting data, including how SQL queries can help you combine data. You’ll also find out the value of feedback and support from your colleagues and how it can lead to new learning that you can apply to your work.
10 videos (Total 39 min), 7 readings, 5 quizzes
WEEK 3
5 hours to complete
Analyze Data to Answer Questions: Aggregating data for analysis
As part of your analysis, you’ll often have to combine data in order to gain insights and complete business objectives. In this part of the course, you’ll explore the functions, procedures, and syntax involved in combining, or aggregating, data. You’ll learn how to do this from multiple cells in spreadsheets and from multiple database tables using SQL queries.
9 videos (Total 46 min), 7 readings, 6 quizzes
WEEK 4
11 hours to complete
Analyze Data to Answer Questions: Performing data calculations
Calculations are one of the more common tasks that data analysts complete during analysis. In this part of the course, you’ll explore formulas, functions, and pivot tables in spreadsheets and queries in SQL, all of which will help with your calculations. You’ll also learn about the benefits of using SQL to manage temporary tables.
13 videos (Total 72 min), 10 readings, 12 quizzes
