Course Content
Course Overview
- Lessons
- Introduction
- Course Materials
- Facilities
- Prerequisites
- What We'll Be Discussing
- Lab : Course Overview
PowerPivot
- Lessons
- Best Things That PowerPivot Brings to Excel
- What Will PowerPivot Do for the Analyst?
- Introduction to PivotTables (Optional)
- PowerPivot Versions
- New 2013 PowerPivot Features
- VLOOKUP Not Required (Use Relationships)
- Architectural Changes in Excel 2013
- PowerPivot and Excel 2013
- PowerPivot and SharePoint
- Enterprise Business Intelligence and PowerPivot
- Importing Data
- Data Models
- Relationships
- Simple PivotTable Reports
- Calculated Columns and Calculated Fields
- Refreshing Data
- Calculations
- SharePoint Sharing
- Lab : PowerPivot
- Pivot Tables (Optional)
- PowerPivot User Interface
- Importing Data
- Importing Large Datasets
- Importing Data with a Query
- Creating Relationships
- Creating a Cascading Relationship
- Creating a Relationship Between Tables From Different Sources
- Hiding Columns, Change Data Type, Sorting, and Filtering
- Calculated Column and Calculated Field
- Add a Calculated Field From the PivotTable
- Filter Context Using One Table
- Row Context and Dynamic Selection
- FILTER Function
- CALCULATE Function
- Build a Date Table
- Relate a Table to an Excel Calendar Table
- Time Intelligence
- Perspectives
- Hierarchies
- KPIs
Power View
- Lessons
- Report Design Principles
- New 2013 Power View Features
- Microsoft Power View User Interface
- Tables
- Charts
- BI Semantic Models
- Saving and Sharing
- Lab : Power View
- Power View
SharePoint 2013 Business Intelligence Center
- Lessons
- Quick Architecture
- New 2013 SharePoint Central Administration
- New 2013 Business Intelligence Center
- Permissions and Roles
- Included Document Library and List Apps
- Create Custom Apps (Libraries) for Visualizations or Workbooks
- Lab : SharePoint 2013 Business Intelligence Center
- Central Administration Tour and Web Application Creation
- Introduction to the Business Intelligence Center
- Permissions and Sharing
- SharePoint 2013 Business Intelligence Center Create Apps