🙌 Support the Course & Earn a Certificate 👉 https://lukeb.co/ChatGPT_Extras 🔑 Primary Resources for the Course ============================ 💽 Job Posting Data Set: https://lukeb.co/FreeData 🤖 Course Chatbot: https://lukeb.co/chatgpt_chatbot 🔢 My Custom Instructions: https://lukeb.co/chatgpt_custom_instructions 📝 Sign up to get my ChatGPT cheat sheet: https://lukebarousse.com/ 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_instructions_v1 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_instructions_v2 1:16:32 Statistical Visualizations 1:27:10 Visualization Best Practices - The Book Every Data Analyst Should Read: https://www.youtube.com/watch?v=09JnFEdZe2A - Visual Vocabulary: https://www.tableau.com/solutions/gallery/visual-vocabulary 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 - https://www.youtube.com/watch?v=jC4v5AS4RIM 2:33:14 Custom Instructions - Custom Instructions: https://lukeb.co/chatgpt_custom_instructions 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/lukebarousse/data-analyst-job-postings-google-search - Github: https://github.com/awesomedata/awesome-public-datasets - Reddit: https://www.reddit.com/r/datasets/ - Google: https://datasetsearch.research.google.com/ 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 - https://www.youtube.com/watch?v=1kU_ASADlPY 3:33:49 Course Wrap-up Social Media / Contact Me ====================== 📫Newsletter: https://www.lukebarousse.com/ 👨🏼‍💼 Linkedin: https://www.linkedin.com/in/luke-b/ 🅧 X/Twitter: https://twitter.com/LukeBarousse 🌄 Instagram: https://www.instagram.com/lukebarousse/ ⏰ TikTok: https://www.tiktok.com/@lukebarousse #datanerd #dataanalyst #chatgpt