Data Modeling is a methodology for standardizing business metrics.
This can mean different things, to different people, but at Hashboard, it was a way for us to understand our customer’s data. Practically, this meant we needed to understand how to build visualizations from data tables.
Diagram shows, at a high level, how the platform conceptualizes a data model. Data is ingested from a source, transformed, then displayed for self-service.
In order for Hashboard to know what to plot and on which axis, we needed to create a tool that allowed customers to set their metrics, define how they were aggregated, and then decide how those visualizations could be filtered or grouped.
Metrics determine how data is aggregated and Attributes determine how the data is grouped and filtered.
Table columns are mapped to either a metric or an attribute.
Data models in hashboard are the center for collaboration
Effective collaboration hinges on good data modelling. Data models are the founding structure of the metrics organizations care about and allow analysts to ensure standardization and transparency.