55072: Visualizing Data with SharePoint 2013, Report Builder, PowerPivot & PowerView with NO CODE Training
This SharePoint 2013 training is for the professionals who want to explore the Microsoft data visualizations and learn what can be achieved without the use of code. SharePoint 2013 PerformancePoint, Excel Services, PowerView, PowerPivot, and Report Builder and covered and fused into dashboards.
This course is an updated version of 50561AC.
This training is designed based on the objectives of the course variant 55072A.
Prerequisites for this training
An ideal candidate will have at least one year of experience within a SharePoint environment.
Who should attend this course?
The target audience of this course is 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.
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.
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! We’ll cover everything you need to know to get you up, running, and analyzing.
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 the process and have a look at best practices.
New 2013 Excel Services Features
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
Lab: 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