Introduction

This is the final chapter that examines the foundations of tabular modeling (at least from the modelers point of view). The following chapters will examine the techniques used to manage the model in a corporate environment and include recipes on subjects such as data refreshes, partitioning, security, query modes, and perspectives. The final chapters will examine querying the model and creating visualizations using Power View (and the Power View settings required by the model).

In order to provide a familiar model which can be used in the later chapters, this chapter is a little different from the previous chapters because it progressively builds the model that is used throughout the rest of the book. Each recipe is intended to demonstrate a particular technique; however, they need to be followed in order so that the final model is completed. If this is not suitable, each completed recipe can also be found in the downloadable resources available on the Packt Publishing website...