Property-management platforms provide rich APIs, but inconsistent schemas make analytics difficult. The real work is standardizing REST, JSON, and CSV feeds into a clean Type-2 dimensional model that supports KPIs and compliance reporting.

Mugnano Data Consulting’s demo pipeline shows how this can be done automatically with minimal custom code.

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.