PowerPivot, Power View and SharePoint 2013 BI Center for Analysts

Have Queries? Ask us +91 72592 22234

Course Overview

The PowerPivot, Power View and SharePoint 2013 BI Center for Analysts training course concentrates on PowerPivot and Power View in Excel 2013. The participants will learn how to surface the workbooks and visualizations using the BI Center in SharePoint 2013. As far as possible each of the modules is stand-alone allowing for customization of the course for those audiences that may not have an interest in a certain service.

Course Content

Course Overview

  • Lessons
    • Introduction
    • Course Materials
    • Facilities
    • Prerequisites
    • What We'll Be Discussing


  • 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

Customer Reviews

Thanks to Xpertised and the tutor who walked me through all the topics with Practical exposure which is helping me in my current project.

Course was quite helpful in terms of understanding of concepts and practicality. Its really a very friendly environment to learn. The timing were mutually chosen, as we both are working professional. I am quite satisfied with the course.


For Batch Details
Call us at: +91 7259222234

Not sure? Consult Our Experts

Looking for a Training for


My Team/Organization

I agree to be contacted over mail or phone

Call us at: +91 7259222234