Analytics Made Simple

Learn

Step-by-step guides for SQL, tools, and practical AI — skills you can use at work. Learn by doing, not by jargon.

Series

Step-by-step paths grouped by topic. Start at part 1 and work through at your pace.

Foundations

How analytics works and how everyday data becomes structured.

Series From spreadsheets to real data Excel and Sheets habits that scale: when a file becomes a liability, real tables, keys, cleaning, clean exports, and a one-page table contract. 6 parts · View series → Series Analytics foundations Questions before data — learn to define the problem so every chart and query actually helps someone decide. 5 parts · View series →

Core skills

SQL, Python, data quality, charts, and metrics — skills you reuse everywhere.

Series Charts that make sense Make charts that answer decisions: purpose, chart choice, honest axes, accessible color, dashboards vs slides, annotation, and chart crime fixes. 7 parts · View series → Series Data quality for people who ship numbers Hands-on data quality for analysts who ship numbers: dimensions, profiling, dedupe, standards, time, checks, and a light scorecard. 7 parts · View series → Series Metrics that matter From goals to metric specs, leading signals, North Star design, incentive traps, and review meetings that actually decide something. 6 parts · View series → Series SQL series Step-by-step SQL — from playground setup through joins, subqueries, and optimization. 14 parts · View series → Series Python for analytics Clean data, explore with pandas, and turn notebooks into reusable analysis you can trust at work. 12 parts · View series →

Data at work

Pipelines, stewardship, and how data moves through real teams.

Series Data stewardship at work A six-part series on weekly data habits: roles, catalogs, access, incidents, retention, and working with Legal and Security without panic. 6 parts · View series → Series How data actually moves A seven-part series for analysts who inherit pipelines: path, latency, storage homes, orchestration, dbt concepts, environments, and observability. 7 parts · View series →

AI fundamentals

Practical AI for everyday work — product-agnostic judgment and workflows.

Series Practical AI for analytics people A nine-part series for analysts: what AI can and cannot do, tokens, prompts, evals, RAG, agents, privacy, documentation, and a personal ops checklist. 9 parts · View series →

AI products

One complete path per brand — first login through deep tools.

Anthropic Claude Anthropic Claude from first login through product map, Claude Code, and Cowork — one continuous path. 31 parts · View series → OpenAI ChatGPT OpenAI ChatGPT from everyday chat through product map, Work mode, Codex, and Custom GPTs — one continuous path. 30 parts · View series → Google Gemini Google Gemini from first login through product map, Workspace, and coding surfaces — one continuous path. 26 parts · View series → xAI Grok xAI Grok from first login through everyday use, Grok Build, and Imagine — one continuous path. 7 parts · View series →

Analytics practice

Stats, experiments, customer and finance analytics, and career paths.

Series Analyst career path IC ladder, portfolio, and storytelling toward senior trust. 3 parts · View series → Series Customer analytics basics Funnels, conversion math, and cohorts for product analysts. 3 parts · View series → Series Experimentation culture Design, guardrails, and decision reviews beyond pure stats. 3 parts · View series → Series Finance analytics for non-finance ARR, churn, and cohort retention with careful definitions. 3 parts · View series → Series Geospatial for beginners When maps help and how to avoid misleading them. 2 parts · View series → Series Inclusive data products Accessibility and whose story your metrics miss. 2 parts · View series → Series Statistics for analysts Bias, sampling, uncertainty, and A/B intuition without the math degree. 4 parts · View series →

BI & workflow tools

Hands-on starters for Power BI, dbt, Airflow, and similar tools.

Series Airflow hello DAG First DAG, retries, sensors, and when not to use Airflow. 2 parts · View series → Series dbt project lab Hands-on layout, models, tests, and PR review. 3 parts · View series → Series Power BI starter Model, measures, and trustworthy publish for beginners. 3 parts · View series →