ChatGPT for Data Analytics: Full Course

Video Description

Part 2 to this Video - ChatGPT Updates 👉 https://youtu.be/8qWtU51lxpM?si=yxApAe02hUGMybc9 Support the Course & Earn a Certificate 👉 https://lukeb.co/ChatGPT_Extras My FREE Course to be a Data Analyst 👉 https://lukebarousse.com/5daycourse 🔑 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 ================ 0:00:00 Intro 0:02:22 Options and Setup - Sign up to ChatGPT: https://openai.com/chatgpt - Access ChatGPT: https://chat.openai.com/ 0:06:59 Walkthrough - Course ChatBot: Data Analytics: https://lukeb.co/chatgpt_chatbot 0:11:56 Prompting 0:16:29 Settings - Custom Instructions: https://lukeb.co/chatgpt_custom_instructions_v1 0:20:41 Images - Pictures for Image: https://lukeb.co/chatgpt_images 2️⃣ Intro to Advanced Data Analysis =========================== 0:26:39 Chapter Intro 0:28:29 ADA Timeout Issues 0:30:01 ADA Intro - Kaggle Job Posting Data Set: https://lukeb.co/FreeData - Chat History: https://lukeb.co/chat_ADA 0:37:48 Connecting to Data Sources 0:41:02 Exploring Data Set 0:45:54 Cleaning Data 0:47:57 Visualizing Data 0:52:19 Predicting Data 0:59:31 Data Set Limitations and Security - Large File: https://lukeb.co/chatgpt_large_file 1:02:01 Chapter Outro 3️⃣ Basic Analysis ============== 1:03:30 Chapter Intro - Kaggle Job Posting Data Set: https://lukeb.co/FreeData 1:07:15 Core Visualization - Custom Instructions: https://lukeb.co/chatgpt_custom_instructions_v2 1:16:36 Statistical Visualizations 1:27:15 Visualization Best Practices - The Book Every Data Analyst Should Read: https://www.youtube.com/watch?v=09JnFEdZe2A&t=494s&ab_channel=LukeBarousse - Visual Vocabulary: https://www.tableau.com/solutions/gallery/visual-vocabulary 1:38:37 Numerical Data 1:45:51 Categorical Data 1:50:34 Types of Data Analytics - Types of Analytics: https://lukeb.co/4types_analytics 1:54:50 Descriptive Analysis 1:59:13 Diagnostic Analysis 2:05:04 Predictive Analysis 2:09:12 Prescriptive Analysis 4️⃣ Advanced ChatGPT ================== 2:13:04 Chapter Intro 2:18:19 Hallucinations 2:25:57 Prompting Best Practices - Prompt Formula by Jeff Su - https://www.youtube.com/watch?v=jC4v5AS4RIM&ab_channel=JeffSu 2:33:23 Custom Instructions - Custom Instructions: https://lukeb.co/chatgpt_custom_instructions 2:39:10 GPTs - Course Chatbot: https://lukeb.co/chatgpt_chatbot 5️⃣ Intro to Plugins =============== 2:47:43 Chapter Intro 2:53:26 Browse with Bing 2:58:38 Time-Saver Plugins 3:03:38 Wolfram Plugin 3:08:20 DALL-E - Image Generation 6️⃣ Data Collection =============== 3:13:29 Chapter Intro 3:17:03 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:21:10 Web Scraping Intro - Glassdoor: https://www.glassdoor.com/Job/index.htm 3:30:23 Web Scraping Advanced - Building a bot to scrape job data - https://youtu.be/1kU_ASADlPY 3:34:02 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