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
How to create a data model in SSAS tabular
Part one of a seven-part series of blogs
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!
The data model is central to everything in SSAS tabular. A data model takes information from a cube, a database or any other data source, and uses it as the basis for (usually) a pivot table in Excel:
A data model feeds off the data in a relational database, and provides the data for a pivot table in Excel.
The model we'll create in this blog will feed off the main tables in the Make-a-Mammal database (which you can view and download here):
The main tables in the underlying relational database.
This would by default give rise to a pivot table which was almost impossible to use:
This pivot table field list includes everything and the kitchen sink, so it's difficult if not impossible to pick out the fields of interest.
What we'll do is:
The result will be a model looking more like this:
This data model is much cleaner and easier to understand.
This gives a pivot table field list which is much easier to use:
Pivot tables like this are the holy grail of tabular models; there are 9 tables included from the underlying database, but only 3 tables visible in the pivot table field list.
Later on in this tutorial we'll discover that you can use the RELATED function to combine these fields into (apparently) a single table.
To create a data model, this tutorial shows how to:
We'll begin with creating a connection to your data source.
|Parts of this blog|
25 Aytoun Street