Course Content
Course Overview
- Lessons
- Introduction
- Course Materials
- Facilities
- Prerequisites
- What We'll Be Discussing
PowerPivot
- Lessons
- What is a data model?
- PowerPivot and Excel
- New 2013 PowerPivot Features
- PowerPivot and SharePoint
- Enterprise BI and PowerPivot
- Enriching Data
- Importing Data
- Refreshing Data
- Formatting Data
- Sorting and Filtering
- Creating Relationships
- Calculations
- SharePoint Sharing
- Lab : PowerPivot
- Import Data from SQL Server
- Import Data from SQL Server Analysis Services
- Hide Unused Columns
- Review and Edit the Imported Relationships
- Create a PivotTable
Power View
- Lessons
- New 2013 Power View Features
- Microsoft Power View User Interface
- Tables
- Charts
- Saving and Sharing
- BI Semantic Models
- Lab : Power View
- Create a Table
- Create a Chart
- Saving and Sharing
- Create a BI Semantic Model
Manually Schedule vs. Auto Schedule
- Lessons
- New 2013 SharePoint Central Administration
- New 2013 BI Center
- Permissions and Roles
- Included Document Library and List Apps
- Create Custom Apps (Libraries) for Visualizations or Workbooks
- Create Custom Connection Apps (Libraries)
- SharePoint 2013 BI Center
- SharePoint 2013 BI Center
- SharePoint 2013 Central Administration Excel Services
- View the Secure Store
- SharePoint 2013 BI Center Create Apps