Rockshell International Ltd. Data Warehouse

Value of work completed for every GH₵1 spent. Below GH₵1.00 means the project is overspending.

Total actual cost per month, all projects

Project summary

Project

Forecast final cost minus approved budget. Positive = over budget.

CPI = earned value ÷ actual cost. Forecast final cost (EAC) = budget ÷ CPI. Status: CPI below 0.90 is Red, below 0.97 is Amber.

Share of purchase-order lines delivered on or before the promised date

How much more each supplier charges than the cheapest supplier for the same material

Rows removed, repaired or rejected during cleansing, by source system

Reconciliation checks from the latest load

Each row of the fact table is one project cost transaction. Every dimension joins directly to it, with no snowflaking.

Every report is one join away from the fact table, so it is simple and fast.
Project, supplier, material, employee, client, cost category and date are shared across all measures.
Changes to project managers and employee roles are kept as history (SCD Type 2).
Budget and actual cost sit in the same table, marked by a scenario column.
An "unknown" row (key 0) in each dimension means no fact row is lost in a join.