Time for spring cleaning in the Data Mart?
The Domo Governance and Data Stats tools can certainly help identify where the problem areas are, or which assets are going unused; however, the first step to rationalizing your Domo data mart is creating a best-practices model for where and how to name or transform datasets. At Onyx Reporting, our consultants align dataset naming conventions recommended in Domo's consulting methodology with conventional wisdom espoused in traditional BI strategy.
In this blog post we'll cover 15 tips for managing your RAW, INT, PROD and STACK dataflows.
Build Dashboard Specific Datasets
In a traditional data mart implementation, central BI will define views that combine fact and dimension tables into a format ready for consumption in applications and reports. In Domo, we deliver a similar experience through STACKed datasets.
One dashboard could have many datasets powering individual cards; however, to engender data trust and assurance, we endeavour to build each dashboard off one STACK dataset—wherein multiple PROD (production) datasets have been UNIONed into a tall sparsely-populated table.
Build re-useable stand-alone Production Datasets
Produce a PROD (production) version of each dataset before consuming it in a STACK. Onyx Reporting recommends Kimball's fact table modelling guidelines as a baseline for table design.
Stage data in Intermediate Dataflows
While staging data, do the minimum work necessary to produce a clean stand-alone (PROD) dataset.
Capture RAW data
To facilitate validation against source PaaS and SaaS systems and provide long term flexibility, when possible accumulate a RAW dataset that avoids unnecessary data transformation during ingestion.
Go Big. Do More. WithLess.
With proper governance tools, consistent ETL design practices and a little automation, central BI teams can use Domo to roll-out or augment a hybrid data lake, warehouse or data mart strategy that scales without a linear investment in data administration.
Consider augmenting your Domo Stats page to identify unused
With experience accumulated during the roll-out of 30+ Domo projects and decades of experience implementing reporting and BI solutions, Onyx Reporting is well situated to service and support your organization during your journey. Contact us to schedule a call.