Google Data Analytics Professional Certificate, Course 4 Process Data from Dirty to Clean

Description:

Google Data Analytics Professional Certificate, Course 4 Process Data from Dirty to Clean #googledataanalytics #dataanalytics #processdataforanalysis #dataprocessing *** please like and subscribe *** for downloading the course material see the 1st comment Table of Contents 00:00:00 Introduction to focus on integrity 00:03:57 Why data integrity is important 00:06:48 Balancing objectives with data integrity 00:10:01 Dealing with insufficient data 00:13:49 The importance of sample size 00:17:15 Using statistical power 00:22:13 Determine the best sample size 00:27:07 Evaluate the reliability of your data 00:32:55 Clean it up! 00:35:42 Why data cleaning is important 00:41:24 Angie_ Why I love cleaning data 00:42:45 Recognize and remedy dirty data 00:48:09 Data-cleaning tools and techniques 00:54:26 Clean data from multiple sources 01:00:11 Data-cleaning features in spreadsheets 01:08:14 Optimize the data-cleaning process 01:22:20 Different data perspectives 01:32:39 Even more data-cleaning techniques 01:39:31 Using SQL to clean data 01:40:17 Sally_ For the love of SQL 01:43:36 Understanding SQL capabilities 01:46:56 Spreadsheets versus SQL 01:51:09 Widely used SQL queries 01:57:17 Evan_ Having fun with SQL 01:59:55 Cleaning string variables using SQL 02:12:42 Advanced data-cleaning functions, part 1 02:19:10 Advanced data-cleaning functions, part 2 02:28:05 Verifying and reporting results 02:31:21 Cleaning and your data expectations 02:36:23 The final step in data cleaning 02:44:39 Capturing cleaning changes 02:50:36 Why documentation is important 02:54:00 Feedback and cleaning 02:56:13 About the data-analyst hiring process 02:57:32 The data analyst job-application process 03:04:30 Creating a resume 03:13:36 Making your resume unique 03:17:01 Joseph_ Black and African American inclusion in the data industry 03:19:00 Translating past work experience 03:23:52 Kate_ My career path as a data analyst 03:27:40 Where does your interest lie_ 03:31:32 Get ready for the course challenge 03:31:55 Congratulations!