------------ TIME STAMP --------------------- ORGANIZING DATA TO BEGIN ANALYSIS 0:00:00 Welcome to the course 0:03:11 The analysis process 0:07:47 Ayanna Stickin with it 0:09:38 Always a need to organize 0:12:21 More on sorting and filtering 0:17:29 Sorting datasets 0:22:25 The SORT function 0:27:55 Emma Journey to a meaningful career 0:30:08 Sorting queries in SQL FORMATING AND ADJUSTING DATA 0:37:45 Getting started with data formatting 0:38:54 From one type to another 0:44:17 Data validation 0:48:08 Conditional Formating 0:52:43 Merging and multiple sources 0:56:58 Strings in Spreadsheets 0:59:58 What to do when you get stuck 1:03:21 Layla all about the analyze phase 1:06:44 Running into challenges Not to worry 1:13:13 When to use which tool AGGREGATING DATA FOR ANALYSIS 1:16:36 Aggregate data for analysis 1:19:39 Preparing for VLOOKUP 1:24:34 Identifying common VLOOKUP errors 1:30:34 Understand JOINS 1:37:57 COUNT and COUNT DISTINCT 1:43:35 Queries within queries 1:50:22 Justin Where data analysis takes you 1:52:23 Using subqueries to aggregate data PERFORMING DATA CALCULATIONS 1:59:36 Data calculations 2:01:59 common calculation formulas 2:12:11 Functions and conditions 2:20:47 Composite functions 2:26:26 Working with pivot tables 2:39:26 Queries and calculations 2:43:35 Embedding simple calculations in SQL 2:51:15 Calculations with other statements 2:55:32 Check and recheck 3:01:11 Temporary tables 3:07:50 Multiple table variations 3:11:30 Congratulations Course Material : drive.google.com/file/d/1SLkZy61gCwFy7VRkW0YxafPWXY8m8bJR/view?usp=sharing
------------ TIME STAMP ---------------------
ORGANIZING DATA TO BEGIN ANALYSIS
0:00:00 Welcome to the course
0:03:11 The analysis process
0:07:47 Ayanna Stickin with it
0:09:38 Always a need to organize
0:12:21 More on sorting and filtering
0:17:29 Sorting datasets
0:22:25 The SORT function
0:27:55 Emma Journey to a meaningful career
0:30:08 Sorting queries in SQL
FORMATING AND ADJUSTING DATA
0:37:45 Getting started with data formatting
0:38:54 From one type to another
0:44:17 Data validation
0:48:08 Conditional Formating
0:52:43 Merging and multiple sources
0:56:58 Strings in Spreadsheets
0:59:58 What to do when you get stuck
1:03:21 Layla all about the analyze phase
1:06:44 Running into challenges Not to worry
1:13:13 When to use which tool
AGGREGATING DATA FOR ANALYSIS
1:16:36 Aggregate data for analysis
1:19:39 Preparing for VLOOKUP
1:24:34 Identifying common VLOOKUP errors
1:30:34 Understand JOINS
1:37:57 COUNT and COUNT DISTINCT
1:43:35 Queries within queries
1:50:22 Justin Where data analysis takes you
1:52:23 Using subqueries to aggregate data
PERFORMING DATA CALCULATIONS
1:59:36 Data calculations
2:01:59 common calculation formulas
2:12:11 Functions and conditions
2:20:47 Composite functions
2:26:26 Working with pivot tables
2:39:26 Queries and calculations
2:43:35 Embedding simple calculations in SQL
2:51:15 Calculations with other statements
2:55:32 Check and recheck
3:01:11 Temporary tables
3:07:50 Multiple table variations
3:11:30 Congratulations
Course Material : drive.google.com/file/d/1SLkZy61gCwFy7VRkW0YxafPWXY8m8bJR/view?usp=sharing
Google Data Analytics Professional Certificate Complete Courses.
ruclips.net/p/PLtS8Ubq2bIlVN4Zom0O-6rBysJs3wns60
Thank you so much for uploading.
56:00 citi bike data CONCATE function on sql
Happy
1:19:00
Thank you so much
01:01:00
@mylesson007 is there a transcript available?
1:07:00
documentation or resources
1:10:00
How do i stop hackers troubling my account
58:00
46:00
31:47
there's a lot of repetition
Better than none
39:00