Microsoft Office 365 Business Intelligence

  • Select Location
Select a location then date
No dates available
Price (exc vat): £3980
PrintDURATION: 4 days
TIME: 09:30 to 16:30 GMT

Consolidate real time business data using Microsoft Office 365 Business Intelligence to display performance, on a range of devices. Training on-site using your system and equipment. The price is for 4 delegates attending the same course.

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.

Tailored Training

The course can be tailored to your specific requirements or an Office 365 (BI) visualisation can be created in conjunction with the trainer.

Course Includes

  • 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

Course Content

Business Intelligence basics

OLTP vs OLAP data
Data Warehouses
Data Marts

SharePoint and Business Intelligence

New Features

Visio Services

Configuring Visio Services
Visio Services Features
Visio Data Tab
Integrating Visio with SharePoint

Reporting Services

Configuring Reporting Services Using Report Builder to edit reports
Loading Reports into Web Parts

Business Connectivity Services

Configuring Business
Connectivity Services
External Content Types
Connecting to external databases

Performance Point Services

Configuring Performance Point Services Business Intelligence Centre
Dashboard Designer
Creating data sources
Creating KPIs
Creating Scorecards
Creating reports

Excel Services

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.

Video Testimonials

Client Testimonials

  • Name: 200 + delegatesCompany: Via

    View all testimonials

  • Name: Scott SellarsCompany: More on

    APM Project Management Qualification (PMQ) course review

    I completed the PMQ course through IPSO FACTO and they were a pleasure to work with from the moment I first made an enquiry. Every piece of course administration was made simple for me and the classroom facilities were just perfect. The course instructor was professional, knew the subject very well and focused our learning in a practical way to help put it into perspective. Overall, a very professional experience and I would recommend IPSO FACTO as a quality training company. Thank you. [Scott Sellars]

    Link to more reviews: ipsofacto live reviews

    View all testimonials

  • Name: Simon M.Company: Career Change

    PRINCE2 Foundation and Practitioner course review

    I attended the project management qualification in December (having already attended the PRINCE2 course in November). Although a challenging subject, I found that the training was engaging because there was adequate time to not only listen but to also give examples and hear examples from other individuals from the class. This aids to help people’s understanding or misunderstanding in some cases and help breakdown the subject into easier chunks. It also helps that IPSO FACTO have in my opinion some of the most experienced instructors in the country, meaning that if you just don’t get something they bring their personal experience into the story to help your understanding. Simon M.

    Link to more reviews: ipsofacto live reviews

    View all testimonials

  • Name: Chelsea B.Company: More on

    APM PFQ (Introductory Certificate) course review

    The PFQ (APM IC) was for me a good introduction into understanding the ‘Project Management’ world better. It helped me to identify areas and processes that I am not yet familiar with but I now have more confidence in tackling. Passing this course has further confirmed that I do want to go on to study for the APMP qualification. Chelsea B.

    Link to more reviews: ipsofacto live reviews

    View all testimonials