# Analytics Made Simple

> Plain-English data analytics, SQL, Python, and practical AI tutorials without the jargon tax. Written by Jose S for everyday practitioners, business partners, and engineers.

Analytics Made Simple (AMS) publishes in-depth, hands-on tutorials covering relational databases, SQL queries, data pipelines, analytics engineering, and applied artificial intelligence. Every guide uses real-world scenarios, concrete data examples, and visual aids to explain complex data topics clearly.

## Core Hubs

- [Learn Hub](https://analyticsmadesimple.com/learn/): Curated learning paths and structured multi-part series across SQL, Python, and modern AI tools.
- [Key Terms Glossary](https://analyticsmadesimple.com/key-terms/): Plain-English data and AI vocabulary without the jargon tax (ETL, MDM, RAG, Grain, KPIs, etc.).
- [Blog & All Tutorials](https://analyticsmadesimple.com/blog/): The chronological feed of all published data, SQL, and AI guides.
- [About the Author](https://analyticsmadesimple.com/about-me/): Background, lived practitioner experience, and editorial standards from Jose S.

## Learning Series

- [AI agents for everyone](https://analyticsmadesimple.com/series/ai-agents-for-everyone/): An agent is a chat that can take steps. Watch, approve, or walk away on purpose. Check the work without being an...
- [AI safety for everyday life](https://analyticsmadesimple.com/series/ai-safety-for-everyday-life/): Scams, deepfakes, school honesty, health and money limits, kids on shared devices, and the job skills that still matter.
- [AI setup from zero](https://analyticsmadesimple.com/series/ai-setup-from-zero/): Accounts, payments, apps, and where your files go. Start on Free. Pay on the website. One vendor at a time.
- [Airflow hello DAG](https://analyticsmadesimple.com/series/airflow-hello/): First DAG, retries, sensors, and when not to use Airflow.
- [Analyst career path](https://analyticsmadesimple.com/series/analyst-career/): IC ladder, portfolio, and storytelling toward senior trust.
- [Charts that make sense](https://analyticsmadesimple.com/series/data-viz/): Make charts that answer decisions: purpose, chart choice, honest axes, accessible color, dashboards vs slides, annotation, and chart crime fixes.
- [Customer analytics basics](https://analyticsmadesimple.com/series/customer-analytics/): Funnels, conversion math, and cohorts for product analysts.
- [Data quality for people who ship numbers](https://analyticsmadesimple.com/series/data-quality/): Hands-on data quality for analysts who ship numbers: dimensions, profiling, dedupe, standards, time, checks, and a light scorecard.
- [Data stewardship at work](https://analyticsmadesimple.com/series/data-stewardship/): A six-part series on weekly data habits: roles, catalogs, access, incidents, retention, and working with Legal and Security without panic.
- [dbt project lab](https://analyticsmadesimple.com/series/dbt-lab/): Hands-on layout, models, tests, and PR review.
- [DeepSeek from scratch](https://analyticsmadesimple.com/series/learn-deepseek/): DeepSeek is a Hangzhou lab with a free chat app and open weights. Separate the product from the files you can download.
- [Experimentation culture](https://analyticsmadesimple.com/series/experimentation-culture/): Design, guardrails, and decision reviews beyond pure stats.
- [Finance analytics for non-finance](https://analyticsmadesimple.com/series/finance-analytics/): ARR, churn, and cohort retention with careful definitions.
- [From spreadsheets to real data](https://analyticsmadesimple.com/series/spreadsheets-to-data/): Excel and Sheets habits that scale: when a file becomes a liability, real tables, keys, cleaning, clean exports, and a one-page table...
- [Geospatial for beginners](https://analyticsmadesimple.com/series/geospatial-basics/): When maps help and how to avoid misleading them.
- [GLM from scratch](https://analyticsmadesimple.com/series/learn-glm/): GLM is Zhipu's (Z.ai) family, including the GLM-5.x era. ChatGLM heritage, chat.z.ai, open weights, coding plans.
- [How data actually moves](https://analyticsmadesimple.com/series/data-pipelines/): A seven-part series for analysts who inherit pipelines: path, latency, storage homes, orchestration, dbt concepts, environments, and observability.
- [Inclusive data products](https://analyticsmadesimple.com/series/inclusive-data/): Accessibility and whose story your metrics miss.
- [Kimi from scratch](https://analyticsmadesimple.com/series/learn-kimi/): Kimi is Moonshot's assistant, famous for long context. The app, the K2/K3 weights, and what long context actually buys you.
- [llama.cpp from scratch](https://analyticsmadesimple.com/series/llama-cpp-from-scratch/): Master Georgi Gerganov's bare-metal C++ inference engine: from zero-dependency builds and GGUF model execution to local OpenAI-compatible API servers and production optimization.
- [Local LLMs from scratch](https://analyticsmadesimple.com/series/local-llms-from-scratch/): Run powerful artificial intelligence models directly on your machine with zero cloud telemetry, complete data privacy, and zero monthly subscription costs.
- [Memory, projects, and files across AI tools](https://analyticsmadesimple.com/series/ai-memory-and-files/): Chat history is not memory. Projects are not a folder. Learn where uploads go and how to turn a messy directory into...
- [Meta Llama from scratch](https://analyticsmadesimple.com/series/learn-llama/): Llama is a family of open-weight models from Meta, not a chatbot app. Map the family, the license, and when a $20...
- [Metrics that matter](https://analyticsmadesimple.com/series/metrics/): From goals to metric specs, leading signals, North Star design, incentive traps, and review meetings that actually decide something.
- [Open-source AI explained](https://analyticsmadesimple.com/series/open-source-ai-explained/): What open means for models: weights, licenses, and the homework of running things yourself. Not a free lunch.
- [OSS and open-weight model map](https://analyticsmadesimple.com/series/open-model-oss-map/): The open-weight model ecosystem decoded: foundations, fine-tunes, -Instruct variants, small edge runtimes, and practical evaluation benchmarks.
- [Power BI starter](https://analyticsmadesimple.com/series/power-bi-starter/): Model, measures, and trustworthy publish for beginners.
- [Practical AI for analytics people](https://analyticsmadesimple.com/series/practical-ai/): A nine-part series for analysts: what AI can and cannot do, tokens, prompts, evals, RAG, agents, privacy, documentation, and a personal ops...
- [Prompting for everyone](https://analyticsmadesimple.com/series/prompting-for-everyone/): Talk to AI like a clear human. Context, constraints, examples, iteration, and when to stop prompting and do the work yourself.
- [Qwen from scratch](https://analyticsmadesimple.com/series/learn-qwen/): Qwen is Alibaba's model family: chat surfaces, open weights, and a huge multilingual line. Start with the map, not the zoo.

## Featured & Recent Tutorials

- [Browser vs mobile vs desktop apps](https://analyticsmadesimple.com/tutorials/ai-setup-browser-vs-mobile-vs-desktop/): Marisol had two ChatGPT sidebars and a 14-minute Slack thread because the Mac app was signed into a personal Apple ID. Start...
- [A/B tests intuition for analysts](https://analyticsmadesimple.com/analytics/ab-tests-intuition-for-analysts/): A/B tests are not a green “ship it” button. They are a designed comparison with a unit, a metric, and a stopping...
- [AI for documentation and data dictionaries](https://analyticsmadesimple.com/tutorials/ai-for-documentation-and-data-dictionaries/): Use AI to draft data dictionary cards fast, then verify grain, formulas, owners, and sensitivity before anything is certified. Draft is cheap....
- [Grok at home, school, and work: four realistic weeks](https://analyticsmadesimple.com/tutorials/grok-family-school-work-examples/): The same Grok model can rewrite a school email and also invent a homework proof. Four realistic weeks (home, school, analyst, manager)...
- [Consumer Gemini vs Workspace Gemini](https://analyticsmadesimple.com/tutorials/gemini-product-map-consumer-vs-workspace/): Consumer Gemini and Workspace Gemini share a brand name but not the same account, admin, or data rules. Part 1 of the...
- [Cohort retention charts without lying](https://analyticsmadesimple.com/analytics/cohort-retention-charts-without-lying/): Cohort retention charts can educate or quietly sell a story. Learn axis honesty, sample size labels, period alignment, and a checklist that...
- [Privacy when pasting data into chat tools](https://analyticsmadesimple.com/tutorials/privacy-when-pasting-data-into-chat-tools/): Pastes into chat tools are processing decisions. Learn a risk ladder, what never to paste, and how synthetic samples keep AI helpful...
- [Which AI product should I try first](https://analyticsmadesimple.com/tutorials/which-ai-product-try-this-first/): A one-breath decision tree for which AI product to open: writing, coding, office files, privacy, or images and live answers. Defaults you...
- [Grok threads and projects: habits that survive a messy week](https://analyticsmadesimple.com/tutorials/grok-threads-projects-habits/): A sixty turn Grok thread that starts as a paragraph rewrite can end with payroll numbers mixed in. Name one job per...
- [When Gemini is the wrong tool](https://analyticsmadesimple.com/tutorials/learn-gemini-when-wrong-tool/): Gemini is the wrong tool for source-of-record systems, licensed advice, banned data, and unreviewed high-stakes work. Part 7 closes Learn Gemini with...
- [Observability for pipelines](https://analyticsmadesimple.com/analytics/observability-for-pipelines/): Pipelines need more than green jobs. Learn freshness, volume, schema drift, and tests on a simple red, yellow, and green board, who...
- [Agents, tools, and harnesses](https://analyticsmadesimple.com/tutorials/agents-tools-and-harnesses/): An agent with tools can query, write, and break things faster than chat alone. Part 6 of Practical AI for analytics people...
- [I want images, voice, or live answers](https://analyticsmadesimple.com/tutorials/ai-images-voice-live-answers/): You want images, voice, or live answers. This part treats pixels, microphones, and search-ish replies as different surfaces from a writing chat,...
- [Grok live answers: how to verify before you send](https://analyticsmadesimple.com/tutorials/grok-live-answers-how-to-verify/): Live Grok answers look current even when they cite a year old forum post. Treat those replies as leads: open the links,...
- [Privacy and Workspace admin basics for normal users](https://analyticsmadesimple.com/tutorials/learn-gemini-privacy-workspace-admin-basics/): Privacy for Gemini is mostly a few controls and a hard line between personal Google accounts and work Workspace seats. Part 6...
- [Working with Legal and Security without panic](https://analyticsmadesimple.com/data-management/working-with-legal-security-without-panic/): Legal and Security are teammates, not the enemy. Learn a PII sensitivity ladder, least privilege for analyst work, a calm intake card...
- [RAG in plain English](https://analyticsmadesimple.com/tutorials/rag-in-plain-english/): RAG means retrieve company docs, then ask the model with that context. Part 5 of Practical AI for analytics people explains the...
- [I care about privacy and running things myself](https://analyticsmadesimple.com/tutorials/ai-privacy-run-it-yourself/): You care about privacy or running things yourself. This part splits closed chat apps, hosted open models, and local runners, and it...
- [Grok for writing, explaining, and brainstorming](https://analyticsmadesimple.com/tutorials/grok-writing-explaining-brainstorming/): Grok can draft, explain, and brainstorm faster than you can type. This tutorial gives you three jobs, prompt ingredients you still own,...
- [Photos, screenshots, PDFs, and multimodal basics](https://analyticsmadesimple.com/tutorials/learn-gemini-photos-screenshots-pdfs-multimodal/): Photos, screenshots, and PDFs make Gemini feel magical and easy to overtrust. Part 5 gives structured prompts, a safe upload ladder, and...

## Complete Documentation

- [Full Index](https://analyticsmadesimple.com/llms-full.txt): Comprehensive markdown index of all published tutorials, guides, and lessons.