Insights for the Rest of Us

Analytics and AI without the intimidation. Plain-language guides to SQL, data work, and practical AI — examples you can use at work, a little humor, no PhD required.

Explore learning

Etsy store

Start here

Series & guides
Step-by-step paths you can follow

Key Terms
Data & AI vocabulary on one page

All articles
Browse, search, and filter the library

Latest posts

All articles →

Key Terms · Tutorials · 9 min read

What is a semantic layer?

A semantic layer is the shared business meaning of metrics and dimensions above raw tables. Learn how it stops three versions of revenue, where it sits in the stack, and how it differs from a warehouse or a BI-only calculated field.

Analytics, Leadership
August 30, 2026
Building a portfolio that gets interviews
Pretty dashboards do not get interviews. Part 2 of Analyst career path shows a portfolio path from question to decision writeup, plus…
Analytics, Tutorials
August 30, 2026
What is dbt (conceptually)?
dbt is not magic BI. This guide explains SQL models, tests, and docs, plus staging, intermediate, and marts layers, so analysts who…
AI, Tutorials
August 30, 2026
I want AI on my files and office work
You want AI on files, mail, and office work. This part maps Claude Cowork, ChatGPT Work, Gemini in Workspace, and Grok in…
AI, Tutorials
August 30, 2026
Gemini app and web: first 30 minutes
A timed first thirty minutes in the Gemini app and web: confirm your account, run one real low-risk task, revise once, and…