The first course in Ahjayee's data analysis learning pathway.
Stop guessing. Learn how to answer real business questions with data — correctly — using spreadsheets and SQL. No dashboards, no machine learning, no fluff. Just the foundations that hold up at work.
By the end of 8 weeks, you'll be able to:
About This Course
Who This Is For
You work with numbers — revenue, costs, performance — and want answers you can actually defend.
You're starting your career and want practical data skills employers ask for, not just theory.
Moving into analytics from another field? Learn the fundamentals without drowning in jargon.
You have data but don't know what questions to ask. Learn to extract answers that drive decisions.
What This Course Is Not
Most beginner courses try to cover everything and end up teaching nothing well. This course has a clear ceiling — and that's the point.
Those come later. Get the foundations right first.
You'll never touch a neural network here.
Charts support analysis — they don't replace it.
We prioritise correctness and clear thinking. Slides come later.
The Curriculum
Each week answers one core question. No fluff, no filler. You'll learn spreadsheets and SQL as tools for structured thinking — not as ends in themselves. Each week unlocks as you complete the previous one.
Week 1
What kinds of questions can data actually answer? Tables, rows, columns. Metrics vs dimensions. Good vs bad analytical questions. No tools yet — just thinking discipline.
Week 2
How do we reliably get numbers from a table? Spreadsheets as visual databases. Sorting, filtering, counting correctly. Your first formulas and charts.
Week 3
Why do 'correct' methods still produce wrong answers? Duplicates, missing values, inconsistent text. Cleaning rules as decisions, not guesses.
Week 4
How do we ask precise questions of a database? SELECT, FROM, WHERE. SQL as spreadsheet logic written down.
Week 5
How do we move from rows to summaries? COUNT, SUM, AVG, GROUP BY. What summaries actually mean — not just how to compute them.
Week 6
Why is related data stored in multiple tables? Primary keys, foreign keys, INNER JOIN vs LEFT JOIN. The hardest conceptual leap — we take it slowly.
Week 7
How do we express conditions and logic in queries? CASE statements, DISTINCT, subqueries. Step-by-step query building for real questions.
Week 8
Can you independently answer real business questions? 10 structured questions, each answered with SQL. We test execution and correctness, not polish.
What You Get
Short, focused videos you can watch at your own pace, on your own schedule.
Supporting materials and exercises to reinforce each concept.
SQLite database built specifically for learning, with realistic business data.
Weekly MCQs and numeric exercises with instant feedback.
Hands-on query exercises, auto-graded so you know immediately if you're right.
Open Q&A session every week — come with any question, open to all.
10 real business questions answered with SQL. 70% to pass.
Proof of completion to share with employers.
Your Instructor
Fractional CTO & Data Analytics Consultant
I spent 20+ years building data and analytics systems at Barclays, CITI, Deutsche Bank, and BNP Paribas — environments where understanding both technical constraints and business requirements wasn't optional. Now I bring that same rigour to startups, scaleups and medium sized businesses.
I wrote "No One Cares About Dashboards" (Selar · Amazon UK) because I got tired of seeing analysts focus on pretty charts instead of insights that drive decisions. This course is the practical foundation I wish I'd had when starting out.
LinkedInComplete 8-week self-paced programme
You'll receive your login details immediately after payment.
Training a team? Email us for group enrolment — discounts available for 5+ seats.
Questions
No. This course is designed for absolute beginners. If you can use a computer and follow instructions, you're ready.
Microsoft Excel (or Google Sheets) and a web browser. For SQL you'll run queries in-browser using the course workspace — no database installation required.
Plan for 4–6 hours per week. This includes watching lessons, completing quizzes and SQL labs, and attending optional office hours. It's designed to fit around a job.
Office hours run weekly and are open to everyone — students and non-students alike. Details are shared after enrolment. Sessions are recorded if you can't attend live.
Immediately after payment. You'll receive an email with your login details within minutes of enrolling.
You need at least 70% on the Week 8 capstone — 10 business questions answered with SQL. The quizzes throughout are for your learning; only the capstone is graded for certification.
There's no deadline. Work through the material at whatever pace suits your schedule. Most students complete it in 8–12 weeks.
The Learning Path
Data Analysis Foundations is a complete programme on its own. It is also the first step in a structured learning path for working professionals.
Step 1 — Now
Spreadsheets + SQL for correct answers and disciplined thinking.
Step 2
Q2 2026Advanced SQL, Python, APIs, and statistical thinking.
Step 3
Q2 2026Experimentation, production systems, and leading analytics work.
Focus on Foundations first. Master the basics, then advance when you're ready.