This SharePoint 2013 training class provides individuals with practical information, exercises and labs that enable them to build reports, dashboards, KPIs, scorecards, charts, power view and power pivot on the Microsoft SharePoint 2013 platform using Dashboard Designer 2013, Excel 2013, Report Builder 3.0 and Visual Studio 2012. 

This class is intended for application developers or reporters who use Microsoft SharePoint 2013 in a team-based, medium to large sized development environment. Anyone looking to build reports, dashboard, KPI’s, scorecards, charts, power view, power pivot on the Microsoft SharePoint 2013 platform using Dashboard Designer 2013, Excel 2013, Report Builder 3.0 and Visual Studio 2012.

[row] [span7]

 

Duration – 2 Days 

 

How You Will Benefit

Goals and Objectives for Attendees Upon Training Completion:

• Understand the SharePoint Data Source and be able to access it via various protocols
• Be able to Work through setting-up a data connection with various option
• Ability to Write Excel based reports
• Be able to deploy Excel based reports to SharePoint as well as understand Excel web access
• Understand how to write Pivot table based report and deploy to it SharePoint
• Be able to write Power Pivot based report and deploy it to SharePoint
• Ability to write Power View report and deploy it to SharePoint
• Understand how to write Dashboard/Scorecards using the Dashboard designer
• Ability to access data from PowerPivot or SQL based cube from a custom database
• Be able to write SSRS report and deploy them to SharePoint 

Topics to Be Covered

Course Outline:

Module 1 – Business Intelligence

• Introduction

Module 2 – Data Connections and Secure Store Service

• Data Source and Connection
• Secure Store Service

Module 3 – Excel Services

• Designing Reports in Excel
• Reports in SharePoint

Module 4 – Excel with PowerPivot

• DAX
• KPIs
• PowerPivot Management

Module 5 – Reporting Services

• Report Builder
• Report Design and Deployment
• Power View

 Module 6 – PerformancePoint Services

• Dashboard Designer
• KPIs and KPI details
• Scorecards
• Analytical charts
• Decomposition tree
• Strategy map

Module 7 – Visio Graphics Service

• Visio Drawing v/s Web Drawing
• Data Connections and refresh

Module 8 – Business Data Connectivity

• Business Data Connectivity Service
• External List

[/span7] [span4]

Course Registration

[/span4] [/row]