Tabular-Modeling-with-SQL-Server-2016-Analysis-Services-Cookbook.pdf

(24176 KB) Pobierz
Table of Contents
Tabular Modeling with SQL Server 2016 Analysis Services Cookbook
Credits
About the Author
About the Reviewer
www.PacktPub.com
Why subscribe?
Customer Feedback
Preface
What this book covers
What you need for this book
Who this book is for
Sections
Getting ready
How to do it…
How it works…
There's more…
See also
Conventions
Reader feedback
Customer support
Downloading the example code
Downloading the color images of this book
Errata
Piracy
Questions
1. Introduction to Microsoft Analysis Services Tabular Mode
Introduction
Learning about Microsoft Business Intelligence and SQL Server 2016
Understanding tabular mode
Learning what's new in SQL Server 2016 tabular mode
Modeling
Instance management
Scripting
DAX
Importing sample datasets
Getting ready
How to do it...
How it works...
Understanding basic concepts
Tables
Columns
Measures
Relationships
Hierarchies
2. Setting up a Tabular Mode Environment
Introduction
Installing and configuring a development environment
Getting ready
How to do it...
How it works...
Installing Visual Studio 2015
Getting ready
How to do it...
How it works...
Installing SQL Server Data Tools (SSDT)
Getting ready
How to do it...
How it works...
Interacting with SQL Server Data Tools
Getting ready
How to do it...
How it works...
Configuring a workspace server
Getting ready
How to do it...
How it works...
There's more...
Configuring SSAS project properties
Getting ready
How to do it...
How it works...
3. Tabular Model Building
Introduction
Adding new data to a tabular model
Getting ready
How to do it...
How it works...
Adding a calculated column
Getting ready
How to do it...
How it works...
Adding a measure to a tabular model
How to do it...
How it works...
Changing model views
How to do it...
How it works...
There's more...
Renaming columns
How to do it...
How it works...
Defining a date table
Getting ready
How to do it...
How it works...
Creating hierarchies
How to do it...
How it works...
Understanding and building relationships
Getting ready
How to do it...
How it works...
Creating and organizing display folders
Getting ready
How to do it...
How it works...
Deploying your first model
Getting ready
How to do it...
How it works...
Browsing your model with SQL Server Management Studio
How to do it...
How it works...
Browsing your model with Microsoft Excel
How to do it...
How it works...
4. Working in Tabular Models
Introduction
Opening an existing model
How to do it...
How it works...
Importing data
Getting ready
How to do it...
How it works...
Modifying model relationships
How to do it...
How it works...
Modifying model measures
How to do it...
How it works...
Modifying model columns
How to do it...
How it works...
Modifying model hierarchies
How to do it...
How it works...
There's more...
Creating a calculated table
How to do it...
How it works...
There's more...
Creating key performance indicators (KPIs)
How to do it...
How it works...
Modifying key performance indicators (KPIs)
How to do it...
How it works...
Deploying a modified model
How to do it...
How it works...
There's more...
5. Administration of Tabular Models
Introduction
Managing tabular model properties
Changing data backup locations
Changing DirectQuery mode
Changing workspace retention
Changing workspace server
Managing perspectives
Getting ready
How to do it...
Adding a new perspective
Editing a perspective
Renaming a perspective
Deleting a perspective
Copying a perspective
Managing partitions

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin