4-1,2,3: 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.
Combine Tableau with SQL, AI and Project Management Skills and you'll be an Elite Analyst
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.
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.
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.
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.
eBook Download - SQL Programming Basics for Beginners
01_01_Introduction to the Course and W3 Schools (Link)
01_02_Role of SQL in Industry as an Analyst, Engineer, Scientist
01_03_Select Statement - Running Queries - Proper Structure
01_04_Using ChatGPT AI to Help Us (Links)
01_05_Select Start, Top Rows and Limit Function
01_06_Where Clause with AND and OR
01_07_Order By Function
01_08_Aggregate Functions
01_09_Introduction to Joins
01_10_Unions - With and Without Duplicate, SubQueries, Aliases
01_11_Case Function
01_12_Arithmetic Operators
01_13_Commentary - 2 Methods
01_14_Finish
Introduction
01_01_What is ChatGPT - Multiple Demonstrations
01_02_How ChatGPT Works Under The Hood
01_03_Gaining Access to ChatGPT - Paid vs Free (Links)
02_01_Iteration Discussion vs Establishing Context Immediately
02_02_Explaining your Skill Level to get Better Explanations
02_03_Outlining your Needs Prior to Prompting
02_04_Analyzing your Tone - JELLYMAN CREATIVE (LINKS)
03_01_Using ChatGPT to Assess our Finances and Buy a House
03_02_Computer Programming - Advanced Capabilities Demo
03_03_Using the Canvas Feature
03_04_Image Generation - Dall-E and Sora - Midjourney Sneak Peak
03_05_Custom GPTs and the GPT Store
03_06_Custom GPT Design
04_01_Finish
Introduction
01_01_Welcome to the Course - Outline, Pre Requisite Knowledge and Software
01_02_getting Started with ChatGPT and Teaching it how to Solve Problems - Uploading Structures
01_03_Uploading your Data Set - Privacy Warning
01_04_Custom GPTs to make your Life Much Easier
01_05_Problem 1 - Starting Easy. Library Data. Single and Multi Queries.
01_06_Problem 2 - Dealing with Joins. Creafting a Powerpoint Slide
01_07_Problem 3 - Analyzing More Complex Problems - Storing in Memory
01_08_Iterating your Script in Stages
01_09_Exporting Instant Reports - Using a Template
01_10_Aggregation Exercise Over Level and Year
01_11_Top Students - Regenerating the Report - Formatting the Report
01_12_Solving Problems when Data Doesn't Exist Yet
01_13_Finish
“
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.
“
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.
“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!
”
“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!
”
“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!
”
“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.
”
“JOINS WERE HOLDING ME BACK
Great – this was holding me back but not any more
”
“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.
”
“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 :)
”
“AMAZING!
Take this course even if you think you're an expert in Tableau
”
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.
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.
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.
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.
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.
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.
This is where your journey begins here at Jellyman Education. You'll get a quick feel for what Tableau is and why it's such an amazing tool.
Now that you've made it through the "Getting Started with Tableau" course, it's time to get stuck into the real training! Here you'll learn a strong foundation of tools used throughout Tableau that prepares you perfectly for the future.
Now it's getting really good! Intermediate covers everything from Data Cleansing, Project Management, Data Structure, Quick Table Calc's, Advanced Filtering and Advanced Maps. You'll be the star of the show with these skills!
You're now delving into some of the highest and most complex operations you'll find in Tableau. LOD's, Joins, Unions, Big Data, Blending, Parameters, Sets, Advanced Dashboards and Custom Visualizations. WOW INDEED!!!!
Now it's getting really fun. Think of Tableau Cloud as the digital cafe where you and your friends meet up to share stories, information, dashboards, data, results and more. It's the future of Data Sharing in the Industry today.
With Visualizations through Tableau Desktop and data sharing through Tableau Online, it's time to tackle Advanced Data Cleansing using Tableau Prep. This is one of the most enjoyable tools you'll find especially if you clean data all day long!
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.
Perfect for job seekers and freelancers—these Tableau projects help you build a standout portfolio on Tableau Public. Showcase your data skills, design thinking, and storytelling in real-world scenarios that make sharing and impressing easy.
Learn how to land your dream data analyst job with a proven system: avoid common mistakes, craft powerful applications, ace interviews and testing, and turn rejection into growth. Build confidence, skills, and a portfolio that gets you hired.