Blogs from Wise Owl on Tabular data models in SSAS tabular

How to crash Analysis Services (Tabular Model)

Posted by Andy Brown on 05 February 2016

It's not often you find a place to right-click which is pretty much guaranteed to crash a software package, so I thought I'd share this discovery!

A tutorial showing how to import data from Excel, Access and many other sources

Posted by Andy Brown on 04 January 2016

You can import data into tabular models from virtually any data source, as shown by this tutorial.

How to create a data model in SSAS tabular

Posted by Andy Brown on 16 November 2015

The first - and most important - part of using Analysis Services (tabular mode) is to create a data model, incuding only those tables and columns you need. This lengthy blog shows you how to go about creating the perfect data model!

Should you use tabular or multi-dimensional SSAS mode? Here's the answer!

Posted by Andy Brown on 07 November 2015

If you're building a data warehouse, you'll want to know whether you should be creating cubes using the legacy multi-dimensional Analysis Services server mode, or creating data models in the new tabular mode. This blog gives Wise Owl's take on the subject.

An explanation of how to set up and use the MAM database used by this tutorial

Posted by Andy Brown on 07 November 2015

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.