Framework Training

Code

BI3

Scheduled Dates

8 Jul 2013
30 Sep 2013
25 Nov 2013
3 Feb 2014

Scheduled Address

Framework Training Ltd

154 - 160 Fleet Street
London
EC4A 2DQ

More about our London Training Centre

Experience Level

intermediate

Days

4

Price per person

£1995 +VAT

Course description

Our SharePoint Business Intelligence training course will get you started developing commercial Business Intelligence solutions using the powerful Dashboard, Analyis, and Publishing capabilities of SharePoint Server 2010 and PerformancePoint Services.

The course includes extensive hands-on labs using SharePoint Server 2010, Visual Studio 2010 / 2012, PerformancePoint Services, Excel Services, and PowerPivot, delivered by our expert Microsoft Business Intelligence instructor.

What you will learn

  • Reporting Solutions in SharePoint 2010
  • Dashboard Designer
  • Key Performance Indicators (KPI)
  • Data Marts and Data Warehouses
  • Extracting & Transforming data
  • Populating SharePoint Lists with SQL Server data
  • Business Connectivity Services & External List
  • Data Mining
  • Excel Services
  • PowerPivot For SharePoint & Excel

Who should attend

Database programmers, business analysts and project managers who want to deploy Business Intelligence solutions to SharePoint 2010, PerformancePoint Services, Excel 2010 Services

Prerequisites

Attendance of our Microsoft Business Intelligence course or equivalent experience in SSRS, SSAS, SSIS. Attendance of our SharePoint Application Development (or equivalent experience) course may be useful but is not mandatory.

Business Intelligence with SharePoint and PerformancePoint Services Training Course

SharePoint 2010 Business Intelligence Overview

SharePoint 2010 Reporting solutions

Deploying reporting solutions to SharePoint 2010 Business Intelligence Center
Dashboard Designer
Configuring Reporting Services Web Parts

Analysis & Data Mining

Key Performance Indicators (KPI)
Data Formats
Data Marts and Data Warehouses
Extracting & Transforming data
MDX queries
Data Mining models
Filter Web Parts
Excel Services
Excel MDX Services
PowerPivot For SharePoint
PowerPivot For Excel

SharePoint Lists

Populating SharePoint Lists with SQL Server data
Extract, Transform & Load (ETL) functionality

Business Connectivity Services

Business Connectivity Services & External List

Related courses

sharepoint1 SharePoint 2010 Development Training Course

BI2 Expert Business Intelligence with SQL Server Training Course

BI1 Intro to Microsoft Business Intelligence Training Course (SQL Server 2008 & SQL Server 2012)