O'Reilly logo

Tabular Modeling with SQL Server 2016 Analysis Services Cookbook by Derek Wilson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Importing sample datasets

For the examples in this chapter you will import two sets of data to create tables inside the model. This first table is a list of all states in the United States plus the District of Columbia. The second data set is a short list of famous landmarks.

Note

These examples are available at https://github.com/derekewilson/SSAS_2016_Tabular_Model.

Getting ready

This example assumes you have a working tabular mode server and SQL Server Data Tools installed.

How to do it...

  1. Open Visual Studio, select File and then New Project.
  2. On the next screen select Analysis Services Tabular Project to create a new Analysis Service tabular project.

  3. Select Model from the menu and Import from Data Source.

  4. Select Excel File from the bottom of the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required