3 arrows

Get 50% Off ForgeRock Training Bundles


Visualizing Data with SharePoint 2013, Report Builder, PowerPivot PowerView with NO CODE

  • Tuition USD $2,786 List Price $3,095 GSA  $2,338.79
  • Reviews star_rate star_rate star_rate star_rate star_half 3095 Ratings
  • Course Code 55072
  • Duration 5 days
  • Available Formats Classroom

This course is designed for the participant to explore the Microsoft data visualizations and gain an understanding of what can be accomplished without the use of code. SharePoint 2013 PerformancePoint, Excel Services, PowerView, PowerPivot and Report Builder are covered and combined into dashboards. This is an upgrade of course 50561AC.

Skills Gained

  • Perform all of the actions and answer all of the questions listed in: Why this course may be for you.

Who Can Benefit

The target audience of this course is for Business Analysts, Report Designers, Team Leads, SharePoint Administrators, Business Intelligence Developers and Project Managers that will be tasked with the implementation, support, management or training needed to rapidly empower the users to take advantage of the exploding world of Data V.

Why this course may be for you:
You have the infrastructure but getting reports generated out of I.T. just takes too long.
Lack of insight into what has happened is hampering your ability to move forward.
You need or want to use the web browser as your source of information so that it is as acceable as the internet.
You want to take advantage of the SharePoint deployment to manage the data connections, report objects, dashboards KPIs etc.
You need to rapidly prototype reports for changing conditions
You want to move from textual reports to graphical reporting.
You are tasked with implementing Six Sigma type reports using Visio Data Driven objects
Your organization wants to implement anaysis based on automatically updating data
You need to implement a Single Source of The Truth structure.
You need to understand the effectivness of the reports and dashboards.
You need an understanding of the tools that are available and how to determine which is the target audience for those tools.
You need to implemant actionable dashboards to allow line managers to rapidly take action.


  • n/a

Course Details


Module 1: Introduction
This module explains how the class will be structured and introduces course materials and additional administrative information.
What you will get out of this module:
Introduction to the instructor and your peers
A review of what we mean by NO CODE
How to work in the course environment

  • What does NO Code mean?
  • How to get the most out of this course
  • The course setup
  • What is not covered?

Lab 1: n/a
After completing this module, students will be able to:
  • n/a

Module 2: Data Visualizations
This module explains concepts of data visualizations.
  • Data Visualization Fundamentals
  • The Microsoft Toolsets for Visualizations

Lab 1: Data Visualizations
  • Explore the Microsoft Toolsets
After completing this module, students will be able to:
  • n/a

Module 3: Dashboard Design Principles
This module is an introduction to successful design principles for Dashboard design.
  • Successful dashboards
  • Quantitative relationships
  • Summary numbers
  • Tables or graphs?
  • Types of graphs
  • Key performance indicators
  • Dashboard taxonomies
  • Pitfalls in dashboard design

Lab 1: Group Review of Design Problems
  • Design Problem 1
  • Design Problem 2
  • Design Problem 3
After completing this module, students will be able to:
  • n/a

Module 4: Microsoft Business Intelligence Stack
This module covers the Microsoft Business Intelligence stack including SQL 2012, Extract-Transform-Load, Reporting Services, Tabular Data, Analysis Services and SharePoint 2013.
  • Microsoft Business intelligence Overview
  • Business Intelligence in three ways
  • SQL Integration Services ETL
  • Reporting Services
  • Master Data Services
  • Data Quality Services
  • SharePoint 2013 Business Intelligence

Lab 1: Tour of the Microsoft Business Intelligence Stack
  • Run a prepared ETL Package
  • Create a SQL Server Analysis Services Cube
  • Create a Tabular Database
  • Examine Master Data Services
  • Examine Reporting Services as a native install
  • Examine Reporting Services as an integrated SharePoint install
  • The SharePoint 2013 Business Intelligence Template
After completing this module, students will be able to:
  • n/a

Module 5: Report Builder 3.0
This module explains Report Builder 3.0 wizards, basics of report design, intermediate reports with report parameters and report expressions, report visualizations including graphs, charts, images, and gauges, advanced reporting including the utilization of maps, interactive reports, Report Parts and subreports.
  • Introduction to Report Builder 3.0
  • Report Builder 3.0 Wizards
  • Report Builder 3.0 Graphics
  • Intermediate Reports

Lab 1: Report Builder 3.0
  • Report Builder Wizards
  • Basic Reports
  • Intermediate Reports
  • Graphics
After completing this module, students will be able to:
  • n/a

Module 6: PowerPivot and PowerView
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. Sounds
powerful? It is! Well cover everything you need to know to get you up, running, and analyzing.
  • PowerPivot
  • DAX
  • PowerView

Lab 1: PowerPivot and PowerView
  • Create a Pivot Table
  • Import Data
  • Create Relationships
  • Create Calculated Columns
  • Create Calculated Fields
  • Save to SQL
  • Create PowerView Reports
  • Deploy to SharePoint
After completing this module, students will be able to:
  • n/a

Module 7: SharePoint 2013 Excel Services
In this module, we will go over all the new 2013 Excel Services features, and we will explore the core components of Excel Services. We will cover Excel Web Access and its capabilities along with any differences you may encounter in the browser as opposed to the desktop client. There is coverage of the Power View add-in for Excel, and then lastly we will explain the save and share process and have a look at best practices.
  • New 2013 Excel Services Features
  • Core Components
  • Excel Web Access (EWA)
  • What Excel Web Access is Not
  • Differences in the Browser vs. Desktop
  • SharePoint Libraries to Store Workbooks
  • Power View Add-in for Excel
  • The Save and Share Process
  • Excel Web App
  • Best Practices

Lab 1: SharePoint 2014 Excel Services
  • Creating a Library to Hold Excel Workbooks
  • Exploring the Power View Add-in for Excel
  • Save and Share an Excel Workbook to a SharePoint Document Library
  • Add an Excel Web App to a Webpage
After completing this module, students will be able to:
  • n/a

Module 8: SharePoint 2013 PerformancePoint Services
In this module, we will give you an overview of the new 2013 PerformancePoint Services features. Dashboard Designer is explored along with many of the objects and connections available within.
  • New 2013 Overview of PerformancePoint Services
  • Dashboard Designer
  • Data Sources
  • Indicators
  • KPIs
  • Visual Reports
  • Filters
  • Scorecards
  • Dashboards

Lab 1: PerformancePoint 2013
  • PerformancePoint Services Dashboard Designer Introduction and Data Source Configuration
  • Standard or Blank KPI Demonstration
  • Leaf KPI Demonstration
  • Objective KPI Demonstration
  • Visual Reports
  • PerformancePoint Filters
  • PerformancePoint Cascading Filters
  • Time Intelligence Filters
  • Scorecard Settings
  • Scorecards Filtered Using the Wizard
  • PerformancePoint Dashboards
After completing this module, students will be able to:
  • n/a

How do I get a Microsoft exam voucher?

Pearson Vue Exam vouchers can be requested and ordered with your course purchase or can be ordered separately by clicking here.

  • Vouchers are non-refundable and non-returnable. Vouchers expire 12 months from the date they are issued unless otherwise specified in the terms and conditions.
  • Voucher expiration dates cannot be extended. The exam must be taken by the expiration date printed on the voucher.

Do Microsoft courses come with post lab access?

Most Microsoft official courses will include post-lab access ranging from 30 to 180 calendar days after instructor led course delivery. A lab training key in class will be provided that can be leveraged to continue connecting to a remote lab environment for the individual course attendee.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour-long after 3-3.5 hours of the class day.

What languages are used to deliver training?

Microsoft courses are conducted in English unless otherwise specified.

The class was very interactive and allowed me to work scenarios hands on. The instructor realized that hands on exercises are what is needed to gain an understanding of the program.

I thought the labs and content were helpful in understanding the services associated with devops

It was a good overview, but I feel like I need a lot more studying to be able to pass the test

This is an amazing tool for high-level continuous learning looking for obtaining Amazon certifications. It is great to have structure and scheduled so well organized. This method could reduce the study time for an Amazon certification to less than a half.

Ray is excellent instructor, very friendly & skilled.. the course is effective, interactive, lots of practice..

0 options available

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links above. We can also contact you when the course is scheduled in your area.

Contact Us 1-800-803-3948
Contact Us
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward