Analyze Data to Answer Questions
Keep adding new skills with 10,000+ programs for $239 (usually $399). Save now.
Analyze Data to Answer Questions
This course is part of Google Data Analytics Professional Certificate
823,868 already enrolled
Included with
Ask Coursera
12,246 reviews
Recommended experience
12,246 reviews
Recommended experience
What you'll learn
Discuss the importance of organizing your data before analysis by using sorts and filters.
Convert and format data.
Apply the use of functions and syntax to create SQL queries to combine data from multiple database tables.
Describe the use of functions to conduct basic calculations on data in spreadsheets.
Skills you'll gain
Tools you'll learn
Details to know
See how employees at top companies are mastering in-demand skills
Build your Data Analysis expertise
- Learn new concepts from industry experts
- Gain a foundational understanding of a subject or tool
- Develop job-relevant skills with hands-on projects
- Earn a shareable career certificate from Google
There are 4 modules in this course
This is the fifth course in the Google Data Analytics Certificate. In this course, you’ll explore what it means to actually analyze your data. You’ll take what you’ve learned up to this point and apply it 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 with your data to address business objectives. 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.
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, learners will: - Learn how to organize data for analysis. - Understand the processes for formatting and adjusting data. - Explore how to aggregate data in spreadsheets and by using SQL. - Use formulas and functions in spreadsheets to make data calculations. - Learn how to complete calculations using SQL queries.
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.
What's included
9 videos13 readings6 assignments
9 videos•Total 37 minutes
- Introduction to getting organized•3 minutes
- The analysis process•5 minutes
- Ayanna: Sticking with it•2 minutes
- Always a need to organize •3 minutes
- Filter data with SQL•5 minutes
- Sort data in spreadsheets•5 minutes
- Use the SORT function in spreadsheets•5 minutes
- Emma: Journey to a meaningful career•2 minutes
- Sort data with SQL•8 minutes
13 readings•Total 70 minutes
- Course 5 overview•8 minutes
- Helpful resources and tips•4 minutes
- Sort and filter data to keep it organized•8 minutes
- Review: Set up your BigQuery account•8 minutes
- Review: Get started with BigQuery•4 minutes
- Working with .csv files•4 minutes
- Upload the movie dataset to BigQuery•4 minutes
- Step-by-Step: Filter data with SQL•4 minutes
- Step-by-step: Sort datasets in spreadsheets•4 minutes
- Step-by-step: Use the SORT function in spreadsheets•4 minutes
- Sort and filter in Sheets and Excel•8 minutes
- Step-by-Step: Sort data with SQL•8 minutes
- Glossary terms from module 1•2 minutes
6 assignments•Total 184 minutes
- Module 1 challenge•40 minutes
- Test your knowledge on organizing data for analysis•8 minutes
- Test your knowledge on sorting data in spreadsheets •8 minutes
- Hands-On Activity: SQL sorting queries•60 minutes
- Hands-On Activity: Analyze weather data in BigQuery•60 minutes
- Test your knowledge on sorting data with SQL •8 minutes
As you move closer to analyzing your data, you’ll want to have it 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 learnings that you can apply to your work.
What's included
10 videos9 readings5 assignments1 plugin
10 videos•Total 38 minutes
- Get started with data formatting •1 minute
- From one type to another •5 minutes
- Data validation•4 minutes
- Conditional formatting •5 minutes
- Merge text strings to gain insights•5 minutes
- Strings in spreadsheets •3 minutes
- When you get stuck•3 minutes
- Layla: All about the analyze stage•3 minutes
- Running into challenges? Not to worry!•6 minutes
- When to use which tool•2 minutes
9 readings•Total 58 minutes
- Step-by-Step: From one type to another•8 minutes
- Convert data in spreadsheets •8 minutes
- Transform data with SQL•4 minutes
- Import and combine data in spreadsheets and databases•8 minutes
- Step-by-Step: Merge text strings to gain insights•8 minutes
- Step-by-Step: Strings in spreadsheets •8 minutes
- Manipulate strings with SQL•4 minutes
- Advanced spreadsheet tips and tricks•8 minutes
- Glossary terms from module 2•2 minutes
5 assignments•Total 136 minutes
- Module 2 challenge•40 minutes
- Test your knowledge on converting and formatting data•8 minutes
- Hands-On Activity: Combine multiple pieces of data•60 minutes
- Test your knowledge on combining multiple datasets •8 minutes
- Self-Reflection: Stack Overflow •20 minutes
1 plugin•Total 10 minutes
- SQL query syntax•10 minutes
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.
What's included
8 videos10 readings9 assignments1 plugin
8 videos•Total 41 minutes
- Aggregate data for analysis •3 minutes
- Prepare for VLOOKUP•5 minutes
- VLOOKUP in action•3 minutes
- Identify and fix common VLOOKUP errors •6 minutes
- Explore how JOINs work •8 minutes
- Queries within queries•7 minutes
- Use subqueries to aggregate data •7 minutes
- Justin: Where data analysis takes you •2 minutes
10 readings•Total 74 minutes
- VLOOKUP Core Concepts •8 minutes
- Upload the employee dataset to BigQuery•8 minutes
- Step-by-Step: Explore how JOINs work•8 minutes
- Secret identities: The importance of aliases•8 minutes
- Use JOINs effectively •8 minutes
- Upload the warehouse dataset to BigQuery•8 minutes
- Step-by-Step: Queries within queries•8 minutes
- Step-by-Step: Use subqueries to aggregate data•8 minutes
- SQL functions and subqueries: A functional friendship•8 minutes
- Glossary terms from module 3•2 minutes
9 assignments•Total 364 minutes
- Module 3 challenge•40 minutes
- Hands-On Activity: Use VLOOKUP to perform a task•60 minutes
- Test your knowledge on VLOOKUP•8 minutes
- Hands-On Activity: Queries for JOINS•60 minutes
- Hands-On Activity: COUNT and COUNT DISTINCT•60 minutes
- Test your knowledge on using JOINS to aggregate data •8 minutes
- Hands-On Activity: Use subqueries to refine data•60 minutes
- Hands-on activity: Use subqueries•60 minutes
- Test your knowledge on working with subqueries •8 minutes
1 plugin•Total 10 minutes
- Review subqueries•10 minutes
Calculations are a common task for data analysts. 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.
What's included
13 videos13 readings10 assignments1 plugin
13 videos•Total 70 minutes
- Data calculations •2 minutes
- Common calculation formulas •10 minutes
- Functions and conditions•9 minutes
- Composite functions •6 minutes
- Start working with pivot tables •7 minutes
- Pivot tables continued•5 minutes
- Queries and calculations•4 minutes
- Embed simple calculations with SQL•7 minutes
- Calculations with other statements •4 minutes
- Check and recheck•5 minutes
- Temporary tables•6 minutes
- Multiple table variations•4 minutes
- Congratulations! Course wrap-up•1 minute
13 readings•Total 80 minutes
- Functions with multiple conditions•8 minutes
- Elements of a pivot table•4 minutes
- Use pivot tables in analysis •8 minutes
- Upload the avocado dataset to BigQuery•8 minutes
- Step-by-Step: Embed simple calculations with SQL•8 minutes
- Types of data validation•4 minutes
- Work with temporary tables •8 minutes
- Your intermediate guide to SQL •8 minutes
- Use Connected Sheets with BigQuery•8 minutes
- Glossary terms from module 4•4 minutes
- Reflect and connect with peers•4 minutes
- Course 5 glossary•4 minutes
- Coming up next...•4 minutes
10 assignments•Total 372 minutes
- Module 4 challenge •40 minutes
- Hands-On Activity: Work with conditions•60 minutes
- Test your knowledge on data calculations •8 minutes
- Hands-On Activity: Explore movie data with pivot tables•60 minutes
- Test your knowledge on pivot tables •8 minutes
- Hands-On Activity: Calculations with SQL •60 minutes
- Test your knowledge on SQL calculations •8 minutes
- Hands-On Activity: From spreadsheets to BigQuery•60 minutes
- Hands-On Activity: Create temporary tables •60 minutes
- Test your knowledge on using SQL with temporary tables •8 minutes
1 plugin•Total 10 minutes
- Start validating•10 minutes
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.
Instructor
Explore more from Data Analysis
Course
Course
Course
Course
Why people choose Coursera for their career
Learner reviews
- 5 stars
74.58%
- 4 stars
16.40%
- 3 stars
5.21%
- 2 stars
2.14%
- 1 star
1.64%
Showing 3 of 12246
Reviewed on Jul 24, 2022
I have really made a very important practice in this data analysis phase, and I believe that this practice coupled with my previous analysis skills would help me to get a new job.
Reviewed on Jun 25, 2024
I found this course the hardest within the Google Data Analytics certification. It was challenging, there was a lot of new information, I had to reflect and try new things a lot! Way to go!
Reviewed on May 29, 2023
alot harder than the other courses but it was still goodsome of the data sets you have to work with is outdated or isnt there on Big query other tha that all was good i learnt alot and enjoyed myself
Frequently asked questions
Data is a group of facts that can take many different forms, such as numbers, pictures, words, videos, observations, and more. We use and create data everyday, like when we stream a show or song or post on social media.
Data analytics is the collection, transformation, and organization of these facts to draw conclusions, make predictions, and drive informed decision-making.
The amount of data created each day is tremendous. Any time you use your phone, look up something online, stream music, shop with a credit card, post on social media, or use GPS to map a route, you’re creating data. Companies must continually adjust their products, services, tools, and business strategies to meet consumer demand and react to emerging trends. Because of this, data analyst roles are in demand and competitively paid.
Data analysts make sense of data and numbers to help organizations make better business decisions. They prepare, process, analyze, and visualize data, discovering patterns and trends and answering key questions along the way. Their work empowers their wider team to make better business decisions.
You will learn the skill set required for becoming a junior or associate data analyst in the Google Data Analytics Certificate. Data analysts know how to ask the right question; prepare, process, and analyze data for key insights; effectively share their findings with stakeholders; and provide data-driven recommendations for thoughtful action.
You’ll learn these job-ready skills in our certificate program through interactive content (discussion prompts, quizzes, and activities) in under six months, with under 10 hours of flexible study a week. Along the way, you'll work through a curriculum designed with input from top employers and industry leaders, like Tableau, Accenture, and Deloitte. You’ll even have the opportunity to complete a case study that you can share with potential employers to showcase your new skill set.
After you’ve graduated from the program, you’ll have access to career resources and be connected directly with employers hiring for open entry-level roles in data analytics.
More questions
Financial aid available,