Data Mart Introduction
This page provides an overview of the different Data Marts that Daasity has designed for reporting and analysis
Overview
Our Data Marts are broken into our original reporting data model (drp) which was developed for our Growth platform where a daily workflow creates all the reporting tables in one schema and our new logic where we are developing stand-alone Data Marts for each individual reporting area
Data Reporting Platform (drp)
drp is the original reporting data model which uses the concept of data marts even though the tables are stored in a single schema. This allows us to build our visualization layer for specific user groups to ensure that a user can build reports themselves and reduce the likelihood they will get the wrong results.
For consumer brands, we construct these tables into several sections:
Visitor Traffic and Store Performance: providing the ability to understand traffic across eCommerce, Marketplace and Retail as well as conversion and site performance (eCommerce and Marketplace)
Channel and Attribution: providing the ability to understand where your customers came from and how different attribution methodologies change that
Marketing: providing the ability to understand how your acquisition marketing is performing
Orders & Revenue: providing the ability to understand the component of revenue and perform complex customer/product/order analytics
Customer & Lifetime Value: providing the ability to build customer segments and how customers perform over time
Subscription: providing the ability to understand the performance of businesses that offer subscription
Email & SMS: providing the ability to understand email/SMS performance from both an email/SMS and customer perspective
Users with access to our Customizable Business Logic feature can review our code in the following Github repositories:
Base DRP Code - Github repository with our base code
Pro DRP Code - Github repository with code specific to our enterprise transformation
Data Marts (dm)
Our new design creates stand-alone data marts that enable the transformation code to run independently and leveraging the Daasity data orchestration engine. This allows for data mart updates to run concurrently and can provide both shorter total execution time and more frequent refreshes
Similar to our original drp schema, the data mart structure enables us to build the visualization layer on top of each data mart to address specific questions related to that area.
Current data marts in production:
Staging data mart (dm_stg): a dart mart that is for temporary tables as data is processed from the normalized schemas into the final reporting schemas
Channel Attribution data mart (dm_chn): a data mart for tables that drive our Attribution dashboard and reporting
Marketing data mart (dm_mkt): a data mart for tables that drive our V3 Marketing dashboard and reporting
Users with access to our Customizable Business Logic feature can review our code in the following Github repositories:
Data Mart Code - Github repository with our Data Mart code
Last updated