Analyze Data to Answer Questions

Instructor: Google Career Certificates

Beginner Level • 1 week at 10 hours a week • Flexible Schedule

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

User Feedback
Spreadsheet Software
Excel Formulas
Data Integration
Data Validation
Data analysis
Analytics
Pivot Tables And Charts
Data Manipulation
Data Compilation
SQL
Data Transformation

Shareable Certificate

Earn a shareable certificate to add to your LinkedIn profile

Outcomes

  • 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

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.

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.

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.

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.