Introduction

In this chapter, you will build your first tabular model, deploy it to the Analysis Server, and then view the results with SQL Server Management Studio and Microsoft Excel. Instead of using the standard sample databases such as AdventureWorks, you will download a public dataset and then create a simple dimensional model. Once the model is completed, you will learn how to deploy the data. The recipes in this chapter cover all of the basics required to get a working model built. Each recipe builds upon information to complete the model. They should be done in order to get the best understanding.

Tabular modeling allows you to quickly take de-normalized data and turn it into a working dimensional model that makes it easy for your users to leverage. By transforming the data and creating user-friendly fields you will be able to create an easy to use reporting database. All of the recipes in this chapter are built using public vehicle crash data from the state of Iowa. Upon completion...