ChatGPT for Data Analytics: Full Course

🙌 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
03:41 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&t=494s&ab_channel=LukeBarousse
– 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&ab_channel=JeffSu
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://youtu.be/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