Loading...
Login / Register

PowerPivot, Power View and SharePoint 2013 Business Intelligence Center for Analysts

This two-day instructor-led course concentrates on PowerPivot and Power View in Excel 2013. The attendees will learn how to surface the workbooks and visualizations using the Business Intelligence Center in SharePoint 20... Show More
Course Prerequisites:
This course is intended for analysts, business intelligence (BI) developers and IT professionals that will be ... Show More
Request a Quote

Instructor-Led Training (ILT)

Attend training in a classroom environment at a campus near you. Instructor-led training is still the number one delivery method of choice because it allows you to interact and discuss the training material, either individually or in a group setting, and you gain access to expert knowledge from certified instructors. This form of guided learning is impactful and produces positive learning outcomes. Day, evening and Saturday classes are offered.

Exam
Included

Duration
2 Days

Course Content

Community 55049A:

PowerPivot, Power View and SharePoint 2013 Business Intelligence Center for Analysts

Module 1: Course Overview
This module explains how the class will be structured and introduces course materials and additional administrative information.

Lessons

  • Introduction
  • Course Materials
  • Facilities
  • Prerequisites
  • What We’ll Be Discussing
  • Module 2: PowerPivot
    In this module we will explore PowerPivot and its analytical capabilities. PowerPivot is a data analysis add-on for Microsoft Excel that allows large amounts of data to be collected, aggregated, and analyzed in one workbook. Sound powerful? It is! We’ll cover everything you need to know to get you up, running, and analyzing.

    Lessons

  • 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 : 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
  • Module 3: Power View
    In this module we will cover Power View and the reporting that can be created. From tables to charts and sharing on SharePoint, this module will have you ready to visualize your data in a variety of ways.

    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
  • Module 4: SharePoint 2013 Business Intelligence Center
    In this module, we will explore the new and improved 2013 SharePoint Central Administration site. We are going to cover specifically the new 2013 Business Intelligence Center template within SharePoint. Permissions and roles will be addressed and the included library and list apps will be explained.

    Lessons

  • 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)
  • SharePoint 2013 Business Intelligence Center
  • Lab : SharePoint 2013 Business Intelligence Center

  • SharePoint 2013 Central Administration Excel Services
  • View the Secure Store
  • SharePoint 2013 Business Intelligence Center Create Apps
  • CTU Training Solutions , Updated: July 6th, 2017

    Share with friends

    Request a Quote



    Your Name

    Your Surname

    Contact Number

    Your Email

    Company

    Which campus would you like to study at?

    Your job title

    Will your training be sponsored?

    Message

    The course information above is subject to change without notification due to market trends in the industry, legislation and/or programme version updates. Terms and Conditions

    Join the CTU community

    Join the CTU Community Portal and gain access to superior resources.

    Join for Free

    Thank you for printing this page.
    Logo
    0861 100 395
    [email protected]
    www.ctutraining.ac.za

    X

    Call me Back

    Leave your details and we'll contact you back!

    Your Name:

    Your Email:


    Contact Number:

    Choose a campus