Chapter 3. Tabular Model Building
In this chapter, we will cover the following recipes:
- Adding new data to a tabular model
- Adding a calculated column
- Adding a measure to a tabular model
- Changing model views
- Renaming columns
- Defining a date table
- Creating hierarchies
- Understanding and building relationships
- Creating and organizing display folders
- Deploying your first model
- Browsing your model with SQL Server Management Studio
- Browsing your model with Microsoft Excel
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 ...
Get Tabular Modeling with SQL Server 2016 Analysis Services Cookbook 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.
