Google Data Analytics Professional Certificate, Course 5 Analyse the Data to Answer the Questions

Description:

Google Data Analytics Professional Certificate, Course 5 Analyse the Data to Answer the Questions #googledataanalytics #dataanalytics #analyzingdata #dataanalytics *** please like and subscribe *** for downloading the course material see the 1st comment Table of Contents 00:00:00 Introduction to getting organized 00:03:17 The analysis process 00:07:54 Ayanna_ Sticking with it 00:09:44 Always a need to organize 00:12:27 More on sorting and filtering 00:17:35 Sort data in spreadsheets 00:22:31 The SORT function 00:27:48 Emma_ Journey to a meaningful career 00:30:01 Sorting queries in SQL 00:37:38 Getting started with data formatting 00:38:47 From one type to another 00:44:10 Data validation 00:48:01 Conditional formatting 00:52:36 Merging and multiple sources 00:57:34 Strings in spreadsheets 01:00:34 What to do when you get stuck 01:03:57 Layla_ All about the analyze phase 01:07:20 Running into challenges_ Not to worry! 01:13:49 When to use which tool 01:17:12 Aggregate data for analysis 01:20:15 Preparing for VLOOKUP 01:25:10 VLOOKUP in action 01:28:30 Identifying common VLOOKUP errors 01:34:04 Understanding JOINS 01:41:47 COUNT and COUNT DISTINCT 01:47:25 Queries within queries 01:54:11 Using subqueries to aggregate data 02:01:24 Justin_ Where data analysis takes you 02:03:26 Data calculations 02:05:49 Common calculation formulas 02:15:43 Functions and conditions 02:24:18 Composite functions 02:29:58 Start working with pivot tables 02:37:13 Pivot tables continued 02:44:28 Queries and calculations 02:48:38 Embedding simple calculations in SQL 02:52:47 Calculations with other statements 02:57:04 Check and recheck 03:02:43 Temporary tables 03:09:22 Multiple table variations 03:13:03 Congratulations!