Author: admin
-
Model in SqlDBM, build in dbt: Methods and tools of scalable data pipelines
Ask a data team where their data model lives, and you’ll often hear a confident answer: “we model in dbt.” As a long-time user and fan, I understand where that confidence comes from. Dbt brought version control, testing, and modularity to data transformation and earned its place at the center of the modern stack. Yet many…
-
From No Model to AI Context Layer: The Data Modeling Maturity Ladder
“Only when the tide goes out do you discover who’s been swimming naked.“ – Warren Buffet AI is not the tide. It is the flood that exposes the gap that humans have quietly been papering over for decades. Unlike humans, AI can’t ask a colleague, call a meeting, or force two teams to resolve a…
-
Why AI Projects Fail Without Data Modeling
Data now flows through dozens of systems: operational platforms, warehouses, lakehouses, pipelines, dashboards, and AI systems. Shared understanding of data meaning, established through proper data modeling, has become essential for AI reliability.
-
SqlDBM Copilot: Embedded AI for Modern Data Modeling
An AI assistant integrated directly into the data modeling workflow that transforms natural language requirements into data models while automating documentation and governance tasks across enterprise teams.
-
The ROI of Data Modeling – Speaking to the C-Suite Using Business Metrics
Data modeling has traditionally been viewed as a technical burden that slows delivery, but it actually represents a strategic tool for driving operational efficiency and reducing costs, yielding nearly 30x ROI.
-
Conceptual, Logical, Physical Data Modeling — What’s the Difference?
Data modeling progresses through three layers (conceptual, logical, physical) each translating business meaning into increasingly concrete database structures, with a fourth transformational layer capturing analytical reshaping.