Course Outcomes

You now understand how to visualize, clean, and deploy data.

But Senior Analysts don’t work in Tableau alone.

They extract data using SQL, accelerate problem-solving with AI tools like ChatGPT, and deliver solutions using Agile development frameworks.

Data Analyst Essentials completes your transformation into a Modern, Senior-Level Analyst.

  • EXTRACT LARGE DATA SETS WITH SQL
    Write structured queries using SELECT, WHERE, JOIN, UNION, CASE, and AGGREGATES to retrieve and shape enterprise-scale data directly from databases.

  • ACCELERATE ANALYSIS WITH AI
    Use ChatGPT strategically to build, refine, debug, and optimize SQL queries — increasing productivity while maintaining analytical control.

  • DELIVER PROJECTS LIKE A LEAD ANALYST

    Apply Agile methodology, prioritization frameworks, and scope control to design scalable analytics solutions that align with business objectives.

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

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.

Course Curriculum

    1. Data Analyst Essentials

    2. ChatGPT Support

    1. 01_01_Introduction to the Course and W3 Schools (Link)

    2. 01_02_Role of SQL in Industry as an Analyst, Engineer, Scientist

    3. 01_03_Select Statement - Running Queries - Proper Structure

    4. 01_04_Using ChatGPT AI to Help Us (Links)

    5. 01_05_Select Start, Top Rows and Limit Function

    6. 01_06_Where Clause with AND and OR

    7. 01_07_Order By Function

    8. 01_08_Aggregate Functions

    9. 01_09_Introduction to Joins

    10. 01_10_Unions - With and Without Duplicate, SubQueries, Aliases

    11. 01_11_Case Function

    12. 01_12_Arithmetic Operators

    13. 01_13_Commentary - 2 Methods

    14. 01_14_Finish

    15. eBook Download - SQL Programming Basics for Beginners (Attachment)

    1. Introduction

    2. 01_01_What is ChatGPT - Multiple Demonstrations

    3. 01_02_How ChatGPT Works Under The Hood

    4. 01_03_Gaining Access to ChatGPT - Paid vs Free (Links)

    5. 02_01_Iteration Discussion vs Establishing Context Immediately

    6. 02_02_Explaining your Skill Level to get Better Explanations

    7. 02_03_Outlining your Needs Prior to Prompting

    8. 02_04_Analyzing your Tone - JELLYMAN CREATIVE (LINKS)

    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

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.