Index
A
- .atomsvc feeds / Using data feeds
- Accessories category /
- ADDCOLUMNS function /
- Advanced tab /
- aggregates
- summing /
- ALL function /
- ALLSELECTED function /
- ALTER commands /
- Analysis Services
- workbook, restoring to /
- Analyze in Excel button /
- AutoSum button /
B
- Bar Chart button /
- base table
- defining /
- bin grouping /
- BISM
- about / Introduction
- BLANK() function /
C
- 445 calendar /
- using /
- working /
- CALCULATE function /
- calculation area /
- Calculation Area button /
- card control
- charts
- creating /
- manipulating /
- client tools /
- Column Filters button /
- connections
- Control Content /
- Convert Report Filters option /
- Convert to Formulas button /
- COUNTROWS function /
- Create Hierarchy option / How to do It…
- Create Linked Table button /
- Create Relationships window /
- CREATE statement /
- cube functions
- about /
- using /
- Cube Name property /
- CUBEVALUE function /
- currency calculations
- performing /
- current date /
- customer list /
D
- 445 Dates /
- data
- importing, as text / Importing data as text, How to do It…, How it works…, There's more...
- importing, from databases / Importing data from databases, Getting ready, How to do It…, How it works…
- sorting / Sorting data, How to do it…
- allocating, at different levels /
- securing, with roles /
- processing /
- retrieving, from single table /
- retrieving, from single table /
- restricting, with filters /
- restricting, with where conditions /
- Data Analysis Expressions (DAX) /
- database
- creating /
- Database Management System (DBMS) / Importing data from databases
- databases
- data, importing from / Importing data from databases, How to do It…, How it works…, There's more...
- Data Categories / How to do it…
- data feeds
- about / Using data feeds
- using / How to do it…
- working / How it works…, There's more...
- data filtering
- tabular relationships, using for /
- datasets
- product list /
- product subcategories list /
- product categories list /
- orders list /
- customers list /
- date list /
- DATEADD function /
- dates list /
- DAX /
- Deployment Wizard
- using, for model deploying /
- Design button / There's more...
- dimension /
- dimensional table
- manipulating /
- DirectQuery Mode Property option /
- DirectQuery solution
- about /
- restrictions /
- new project, creating /
- implications, demonstrating /
- DISTINCTCOUNT function /
- Do Not Process option /
- Download button /
- dynamic security
- implementing /
E
- <expression> parameter /
- Excel tabular model
- promoting, methods /
- Existing Connections button /
- Export to Data Feed button / How to do it…
F
- field appearance
- managing /
- Field List /
- Field List button /
- fields
- adding, to tables /
- linking, between tables /
- Filter /
- Filters Pane /
- FIRSTDATE function /
- Format as Table button /
- Formulas tab /
- From Data Feeds button / How to do it…
H
- HideMemberIf property /
- hierarchies
- creating, for drilldown interaction / Creating hierarchies for drilldown interaction, How to do It…, How it works…, There's more...
- hierarchy /
- Home Tab /
I
- ImageLoad command /
- images
- displaying /
- using /
- Import From Data Source button /
- Install button /
K
- KPI
- about /
- creating /
- adding, to model /
- measures, adding to model /
L
- LASTDATE function /
- last non-empty function
- using /
- working /
- last year value /
- levels /
- lookupvalue function /
- LOOKUPVALUE function /
M
- Manage Relationships button /
- many-to-many relationships
- defining /
- working /
- maps
- about / Using maps
- MDX (Multidimensional Expressions) /
- measure group /
- Measure Settings window /
- Microsoft SQL Server /
- model
- creating /
- working /
- model calculations
- about /
- creating /
- models
- importing, to SQL Server Data Tools (SSDT) /
- importing to SQL Server Data Tools (SSDT) /
- deploying, in SQL Server Data Tools (SSDT) /
- deploying, from SSDT /
- deploying, Deployment Wizard used /
- Month to Date (MTD) aggregations /
- Multidimensional Online Analytical Processing (MOLAP) /
- multidimensional view
- differentiating, with tabular model /
- multiples / How to do it…
N
- Name Box /
- Name Manager window /
O
- Online Transactional Processing (OLTP) / Getting ready
- Open DataBase Connectivity (ODBC) / Importing data from databases
- Open Data Protocol (OData) / Using data feeds
- orders list /
P
- parent-child hierarchies
- about /
- using /
- diagram /
- creating /
- Pareto principle /
- partitions
- creating /
- managing /
- PATHITEM function /
- perspectives
- creating /
- pipe symbol (|) /
- PivotTable button /
- PivotTable Connections... option /
- PivotTable Field List window /
- pivot tables
- connecting /
- Power Pivot /
- installing /
- Power Pivot Data Connections group / There's more...
- PowerPivot Field List /
- PowerPivot Field List panel /
- Power View
- about /
- trellis charting, implementing / Using multiples (Trellis Charts)
- Power View report
- creating /
- Report Canvas /
- Filters Pane /
- Power View Field List /
- Control Content /
- Preview Selected Table window / How it works…
- prior period value
- forms /
- about /
- working /
- processed /
- ProcessRecalc command /
- product categories list /
- product list /
- product subcategories list /
- projection
- used, for data combination from different tables /
Q
- Quarter to Date (QTD) aggregations /
R
- RANKX function /
- ratios
- building /
- Recurring option /
- related table /
- Relational Online Analytical Processing (ROLAP) /
- Relative Time dimension
- about /
- using /
- Report Canvas /
- Resellers table
- discretizing /
- result_columnName parameter /
- role playing dimensions
- about /
- roles
- data, securing with /
- row filter context /
- Row Filters tab /
- rows
- iterating /
- running totals
- using /
- adding, to model /
S
- Select Related Tables button / How it works…, How to do it…
- Select Tables and Views window / How it works…
- SharePoint /
- Silver Light /
- single table
- data, retrieving from /
- Slicer
- managing, through VBA /
- Slicer Control /
- Slicers
- connecting /
- Slicer Settings... options /
- smart key /
- snowflake schema /
- sort by column /
- sp_grant_proxy_to_subsystem command /
- SQL Server Analysis Server (SSAS) /
- SQL Server Analysis Services (SSAS) /
- SQL Server Data Tool (SSDT) /
- SQL Server Data Tools (SSDT) /
- models, importing to /
- models, deploying in /
- SQL Server Management Studio (SSMS) /
- SQL Server Trace /
- SSAS
- about / Introduction
- SSDT
- models, deploying from /
- about /
- stacked chart
- using /
- star schema /
- status measure /
- Stock on Hand /
- Summing Aggregates and Row Iteration /
T
- table appearance
- managing /
- table behavior
- working with / Working with table behavior and card control
- Table Behavior dialog / How to do it…
- table fields
- automating, with default field sets / Automating the table fields with default field sets, How to do it…
- Table Import Wizard window / How it works…, How to do it…
- TABLE label /
- tables
- fields, linking between /
- managing / Managing connections and tables, Getting ready, How to do it…, How it works…, There's more...
- deriving /
- deriving, with DAX query /
- tabular model
- differentiating, with multidimensional view /
- configuring, for using with map / Using maps, How to do it…
- tabular modeling
- about /
- life cycle, steps /
- tabular relationships
- used, for data filtering /
- target measure /
- tilde (~) /
- tile
- about /
- adding /
- Tile Type button /
- TOP % query /
- TOPN function /
- TOP N query /
- totals to date functions
- working /
- trellis charting
- about / Using multiples (Trellis Charts)
- implementing, in Power View / Using multiples (Trellis Charts), How it works..., There's more...
U
- Uniform Resource Locator (URL) /
- Use an external data source option /
- USERNAME() function /
- Utility dimension
- about /
- creating /
V
- Validate button / How to do it…
- Value measure /
- VALUES() function /
- VALUES function /
- VBA
- working with /
- Slicer, managing through /
- Visual Basic for Applications (VBA) /
W
- WEB URL feature /
- workbook
- restoring, to Analysis Services /
- worksheet events
- working with /
- Worksheet_SelectionChange event /
X
- XMLA /
- xVelocity / Introduction
Y
- Year to Date (YTD) aggregations /