Tutorial for Hotel Reporting Services
Back to the Home Page

Here is the Azure Functional Hierarchy
which provides guidelines for the following 5 Steps


Step 1. Start with the Conceptual Data Warehouse

Data Warehouse

Step 2. Then review the Revenue Data Mart

Conceptual Data Model for Hotel Reporting Services

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