Microsoft Tabular Modeling Cookbook电子书

Microsoft Tabular Modeling Cookbook

Table of Contents

Microsoft Tabular Modeling Cookbook

Credits

About the Author

About the Reviewers

www.PacktPub.com

Support files, eBooks, discount offers and more

Why Subscribe?

Free Access for Packt account holders

Instant Updates on New Packt Books

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Downloading the example code

Errata

Piracy

Questions

1. Getting Started with Excel

Introduction

Creating the model

Getting ready

How to do it…

How it works…

There's more…

Managing the appearance of tables and fields

Getting ready

How to do it…

How it works…

There's more…

Using tabular relationships to filter data

Getting ready

How to do it…

How it works…

There's more…

Adding fields to tables

Getting ready

How to do it…

How it works…

Linking fields between tables

Getting ready

How to do it…

How it works…

Creating model calculations

Getting ready

How to do it…

How it works…

There's more...

2. Importing Data

Introduction

Importing data as text

Getting ready

How to do It…

How it works…

There's more...

Importing data from databases

Getting ready

How to do It…

How it works…

There's more...

Managing connections and tables

Getting ready

How to do it…

How it works…

There's more...

Using data feeds

Getting ready

How to do it…

How it works…

There's more...

3. Advanced Browsing Features

Introduction

Sorting data

Getting ready

How to do it…

How it works…

Creating hierarchies for drilldown interaction

Getting ready

How to do It…

How it works…

There's more...

Summing aggregates and row iteration

Getting ready

How to do it…

How it works…

There's more…

Parent-child hierarchies

Getting ready

How to do It…

How it works…

There's more…

Creating and using Key Performance Indicators

Getting ready

How to do It…

How it works…

There's more...

Role playing dimensions and relationships

Getting ready

How to do it…

How it works…

There's more…

Building ratios

Getting ready

How to do It…

How it works…

There's more…

4. Time Calculations and Date Functions

Introduction

Calculating running totals – totals to date

Getting ready

How to do it...

How it works…

Month, quarter, and year to date aggregations

Getting ready

How to do it…

How it works…

There's more…

445 dates and irregularities

Getting ready

How to do it...

How it works...

Last year and prior period values

Getting ready

How to do it…

How it works…

There's more…

Relative Time – pivoting around measures

Getting ready

How to do it...

How it works…

Moving averages and last n averages

Getting ready

How to do it...

How it works…

There's more…

5. Applied Modeling

Introduction

Grouping by binning and sorting with ranks

Getting ready

How to do it…

How it works…

Discretizing sales

There's more...

Defining many-to-many relationships

Getting ready

How to do it…

How it works…

Using the last non-empty function for stock data

Getting ready

How to do it…

How it works…

Performing currency calculations

Getting ready

How to do it…

How it works…

Allocating data at different levels

Getting ready

How to do it…

How it works…

There's more...

6. Programmatic Access via Excel

Introduction

Connecting pivot tables and Slicers

Getting ready

How to do it…

How it works…

There's more...

Using cube functions

Getting ready

How to do it…

How it works…

Working with worksheet events and VBA

Getting ready

How to do it…

How it works…

There's more...

Managing the Slicer through VBA

Getting ready

How to do it…

How it works…

There's more...

7. Enterprise Design and Features

Introduction

Restoring a workbook to Analysis Services

Getting ready

How to do it…

How it works…

There's more...

Importing models into SQL Server Data Tools

Getting ready

How to do it…

How it works…

There's more...

Developing models in SQL Server Data Tools

Getting ready

How to do it…

How it works…

There's more...

Securing data with roles

Getting ready

How to do it…

How it works…

There's more...

Implementing dynamic security

Getting ready

How to do it…

How it works…

Creating perspectives

Getting ready

How to do it…

How it works…

There's more...

8. Enterprise Management

Introduction

Deploying models from SSDT

Getting ready

How to do it…

How it works…

Deploying models with the Deployment Wizard

Getting ready

How to do it…

How it works…

There's more...

Creating and managing partitions

Getting ready

How to do it…

How it works…

There's more...

Processing the data

Getting ready

How to do it…

How it works…

DirectQuery and real-time solutions

Getting ready

How to do it…

How it works…

9. Querying the Tabular Model with DAX

Introduction

Retrieving data from a single table

Getting ready

How to do it…

How it works…

There's more...

Using projection to combine data from different tables

Getting ready

How to do it…

How it works…

There's more...

Restricting data with filters and where conditions

Getting ready

How to do it…

How it works…

There's more...

Deriving tables and selecting top n records

Getting ready

How to do it…

How it works…

There's more...

10. Visualizing Data with Power View

Introduction

Creating a Power View report

Getting ready

How to do it…

How it works...

There's more...

Creating and manipulating charts

Getting ready

How to do it…

Using tiles (parameters)

Getting ready

How to do it…

How it works...

There's more...

Using and showing images

Getting ready

How to do it…

There's more...

Automating the table fields with default field sets

Getting ready

How to do it…

Working with table behavior and card control

Getting ready

How to do it…

How it works...

Using maps

Getting ready

How to do it…

How it works...

There's more...

Using multiples (Trellis Charts)

Getting ready

How to do it…

How it works...

There's more...

A. Installing PowerPivot and Sample Databases

Installing PowerPivot

Creating the database

Index