📖 Knowledge Base & Tutorials

All Articles & Tutorials

Explore practical guides, step-by-step masterclasses, and foundational definitions across AI, SQL, and data systems — written in plain, human English.

🎓 Looking for structured masterclasses?

Explore our newly reorganized 5 Learning Tracks (Core Analytics, Everyday AI, AI Platforms, AI Engineering, and Data Systems) on the Learn Hub.

Explore 5 Tracks ➔

Showing 5 articles

Analytics, Tutorials
Python for analytics · Part 6
August 6, 2026
12 min read
Joins and merges in plain English
Learn how pandas merges map to SQL joins, when row counts explode, and how to check keys with validate and indicator. A customers-and-orders walkthrough keeps grain honest before…
By Jose S
AI, Tutorials
ChatGPT · Part 12
August 5, 2026
18 min read
API and builders’ tools (light)
Part 4 closes the ChatGPT product map: ChatGPT Plus or Pro is not free unlimited API. Open platform.openai.com only if you build software that calls models. Most AMS…
By Jose S
AI, Tutorials
Claude · Part 12
August 5, 2026
14 min read
Claude Design and Claude Science (where they fit)
Claude Design handles visual work (decks, mockups, prototypes, brand systems, exports). Claude Science is a research workbench with tools, compute, and auditable artifacts, not peer review. Part 4…
By Jose S
Analytics, Tutorials
Python for analytics · Part 5
August 5, 2026
10 min read
Aggregations and groupby
Learn pandas groupby as split-apply-combine, the same idea as SQL GROUP BY. Build sum, mean, count, and multi-metric aggregations, with a clear sales-by-region before and after table example.
By Jose S
AI, Tutorials
ChatGPT · Part 11
August 4, 2026
17 min read
Models chooser in plain English
Part 3 of the ChatGPT product map: Instant, reasoning, Pro tiers, and Work or Codex models without FOMO. Start on the default, upgrade only when a clear prompt…
By Jose S