55058A-Powerpivot And Report Builder Combo Pack




    4 Day(s) Course


    Official Courseware


    Exam Voucher


    Certified Trainer


    1:1 Training Available on Demand


    Customize Your Batch



    PowerPivot & Report Builder Combo Pack training is a four-day course that provides essential knowledge of the features and functionalities of PowerPivot and Power View in Excel 2013. Through this course, the candidates will learn to surface workbooks and visualizations using the Business Intelligence Center in SharePoint 2013.

    In this course, each of the modules is stand-alone that allows customization of the course for those audiences that may not express interest in a particular service.

    This course will help participants to develop reports using Microsoft Report Builder 3.0. The training environment of this class will include

    • SQL 2008R2,
    • SQL Express 2012 and
    • SQL 2012 Standard and Enterprise

    so that the participants can deploy Report Builder 3.0 to generate reports from multiple sources.

    Module 1: Course Overview


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

    Module 2: PowerPivot

    This module describes the PowerPivot and its analytical capabilities. PowerPivot is a data analysis add-on for Microsoft Excel that allows collection, aggregation, and analysis of large amounts of data in one workbook.


    • Best Things That PowerPivot Brings to Excel
    • What Will PowerPivot Do for the Analyst?
    • Introduction to PivotTables (Optional)
    • PowerPivot Versions
    • PowerPivot and Excel 2013
    • PowerPivot and SharePoint
    • New 2013 PowerPivot Features
    • SharePoint Sharing
    • Calculations
    • VLOOKUP Not Required (Use Relationships)
    • Architectural Changes in Excel 2013
    • Relationships
    • Enterprise Business Intelligence and PowerPivot
    • Importing Data
    • Data Models
    • Simple PivotTable Reports
    • Calculated Columns and Calculated Fields
    • Refreshing Data

    Module 3: Power View

    This module describes the Power View and the reporting that can be created. From tables to charts and sharing on SharePoint, this module will get you ready to visualize your data in a variety of ways.


    • Report Design Principles
    • New 2013 Power View Features
    • Microsoft Power View User Interface
    • Tables
    • Charts
    • BI Semantic Models
    • Saving and Sharing

    Module 4: SharePoint 2013 Business Intelligence Center

    This module describes the new and improved 2013 SharePoint Central Administration site. We are going to cover specifically the new 2013 Business Intelligence Center template within SharePoint.


    • Quick Architecture
    • New 2013 Business Intelligence Center
    • New 2013 SharePoint Central Administration
    • Permissions and Roles
    • Create Custom Apps (Libraries) for Visualizations or Workbooks
    • Included Document Library and List Apps

    Module 5: Introduction to Report Builder 3.0

    This module describes the interface of Report Builder 3.0, the different features available, and variances in data sources and sets.


    • Plan Your Reports
    • The Interface
    • Variances Between SQL Versions
    • How to Use Report Builder 3.0 with SQL Express 2012
    • Data Sources
    • Datasets

    Module 6: Report Builder 3.0 Wizards

    This module describes the wizards.


    • Explore the Report Builder 3.0 Wizards
    • Create Reports with the Wizards

    Module 7: Report Builder 3.0 Basic Reports

    This module describes the basics with lists, matrix, and tables then go into parameters and the expressional aspect of reports.


    • Report Lists
    • Report Tables
    • Report Matrix
    • The Data Region
    • Report Parameters
    • Report Expressions
    • Formatting Reports

    Module 8: Report Builder 3.0 Graphics

    This module describes the graphics including embedded and Bing map.


    • Report Charts
    • Report Images
    • Report Sparklines
    • Report Data Bars
    • Report Gauges
    • Report Maps

    Module 9: Intermediate Reports

    This module describes intermediate reporting with emphasis on actionable reports.


    • Time Intelligence
    • Drill Through
    • Subreports
    • Interacting with Actionable Reports
    • Reuse Report Parts

    Module 10: Report Builder 3.0 Tips and Tricks

    This module describes a collection of how-to with examples.


    • Dozens of Step-By-Step Examples for Report Situations

    This course is intended for:

    • Analysts,
    • Business Intelligence (BI) Developers and
    • IT Professionals

    involved in designing, developing and maintaining Excel workbooks utilizing PowerPivot and Power View 2013 to be surfaced on SharePoint.

    This course is also intended for:

    • Power Users,
    • Developers, and
    • IT Professionals

    involved in designing, developing and maintaining reports created with Report Builder 3.0.

    Before attending this course, candidates must have:

    • Experience with Excel 2007 or higher.
    • Basic understanding of PivotTables.
    • Basic understanding of relational databases.

    Name Code Fee



    What Our Trainees Say

    Mercury Solutions Ltd. is rated 4.6 stars by based on 18 reviews.