Google Data Analytics Professional Certificate, Course 3 Prepare Data for Exploration

At 00:00:00, the course begins with an introduction to data exploration. At 00:03:45, we delve into fascinating data insights. At 00:06:45, we cover data collection in our world. At 00:10:36, we discuss determining what data to collect. At 00:14:23, we discover data formats. At 00:19:29, we explore understanding structured data. At 00:21:21, we learn to know the type of data you're working with. At 00:25:34, we examine data table components. At 00:27:56, we meet wide and long data. At 00:31:29, we ensure data integrity. At 00:32:58, we analyze bias from questions to conclusions. At 00:36:03, we differentiate biased and unbiased data. At 00:38:05, we understand bias in data. At 00:41:56, we identify good data sources. At 00:44:47, we discuss what is bad data. At 00:47:41, we introduce data ethics. At 00:52:28, we provide an optional refresher on the importance of data ethics. At 00:55:29, we introduce data privacy. At 00:57:23, we discuss the ethical use of data. At 01:00:12, we cover features of open data. At 01:04:27, we outline steps for ethical data use. At 01:07:40, we explore all about databases. At 01:10:05, we review database features. At 01:13:47, we explore metadata. At 01:17:37, we use metadata as an analyst. At 01:21:23, we manage metadata. At 01:24:50, we have fun with metadata. At 01:27:37, we work with more data sources. At 01:30:49, we import data from spreadsheets and databases. At 01:34:40, we sort and filter. At 01:40:15, we set up BigQuery, including sandbox and billing options. At 01:43:58, we learn how to use BigQuery. At 01:48:21, we see BigQuery in action. At 01:55:20, we feel confident in your data. At 01:56:13, we get organized. At 02:00:50, we cover all about file naming. At 02:03:23, we discuss security features in spreadsheets. At 02:06:42, we manage your presence as a data analyst. At 02:07:45, we explain why an online presence is important. At 02:11:01, we give tips for enhancing your online presence. At 02:14:35, we share networking know-how. At 02:16:50, we discuss benefits of mentorship. At 02:20:48, we highlight mentors are key. At 02:23:43, we wrap up the course.