| Description |
1 online resource |
| Contents |
Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; 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 interactionSumming 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 ranksDefining 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 rolesImplementing 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 |
|
IntroductionCreating 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: Installing Power Pivot and Sample Databases; Installing Power Pivot; Creating the Database; Index |
| Summary |
This book follows a cookbook style with recipes explaining the steps for developing analytic data using Business Intelligence Semantic Models. This book is designed for developers who wish to develop powerful and dynamic models for users as well as those who are responsible for the administration of models in corporate environments. It is also targeted at analysts and users of Excel who wish to advance their knowledge of Excel through the development of tabular models or who wish to analyze data through tabular modeling techniques. We assume no prior knowledge of tabular modeling |
| Notes |
English |
|
Print version record |
| Subject |
Client/server computing.
|
|
Database management.
|
|
Relational databases.
|
|
Client/server computing
|
|
Database management
|
|
Relational databases
|
| Form |
Electronic book
|
| ISBN |
1306270030 |
|
9781306270038 |
|
9781782170891 |
|
1782170898 |
|
9781782170884 |
|
178217088X |
|
