An explanation of how to set up and use the MAM database used by this tutorial
Part two 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
  2. Installing the Make-a-Mammal (MAM) database (this blog)

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.

Installing the Make-a-Mammal (MAM) database

This pages gives instructions on how to install the MAM database on your computer. 

This database was created by Wise Owl for private use.  Neither the database nor any part of this tutorial can be redistributed in any form whatsoever, or for any purpose, without the prior written permission of the author.   

Downloading the database

Begin by downloading the database by clicking on this link.  This will give you a zipped file.  When you double-click on this, you should see what it contains:

Extract all files

Choose to extract all of the files (there is only one!) from this zipped file. This screen dump is for Windows 7, but other Windows versions will be similar.

You'll then probably need to repeat this process to get at the actual SQL file:

The MAM SQL script

Eventually you'll be able to extract the SQL script.

Running the script

To generate the Make-a-Mammal database, you'll need to run the script you've downloaded.  In SQL Server Management Studio, choose to open a file:

Open a file

You can also press CTRL + O to do this.

Double-click on the script file you've downloaded and extracted:

The script file

Choose to open this file.


Management Studio displays the script:

Start of script

The start of the (long) script to generate the database and its tables.


You can now execute the script:

Executing script

Either click on this tool or press the F5 key.


The script will now generate the database and its tables, although this takes a while:

The script running

On my laptop this took 13 seconds, but yours may take quite a bit longer.


Viewing the database

At first sight it may seem that nothing has been created, but this may be because you haven't refreshed your databases:

Refreshing databases

Right-click on Databases and choose to refresh the list.


You can now expand the MAM database to see its contents:

Database tables

The tables in the MAM database.


You're now in a position to continue with the rest of this tutorial!


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