К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Analyze Data to Answer Questions · LearnSpace
Назад в каталог
courseraАнализ данных

Analyze Data to Answer Questions

Курс от Google
Начальный≈ 25.9 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

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.

Навыки, которые вы освоите

SQLData ManipulationPivot Tables And ChartsExcel FormulasSpreadsheet SoftwareData ValidationData ProcessingData CompilationData QualityDatabase ManagementData AnalysisAnalytical SkillsData IntegrationConsolidationData TransformationQuery Languages

Программа курса

4 модулей · 118 учебных материалов

01Organize data for more effective analysis 28 материалов

Let's get organized

Introduction to getting organizedВидеоCourse 5 overviewЧтениеHelpful resources and tipsЧтение

Organize data for analysis

The analysis processВидео

Учитесь у экспертов

Google Career Certificates

Преподаватель курса

Analyze Data to Answer Questions
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 25.9 ч

4 модулей

Язык: Английский

Субтитры: Арабский, Французский, Украинский, Бразильский португальский, Корейский, Немецкий, Индонезийский, Турецкий, Испанский, Японский

Часть программы вашего университета
Ayanna: Sticking with itВидео
Always a need to organize Видео
Sort and filter data to keep it organizedЧтение
Review: Set up your BigQuery accountЧтение
Review: Get started with BigQueryЧтение
Working with .csv filesЧтение
Upload the movie dataset to BigQueryЧтение
Step-by-Step: Filter data with SQLЧтение
Filter data with SQLВидео
Test your knowledge on organizing data for analysisЗадание

Sort data in spreadsheets

Step-by-step: Sort datasets in spreadsheetsЧтениеSort data in spreadsheetsВидеоStep-by-step: Use the SORT function in spreadsheetsЧтениеUse the SORT function in spreadsheetsВидеоSort and filter in Sheets and ExcelЧтениеEmma: Journey to a meaningful careerВидеоTest your knowledge on sorting data in spreadsheets Задание

Sort data using SQL

Step-by-Step: Sort data with SQLЧтениеSort data with SQLВидеоHands-On Activity: SQL sorting queriesЗаданиеHands-On Activity: Analyze weather data in BigQueryЗаданиеTest your knowledge on sorting data with SQL Задание

Module 1 challenge

Glossary terms from module 1ЧтениеModule 1 challengeЗадание
02Format and adjust data 25 материалов

Formatting for better analysis

Get started with data formatting ВидеоStep-by-Step: From one type to anotherЧтениеFrom one type to another Видео Convert data in spreadsheets ЧтениеData validationВидеоConditional formatting ВидеоTransform data with SQLЧтениеTest your knowledge on converting and formatting dataЗадание

Combine multiple datasets

Import and combine data in spreadsheets and databasesЧтениеStep-by-Step: Merge text strings to gain insightsЧтениеMerge text strings to gain insightsВидеоHands-On Activity: Combine multiple pieces of dataЗаданиеStep-by-Step: Strings in spreadsheets ЧтениеStrings in spreadsheets Видео

Get support during analysis

When you get stuckВидеоAdvanced spreadsheet tips and tricksЧтениеLayla: All about the analyze stageВидеоRunning into challenges? Not to worry!ВидеоWhen to use which toolВидеоSelf-Reflection: Stack Overflow Задание

Module 2 challenge

Glossary terms from module 2ЧтениеModule 2 challengeЗадание
03Aggregate data for analysis 28 материалов

VLOOKUP and data aggregation

Aggregate data for analysis ВидеоPrepare for VLOOKUPВидеоVLOOKUP in actionВидеоIdentify and fix common VLOOKUP errors ВидеоVLOOKUP Core Concepts ЧтениеHands-On Activity: Use VLOOKUP to perform a taskЗаданиеTest your knowledge on VLOOKUPЗадание

Use JOINS to aggregate data in SQL

Upload the employee dataset to BigQueryЧтениеStep-by-Step: Explore how JOINs workЧтениеExplore how JOINs work ВидеоSecret identities: The importance of aliasesЧтениеUse JOINs effectively ЧтениеHands-On Activity: Queries for JOINSЗадание

Work with subqueries

Step-by-Step: Queries within queriesЧтениеQueries within queriesВидеоHands-On Activity: Use subqueries to refine dataЗаданиеStep-by-Step: Use subqueries to aggregate dataЧтениеUse subqueries to aggregate data ВидеоSQL functions and subqueries: A functional friendshipЧтение

Module 3 challenge

Glossary terms from module 3ЧтениеModule 3 challengeЗадание
04Perform data calculations 37 материалов

Get started with data calculations

Data calculations ВидеоCommon calculation formulas ВидеоFunctions and conditionsВидеоFunctions with multiple conditionsЧтениеHands-On Activity: Work with conditionsЗаданиеComposite functions ВидеоTest your knowledge on data calculations Задание

Pivot...pivot...pivot...

Start working with pivot tables ВидеоPivot tables continuedВидеоElements of a pivot tableЧтениеUse pivot tables in analysis ЧтениеHands-On Activity: Explore movie data with pivot tablesЗаданиеTest your knowledge on pivot tables Задание

Learn more SQL calculations

Queries and calculationsВидеоUpload the avocado dataset to BigQueryЧтениеStep-by-Step: Embed simple calculations with SQLЧтениеEmbed simple calculations with SQLВидеоCalculations with other statements ВидеоHands-On Activity: Calculations with SQL Задание

The data-validation process

Check and recheckВидеоTypes of data validationЧтениеHands-On Activity: From spreadsheets to BigQueryЗаданиеStart validatingPLUGIN

SQL and temporary tables

Temporary tablesВидеоHands-On Activity: Create temporary tables ЗаданиеMultiple table variationsВидеоWork with temporary tables ЧтениеYour intermediate guide to SQL ЧтениеUse Connected Sheets with BigQueryЧтение

Module 4 challenge

Glossary terms from module 4ЧтениеModule 4 challenge Задание

Course wrap-up

Reflect and connect with peersЧтениеCourse 5 glossaryЧтениеCongratulations! Course wrap-upВидеоComing up next...Чтение
Manipulate strings with SQLЧтение
SQL query syntaxPLUGIN
Test your knowledge on combining multiple datasets Задание
Upload the warehouse dataset to BigQueryЧтение
Hands-On Activity: COUNT and COUNT DISTINCTЗадание
Test your knowledge on using JOINS to aggregate data Задание
Review subqueriesPLUGIN
Justin: Where data analysis takes you Видео
Hands-on activity: Use subqueriesЗадание
Test your knowledge on working with subqueries Задание
Test your knowledge on SQL calculations Задание
Test your knowledge on using SQL with temporary tables Задание