DWH Tables - lucaboesch/moodle-report_datawarehouse GitHub Wiki

Documentation about the modeling of the tables inside the Data Warehouse

The tables inside the different areas of the data warehouse are modeled with purpose and they follow a logic sequence building up on each other.

In the STAGING area, the data from the quiz activity come in as large table with many rows. Then, when pulled into the following areas, the structure changes. Using the "Data vault" data warehouse modelling approach, tables for hubs, links and satellites are used. Hub tables are containing the main entities. Link tables provide the information needed to relate hubs to each others. In satellite tables, additional properties of the hub entities are saved, sometimes satellite tables can also refer to link tables.

Those are the tables in the "Cleansing" area that refer to Moodle quizzes, questions, and attempts: