ChatGPT for Data Analytics: Full Course Part 2 📊

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