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.