Data Warehouse Subsystems

Developing a data warehouse means assembling a lot of subsystems in order to create a whole and coherent data application.

Discovers the 34 Kimball Subsystems and drill down to discover them

Data Warehouse Subsystems

Data Processing

Data processing has changed a lot since 1940 :) and luckily, we are not using punch card anymore.

Stream processing is becoming the norm in data integration task while batch processing stays the king in data analysis.

Data Processing

Data Modeling

Data Modeling is the translation of process into the world of data. The process is tricky but not insurmountable.

Data Modeling

Dimensional Data Modeling

Dimensional Data Modeling permits you to model a (hyper)cube and analyse a process through different perspective. You define dimensions, measures and metrics.

Dimensional Data Modeling

Function

A Function is the basic block of all reusable code component. It is also becoming the central component of any serverless architecture.

Function

Actually working on …

Slow improvement is still improvement. We have worked on the following pages recently.

• CSS - Inline-Block
• CSS - (Display property|Box Type)
• Object - Constructor
• PHP - String
• SQL - Software and Database Client (Database)
• SQL - SQLLine (SQL at the command line)
• client

Table / Relation

The table format (known also as a relation) is the most important data structure used in data analysis. Did you know that its name originate from the medieval counting table ?

Table