4-1: Data Analyst Essentials

Master the essentials of data analysis with SQL, ChatGPT, AI-powered SQL, and project management. Gain practical skills to solve real problems and boost your career as a data analyst.

Subscribe Now FREE PREVIEW

Want Access To More Than Just This Course?

Upgrade To The Full Bundle And Unlock Every Course, Every Update, And The Complete Learning Pathway.

Jellyman Full Site Package
Bundle • 9 learning products
Full access to every JME course — Tableau, SQL, Cloud, ChatGPT, Portfolio builds and the Job Hunt System. $19.95/month. 14-day free trial. Cancel anytime. Money-back guarantee. Built for non-data professionals ready to get hired.

$19.95 / month with 14 day free trial

Purchase

Data Essentials Course Tour!

What You'll Learn in this Course

Learn SQL to retrieve and manage data, accelerate queries with AI support, and apply Agile methods to prototype, iterate, and deliver solutions.

Uniting technical skills with stakeholder alignment and project execution.

SQL Fundamentals – Retrieve, manage, and analyze data effectively for real-world decision-making.
AI Acceleration – Use ChatGPT to draft, refine, and explain SQL queries faster and with clarity.
Agile Execution – Prototype, iterate, and deploy projects while aligning with stakeholder needs.

Course Curriculum

1. Data Analyst Essentials
  FREE PREVIEW
2. ChatGPT Support
  FREE PREVIEW
1. Introduction
  FREE PREVIEW
2. 01_01_What is ChatGPT - Multiple Demonstrations
  FREE PREVIEW
3. 01_02_How ChatGPT Works Under The Hood
  FREE PREVIEW
4. 01_03_Gaining Access to ChatGPT - Paid vs Free (Links)
  FREE PREVIEW
5. 02_01_Iteration Discussion vs Establishing Context Immediately
  FREE PREVIEW
6. 02_02_Explaining your Skill Level to get Better Explanations
  FREE PREVIEW
7. 02_03_Outlining your Needs Prior to Prompting
  FREE PREVIEW
8. 02_04_Analyzing your Tone - JELLYMAN CREATIVE (LINKS)
  FREE PREVIEW
9. 03_01_Using ChatGPT to Assess our Finances and Buy a House
10. 03_02_Computer Programming - Advanced Capabilities Demo
11. 03_03_Using the Canvas Feature
12. 03_04_Image Generation - Dall-E and Sora - Midjourney Sneak Peak
13. 03_05_Custom GPTs and the GPT Store
14. 03_06_Custom GPT Design
15. 04_01_Finish
1. Introduction
2. 01_01_Welcome to the Course - Outline, Pre Requisite Knowledge and Software
3. 01_02_getting Started with ChatGPT and Teaching it how to Solve Problems - Uploading Structures
4. 01_03_Uploading your Data Set - Privacy Warning
5. 01_04_Custom GPTs to make your Life Much Easier
6. 01_05_Problem 1 - Starting Easy. Library Data. Single and Multi Queries.
7. 01_06_Problem 2 - Dealing with Joins. Creafting a Powerpoint Slide
8. 01_07_Problem 3 - Analyzing More Complex Problems - Storing in Memory
9. 01_08_Iterating your Script in Stages
10. 01_09_Exporting Instant Reports - Using a Template
11. 01_10_Aggregation Exercise Over Level and Year
12. 01_11_Top Students - Regenerating the Report - Formatting the Report
13. 01_12_Solving Problems when Data Doesn't Exist Yet
14. 01_13_Finish
1. 02_01_Project Management Topics
2. 02_02_You Are Now a Lead Data Analyst for SpaceX (Attachment)
3. 02_03_Management Methodologies - Agile vs Waterfall (Attachment)
4. 02_04_Waterfall Method Visualized (Attachment)
5. 02_05_Agile Development Visualized (Attachment)
6. 02_06_Managing Scope Creep (Attachment)
7. 02_07_Prioritization using Impact vs Effort (Attachment)
8. 02_08_Designing for the Long Term (Attachment)
9. 02_09_Eliminating Waste in Analytics Projects (Attachment)
10. 02_10_Project Tracking and Communication (Attachment)
11. 03_01_Finished
1. 05_01_Congrats and Tableau Portfolio Next

Course Details

58 lessons
6.5 hours of video content
Ideal for beginners
Visualization Basics
Apply Knowledge Immediately

What You Get In This Course

50+ Videos

Learn through over 50 bite-sized lessons that guide you step by step, making Tableau simple and approachable for complete beginners.
Quizzes to Test Your Knowledge

Reinforce what you’ve learned with interactive quizzes designed to check your understanding and build confidence as you progress.
Assignments with Video Walkthroughs

Apply your skills in real assignments and follow along with video walkthrough solutions to ensure you never feel stuck.

Learning SQL and AI with Free Tools

In this course, you’ll practice SQL using W3Schools and explore AI with the free version of ChatGPT.

SQL Fundamentals

Learn the essential language of data to retrieve, manage, and analyze information effectively.

Mastering the fundamentals of SQL gives you the ability to retrieve, manage, and analyze data efficiently.

You’ll discover why SQL is essential across industries and how it powers data-driven decision-making in every business sector.

Access data quickly from large and complex datasets
Manage information by inserting, updating, and deleting records securely
Support decisions with accurate insights for business strategies
Work flexibly across multiple database systems like MySQL, PostgreSQL, and Oracle
Boost career value by mastering one of the most in-demand skills in data

SQL Acceleration with ChatGPT

Use AI to draft, refine, and explain SQL queries faster and more effectively.

Leveraging ChatGPT as your coding partner speeds up the process of writing and understanding SQL.

You’ll learn how to frame problems clearly, provide context, and iterate effectively—transforming AI into a powerful assistant for your workflow.

Draft queries rapidly from natural language prompts
Refine results step-by-step to improve accuracy
Learn concepts through instant explanations and examples
Document work by generating clear summaries of queries
Save time while boosting efficiency and clarity in analysis

Project Management with Agile

Apply Agile methods to prototype, iterate, and deliver real-world solutions aligned with stakeholder needs.

Adopting Agile principles ensures projects move quickly from ideas to working solutions.

You’ll discover how to build in short cycles, adapt to evolving requirements, and deliver value that truly meets business goals.

Prototype rapidly to test and validate ideas before full build-out
Deploy faster by working in short, iterative cycles
Refine continuously with stakeholder feedback at every stage
Reduce overhead by avoiding excessive up-front documentation
Maximize impact by aligning solutions with actual business needs

HERE'S WHAT MY AWESOME STUDENTS HAVE TO SAY

“

AMAZING TEACHER

I love your course and could listen for hours. You distill valuable advice clearly. Found you on YouTube while struggling with LOD expressions; examples helped immensely. Grateful for accessible pricing and free content—your teaching is engaging and generous.

”

Emeline Courcelle

“

GAME-CHANGING COURSE FOR FIRST-TIME TABLEAU USERS

This course is a must for first-time Tableau users intimidated by data. Jed simplifies Tableau with step-by-step guidance: setup, import data, navigate the UI, and create visualizations. Clear, encouraging teaching—confidence transformed and ready to build. Thanks for making Tableau accessible.

”

Adam Lockwood

“EXCELLENT COURSE

Jellyman is an excellent teacher! His content is interesting, applicable and well-explained.

He has clearly thought about the way people absorb information and doesn't gloss over any assumed knowledge like many other courses do. He has taken the time to go through methods & concepts step by step so it's almost impossible not to learn! ”

Elizabeth Deterding

“AMAZING COURSE

The course is great! Feels like studying with a friend :) Everything is explained very easily and I am looking forward to the next one! ”

Anastasiia Larina

“BEST TABLEAU TRAINING EVER

Totally clear and very well explained with a bunch of examples. All sensible topics – LOD, Actions and Calculated Fields are tackled.

Big Thank You! ”

Nicolaie Cozma

“I LOVE LEARNING TABLEAU WITH JED

The best teacher of Tableau I have ever found! I would love to meet Jed someday in real life. I like his sense of humor and the way he explains everything.

Jed much thanx for this course. ”

Emilia B Korycka

“JOINS WERE HOLDING ME BACK

Great – this was holding me back but not any more ”

Brian Sundermeijer

“STILL LEARNING THINGS

I was wondering why we were just now covering joins when it's something I felt essential enough to be a beginner subject. Then you delved into joins versus relationships versus blends and it became much clearer – this was more complex than an entry level subject.

Great explanations all around and I have a better understanding of when to use which tool.

Update: Just finished LODs. Mind continues to be blown! Can't recommend this course enough. ”

Bryan Nylander

“ONE OF THE BEST EDUCATORS ON PLANET TABLEAU

Jellyman is a fantastic teacher! His lessons are unlike others to say the least!!!

Hats off to his engineering personality and his koool sense of humour (A bit of contradiction there but definitely works like magic on our memory capacity to retain his fun lessons :) ”

Jenny Wang

“AMAZING!

Take this course even if you think you're an expert in Tableau ”

Kamirah Martin

Data Analyst FAQ

Do I need prior SQL experience?

No. We start with beginner-friendly fundamentals and hands-on practice using a simple online SQL sandbox, so you can learn with no installs. Then we progress to real-world queries and best practices step-by-step.
Why are we using W3Schools and free ChatGPT?

We use W3Schools for a simple, in-browser SQL sandbox—no setup required. The free version of ChatGPT helps draft, explain, and refine queries, making learning faster and cost-free.
How does ChatGPT help with SQL?

ChatGPT can turn your questions into SQL queries, explain code step-by-step, and help you iterate quickly. You’ll still write SQL yourself to build confidence and accuracy.
What is Agile and why is it part of the course?

Agile is a project approach focused on prototyping, iteration, and feedback. It ensures your technical skills translate into real-world solutions that meet stakeholder needs effectively.
Will this course boost my career?

Yes. Combining SQL, AI acceleration, and Agile skills makes you highly valuable in today’s data-driven world. You’ll gain practical abilities employers look for in data analysts and professionals.
Do I need special software installed?

No. Everything runs online using a browser-based SQL sandbox and the free version of ChatGPT. There’s no setup required—just log in and start learning immediately.