Course details
Students will learn PowerPivot and Power View in Excel 2013 and how to surface the workbooks and visualizations using the Business Intelligence Center in SharePoint 2013.
Course Outline
1 - Course Overview
- Introduction
- Course Materials
- Facilities
- Prerequisites
- What We'll Be Discussing
- Lab 1: Course Overview
2 - PowerPivot
- What is a data model?
- PowerPivot and Excel
- New 2013 PowerPivot Features
- PowerPivot and SharePoint
- Enterprise Business Intelligence and PowerPivot
- Enriching Data
- Importing Data
- Refreshing Data
- Formatting Data
- Sorting and Filtering
- Creating Relationships
- Calculations
- SharePoint Sharing
- Lab 1: PowerPivot
3 - Power View
- New 2013 Power View Features
- Microsoft Power View User Interface
- Tables
- Charts
- Saving and Sharing
- BI Semantic Models
- Lab 1: Power View
4 - SharePoint 2013 Business Intelligence Center
- 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
- Create Custom Connection Apps (Libraries)
- Set Policies for Excel Services
- Lab 1: SharePoint 2013 Business Intelligence Center
Target Audience: This course is intended for analysts, business intelligence (BI) developers and IT professionals that will be involved with the design, development, and maintenance of Excel workbooks utilizing PowerPivot and Power View 2013 to be surfaced on SharePoint.
Updated on 08 November, 2015Course Location
About New Horizons Ireland
With a very convenient location next to Jervis street in Dublin 1, we offer a wide range of IT and business skills courses and we can also send our instructors to your location.
We are 100% Irish owned, but we are also part of the largest independent IT Training Provider, New Horizons Computer Learning Centres who deliver more courses than any other IT training company.
Because we're local, we understand the needs of business and individuals in our community. Whether you choose to take classes in person or online, you're always welcome to call or stop by.
See all New Horizons Ireland courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Microsoft SharePoint 2016 For Administrators Diploma Alpha AcademyEUR 24
EUR 305Duration: Upto 13 Hours - EUR 12Duration: Upto 1 Hour
