Toll Free - 877-442-3915

Account | Self-Paced Login

Account | Self-Paced Login | 877-442-3915

SharePoint 2010 Business Intelligence  Course

SharePoint 2010 Business Intelligence Training Course


Course Description:

Training Dates
(Click on the course name below to view course details and full list of class dates)
Course Syllabus



Section 1: Overview
A simple introduction section.

Section 2: Business Intelligence
In this section, we review what Business Intelligence (BI) is and what the typical BI goals are. We also discuss how Microsoft BI tools are enabling more advanced Business Intelligence features to filter down/up to the decision makers and Information Workers in general.
Topics
•Business Intelligence
Lab 1: Business Intelligence Worksheet
•Answer Business Intelligence Questions

Section 3: Business Intelligence Center
In this section, we are going to discuss the Business Intelligence Center site definition that comes with SharePoint 2010.
Topics
•Business Intelligence Center
Lab 1: Business Intelligence Center
•Exploring SharePoint Business Intelligence Center
•Exploring Dashboard Designer

Section 4: Data Mart and Data Warehouses
In this section, we discuss what data is and some of the many forms that it takes. We then discuss and define the terms Data Warehouse and Data Mart. This section is important in that as we move through the remainder of the course, we will need to have data to manipulate and work with to build our BI components.
Topics
•Understanding Data and Data Formats
•Building Data Marts and Data Warehouses
Lab 1: Data and Data Formats
•Exploring Data Formats
Lab 2: Build A Data Warehouse
•Creating a Simple Data Warehouse
Lab 3: Extract and Load
•Exploring the Extract stage
Lab 4: Transform and Load
•Exploring Transform and Load stages
•Realizing the importance of primary/unique keys
Lab 5: Granularity
•Creating Data Warehouse Granularity Levels
Lab 6: Build A Data Mart
•Creating a Data Mart
Lab 7: SQL Server to SharePoint Lists
•Populate a SharePoint List with SQL Server data

Section 5: Business Connectivity Services
In this section, we are going to take a look at the new Business Connectivity Services.
Topics
•Business Connectivity Services
Lab 1: BCS Basics
•Exploring External Content Types
•Creating a new External Content Type
•Creating an External List
Lab 2: BCS With Data Warehouse
•Creating an Large External List using ECTs
•Using Filters and External lists
•Creating and Configuring Entity Profile Pages
Lab 3: Office and BCS for BI
•Exploring Office and BCS Integration

Section 6: Analysis Services
In this section, we will discuss the feature of SQL Server called Analysis Services (SSAS). When regular SQL queries can't handle your data, MDX queries in SSAS can!
Topics
•Analysis Services
Lab 1: Analysis Services
•Creating Dimension and Fact tables with SSIS
Lab 2: Building An Analysis Services Database
•Creating a Analysis Services Database
•Creating a Cube
•Creating Dimensions
•Creating Fact Tables
•Creating a KPI

Section 7: Filter Web Parts
In this section, we will discuss Filter Web Parts and the important role they play in building Business Intelligence portals.
Topics
•Filter Web Parts
Lab 1: Filter Web Parts
Using each of the Filter Web Parts
Lab 2: User Profiles and Filters
Integrating User Profiles with Filters and Reports

Section 8: Excel Services
In this section, we will discuss and work with the various features of SharePoint's Excel Services.
Topics
•Excel Services
Lab 1: Creating An Excel Report
•Creating An Excel Report
Lab 2: Excel Services
Learning to use Excel Services
•Creating/Publish to Excel Services
Configuring Excel Services
•Shared Data Connections
Lab 3: MDX
•Exploring Excel 2010 MDX features
•Creating a Slicer
•Creating an MDX Set
Lab 4: Sparklines
Using Excel 2010 Sparklines
Lab 5: Filters and Excel Services
•Exploring Filter Web Parts and Excel Services
Lab 6: REST and Web Services
•Exploring REST features of Excel Services
•Exploring the Excel Services Web Service

Section 9: PowerPivot
In this section, we discuss the new PowerPivot tools of SQL Server 2008 R2 and Excel 2010.
Topics
•PowerPivot For SharePoint
•PowerPivot For Excel
Lab 1: Install Power Pivot
•Installing PowerPivot for Excel
•Installing PowerPivot for SharePoint 2010
Configuring PowerPivot for SharePoint
Lab 2: Use PowerPivot
•Exploring PowerPivot Functions
Using Basic PowerPivot
Using PowerPivot with Large DataSets
•Creating PowerPivot Linked Tables
•Publishing to SharePoint
•Automating Data Refresh
•Analyzing Usage Data

Section 10: Reporting Services
In this section, we will discuss Reporting Services, its integration with SharePoint and how to build Reporting Services reports.
Topics
•Reporting Services
•Reports
Lab 1: Install Reporting Services
Configuring Reporting Services
•Creating a Reporting Services Report
Configuring Reporting Services Web Part
Lab 2: Building Reports with Reporting Services
•Creating Advanced Reporting Services report
•Filter Web Parts and Reports
Lab 3: Creating Advanced Reporting Services reportFilter Web Parts and Reports
•Creating Report Part Gallery
•Creating a Report Library
•Creating Report Parts
•Creating a Report using Report Parts
•Automated Report Delivery
Lab 4: Reporting Services and PowerPivot
•Setup Reporting Services RSS Feed
•Creating and Use Data Feed Library
•Utilize Reporting Services data in PowerPivot
•Utilize PowerPivot data in Reporting Services

Section 11: Performance Point
In this section, we will discuss Performance Point and how it supercharges your BI Dashboards and Key Performance Indicators.
Topics
•Performance Point
Lab 1: Performance Point
•Exploring Performance Service Application
•Exploring the Dashboard Designer
•Creating a Scorecard
•Creating a PP KPI
•Exploring Time Intelligence
•Creating Performance Point Reports
•Creating Filters
•Creating a Dashboard

Section 12: Visio and Access Services
In this section, we will discuss Visio and Access Services and how to integrate it into your Report process.
Topics
•Visio Services
•Access Services
Lab 1: Visio Servcies
Using Visio Services
•Publish a Visio to SharePoint
•Tie report process to Visio
Lab 2: Access Services
•Exploring Access Services
•Publish Access Database To SharePoint

Section 13: GeoSpatial Data with Charts and Maps
In this section, we will discuss GeoSpatial data and how to use the new .NET Charts and Mapping features of SharePoint 2010.
Topics
•Charts and Maps
•GeoSpatial Data
Lab 1: GeoSpatial Data with SQL Server
•Populating a SQL Server Database using Shape2SQL
•Utilizing the new Spatial Data Types in SQL Server
•Creating a Reporting Services Report using Geospatial Data
•Publish Geospatial Data to SharePoint 2010
Lab 2: Bing Maps
•Utilize Bing Maps API
•Creating a Simple Map With Content Editor Web Part
•Creating an Advanced Map with Data Views
•Exploring Filters, Data Views and Bing Maps integration
Integrating Geospatial Customer data into SharePoint Sites
Lab 3: .NET Charts
•Utilize .NET Charts
Lab 4: Google Maps
•Utilize Google Maps API
•Creating a Simple Map With Content Editor Web Part
•Creating an Advanced Map with Data Views
•Exploring Filters, Data Views and Google Maps integration
Integrating Geospatial Customer data into SharePoint Sites

Available Locations

Alabama
Birmingham
Birmingham South
Huntsville
Mobile
Montgomery

Arizona
Mesa
Phoenix
Scottsdale
Tucson

Arkansas
Bentonville
Fayetteville
Little Rock
Little Rock west

California
Bakersfield
El Segundo
Elk Grove
Fresno
Glendale
Irvine
Los Angeles
Los Angeles West
Mission Valley
Orange
Palo Alto
Petaluma
Pleasanton
Redwood City
Riverside
Sacramento
San Diego
San Diego downtown
San Francisco
San Jose
Walnut Creek
Woodland Hills

Colorado
Boulder
Centennial
Colorado Springs
Denver
Fort Collins
Grand Junction
Lakewood
Loveland

Connecticut
Cheshire
Danbury
East Granby
Hartford
Rocky Hill
Shelton
Stamford

Delaware
Wilmington DE

Florida
Boca Raton
Brandon
Clearwater
Daytona Beach
Fort Myers
Fort Walton Beach
Ft Lauderdale
Jacksonville
Kissimmee
Lake Mary
Lakeland
Land O Lakes
Melbourne
Miami
Miami Doral
Miramar Beach
Naples
Orange Park
Orlando
Orlando Downtown
Orlando Northeast
Palm Beach Gardens
Pensacola
Plantation
Sarasota
St Petersburg
Tallahassee
Tampa
Vero Beach

Georgia
Alpharetta
Atlanta Buckhead
Augusta
Columbus GA
Duluth
Kennesaw
Macon
Savannah

Idaho
Boise
Meridian

Illinois
Chicago
Gurnee
Joliet
Naperville
Northbrook
Oakbrook Terrace
Peoria
Rockford
Schaumburg

Indiana
Carmel
Evansville
Fort Wayne
Indianapolis
Indianapolis downtown
South Bend

Iowa
Cedar Rapids
Des Moines
Quad Cities

Kansas
Lenexa
Topeka
Wichita

Kentucky
Erlanger
Lexington
Louisville

Louisiana
Baton Rouge
Lafayette
New Orleans

Maine
Portland ME

Maryland
Annapolis
Baltimore
Bethesda
Columbia MD
Ellicott City
Frederick
Germantown
Greenbelt
Owings Mills
Rockville
Towson

Massachusetts
Boston
Braintree
Danvers
Mansfield
Newton
North Andover
Norwell
Springfield MA
Westborough
Woburn
Worcester

Michigan
Ann Arbor
Franklin MI
Grand Rapids
Kalamazoo
Lansing
Livonia
Novi
Traverse City
Troy

Minnesota
Bloomington
Maple Grove
Minneapolis
Minneapolis downtown
Rochester MN
St Cloud
Woodbury

Mississippi
Gulfport
Jackson

Missouri
Columbia MO
Kansas City
Lees Summit
O Fallon
Springfield
St Louis
St Louis downtown

Montana
Great Falls

Nebraska
Lincoln
Omaha

Nevada
Henderson
Las Vegas
Reno

New Hampshire
Bedford
Concord
Londonderry
Nashua
Portsmouth

New Jersey
Bridgewater
East Brunswick
East Rutherford
Hamilton
Jersey City
Mahwah
Morristown
Mt Laurel
Paramus
Princeton
Red Bank

New Mexico
Albuquerque

New York
Albany
Bohemia
Brooklyn
Buffalo
Harrison
Melville
Mt Kisco
New York City - Grand Central Station
New York City - Lower Manhattan
New York City - Penn Station
Poughkeepsie
Queens
Rochester
Syracuse
Uniondale

North Carolina
Asheville
Chapel Hill
Charlotte
Charlotte North
Charlotte Uptown
Fayetteville
Greensboro
Hickory
Morrisville
Raleigh
Wilmington

North Dakota
Fargo
Grand Forks

Ohio
Akron
Beachwood
Blue Ash
Cincinnati
Cleveland
Columbus
Columbus Downtown
Dayton
Dublin
Independence OH
Norwood
Toledo
Westlake
Youngstown

Oklahoma
Edmond
Oklahoma City
Tulsa

Oregon
Beaverton
Eugene
Medford
Portland
Salem
Tualatin

Pennsylvania
Allentown
Conshohocken
Erie
Harrisburg
Huntingdon Valley
Lancaster
Malvern
Philadelphia
Pittsburgh
Pittsburgh downtown
State College
University Center
Wexford
York

Rhode Island
Providence
Warwick

South Carolina
Cayce
Greenville
Mount Pleasant

South Dakota
Sioux Falls

Tennessee
Chattanooga
Franklin
Knoxville
Memphis
Nashville

Texas
Addison
Amarillo
Austin
Austin downtown
Bryan
Corpus Christi
Dallas
El Paso
Fort Worth
Grapevine
Houston
Houston North
Irving
Katy
Keller
League City
McAllen
Midland
Plano
Plano Frisco
San Antonio
San Antonio downtown
Sugar Land
The Woodlands
Waco

Utah
Provo
Salt Lake City

Vermont
Shelburne

Virginia
Alexandria
Arlington VA
Charlottesville
Fairfax
Fredericksburg
Glen Allen
Lynchburg
Manassas
McLean
Newport News
Norfolk
Reston
Richmond
Roanoke

Washington
Bellevue
Bellingham
Bothell
Kennewick
Mukilteo
Olympia
Puyallup
Seattle
Spokane
Tacoma

Washington DC
Washington DC
Washington DC - Union Station

West Virginia
Martinsburg

Wisconsin
Brookfield
Glendale WI
Green Bay
Madison
Madison east
Milwaukee

Wyoming
Casper
Cheyenne


Online Self-Paced Training Value Package Only $149

"The Instructor made class truly interesting and put everything into real world terms."
- Meredith T(Jersey City, NJ)


Business Computer Skills BBB Profile