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 resourceSemantic-Modeling
SQL is not the bottleneck for most teams; understanding the data is. Why profiling and governed context must come before AI-generated models.
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 reference from solution purpose through modeling, security, refresh modes, deployment pipelines, and AI-ready semantic models for Microsoft Power BI and Fabric.
Open resourceSemantic layers are becoming the controlled, foundational “business memory” powering reliable AI decisions.
Semantic layers and knowledge graphs are not rivals: one governs metrics and repeatable numbers; the other structures entities and relationships. AI needs both …