Step 1. Start with the Conceptual Data Warehouse
Step 2. Then review the Revenue Data Mart
Step 3) Conceptual Data Model
This is a general Approach to defining Dimensional Reports
Step 4. Tables for Revenue KPI
Here we populate a KPI that tracks Daily Revenue per Room.
Step 5. Here we show Daily Revenue for the period
from Jan 3rd to Jan 8th for the KPI