Analyze Data to Answer Questions
4.5 /5- Offered byCoursera
Analyze Data to Answer Questions at Coursera Overview
Duration | 23 hours |
Start from | Start Now |
Total fee | Free |
Mode of learning | Online |
Difficulty level | Beginner |
Official Website | Explore Free Course  |
Credential | Certificate |
Analyze Data to Answer Questions at Coursera Highlights
- Shareable Certificate Earn a Certificate upon completion
- 100% online Start instantly and learn at your own schedule.
- Course 5 of 8 in the Google Data Analytics
- Flexible deadlines Reset deadlines in accordance to your schedule.
- Beginner Level No prior experience with spreadsheets or data analytics is required. All you need is high-school level math and a curiosity about how things work.
- Approx. 23 hours to complete
- English Subtitles: English
Analyze Data to Answer Questions at Coursera Course details
- This is the fifth course 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. 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, you will:
- - Learn how to organize data for analysis.
- - 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.
Analyze Data to Answer Questions at Coursera Curriculum
Organizing data to begin analysis
Welcome to the course
The analysis process
Ayanna: Sticking with it
Always a need to organize
More on sorting and filtering
Sorting datasets
The SORT function
Emma: Journey to a meaningful career
Sorting queries in SQL
Course syllabus
Learning Log: Process and organize your data
Keeping data organized with sorts and filters
Optional: Upload the movie dataset to BigQuery
Sorting and filtering in Sheets and Excel
Optional Refresher: Using BigQuery
Glossary: Terms and definitions
Test your knowledge on understanding data analysis
Test your knowledge on organizing data
Test your knowledge on sorting in spreadsheets
Hands-On Activity: SQL sorting queries
Test your knowledge on sorting in SQL
Weekly challenge 1
Formatting and adjusting data
Getting started with data formatting
From one type to another
Data validation
Conditional formatting
Merging multiple pieces of data from multiple sources
Strings in spreadsheets
What to do when you get stuck
Layla: All about the analyze stage
Running into challenges? Not to worry!
When to use which tool
Converting data in spreadsheets
Transforming data in SQL
Manipulating strings in SQL
Learning Log: Start a data analysis checklist
Advanced spreadsheet tips and tricks
Glossary: Terms and definitions
Test your knowledge on converting and formatting data
Hands-On Activity: Combine multiple pieces of data
Test your knowledge on combining multiple datasets
Self-Reflection: Stack Overflow
Weekly challenge 2
Aggregating data for analysis
Aggregate data for analysis
Preparing for VLOOKUP
Identifying common VLOOKUP errors
Understanding JOINS
COUNT and COUNT DISTINCT
Queries within queries
Using subqueries to aggregate data
Justin: Where data analysis takes you
VLOOKUP core concepts
Optional: Using JOINs effectively
Secret identities: the importance of aliases
SQL functions and subqueries: A functional friendship
Glossary: Terms and definitions
Hands-On Activity: Using VLOOKUP
Test your knowledge on VLOOKUP
Hands-On Activity: Queries for JOINS
Test your knowledge on aggregating data
Test your knowledge on working with subqueries
Weekly challenge 3
Performing data calculations
Data calculations
Common calculation formulas
Functions and conditions
Composite functions
Working with pivot tables
Queries and calculations
Embedding simple calculations in SQL
Calculations with other statements
Check and recheck
Temporary tables
Multiple table variations
Congratulations!
Functions with multiple conditions
Using pivot tables in analysis
Instructions: Upload the avocado dataset to BigQuery
Types of data validation
Working with temporary tables
Your intermediate guide to SQL
Learning Log: Finish your data analysis checklist
Glossary: Terms and definitions
Coming up next...
Hands-On Activity: Working with conditions
Test your knowledge on data calculations
Test your knowledge on using pivot tables
Hands-On Activity: Calculations in SQL
Test your knowledge on SQL calculations
Test your knowledge on data validation
Hands-On Activity: Create temporary tables
Test your knowledge on using SQL with temporary tables
Weekly challenge 4
Course challenge
Analyze Data to Answer Questions at Coursera Admission Process
Important Dates
Other courses offered by Coursera
Student Forum
Anything you would want to ask experts?