Database Answers Bellevue, Washington (Click for Fed Center Web Site)
Printer Printer-friendly version

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Hotel Reporting Services   

We start by designing the Conceptual Data Model, then the Bookings Data Mart to provide the data for our Bookings Reports,
and then the Logical Data Model to generate the Physical Data Model and finally the Database. Here's a short Tutorial


0) Conceptual Data Warehouse

Data Warehouse

0) Logical Data Warehouse



Physical Data Model


1) Business Data Model

Conceptual Data Model for Hotel Reporting Services

2) Conceptual Data Model

Conceptual Data Model for Hotel Reporting Services
3) Tables for Revenue KPI


4) Revenue Data Mart


5) Conceptual Bookings Data Mart


6) Logical Data Model for Reporting Services

Logical Data Model for Hotel Reporting Services

7) Report Parameters Data Model


Barry Williams
Principal Consultant
Database Answers Ltd.
London, England
March 23rd. 2018


© Database Answers Ltd. 2017
About Us Contact Us