4-1 DATA ANALYST ESSENTIALSBuild Practical SQL, AI And Agile Skills For Real Analyst Work
4-1 · Data Analyst Essentials

Learn the Tools Behind the Analyst. Not Just the Dashboard.

You’ve learned how to work with data visually. Now build the wider skills analysts use every day —  SQL to retrieve it, AI to accelerate your work, and Agile to deliver it inside real teams. 

Data analyst working at a computer
Tableau is part of the job. Now build the skills that surround it.
🗄️ SQL Fundamentals
✨ AI-Assisted Analysis
👥 Agile Delivery
⚙️ Professional Workflow

The Dashboard Is Only One Part of the Job.  Now Learn Everything Around It. 

Professional analysts work across an entire process.  Understand the question, find the data, query it, analyse it, collaborate with others and turn the result into action. 

?
 Business Question   What are we trying to understand? 
🗄️
 Find the Data   Where does the information live? 
</>
 Query With SQL   Retrieve exactly what you need. 
✨
 Analyse + AI   Work faster and explore the answer. 
👥
 Deliver With Teams   Share, refine and collaborate. 
📊
 Business Decision   Turn analysis into action. 
YOU’RE LEARNING THE COMPLETE ANALYTICAL WORKFLOW.
SQL Fundamentals

Your Data Won’t Always Come in a Spreadsheet.  Learn How to Ask for Exactly What You Need. 

SQL lets you communicate directly with databases and  retrieve the information required to answer the business question. 

SELECT Choose what you need
FROM Find where it lives
WHERE Filter out the noise
GROUP BY Summarise the answer
ORDER BY Make the result useful

SELECT
  customer,
  SUM(revenue) AS total_revenue

FROM sales

WHERE year = 2026

GROUP BY customer

ORDER BY total_revenue DESC;
</>
 You Don’t Need to Become a Database Engineer.   You just need enough SQL to stop being dependent on one. 
Learn By Doing

No Installation. No Database Setup.  Just Start Querying. 

Use browser-based SQL exercises so you can  start writing and running queries immediately. 

SQL training exercise
THE FASTEST WAY TO UNDERSTAND SQL IS TO ACTUALLY USE IT.
AI-Powered SQL

SQL Gets You the Data.  AI Helps You Move Faster. 

Learn how ChatGPT can help you  write queries, understand unfamiliar SQL, diagnose errors and improve your existing work. 

 YOU  “Give me sales by customer for the last 12 months.”
→
 ✨   ChatGPT 
→
SELECT
  customer_name,
  SUM(sales)
FROM orders
WHERE order_date >= ...
GROUP BY customer_name;
WRITE IT
EXPLAIN IT
DEBUG IT
IMPROVE IT
AI in Modern Analytics

AI Is the Instrument.  You Are Still the Musician. 

People often say AI will replace analysts, engineers and data scientists. But that view usually underestimates  what those professionals actually do every day — and how experienced people really use AI. 

Give the same piano to a beginner and a concert pianist and you’ll hear two completely different results.  The instrument didn’t change. The person using it did. 
 Same Instrument   AI   Same capability. Completely different results. 
Inexperienced User

Twinkle, Twinkle.

AI can still produce something useful. But without experience, context or validation, its potential is limited.

Ask a generic question
Provide little business context
Accept the first answer
Limited ability to validate the result
Result  Basic Output 
Experienced Analyst

Make It Sing.

Experience changes how the analyst collaborates with the machine — and dramatically changes the quality of the result.

Gives AI the right business context
Breaks complex problems into better questions
Challenges and refines the output
Validates the logic against the data
Adds judgment, experience and business understanding
Result  Powerful Analysis 
Agile Development & Delivery

Great Analysis Still Has to Get Delivered.  This Is Where Agile Comes In. 

Learn how analytical work moves through a real team.  Agile helps you organise the work, prioritise what matters, respond to feedback and keep projects moving toward delivery. 

To Do 2
 Understand Requirements   What does the business actually need? 
 Find the Data   Identify the right sources. 
In Progress 2
 Build the Analysis   Query, explore and investigate. 
 Validate Findings   Check the logic and results. 
Review 2
 Stakeholder Feedback   Does this answer the original question? 
 Refine the Output   Improve the analysis before delivery. 
Done 3
 Publish   Put the analysis into the business. 
 Communicate   Explain what the analysis means. 
 Measure Impact   Did the work create an outcome? 
AGILE ISN’T ABOUT MOVING TICKETS ACROSS A BOARD.  IT’S ABOUT MOVING WORK TOWARD AN OUTCOME. 

Real Analytics Is Collaborative.  You’re Rarely Working Alone. 

 STAKEHOLDER  “What are we trying to understand?”
Your Role
 THE
 ANALYST 

 QUESTIONS   ↓   ANALYSIS   ↓   DECISIONS 
 DATA ENGINEER  “Where does the information live?”
 MANAGER  “What should we do next?”
 PRODUCT / OPERATIONS  “How do we make it happen?”
THE ANALYST CONNECTS THE QUESTION, THE DATA AND THE DECISION.
The Bigger Toolkit

One Analyst.  A Bigger Toolkit. 

 🗄️   SQL 

Get the data.

 ✨   AI 

Accelerate the work.

 👥   AGILE 

Deliver the outcome.


DATA ANALYST

 Tableau helps you communicate the insight. 
These skills help you operate throughout the entire analytical process.

What You’ll Be Able to Do

Finish With Workplace Capability.  Not Just Three More Tools. 

 🗄️  Query Data With SQL
 📄  Understand Existing SQL
 ✨  Use AI to Write & Debug Queries
 ⚠️  Recognise When AI Is Wrong
 👥  Work Within Agile Teams
 🎯  Turn Business Questions Into Analysis

LEARNING JOURNEY

    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

WHAT YOU’LL UNLOCK

  • 58 lessons
  • 6.5 hours of video content
  • Query Data Instantly
  • Supercharge With AI
  • Work Like Teams

Access to All Collections.
One Simple Subscription.

YOUR FIRST 7 DAYS ARE FREE

$24 USD / MONTH

Pay nothing for your first week and start exploring the content. Cancel anytime if it's not for you.

 POPULAR CLICK HERE TO START YOUR FREE 7-DAY TRIAL  
📊

Complete Tableau.

  • Tableau Desktop from Foundations to Artisan
  • Advanced Tableau techniques and custom visualisations
  • Tableau Cloud site creation, publishing, sharing and collaboration
  • Tableau Prep for cleaning, reshaping and combining data
  • Tableau Public and real portfolio builds
🤖

SQL, AI & Agile.

  • SQL fundamentals for working with corporate databases
  • ChatGPT and AI workflows for modern analyst work
  • Agile development and project delivery fundamentals
  • Learn how analysts work alongside new technology
  • Build skills designed to prepare you for the future of analytics
💼

Get Job Ready.

  • Career advice from real professional experience
  • Portfolio strategy and project selection
  • Step-by-step portfolio builds
  • Job-search strategy and finding opportunities
  • Applications, resumes and cover letters
  • Interview preparation and employment guidance
🎓

A Complete Learning Library.

  • Nearly 800 guided lessons
  • 80+ hours of training
  • Video lessons and guided walkthroughs
  • PDF downloads and reports
  • Excel and CSV files
  • Templates, briefs and practical learning materials
🧩

Practise What You Learn.

  • Quizzes to reinforce your knowledge
  • Assignments and practical challenges
  • Video walkthroughs to guide you through solutions
  • Downloadable templates
  • Datasets and downloadable assets
  • Resources designed for hands-on practice
🎁

5 Bonus Collections.

  • Data Analyst eBook
  • Resume & Cover Letter Collection
  • Tableau Workbook Collection
  • Infographic Collection
  • Practice Dataset Collection
  • Extra resources to support your learning and career
OR
WANT IT FOR LIFE?

Everything Above.
Yours Forever.

Choose the Ultimate Convenience and Become a Jellyman Member for Life. Includes Everything Above and All Future Content.

  • ALL CURRENT CONTENT
  • ALL FUTURE CONTENT
  • MEMBER FOR LIFE
  • ONE PAYMENT
  • SIMPLE
$199 USD · ONE-TIME PAYMENT   GET LIFETIME ACCESS