|
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
|
0) Logical Data Warehouse
|
|
Physical Data Model
|
1) Business Data Model
|
2) Conceptual Data Model
3) Tables for Revenue KPI
|
4) Revenue Data Mart
|
5) Conceptual Bookings Data Mart
|
6) Logical Data Model for Reporting Services
|
7) Report Parameters Data Model
|
Barry Williams
Principal Consultant
Database Answers Ltd.
London, England
March 23rd. 2018
|
© Database Answers Ltd. 2017
|