Knowledge is the Key to Riches!: ChatGPT for Data Analytics: Full Course

1️⃣ Intro to ChatGPT

================ 00:00 Intro 02:22 Options and Setup - Sign up to ChatGPT: https://openai.com/chatgpt - Access ChatGPT: https://chat.openai.com/ 06:59 Walkthrough - Course ChatBot: Data Analytics: https://lukeb.co/chatgpt_chatbot 11:56 Prompting 16:28 Settings - Custom Instructions: https://lukeb.co/chatgpt_custom_instr... 20:40 Images - Pictures for Image: https://lukeb.co/chatgpt_images 2️⃣ Intro to Advanced Data Analysis =========================== 26:38 Chapter Intro 28:28 ADA Timeout Issues 30:00 ADA Intro - Kaggle Job Posting Data Set: https://lukeb.co/FreeData - Chat History: https://lukeb.co/chat_ADA 37:46 Connecting to Data Sources 41:00 Exploring Data Set 45:52 Cleaning Data 47:55 Visualizing Data 52:16 Predicting Data 59:28 Data Set Limitations and Security - Large File: https://lukeb.co/chatgpt_large_file 1:01:58 Chapter Outro 3️⃣ Basic Analysis ============== 1:03:27 Chapter Intro - Kaggle Job Posting Data Set: https://lukeb.co/FreeData 1:07:11 Core Visualization - Custom Instructions: https://lukeb.co/chatgpt_custom_instr... 1:16:32 Statistical Visualizations 1:27:10 Visualization Best Practices - The Book Every Data Analyst Should Read: • The book every Data Analyst should read - Visual Vocabulary: https://www.tableau.com/solutions/gal... 1:38:31 Numerical Data 1:45:45 Categorical Data 1:50:28 Types of Data Analytics - Types of Analytics: https://lukeb.co/4types_analytics 1:54:43 Descriptive Analysis 1:59:06 Diagnostic Analysis 2:04:57 Predictive Analysis 2:09:05 Prescriptive Analysis 4️⃣ Advanced ChatGPT ================== 2:12:56 Chapter Intro 2:18:11 Hallucinations 2:25:48 Prompting Best Practices - Prompt Formula by Jeff Su - • Master the Perfect ChatGPT Prompt For... 2:33:14 Custom Instructions - Custom Instructions: https://lukeb.co/chatgpt_custom_instr... 2:39:01 GPTs - Course Chatbot: https://lukeb.co/chatgpt_chatbot 5️⃣ Intro to Plugins =============== 2:47:33 Chapter Intro 2:53:16 Browse with Bing 2:58:27 Time-Saver Plugins 3:03:27 Wolfram Plugin 3:08:09 DALL-E - Image Generation 6️⃣ Data Collection =============== 3:13:18 Chapter Intro 3:16:51 Public Data Sets - Kaggle: https://www.kaggle.com/datasets/lukeb... - Github: https://github.com/awesomedata/awesom... - Reddit: / datasets - Google: https://datasetsearch.research.google... 3:20:58 Web Scraping Intro - Glassdoor: https://www.glassdoor.com/Job/index.htm 3:30:10 Web Scraping Advanced - Building a bot to scrape job data - • Building a bot to scrape job data… Ho... 3:33:49 Course Wrap-up