Chapter 11. Data Modeling in Tabular

Data modeling plays a very important role in Tabular development. Choosing the right data model can dramatically change the performance and usability of the overall solution. Even if we cannot cover all the many data modeling techniques available to analytical database designers, we believe that it is important to dedicate a full chapter to data modeling to give you some information about which techniques work best with Tabular.

In the data warehouse world, there are two main approaches to the database design: the school of William Inmon and the school of Ralph Kimball. Additionally, if data comes from online transaction processing (OLTP) databases, there is always the possibility that an analytical solution ...

Get Microsoft® SQL Server® 2012 Analysis Services: The BISM Tabular Model now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.