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.

  1. Understanding the Make-a-Mammal database (this blog)
  2. Installing the Make-a-Mammal (MAM) database

This blog is part of our online SSAS Tabular tutorial; we also offer lots of other Analysis Services training resources.

Posted by Andy Brown on 07 November 2015

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Understanding the Make-a-Mammal database

To follow this tutorial, you should understand the main tables in the MAM (Make-a-Mammal) database. 

How the tables link to each other

Firstly, there is a geographical dimension:

Geography tables

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:

Store tables

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:

The database diagram

How the main transaction tables fit into the database diagram.

What this means in practise - a walk-through

Consider the following two rows in the transactions table tblTransaction:

Two transactions

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):

  • Two of product number 4, costing £11.04 each; and
  • Two of product 9, costing £11.16 each.

Looking at the products table (tblProduct) shows which products were bought:

The products table

Apparently this person bought 2 Crocky products and 2 Pingu ones.


Chasing through the tables gives us the animals:

The animals table

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:

The Pos table

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:

The centres table

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!

  1. Understanding the Make-a-Mammal database (this blog)
  2. Installing the Make-a-Mammal (MAM) database
This blog has 0 threads Add post