Tutorial for Hotel Reporting Services
Back to the Home Page


Step 1. Start with the Conceptual Data Warehouse

Data Warehouse

Step 2. Then review the Revenue Data Mart


Step 3) Conceptual Data Model
This is a general Approach to defining Dimensional Reports

Conceptual Data Model for Hotel Reporting Services

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




© Database Answers Ltd. 2017