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.
Sheets: formulas, cleanup, and explanations
Sheets plus Gemini is for explanations, cleanup plans, and validation ideas you test on a scratch tab. Implement in a copy, verify known rows, then promote. Never invent…
One local stack end to end (Ollama-style)
Pick one local stack and live in it. Three apps on three ports is a raffle, not a setup. This guide walks a 30-minute Ollama path and shows…
Quality without benchmark theater
A Slack rank is not a quality test. Run five real tasks from your week, score pass or fail, and ignore a 0.3 point LMSYS jump when the…
Docs: outline to draft with control
Docs plus Gemini stays useful when you control the path: brief, outline, section drafts, human facts, then voice edit. Placeholders beat fake precision. Humans own the byline.
Friendly desktop runners from zero
Desktop runners like Ollama and LM Studio get open weights onto a laptop. Install one app from the official site, pull one small local model, send one public…




