SharePoint 2016 Business Intelligence (55157)
Volg de MS55157 training SharePoint 2016 Business Intelligence. Deze training behandelt de services en functies in SharePoint die ondersteuning bieden voor Business Intelligence-scenario's.
Na afronding van deze training kun je onder andere:
Training: SharePoint 2016 Business Intelligence (55157)
This course covers the services and features in SharePoint that offer support for Business Intelligence scenarios.
- Learn to configure SharePoint sites for business intelligence
- Learn to configure and use SharePoint Excel Services
- Learn to configure and use SharePoint Visio Services
- Learn to configure and use the PowerPivot add-on for SharePoint
- Learn to configure and use Power View in SharePoint
- Learn to configure and use the PowerPivot add-on for SharePoint
- Learn to configure and use the Reporting Services add-on for SharePoint
- Learn to configure and use PerformancePoint in SharePoint
- Learn the basics of Power BI and how it fits with SharePoint
- Basic knowledge of SharePoint navigation and functionality.
- Basic knowledge of data modeling would be helpful but not required for students in this course.
This course is intended for information workers and business intelligence analysts who have a minimum of three months experience using SharePoint sites, lists, and libraries and have basic Web navigation skills.
Module 1: Overview of SharePoint Business Intelligence Services and Features
This module provides an overview of SharePoint Business Intelligence Services and features.
Lessons
- SharePoint BI Services
- SharePoint BI Features
After completing this module, students will be able to:
- Understand what services and features are offered.
Module 2: Configuring SharePoint Sites for Business Intelligence
This module explains how to configure an existing team site for BI.
Lessons
- SharePoint Business Intelligence Site Template
- Configuring an Existing SharePoint Team Site for Business Intelligence
Lab : Configuring SharePoint Team Site for Business Intelligence
- Configuring SharePoint Team Site for Business Intelligence
After completing this module, students will be able to:
- Configure an existing SharePoint Team Site for Business Intelligence.
Module 3: Excel Services in SharePoint
This module explains how to use Excel Services.
Lessons
- Viewing Excel Spreadsheets with SharePoint Excel Services
- Using SharePoint Excel Services Web Part
- Basic Excel Services Farm Configuration Options
- Refreshing Data Sources with SharePoint Excel Services
Lab : Configuring Excel Services Farm Options
- Configuring Excel Services Farm Options
Lab : Refreshing Data with Excel Services
- Refreshing Data with Excel Services
After completing this module, students will be able to:
- View Excel sheet with SharePoint Excel Services.
- Use Excel Services Web Part.
- Configure basic Excel services.
- Refresh data sources.
Module 4: Visio Services in SharePoint
This module explains how to use Visio Services.
Lessons
- Configuring Visio Services Farm Settings
- View Visio Drawings with SharePoint Visio Services
- Attaching Data to Visio Drawings
Lab : Using SharePoint Visio Services
- Using SharePoint Visio Services
After completing this module, students will be able to:
- Configure Visio services.
- View Visio drawings.
- Attach data to drawings.
Module 5: SharePoint PowerPivot Add-on
This module explains how to work with PowerPivot Models, Farm Settings, and Gallery.
Lessons
- Overview of PowerPivot Data Models
- Configuring PowerPivot Farm Settings
- Creating a PowerPivot Gallery
- PowerPivot Data Refresh Options
Lab : Configuring PowerPivot for SharePoint
- Configuring PowerPivot for SharePoint
Lab : Refreshing Data from a PowerPivot Gallery
- Refreshing Data from a PowerPivot Gallery
After completing this module, students will be able to:
- Configure PowerPivot Farm settings.
- Create a PowerPivot Gallery.
- Use data refresh options.
Module 6: SharePoint Power View Feature
This module explains how to work with Power View.
Lessons
- Overview of Power View in SharePoint
- Configuring Data Sources for Power View Reports
- Creating Power View Reports
Lab : Creating a Report with Power View
- Creating a Report with Power View
After completing this module, students will be able to:
- Configure data sources.
- Create Power View repots.
Module 7: SQL Reporting Services Add-on for SharePoint
This module explains how to work with Reporting Services for SharePoint.
Lessons
- Configuring Reporting Services Farm Settings
- Configuring a SharePoint Library for Reporting Services Reports
- Reporting Services Subscriptions and Alerts
- Report Viewer Web Part
Lab : Adding Reporting Services Reports to a SharePoint Library
- Adding Reporting Services Reports to a SharePoint Library
Lab : Configuring Subscriptions and Alerts to Reports
- Configuring Subscriptions and Alerts to Reports
After completing this module, students will be able to:
- Configure Reporting Services Farm Settings.
- Configure a SharePoint Library.
- Work with subscriptions and alerts.
- Work with Viewer Web Part.
Module 8: SharePoint PerformancePoint Services
This module explains how to work with PerformancePoint Services.
Lessons
- Overview of PerformancePoint Services
- Configuring SharePoint Lists and Libraries for PerformancePoint
- Creating a Data Source
- Creating a Score Card and KPI
- Creating PerformancePoint Charts and Graphs
- Creating PerformancePoint Dashboards
Lab : Configuring a SharePoint Site for PerformancePoint
- Configuring a SharePoint Site for PerformancePoint
Lab : Create a PerformancePoint Dashboard
- Create a PerformancePoint Dashboard
After completing this module, students will be able to:
- Configure lists and libraries for PerformancePoint.
- Create a data source.
- Create a score card and KPI.
- Create PerformancePoint charts and graphs.
Module 9: Power BI
This module explains how work with Power BI.
Lessons
- Overview of Power BI
- How Power BI fits with SharePoint
Lab : Working with Power BI
- Working with Power BI
After completing this module, students will be able to:
- Work with Power BI.
In de klas, online of beiden.
Active Learning
Je maakt samen met je trainer een plan en gaat actief aan de slag. In een kleine klas verdiepen in wat je echt nodig hebt, inzoomen op zaken die je echt interesseren en overslaan wat je al weet of niet nodig hebt. Plan je lesdagen flexibel, neem real-life casussen mee en werk ze uit met je trainer. Verrijk je kennis en verbind het met alles wat je al wist.
E-Learning
Ben je op zoek naar volledige zelfstudie? Wij bieden je de mogelijkheid om jouw training volledig in jouw eigen tijd te volgen. Uiteraard met het officiële lesmateriaal waarmee je de juiste kennis opdoet.
Wil je toch graag een dag persoonlijke begeleiding? Dan kan je altijd een extra lesdag bij boeken en de training als blended learning volgen!
Incompany
Wist jij dat alle IT trainingen die we aanbieden op de website ook bij jouw bedrijf uitgevoerd kunnen worden? Zo volg je een maatwerk IT training (Incompany training) met al je collega’s. Jij kunt de training nog specifieker voor jouw bedrijf laten inrichten en het is zelfs mogelijk om een geheel maatwerk traject door ons te laten ontwerpen.
Je bespaart reiskosten en reistijd voor de deelnemers, doordat onze trainer bij jou op locatie komt. Op deze manier kun je meerdere deelnemers van jouw organisatie dezelfde training laten volgen. Dat is efficiënt en effectief! Samen heb je een gemeenschappelijke opleidingsbehoefte en daar gaan we je bij helpen.
We hebben jarenlang ervaring in het geven van maatwerk it trainingen. We kijken zorgvuldig naar de opleidingsbehoefte om volledig aan te sluiten bij je wensen. Zo formuleren we haalbare en concrete doelstellingen en deelnemers kunnen het geleerde in de praktijk toepassen. Op deze manier groeien deelnemers persoonlijk en professioneel op meerdere niveaus.