Category: Tutorials
You are in the right place if you want a lesson you can follow, not a glossary and not a product homepage. This shelf holds most of the articles on Analytics Made Simple. Two paths sit inside it on purpose. SQL is the database path: you have rows, and you need to ask a question without exporting another spreadsheet. AI is the tool path: chat products, open-weight models, and the jobs those tools are actually good at. Other tutorials land here when they teach a skill that does not belong on a narrower shelf.
A category page is the pile. A series page is the path, with a place to start and an order. If you open a tag or page 2 of this list, you are in a filing cabinet. The lesson is the article, or the series hub that lines the articles up.
Where to start: if the pain is a table, open the SQL series and use the first part on that page. If the pain is a model name or a chat tool, open the AI category and pick the product you already have on screen. If you are not sure which job you have, open Learn and choose the track that matches the work, not the logo.
Uncertainty and confidence in plain English
Read point estimates with intervals. Confidence intervals show a range of plausible values under a model. Statistical significance is not business importance.
Retention, deletion, and we might need it someday
Treat retention as a keep, archive, or delete decision with owners and dates. Prefer delete, anonymize, or aggregate over forever. Legal holds are a different job from “we…
Evals for humans
Build human-sized evals: spot checks, golden questions, and a regression set with clear pass criteria. Score analytics outputs before fluent wrong SQL or prose becomes process.
What is a semantic layer?
A semantic layer defines metrics and terms once for many BI tools. It is not a second warehouse. Start with one certified revenue metric before you buy a…
What is dbt (conceptually)?
dbt turns SQL transforms into versioned models with tests and docs. Learn staging, intermediate, and marts so you can read a change even if you do not own…




