Course details

This course explores how to use SharePoint as your platform for Business Intelligence. Journey through the SharePoint Business Intelligence Center, Excel Services, Reporting Services, Analysis Service, Performance Point and PowerPivot.

Course Outline

1 - Overview

  • Understand your course, classroom, classmates, facility and instructor.

2 - Business Intelligence

  • Business Intelligence
  • Lab : Business Intelligence Worksheet

3 - Business Intelligence Center

  • Business Intelligence Center
  • Lab : Business Intelligence Center

4 - Data Mart and Data Warehouses

  • Understanding Data and Data Formats
  • Building Data Marts and Data Warehouses
  • Lab : Data and Data Formats
  • Lab : Build A Data Warehouse
  • Lab : Extract and Load
  • Lab : Transform and Load
  • Lab : Granularity
  • Lab : Build A Data Mart
  • Lab : SQL Server to SharePoint Lists

5 - Business Connectivity Services

  • Business Connectivity Services
  • Lab : BCS Basics
  • Lab : BCS With Data Warehouse
  • Lab : Office and BCS for BI

6 - Analysis Services

  • Analysis Services
  • Lab : Analysis Services
  • Lab : Building An Analysis Services Database

7 - Filter Web Parts

  • Filter Web Parts
  • Lab : Filter Web Parts
  • Lab : UserProfiles and Filters

8 - Excel Services

  • Excel Services
  • Lab : Create An Excel Report
  • Lab : Excel Services
  • Lab : MDX
  • Lab : Sparklines
  • Lab : Filters and Excel Services
  • Lab : REST and Web Services

9 - PowerPivot

  • PowerPivot For SharePoint
  • PowerPivot For Excel
  • Lab : Install Power Pivot
  • Lab : Use PowerPivot

10 - Reporting Services

  • Reporting Services
  • Reports
  • Lab : Install Reporting Services
  • Lab : Building Reports with Reporting Services
  • Lab : Create Advanced Reporting Services reportFilter Web Parts and Reports
  • Lab : Reporting Services and PowerPivot

11 - Performance Point

  • Performance Point
  • Lab : Performance Point

12 - Visio and Access Services

  • Visio Services
  • Access Services
  • Lab : Visio Services
  • Lab : Access Services

13 - GeoSpatial Data with Charts and Maps

  • Charts and Maps
  • GeoSpatial Data
  • Lab : GeoSpatial Data with SQL Server
  • Lab : Bing Maps
  • Lab : .NET Charts
  • Lab : Google Maps

Target Audience: Sr Business Intelligence Architects and Consultants, Sr Business Analysts, anyone responsible for implementing BI with SharePoint.

Updated on 08 November, 2015

About New Horizons Ireland

With a very convenient location next to Jervis street in Dublin 1, we offer a wide range of IT and business skills courses and we can also send our instructors to your location.

We are 100% Irish owned, but we are also part of the largest independent IT Training Provider, New Horizons Computer Learning Centres who deliver more courses than any other IT training company.

Because we're local, we understand the needs of business and individuals in our community. Whether you choose to take classes in person or online, you're always welcome to call or stop by.

See all New Horizons Ireland courses
Are you from New Horizons Ireland ? Claim your course!
Courses you can instantly connect with... Do an online course on SharePoint starting now. See all courses

Is this the right course for you?

Didn't find what you were looking for ?

or