Overview

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.

Objectives

After completing this course, students will be able to: - Explore the new Business Intelligence Center, Analysis Services, Excel Services, Business Connectivity Services, Visio Services, Access Services, Power Pivot, Performance Point and Bing Maps.

Audience

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

Syllabus

Overview

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

Business Intelligence

  • Business Intelligence
  • Lab : Business Intelligence Worksheet

Business Intelligence Center

  • Business Intelligence Center
  • Lab : Business Intelligence Center

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

Business Connectivity Services

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

Analysis Services

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

Filter Web Parts

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

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

PowerPivot

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

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

Performance Point

  • Performance Point
  • Lab : Performance Point

Visio and Access Services

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

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

Training provider

Teaching mode:
Classroom - Instructor Led
Online - Instructor Led
Duration: 5 days
Gooroo has partnered with the global leaders in IT training to give you access to quality training, personalised to you, targeted at increasing your job opportunities and salary.

Our pricing

We do not display pricing as Gooroo members qualify for special discounts not available elsewhere. You must enquire through Gooroo to get this benefit.

New courses are happening all the time

Our partner's expert training consultant will provide you with the times and all the details you need. Enquire today.

Top skills covered in this course

SharePoint
United States
This skill has an average salary of
US$80,606
and is mentioned in
1.75%
of job ads in this area.
.NET
United States
This skill has an average salary of
US$101,115
and is mentioned in
1.40%
of job ads in this area.
Microsoft SQL Server
United States
This skill has an average salary of
US$96,230
and is mentioned in
2.10%
of job ads in this area.
Web services
United States
This skill has an average salary of
US$106,613
and is mentioned in
1.79%
of job ads in this area.