The Northwind data model
Now that we downloaded the Northwind Microsoft Access database and successfully created our ODBC connection, let's have a look on the Northwind data model. We can see two main contexts in the Northwind database, as shown in the following screenshot:
The first context is related to orders, and the other one is related to inventory. We can think of context as a subject area that covers some related information stored in some related tables. Before we go deep into the Northwind data model, let's first define some terminologies that we will use.
Dimensional modeling terminologies
We have three types of information from the business ...
Get Creating Universes with SAP BusinessObjects now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
