About Microsoft Office 365 Business Intelligence •
Microsoft Office 365 Business Intelligence
Microsoft SharePoint Business intelligence (BI) is a cloud-based business analytics service that gives you a single view of your most critical business data. You can monitor the health of your business using a live dashboard, create rich interactive reports and access your data on the go with native Mobile apps.
As a part of Office 365, SharePoint BI is only available through a subscription and only available as an add-on to Office 365 Enterprise customers.
Who should attend
This course is for SharePoint 365 administrators who have access to live company data that can be used to create BI visualisations/dashboards.
The course can be tailored to your specific requirements or an Office 365 (BI) visualisation can be created in conjunction with the trainer.
- Lunch and Refreshments – let us know if you have any special dietary needs. [Excluding London]
- Microsoft Office 365 (BI) training manual
- Certificate on completion
- Post course support relating to course content
Aim & Objectives
To create and manage an Office 365 Business Intelligence visualisation.
By the end of the course you will be able to:
- Integrate Visio with SharePoint
- Configure reporting services
- Configure Business Connectivity services
- Configure Performance Point Services
- Configure Excel Services
- Publish Excel data to SharePoint
- Manipulate Excel’s PowerPivot tool
Business Intelligence basics
OLTP vs OLAP data
SharePoint and Business Intelligence
Configuring Visio Services
Visio Services Features
Visio Data Tab
Integrating Visio with SharePoint
Configuring Reporting Services Using Report Builder to edit reports
Loading Reports into Web Parts
Business Connectivity Services
External Content Types
Connecting to external databases
Performance Point Services
Configuring Performance Point Services Business Intelligence Centre
Creating data sources
Configuring Excel Services
Creating and publishing Excel data to SharePoint
Excel Services and SSAS
PowerPivot for Excel
The course can be tailored to your exacting requirements or an Office 365 (BI) visualisation created in conjunction with the trainer.