Tabular Modeling With SQL Server 2016 Analysis Services Cookbook by Wilson, Derek -- Read -- Imperial Library of Trantor

Index

Tabular Modeling with SQL Server 2016 Analysis Services Cookbook

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

How to do it...

Creating a Partition Editing a partition Processing partitions

How it works...

Managing roles

Getting ready How to do it...

Creating Admin role Creating a Read role Creating a read and process role Creating a process role Editing roles

There's more...

Managing server properties

How to do it...

Managing Analysis Services memory

How to do it... How it works...

6. In-Memory Versus DirectQuery Mode

Introduction

Understanding query modes Understanding in-memory mode

Advantages of in-memory Limitations of in-memory

Understanding DirectQuery mode

Advantages of DirectQuery Limitations of DirectQuery mode

Creating a new DirectQuery project

How to do it... How it works...

Configuring DirectQuery table partitions

How to do it... How it works...

Testing DirectQuery mode

How it works...

7. Securing Tabular Models

Introduction Configuring static row-level security

Getting ready How to do it... How it works...

Configuring dynamic filter security

Getting ready How to do it... How it works...

8. Combining Tabular Models with Excel

Introduction Using Analyze in Excel from SSMS

How to do it... How it works...

Connecting to Excel from SQL Server Data Tools

How to do it... How it works...

Using PivotTables with tabular data

Using Slice, Sort, and Filter How to do it... How it works...

Using the timeline filter with pivot tables

How to do it... How it works...

Analyzing data with Power View

How to do it... How it works... There's more...

Importing data with Power Pivot

Getting ready How it works...

Modeling data with Power Pivot

Getting ready How to do it... How it works...

Adding data to Power Pivot

Getting ready How to do it... How it works...

Moving Power Pivot models to the enterprise

Moving Power Pivot to SSAS via Management Studio

How to do it... How it works...

Moving Power Pivot to SSAS via SQL Server Data Tools

How to do it... How it works...

9. DAX Syntax and Calculations

Introduction Understanding DAX formulas

Getting ready How to do it... How it works... There's more...

Using the AutoSum measure in Visual Studio

How to do it... How it works...

Creating calculated measures

Getting ready How to do it... How it works...

Creating calculated columns

How to do it... How it works... There's more...

Using the IF function

Getting ready How to do it... How it works...

Using the AND function

How to do it...

Using the SWITCH function

How to do it... How it works... There's more...

Using the CONCATENATE function

How to do it... How it works... There's more...

Using the LEFT Function

How to do it... How it works... There's more...

Using the RELATED function

How to do it... How it works... There's more...

Using the RELATEDTABLE function

How to do it... How it works...

Using EVALUATE in DAX queries

How to do it...

Filtering based on a value

Getting ready How to do it... How it works...

Filtering a related table

How to do it... How it works...

Using ALL to remove filters

How to do it... How it works...

Using ALL to calculate a percentage

Getting ready How to do it... How it works...

Using the SUMMARIZE function

How to do it... How it works...

Adding columns to the SUMMARIZE function

Getting ready How to do it... How it works...

Using ROLLUP with the SUMMARIZE function

How to do it... How it works...

10. Working with Dates and Time Intelligence

Introduction Creating a date table in Visual Studio

Getting ready How to do it... How it works...

Using the CALENDAR function

How to do it... How it works...

Modifying the date table with the YEAR function

Getting ready How to do it... How it works...

Modifying the date table to include month data

How to do it... How it works... There's more...

Using the NOW and TODAY functions

How to do it... How it works...

Using the DATEDIFF function

Getting ready How to do it... How it works... There's more...

Using the WEEKDAY function

How to do it... How it works... There's more... See also...

Using the FIRSTDATE function

How to do it... How it works... There's more...

Using the PARALLELPERIOD function

How to do it... How it works... There's more...

Calculating Year over Year Growth

How to do it... How it works...

Using the OPENINGBALANCEMONTH function

How to do it... How it works...

Using the OPENINGBALANCEYEAR function

How to do it... How it works...

Using the CLOSINGBALANCEMONTH function

How to do it... How it works...

Using the CLOSINGBALANCEYEAR function

How to do it... How it works...

Using the TOTALYTD function

How to do it... How it works...

11. Using Power BI for Analysis

Introduction Getting started with Power BI desktop

How to do it... How it works...

Adding data to Power BI reports

How to do it... How it works... There's more...

Visualizing the crash data with Power BI

Getting ready How to do it... How it works...

Editing visualization properties in Power BI

Getting ready How to do it... How it works...

Adding additional visualizations to Power BI

Getting ready How it to do it... How it works...

Adding a slicer to Power BI

Getting ready How to do it... How it works...

Using analytics in Power BI

Getting ready How to do it... How it works...

← Prev
Back
Next →

← Prev
Back
Next →