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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.