Index
A
- aggregation principle / Introducing Data Analysis Expressions (DAX)
- Analysis Services xVelocity in-memory analytics engine / The principle of PowerPivot for Excel
- Azure DataMarket dataset / Data feeds
B
- BI reports
- creating / A general overview of BI reports creation
- BI reports creation
- about / A general overview of BI reports creation
- OLTP / OLTP versus OLAP
- OLAP / OLTP versus OLAP
- business Process Perspective / Business scorecards
- business scorecards
- about / Business scorecards
- KPI / Key Performance Indicators (KPIs)
C
- Campaign Management System (CMS)
- column
- configuration, PowerPivot for SharePoint / Configuring PowerPivot for SharePoint
- constellation schema / General overview of a data model
- Contoso, sales store name / Sales analysis data importing
- copy and paste
- used, for importing data / Importing data based on copy and paste
- customer Perspective / Business scorecards
- Customer relationship management (CRM) / Creating a report using the PowerPivot interface
- Customer Relationship Management (CRM)
D
- dashboard report
- creating / PowerPivot Dashboards
- dashboards
- about / Dashboards
- data
- importing from sources, need for / Purpose of importing data from a variety of sources
- Data Analysis Expressions (DAX) / The principle of PowerPivot for Excel
- data feeds
- types / Data feeds
- data importing
- E-commerce customer activity / E-commerce customer activity data importing
- from SQL Server / Importing data from the SQL Server
- from flat file / Importing data from a flat file
- Sales analysis / Sales analysis data importing
- from MS Access database / Importing data from the MS Access database
- SQL query used / Importing data using a SQL query
- copy and paste based / Importing data based on copy and paste
- Excel linked table used / Importing data using an Excel-linked table
- data model
- about / General overview of a data model
- data model, PowerPivot / A data model in PowerPivot
- data refresh processes
- in PowerPivot / Data refresh
- data sources
- about / List of data sources
- RDBMS / Relational database
- multidimensional data sources / Multidimensional sources
- data feeds / Data feeds
- text files / Text files
- adding, in single worksheet / Adding a data source in a single worksheet from a variety of data sources
- DAX
- about / Introducing Data Analysis Expressions (DAX)
- functionalities / Introducing Data Analysis Expressions (DAX)
- fx button / Introducing Data Analysis Expressions (DAX)
- expressions / Introducing Data Analysis Expressions (DAX)
- formula, example / Introducing Data Analysis Expressions (DAX)
- DAX expression
- denormalization
- about / General overview of a data model
- dimension table
- features / General overview of a data model
E
- E-commerce customer activity data importing
- about / E-commerce customer activity data importing
- from SQL Server / Importing data from the SQL Server
- from flat file / Importing data from a flat file
- Ecommerce PowerPivot workbook
- tables, importing into / E-commerce data model design process
- about / E-commerce data model design process
- User table, splitting for / Splitting the User table for e-commerce data analysis
- relationship, creating / Creating relationships
- column, adding / Adding a new calculated column using DAX and creating hierarchies for e-commerce data
- hierarchies, creating / Adding a new calculated column using DAX and creating hierarchies for e-commerce data
- logical design, viewing / Viewing the logically designed data model for e-commerce data analysis
- ETL
- about / General overview of ETL
- extraction / General overview of ETL
- functions, examples / Examples
- examples / Examples
- PowerPivot performance / PowerPivot performance in ETL
- Excel linked table
- used, for importing data / Importing data using an Excel-linked table
- extract, transform, and load (ETL) / A data model in PowerPivot
F
- fact table
- features / General overview of a data model
- financial Perspective / Business scorecards
- flat file
- data, importing from / Importing data from a flat file
- foreign key / Creating a data relationship for the sales analysis data
- fx button / Introducing Data Analysis Expressions (DAX)
G
- Graphical User Interface (GUI) / Benefits of using PowerPivot
H
- hierarchies
- about / Creating hierarchies for sales analysis data
- creating, for Sales Analysis PowerPivot workbook / Creating hierarchies for sales analysis data
- creating, for Ecommerce PowerPivot workbook / Adding a new calculated column using DAX and creating hierarchies for e-commerce data
I
- installation, PowerPivot / Downloading and installing the PowerPivot add-in for Excel 2010
- verifying / Verifying installation
- installation, PowerPivot for SharePoint
- verifying / Verifying the installation
- installation, SharePoint Server 2010 / Configuring PowerPivot for SharePoint
- integration principle / Introducing Data Analysis Expressions (DAX)
- integrity constraint / Creating a data relationship for the sales analysis data
- IT department
K
- KPI
- about / Key Performance Indicators (KPIs)
- creating / Creating key performance indicators
- creating, perspectives used / Creating a KPI using a Perspective
L
- learning and growth Perspective / Business scorecards
- logical design
- about / General overview of a data model
- viewing, of Sales Analysis PowerPivot workbook / Viewing the logical design data model of sales analysis
- viewing, of Ecommerce PowerPivot workbook / Viewing the logically designed data model for e-commerce data analysis
M
- marketing department
- Microsoft Business Intelligence (MBI) / The principle of PowerPivot for Excel
- Microsoft Excel 2010
- PowerPivot / The principle of PowerPivot for Excel
- PowerPivot, obtaining for / Getting the PowerPivot add-in for Excel 2010
- PowerPivot, installing / Downloading and installing the PowerPivot add-in for Excel 2010
- PowerPivot, downloading / Downloading and installing the PowerPivot add-in for Excel 2010
- PowerPivot, enabling / Enabling the PowerPivot add-in for Excel 2013
- Microsoft SQL Server Analysis Services (SSAS) / Creating a report using the PowerPivot interface
- MS Access database
- data, importing from / Importing data from the MS Access database
- multidimensional data sources
- about / Multidimensional sources
- Multidimensional Expressions (MDX) / Benefits of using PowerPivot
N
- normalization
- about / General overview of a data model
O
- ODBC
- about / List of data sources
- OLAP
- versus, OLTP / OLTP versus OLAP
- about / OLTP versus OLAP
- goals / OLAP analyses
- OLAP analysis / OLAP analyses
- OLE DB
- about / List of data sources
- OLTP
- about / OLTP versus OLAP
- versus, OLAP / OLTP versus OLAP
P
- Perspectives
- about / Business scorecards
- financial Perspective / Business scorecards
- business Process Perspective / Business scorecards
- learning and growth Perspective / Business scorecards
- customer Perspective / Business scorecards
- perspectives
- used, for creating KPI / Creating a KPI using a Perspective
- PivotChart
- creating / Creating a PivotChart
- creating, with slicers / Creating PivotChart with Slicers
- PivotTable
- creating / Creating a PivotTable
- creating, with slicers / Creating a PivotTable with Slicers
- PowerPivot
- about / The principle of PowerPivot for Excel
- architecture / The principle of PowerPivot for Excel
- using, benefits / Benefits of using PowerPivot
- installing / Installing PowerPivot, Downloading and installing the PowerPivot add-in for Excel 2010
- hardware, requisites / Hardware requirements
- software, requisites / Software requirements
- recommendations / Recommendations
- obtaining, for Microsoft Excel 2010 / Getting the PowerPivot add-in for Excel 2010
- downloading / Downloading and installing the PowerPivot add-in for Excel 2010
- enabling / Enabling the PowerPivot add-in for Excel 2013
- installation, verifying / Verifying installation
- testing / Testing the PowerPivot add-in
- performance, in ETL / PowerPivot performance in ETL
- integration principle / Introducing Data Analysis Expressions (DAX)
- aggregation principle / Introducing Data Analysis Expressions (DAX)
- data refresh processes / Data refresh
- data model / A data model in PowerPivot
- simple reports, creating / Creating simple reports in PowerPivot
- PowerPivot for SharePoint
- about / PowerPivot for SharePoint
- configuring / Configuring PowerPivot for SharePoint
- installation, verifying / Verifying the installation
- users, types / Types of users
- PowerPivot interface
- about / Adding a data source in a single worksheet from a variety of data sources
- used, for creating reports / Creating a report using the PowerPivot interface
- PowerPivot site
- reports, deploying in / Deploying the reports in a PowerPivot site
- PowerPivot table
- PowerPivot window
- PowerPivot workbook
- PowerPivot workspace
- primary key / Creating a data relationship for the sales analysis data
R
- Relational database
- about / Relational database
- relationship
- creating, for Sales Analysis PowerPivot workbook / Creating a data relationship for the sales analysis data
- creating, for Ecommerce PowerPivot workbook / Creating relationships
- relationship, types
- one-to-one relationship / Creating a data relationship for the sales analysis data
- one-to-many relationship / Creating a data relationship for the sales analysis data
- many-to-one relationship / Creating a data relationship for the sales analysis data
- many-to-many relationship / Creating a data relationship for the sales analysis data
- reports
- importance / The importance of reports
- goals / The importance of reports
- benefits, for organization / The importance of reports
- dashboards / Dashboards
- business scorecards / Business scorecards
- creating, PowerPivot interface used / Creating a report using the PowerPivot interface
- deploying, in PowerPivot site / Deploying the reports in a PowerPivot site
- retail industry
S
- Sales analysis data importing
- about / Sales analysis data importing
- from MS Access database / Importing data from the MS Access database
- SQL query used / Importing data using a SQL query
- copy and paste based / Importing data based on copy and paste
- Excel linked table used / Importing data using an Excel-linked table
- Sales Analysis PowerPivot workbook
- about / Sales analysis data model design process
- tables, importing into / Sales analysis data model design process
- relationship, creating / Creating a data relationship for the sales analysis data
- new column, adding / Adding a new column using DAX for sales analysis data
- hierarchies, creating / Creating hierarchies for sales analysis data
- logical design, viewing / Viewing the logical design data model of sales analysis
- schema
- star schema / General overview of a data model
- snowflake schema / General overview of a data model
- constellation schema / General overview of a data model
- SharePoint Server 2010
- installing / Configuring PowerPivot for SharePoint
- simple reports
- creating / Creating simple reports in PowerPivot
- slicers
- PivotTable, creating with / Creating a PivotTable with Slicers
- PivotChart, creating with / Creating PivotChart with Slicers
- snowflake schema / General overview of a data model
- characteristics / General overview of a data model
- SQL query
- used, for importing data / Importing data using a SQL query
- SQL Server
- data, importing from / Importing data from the SQL Server
- SQL Server Reporting Service (SSRS) / Data feeds
- star query / General overview of a data model
- star schema / General overview of a data model
- advantages / General overview of a data model
- characteristics / General overview of a data model
T
- text files
- about / Text files
- Excel file / Text files
- timely financial metrics / Business scorecards
- transformation task
- about / General overview of ETL
U
- users, types
- Executives / Types of users
- business decision makers / Types of users
- information workers / Types of users
- analysts / Types of users
- line workers / Types of users
- User table
- splitting, for Ecommerce PowerPivot workbook / Splitting the User table for e-commerce data analysis