Home
Courses
Creating Dashboards with SharePoint Training

Creating Dashboards with SharePoint Training

Course 1536

Duration: 4 days
Labs: Yes
Language: English
Level: Intermediate

In this Creating Dashboards with SharePoint training course, you gain the knowledge and skills to leverage built-in SharePoint Business Intelligence capabilities and build reporting dashboards in SharePoint Server — allowing your organisation to implement and visualise enterprise data. You will learn to integrate Excel worksheets and chart data, develop KPIs with PerformancePoint Services, present business insight from a variety of reports and data sources and connect Web Parts to display and filter data for analysis.

Business Intelligence (BI) is the process of exposing enterprise data that enables management to make informed business decisions. In this training course, you gain the knowledge and skills to leverage built-in SharePoint BI capabilities and build reporting dashboards in SharePoint Server — allowing your organisation to implement and visualise enterprise data.

Creating Dashboards with SharePoint Training Delivery Methods

In-Person
Online

Creating Dashboards with SharePoint Training Course Information

In this training, you will:

Present business insight from a variety of reports and data sources.
Integrate Excel worksheets and chart data.
Develop KPIs with PerformancePoint Services.
Connect Web Parts to display and filter data for analysis.

Prerequisites

Basic understanding of SharePoint at the level of Course 1540, Microsoft SharePoint 2016 Training
Background knowledge of Excel, report development, or data analysis

Creating Dashboards with SharePoint Course Outline

Module 1: Creating Dashboards in SharePoint

Defining dashboards
Delivering dashboards with SharePoint
Customising SharePoint web pages
Architecting Wiki and Web Part pages

Module 2: Publishing Excel in Dashboards

Leveraging Excel Access Web Parts

Displaying Excel in SharePoint pages
Connecting Excel Web Parts
Tailoring Excel Access Web Parts

Incorporating Excel Services

Evaluating Excel Services publishing options
Detecting parameters in Excel Services
Assembling Power Pivot in Excel

Module 3: Deploying Business Reports

Exposing SQL Server Reporting Services

Assessing capabilities of SQL Server Reporting Services
Allocating a Reports Library
Adding SQL Server Reports to web pages

Utilising third–party Web Parts

Enhancing dashboards with Web Parts
Integrating third–party Web Parts with List Data

Module 4: Implementing SharePoint Apps

Consuming SharePoint Lists as a data source

Uncovering SharePoint Lists as dashboard items
Enabling functionality of Lists with Views
Enhancing SharePoint Lists with metadata

Charting SharePoint Lists

Investigating charting options
Connecting Lists to charting Web Parts
Exhibiting SharePoint Lists on web pages

Module 5: Working with the Business Intelligence Center

Adopting Self–Service BI

Getting started using a BI Center
Identifying components of a BI Center site template
Benefiting from PerformancePoint functionalities
Configuring data connections

Planning for a successful dashboard

Gathering user information needs
Locating data sources
Sketching a mock–up

Authoring feature–rich content

Analysing data structures for accuracy in reporting
Selecting Facts and Dimensions for business reporting
Consuming a Tabular Model and Analysis Services Cube
Engineering content for visualisation

Exploiting PerformancePoint Dashboard Designer

Producing reports, charts, graphs and filters
Formulating KPIs and indicators
Developing reports and scorecards to measure performance
Slicing and dicing with Power Pivot
Providing decomposition tree functionality

Building the dashboard in SharePoint

Combining reporting objects on a web page
Applying filters to reports and graphs
Extending KPIs with trend indicators
Targeting access to various audiences

Module 6: Enhancing Dashboards with SharePoint Web Parts

Drilling–down for root–cause analysis

Taking advantage of Out–of–the–Box Web Parts
Filtering Web Parts
Surfacing information with Query Web Parts
Displaying videos with Media Web Parts

Evaluating Web Part sources

Detecting third–party providers
Appraising the need for custom building

Module 7: Launching a Dashboard Portal

Designing intuitive navigation

Uncovering the need for navigation
Selecting SharePoint options for web page transitions

Building portal pages

Implementing Promoted Links App
Exploiting Links App
Leveraging Wiki page editing
Modifying Current and Global Navigation

Get This Course 27 950 kr

4-day instructor-led training course
After-course computing sandbox included
Learning Tree end-of-course exam included
One-on-one after-course instructor coaching benefit

Include dates with afternoon start times

#1536

nov 21 - 24 9:00 - 16:30 CET

Stockholm or Virtual
nov 21 - 24 10:00 - 18:00 CET

London or Virtual
jan 9 - 12 15:00 - 22:30 CET

Herndon, VA or Virtual
feb 20 - 23 9:00 - 16:30 CET

Stockholm or Virtual
feb 20 - 23 10:00 - 18:00 CET

London or Virtual
apr 2 - 5 15:00 - 22:30 CEST

New York or Virtual
maj 28 - 31 9:00 - 16:30 CEST

Stockholm or Virtual
maj 28 - 31 10:00 - 18:00 CEST

London or Virtual
jul 9 - 12 15:00 - 22:30 CEST

Herndon, VA or Virtual
aug 27 - 30 9:00 - 16:30 CEST

Stockholm or Virtual
aug 27 - 30 10:00 - 18:00 CEST

London or Virtual

Scroll to view additional course dates

Bring this or any training to your organisation
Full-scale programme development
Delivered when, where, and how you want it
Blended learning models
Tailored content
Expert team coaching

#1536

Questions about this course?

Customise Your Team Training Experience

Fill out the form below or call +46 (0)8 506 668 00

* Required Fields

Preferred method of contact:

Phone

Need Help Finding The Right Training Solution?

Our training advisors are here for you.

Course FAQs

Yes! We know your busy work schedule may prevent you from getting to one of our classrooms which is why we offer convenient online training to meet your needs wherever you want. This course is available in class and live online.