Self-service BI works when the data foundation removes friction for business users. Our reusable dimensional framework gives you trusted definitions, “as-was” and “as-is” choices, foolproof joins, and upstream data quality checks, so teams can explore confidently without hand-coding SQL or exporting to Excel (or god help us all MS Access).

Dive deeper into how we leverage the extensibility features of the DbSchema Data Modeling Tool. Specifically, we’ll show how to design a dimensional model and generate DDL that directly integrates with Mugnano Data Consulting’s dimension utility functions

This post introduces DbSchema, a data modeling tool I found effective for Greenplum. I’ll show how I worked with the vendor to make Greenplum a first-class citizen in the platform, supporting logical and physical design as well as DDL generation.