Why Data Modelling Matters in Power BI
As part of my Retail Business Performance Analysis project, I created relationships between four tables: Raw Data, Customer Master…Continue reading on Medium »
As part of my Retail Business Performance Analysis project, I created relationships between four tables: Raw Data, Customer Master…Continue reading on Medium »
Discover how to design, test, and optimize models in Tableau Semantics. Learn how to structure models for max query speed, governance, and enterprise scale.
Configuration-driven reporting: one semantic model, one metric catalog, and a few lines of configuration per audience The post How to Report for 100+ Clients With One Semantic Mode...
As agents build data systems, models must help us understand the decisions behind them.
erwin Data Modeler has been a fixture in enterprise data teams for decades, but a lot of the shops I've talked to recently are quietly looking for the exit. The desktop-first workf...
Financial modeling is an essential component of what you do in finance and banking in particular. In fact, during the first several years of your work, it may be all you do. Given...
Many of the most valuable predictive machine learning applications rely on tabular data...
Data warehouse design sits at the intersection of storage efficiency and query performance, and the... The post Snowflake Schema Complexity: Normalizing Dimension Tables to Reduce...
MySQL can now hand your application a complete JSON document, such as an order with its customer and line items, while the data stays in normal relational tables. You can even send...
A CRM that can’t model your agency’s real entities will always be something you work around. You won’t fix that by adding more fields or coming up with cleverer tags, because the p...
When agents answer the questions, they can maintain the data model. Here is what that demands from the orchestration engine.
Disclosure: I build Schemity, a desktop ERD tool - this post is from our blog and uses it for the examples. TL;DR: We put two Snowflake schemas through Schemity, TPC-DS as Snowfl...
(This is the third post in a three-part series on how AI is changing the way we build solutions in Microsoft Fabric. The first post explored how the new... The post Using AI to Bui...
A few years back, I sat through a production incident review where the root cause turned out to be a single stored procedure nobody on the team had touched in four years. The origi...
Learn how to evaluate enterprise data lineage platforms by comparing integration capabilities, transformation visibility, governance requirements, lineage quality, and total cost o...
The third post in our semantic-layer series builds a governed customer 360 model on Amazon Redshift with AtScale, then exposes it to a Strands agent on Amazon Bedrock AgentCore thr...
Data Integration: An Enterprise Framework for Connecting Data Across Systems Data integration is the architecture that allows information to move between the systems that create, p...
Most semantic layers come with a great declarative modeling language to define metrics and measures well1, but very soon after, you start building wrappers around the semantic laye...
Most semantic layers come with a great declarative modeling language to define metrics and measures well1, but very soon after, you start building wrappers around the semantic laye...
A Field guide for data leaders
Ever wondered why some interfaces feel effortless: like they already know what you’re trying to do, while others leave you guessing? The difference often lies in how well a product...
Use SocialBu to discover ideas, generate post drafts, and schedule them across your social channels.