560 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
An explanation of how to set up and use the MAM database used by this tutorial
Part one of a two-part series of blogs
Our tutorial on using tabular model (Analysis Services) is based on our Make-a-Mammal database. This blog shows how to install this database, and how to understand the tables and relationships that it contains.
To follow this tutorial, you should understand the main tables in the MAM (Make-a-Mammal) database.
Firstly, there is a geographical dimension:
The Make-a-Mammal or MAM chain of stores categorises its 13 products into 8 animals and 4 species.
Purchases are also categorised by where they took place:
Geographically, the MAM chain is split by quadrant (not shown here), region, town, shopping centre and then store.
Here's a diagram of these tables joined with the transactions and point-of-sale tables:
How the main transaction tables fit into the database diagram.
Consider the following two rows in the transactions table tblTransaction:
These two transactions are for the same point-of-sale record (number 36779).
You can see from this that someone bought (as part of the same point-of-sale visit 36779):
Looking at the products table (tblProduct) shows which products were bought:
Apparently this person bought 2 Crocky products and 2 Pingu ones.
Chasing through the tables gives us the animals:
Product 9 (Pingu) is - unsurprisingly - a penguin, and product 4 (Crocky) is (equally unsurprisingly) a crocodile.
You could now follow the Pos table row to find out the store number:
These items were bought in store number 2, and the person was served by staff number 3369.
You could then find from this in which shopping centre the transaction took place:
Store 2 turns out to be in store A of the Times Square shopping centre.
You could then follow the trail to find out that this is in town number 170 (Sutton) in region 3 (London).
Although it's perhaps a tad late to say this, to anyone with an understanding of relational databases the above was probably pretty obvious!
|Parts of this blog|
25 Aytoun Street