Name: Microsoft Tabular Modeling Cookbook
Author: Paul te Braak
ISBN: 9781782170891

微信读书书城Microsoft Tabular Modeling Cookbook

首页我的书架登录

Microsoft Tabular Modeling CookbookPaul te Braak

微信读书推荐值

待评分

推荐

一般

不行

推荐

一般

不行

推荐

一般

不行

推荐

一般

不行

Microsoft Tabular Modeling Cookbook

Paul te Braak

扉页
coverpage
+书签
Microsoft Tabular Modeling Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Support files, eBooks, discount offers and more
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Chapter 1. Getting Started with Excel
Introduction
Creating the model
Managing the appearance of tables and fields
Using tabular relationships to filter data
Adding fields to tables
Linking fields between tables
Creating model calculations
Chapter 2. Importing Data
Introduction
Importing data as text
Importing data from databases
Managing connections and tables
Using data feeds
Chapter 3. Advanced Browsing Features
Introduction
Sorting data
Creating hierarchies for drilldown interaction
Summing aggregates and row iteration
Parent-child hierarchies
Creating and using Key Performance Indicators
Role playing dimensions and relationships
Building ratios
Chapter 4. Time Calculations and Date Functions
Introduction
Calculating running totals – totals to date
Month, quarter, and year to date aggregations
445 dates and irregularities
Last year and prior period values
Relative Time – pivoting around measures
Moving averages and last n averages
Chapter 5. Applied Modeling
Introduction
Grouping by binning and sorting with ranks
Defining many-to-many relationships
Using the last non-empty function for stock data
Performing currency calculations
Allocating data at different levels
Chapter 6. Programmatic Access via Excel
Introduction
Connecting pivot tables and Slicers
Using cube functions
Working with worksheet events and VBA
Managing the Slicer through VBA
Chapter 7. Enterprise Design and Features
Introduction
Restoring a workbook to Analysis Services
Importing models into SQL Server Data Tools
Developing models in SQL Server Data Tools
Securing data with roles
Implementing dynamic security
Creating perspectives
Chapter 8. Enterprise Management
Introduction
Deploying models from SSDT
Deploying models with the Deployment Wizard
Creating and managing partitions
Processing the data
DirectQuery and real-time solutions
Chapter 9. Querying the Tabular Model with DAX
Introduction
Retrieving data from a single table
Using projection to combine data from different tables
Restricting data with filters and where conditions
Deriving tables and selecting top n records
Chapter 10. Visualizing Data with Power View
Introduction
Creating a Power View report
Creating and manipulating charts
Using tiles (parameters)
Using and showing images
Automating the table fields with default field sets
Working with table behavior and card control
Using maps
Using multiples (Trellis Charts)
Appendix A. Installing PowerPivot and Sample Databases
Installing PowerPivot
Creating the database
Index

简介

版权

Microsoft Tabular Modeling Cookbook