SQL is not the bottleneck for most teams; understanding the data is. Why profiling and governed context must come before AI-generated models.
Semantic Stack
A technical blog about semantic modeling, dbt architecture, and AI-assisted analytics engineering. Read practical guides, grab templates from the resources hub, and use Semantic Explorer for private browser data analysis.
Featured Blog Posts
Semantic 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 …
Featured resources
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 resource
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 resourceTools
Semantic Explorer (Beta)
Private in-browser exploration powered by DuckDB WASM with automated profiling, join safety checks, and context exports for dbt and AI coding assistants. Beta release, work in progress.
- Zero upload architecture for sensitive datasets
- Profiling, join coverage, fanout, orphan, null, duplicate, and type signals
- Explore through UI, custom SQL, or AI-assisted query generation
- Export analysis artifacts, modeling notes, and dbt YAML context packages
Semantic Explorer Pro (Planned)
DuckDB WASM edition with project save and reopen, scaled file handling through loading and partitioning optimizations, and data from URLs and cloud buckets (S3-compatible, Azure Blob, and similar).
- Save and open projects: store configurations and resume analysis after the browser closes.
- Larger and multi-file workflows: optimized ingestion and partitioning-oriented strategies in the browser.
- Remote sources: HTTPS URLs and object storage such as S3-compatible buckets and Azure Blob.
[Ad Space — Insert ad script here]