Skip to content

Data structure

layered data-engineering convention

layeded data engineering

Folder in data Description
raw initial start of the pipeline, containing the sourced data model(s) that should never be changed, it forms your single source of truth to work from. these data models are typically un-typed in most cases e.g. csv, but this will vary from case to case
intermediate optional data model(s), which are introduced to type your raw data model(s), e.g. converting string based values into their current typed representation
primary domain specific data model(s) containing cleansed, transformed and wrangled data from either raw or intermediate, which forms your layer that you input into your feature engineering
feature analytics specific data model(s) containing a set of features defined against the primary data, which are grouped by feature area of analysis and stored against a common dimension
model input analytics specific data model(s) containing all feature data against a common dimension and in the case of live projects against an analytics run date to ensure that you track the historical changes of the features over time
models stored, serialised pre-trained machine learning models
model output analytics specific data model(s) containing the results generated by the model based on the model input data
reporting reporting data model(s) that are used to combine a set of primary, feature, model input and model output data used to drive the dashboard and the views constructed. it encapsulates and removes the need to define any blending or joining of data, improve performance and replacement of presentation layer without having to redefine the data models

References