This page has 0 threads | Add post

Blogs

Finding our blogs useful? Please consider helping us to share more!

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. Understanding the Make-a-Mammal database 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.

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.

Understanding the Make-a-Mammal database
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 July 2023

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:

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:

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:

You can also press CTRL + O to do this.

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

Choose to open this file.

Management Studio displays the script:

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

You can now execute the 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:

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:

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

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

The tables in the MAM database.

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

Parts of this blog
Understanding the Make-a-Mammal database Installing the Make-a-Mammal (MAM) database (this blog)

Some other pages relevant to the above blogs include:

This blog has 0 threads

Add a new post

Book any course as classroom, onsite or online training, or as one-to-one consultancy

Free resources

Paid services

Getting help

Where we are

Where you are

Online

Transparent reviews

Delivery of courses

Nicer to work with

Reliable and established

Our training courses

C#

Excel

MySQL

Power Apps

Power Automate

Power BI and DAX

Python

Report Builder

SQL

SQL Server

VBA Macros

Other training resources

Blogs

Exercises

YouTube tutorials

YouTube shorts

Test your skills

Consultancy

Courseware

Self-paced courses

Newsletters

Publications

Our training venues

London

Manchester

Across the UK

At your site

Online

Why we are different

Hundreds of published reviews

Small class sizes

Outstanding courseware

Online classroom

(Almost) no cancellations

Wise Owl trainers only

Genuine integrity

Invoices after training

30+ years of Wise Owl

Our top 100 clients

BLOGS BY TOPIC

BLOGS BY AUTHOR