A structured reference for dbt projects covering folder structure, model contracts, materialization choices, testing strategy, semantic models and metrics, dbt Mesh, SQL conventions, snapshots, and consistency for AI-assisted analytics engineering.
Open resourceResources
Original guides, templates, and downloadable files—parallel to the blog so layouts, taxonomies, and permalinks can diverge when you need them to.
A structured reference on modeling from business processes, declaring grain, avoiding fact-to-fact joins, using semantic layers as the governed interface, and when graphs complement dimensional BI.
Open resource
A structured guide to effective data visualization—defining the insight before the visual, guiding attention, choosing encodings, and presenting clearly for BI and analytics teams.
Open resource
A structured toolkit of business analytics techniques with ready-to-use Excel templates (PEST, Porter, regression, time series, scenarios, and more) for fast decision support.
Open resource
A structured reference from solution purpose through modeling, security, refresh modes, deployment pipelines, and AI-ready semantic models for Microsoft Power BI and Fabric.
Open resource