Process Data from Dirty to Clean Complete Course | Data Analytics

[@MyLesson007]

----------------- TIME STAMP -------------------- THE IMPORTANCE OF INTEGRITY 0:00:00 Welcome to the course 0:03:51 Why data integrity is important 0:06:42 Balancing objectives with data integrity 0:09:55 Dealing with insufficient data 0:13:43 The importance of sample size 0:17:08 Using statistical power 0:22:06 Determine the best sample size 0:27:00 Evaluate the reliability of your data SPARKLING-CLEAN DATA 0:32:48 Clean it up! 0:35:38 Why data cleaning is important 0:41:20 Angie Why i love cleaning data 0:42:41 Defining dirty data 0:48:05 Data-cleaning tools and techniques 0:54:22 Cleaning data from multiple sources 1:00:07 Data-Cleaning features in spreadsheets 1:08:10 Optimize the data-cleaning process 1:22:16 Different data perspectives 1:32:35 Even more data-cleaning techniques CLEANING DATA WITH SQL 1:39:28 Using SQL to clean data 1:40:13 Sally for the love SQL 1:43:32 Understanding SQL capabilities 1:46:52 Spreadsheets versus SQL 1:51:05 Widely used SQL queries 1:57:14 Evan having fun with SQL 1:59:52 Cleaning string variables using SQL 2:12:39 Advance data-cleaning functions, part1 2:19:00 Advance data-cleaning functions, part2 VERIFY AND REPORT ON YOUR CLEANING RESULTS 2:27:55 Verifying and reporting results 2:31:11 Cleaning and you data expectations 2:36:12 The final step in data cleaning 2:44:28 Capturing cleaning changes 2:50:25 Why documentation is important 2:53:49 Feedback and cleaning OPTIONAL: ADDING DATA TO YOUR RESUME 2:56:02 About the data-analyst hiring process 2:57:21 The data analyst job-application process 3:04:19 Creating a resume 3:13:25 Making your resume unique 3:16:50 Joseph Black and African Americal Inclusion in the data industry 3:18:49 Translating past work experience 3:23:41 Kate My Career path as a data analyst 3:27:30 Where does your interest lie COURSE CHALLENGE 3:31:21 GEt ready for the course challenge 3:31:44 Congratulations! Courser Material : drive.google.com/file/d/1WatrY-shwU97fmUbfB_KG_if1cC0w9_J/view?usp=sharing

[@dynamix9916]

Thank you🙏

[@MyLesson007]

Google Data Analytics Professional Certificate Complete Courses. kzbin.info/aero/PLtS8Ubq2bIlVN4Zom0O-6rBysJs3wns60

[@ajulodamilola9865]

To get the best out of this course with this video, I’d suggest you audit (or access the financial) the course on Coursera thereby getting the reading materials and practice questions.

[@JorgeAlibrandi]

you earned my respect and admiration. thanks

[@mauzrana6091]

why was the function FLOAT64 used instead of FLOAT only? on 2:17:41

[@YemiAdeyemiDelateur]

Good and helpful course. Please, where can I get data to practice?

[@GabrielGMChaves]

I know I'm a bit late to answer your question, but you can find lots of data in Kaggle :)

[@nishwakarma3]

How She Auto Fill the Formulal in the Remaing Cells?

[@FordTruckFan]

In the bottom right of a cell there is a small box. Double click it to fill the column or drag it down to the selected cells

[@seeta9211]

ctrl+d

[@mohitsharda7373]

2:00:00

[@mohitsharda7373]

1:27:00

[@ameer.suhail]

Do u have telegram channel?

[@mohitsharda7373]

41:00

[@mohitsharda7373]

32:00:00

[@zemry-mh4sq]

9:55

[@mohitsharda7373]

14:00

[@SakshiKumari-lc5wb]

You sure this is real course from Coursera?

[@MyLesson007]

Yes

[@FordTruckFan]

This is not the full course from the Google data analytics certificate. These videos are about 10% of the content (they are reuploads). The course is meant to make you job ready with dense content.

[@djpoepe]

Thank you for the courses....but the files are not opening

[@FordTruckFan]

The paid course includes a lot more content that makes you job ready. This is just a reupload of some of the videos. The files the uploader provided are not official.

[@SaqibMehmood-yy4zg]

Is this the paid course that Google offers on Coursera?

[@FordTruckFan]

The paid course includes a lot more content that makes you job ready. This is just a reupload of some of the videos.

[@ahmedmarzouk291]

@@FordTruckFan it is the same content google course content will no make you ready for any job it is just an introduction.

[@sunnygawande5283]

How do they create sample size calculator m

[@jerichodeguzman4005]

where the hell are those datasets?

[@FordTruckFan]

The official course has all the material, these are reuploads from the course and do not represent the entire course.

[@oneshot1086]

@@FordTruckFan you mean all the 8 videos don't add up to the entire course on coursera?

[@HoangNguyen-pv6fz]

These videos are from the courses on Coursera, so if you want all materials, please enrol on Coursera. Have fun learning ❤ P.s: use your brain before commenting next time 😊

[@mahender2517]

please upload files related to this video too. will be helpful.Thanks

[@ohaegbulamprecious5961]

Did you get the files?

[@mahender2517]

@@ohaegbulamprecious5961 no

[@MyLesson007]

Yes Courser Material : drive.google.com/file/d/1WatrY-shwU97fmUbfB_KG_if1cC0w9_J/view?usp=sharing

[@MyLesson007]

Courser Material : drive.google.com/file/d/1WatrY-shwU97fmUbfB_KG_if1cC0w9_J/view?usp=sharing

[@ohaegbulamprecious5961]

@@MyLesson007 please what type of file is this? I can't open it on my phone and laptop

[@perseoeridano4182]

👏👏👏

[@mohitsharda7373]

1:55:00

[@mohitsharda7373]

53:00

[@zemry-mh4sq]

9:55

[@mohitsharda7373]

2:30:00