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.
Analyze Data to Answer Questions
This course is part of Google Data Analytics Professional Certificate
Instructor: Google Career Certificates
Top Instructor
Sponsored by The University of Akron
633,739 already enrolled
(11,337 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
Details to know
Add to your LinkedIn profile
30 quizzes
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
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review
There are 4 modules in this course
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 quizzes1 plugin
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 quizzes1 plugin
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 quizzes1 plugin
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 quizzes1 plugin
Instructor
Offered by
Why people choose Coursera for their career
Learner reviews
11,337 reviews
- 5 stars
74.33%
- 4 stars
16.59%
- 3 stars
5.24%
- 2 stars
2.14%
- 1 star
1.67%
Showing 3 of 11337
Reviewed on Jan 6, 2022
An excellent course for learning analysis techniques using Spreadsheets and SQL. Recommended for all engineering and data science students as well as for those managing businesses and human resource.
Reviewed on Apr 12, 2021
This course is very great for gaining hands-on experience with SQL, as well as instilling the critical thinking skills essential to the data analysis process. Definitely worth the pricetag.
Reviewed on Oct 11, 2021
Quiero resaltar los grandes cambios que ha tenido esta plataforma en pro de fortalecer por medio de la práctica de labs y diferentes ayudas audiovisuales los diferentes conceptos y temarios.
Open new doors with Coursera Plus
Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription
Advance your career with an online degree
Earn a degree from world-class universities - 100% online
Join over 3,400 global companies that choose Coursera for Business
Upskill your employees to excel in the digital economy