Tabular Modeling in Microsoft SQL Server Analysis Services, Second Edition

Chapter 8. The tabular presentation layer

One important consideration that is often ignored when designing tabular models is usability. You should think of a tabular model as a user interface for the data it contains. To a large degree, the success or failure of your project depends on whether your end users find that interface intuitive and easy to use.

This chapter covers several features that the tabular model provides to improve usability, such as the ability to sort data in a column and control how the measure values are formatted. It also covers perspectives, translations, and key performance indicators (KPIs). Although these features might seem less important than the ability to query vast amounts of data and perform complex calculations, ...