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.
Offered By
About this Course
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.
Could your company benefit from training employees on in-demand skills?
Try Coursera for BusinessWhat 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
- SQL
- Data Calculations
- Data Aggregation
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.
Could your company benefit from training employees on in-demand skills?
Try Coursera for BusinessOffered by
Syllabus - What you will learn from this course
Organizing data to begin analysis
Formatting and adjusting data
Aggregating data for analysis
Performing data calculations
Reviews
- 5 stars74.33%
- 4 stars17.01%
- 3 stars5.21%
- 2 stars1.99%
- 1 star1.44%
TOP REVIEWS FROM ANALYZE DATA TO ANSWER QUESTIONS
The course is of high quality to teach students SQL and Spreadsheet coping skills. The hand-on activities can hone students' technical knowledge in a practical way. Thank you, Google team.
some time data are not available in sql only that section is hard to learn can you please use available data so it can be good us to learn otherwise everything is good and help out in learning
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.
Phenomenal course and course instructor! You have made the complex SQL queries quite easy to understand and follow through. Great job!
Notably, some of the video lessons had very low volumes.
Frequently Asked Questions
When will I have access to the lectures and assignments?
What will I get if I subscribe to this Certificate?
What is data analytics?
Why start a career in data analytics?
Why enroll in the Google Data Analytics Certificate?
What background is required?
Do you need to be strong at math to succeed in this certificate?
What tools and platforms are taught in the curriculum?
Which “spreadsheet” platform is being taught?
Do you need to take each course in course order?
More questions? Visit the Learner Help Center.