ChatGPT for Data Analytics: Full Course
Key Takeaways
The video course covers using ChatGPT for data analytics, including setting up and using the tool, advanced data analysis, and basic analysis techniques. Specific tools and resources used include ChatGPT, Kaggle Job Posting Data Set, and custom instructions for ChatGPT.
Original 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
Watch on YouTube ↗
(saves to browser)
Sign in to unlock AI tutor explanation · ⚡30
Playlist
Uploads from Luke Barousse · Luke Barousse · 0 of 60
← Previous
Next →
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
Connect Google Sheets to Tableau & Joining Data - Tableau Tutorial P.1
Luke Barousse
How To Use Tableau Desktop Controls - Tableau Tutorial P.2
Luke Barousse
Dimensions Vs Measures (Blue Vs Green Data) - Tableau Tutorial P.3
Luke Barousse
Create Stacked Bar Chart (and any other visuals EASILY!) w/ Show Me! - Tableau Tutorial P.4
Luke Barousse
Conditional Format Tables in Tableau (Like Excel!) - Tableau Tutorial P.5
Luke Barousse
Calculated Fields in Tableau (Formulas & IF Statements) - Tableau Tutorial P.6
Luke Barousse
Parameters (Create & Use in Calculated Fields and/or Visuals) - Tableau Tutorial P.7
Luke Barousse
Totals, Average Lines, & Trend Lines (Analytics Pane) - Tableau Tutorial P.8
Luke Barousse
How To Create a Dashboard - Tableau Tutorial P.9
Luke Barousse
Upload your dashboard to Tableau Public - Tableau Tutorial P.10
Luke Barousse
Install Python for Data Science on Mac & Windows (PC) with Anaconda - P.1
Luke Barousse
How to run Python for Data Science - Editors vs IDEs - P.2
Luke Barousse
Install VS Code with Python for Data Science / Data Analysis - P.3
Luke Barousse
Understanding Virtual Environments for Data Science / Data Analysis - P.4
Luke Barousse
Using VS Code with Python for Data Science / Data Analysis - P.5
Luke Barousse
Python for Data Science / Analysis ft. 'The Office' Dataset - P.0
Luke Barousse
Python Objects frequently used in Data Science / Data Analysis - P.1
Luke Barousse
Python If Statements for Data Science / Data Analysis - P.2
Luke Barousse
Python For & While Loops for Data Science / Data Analysis - P.3
Luke Barousse
Python List Comprehension for Data Science / Data Analysis - P.4
Luke Barousse
Python Functions for Data Science / Data Analysis - P.5
Luke Barousse
Lambda Functions for Data Science / Data Analysis - Python P.6
Luke Barousse
How NOT to learn Python for Data Science
Luke Barousse
What is Business Intelligence (BI)? 📊😅
Luke Barousse
Top 3️⃣ Technical Skills for Business Intelligence 📚📊
Luke Barousse
Top Non-technical Skills for Business Intelligence 📊👨🏼💻
Luke Barousse
M1 vs Intel Mac for Data Science
Luke Barousse
M1 vs Intel Mac for Excel 📈👨🏼💻
Luke Barousse
M1 vs Intel Mac for Python 🐍👨🏼💻
Luke Barousse
M1 vs Intel Mac for Business Intelligence Tools 💻📊
Luke Barousse
M1 Macbook Air vs Pro (8 vs 16 GB) for Data Science
Luke Barousse
Python for M1 Mac vs Intel (SPOILER: M1 is 2x faster)
Luke Barousse
Data Analyst's WFH Setup & Upgrades
Luke Barousse
Windows on the M1 Mac - What are your options?
Luke Barousse
Install your favorite Windows app on M1 Mac - ft. Parallels
Luke Barousse
Data Science shortcuts for Mac
Luke Barousse
Day in the life of a data analyst
Luke Barousse
Power BI vs Tableau - Best BI Tool
Luke Barousse
Mac Vs PC - BEST for Data Science
Luke Barousse
Data Scientist vs Data Analyst (funny!)
Luke Barousse
Become a DATA ANALYST with NO degree?!? The Google Data Analytics Professional Certificate
Luke Barousse
Certificates vs Degree for Data Analysts (ft. Google Data Analytics Professional Certificate)
Luke Barousse
Google vs IBM Data Analyst Certificate - BEST Certificate for Data Analysts
Luke Barousse
Python Vs R (funny!)
Luke Barousse
THIS got me my job as a Data Analyst - My portfolio tip
Luke Barousse
I used Python to Count my Bike Jumps!
Luke Barousse
Standout as a Data Analyst with THIS TOOL
Luke Barousse
STOP using Spreadsheets for Everything!
Luke Barousse
Transition into Data Science - My Tips & Story
Luke Barousse
Get a JOB w/ Google Data Analytics Certificate?!? (ft. Certificate Holders)
Luke Barousse
Staying Motivated in Data Science
Luke Barousse
Data Science - Expectation vs Reality (funny!) - ft. @KenJee_ds
Luke Barousse
Get NOTICED in Data Science!!! (3 types of GREAT projects)
Luke Barousse
Use THIS to showcase EXPERIENCE in Data Science
Luke Barousse
How to show EXPERIENCE... when you have NONE?!?
Luke Barousse
Learn PYTHON to be a DATA ANALYST?!? (or is R enough...)
Luke Barousse
The BIGGEST MISTAKE when starting a data project!
Luke Barousse
Top Jobs in Data Science
Luke Barousse
How to get Data Analytics side jobs - NEW LinkedIn Feature
Luke Barousse
Building a bot to scrape job data… How NOT to collect data
Luke Barousse
More on: Data Literacy
View skill →
Related Reads
📰
📰
📰
📰
The Data Foundation for Finance Transformation at Enterprise Scale
Medium · Data Science
Your Pipeline Is 25.4h Behind: Catching Defence Sentiment Leads with Pulsebit
Dev.to · Pulsebit News Sentiment API
Value to the mentees?
Reddit r/datascience
I turned a public-domain government CSV into a searchable index of every port and airport on Earth
Dev.to · ZahidRahman47
Chapters (22)
Intro
2:22
Options and Setup
6:59
Walkthrough
11:56
Prompting
16:29
Settings
20:41
Images
26:39
Chapter Intro
28:29
ADA Timeout Issues
30:01
ADA Intro
37:48
Connecting to Data Sources
41:02
Exploring Data Set
45:54
Cleaning Data
47:57
Visualizing Data
52:19
Predicting Data
59:31
Data Set Limitations and Security
1:02:01
Chapter Outro
1:03:30
Chapter Intro
1:07:15
Core Visualization
1:16:36
Statistical Visualizations
1:27:15
Visualization Best Practices
1:38:37
Numerical Data
1:45:51
Categorical Data
🎓
Tutor Explanation
DeepCamp AI