SharePoint 2010 Business Intelligence

Course:   SP10BI
Duration:   4 Days
Level:   II
On our website at:   http://www.verhoef-training.com/courses/SP10BI.html
 
Course Summary

This course provides students with the knowledge and skills to create business solutions using SharePoint 2010, PerformancePoint Services, Excel Services, and Report Builder 3.0. The course introduces the students to Microsoft Analysis Services, Reporting Services, SharePoint 2010 Integration, Reporting Services Content Types, and Dashboard Designer.

Topics Covered In This Course

Business Intelligence Overview

  • Business Intelligence Platform
  • Analysis Services
  • Reporting Services
  • Performance Management Tools
  • Multidimensional Space
  • MDX
  • Understanding the Terminology

Analysis Services

  • Key Concepts
  • Schemas
  • Measures
  • Dimensions
  • Cube Processing
  • Partitions
  • Proactive Caching
  • Aggregations

Reporting Services

  • Integration with SharePoint
  • Getting Started
  • Report Authoring Concepts
  • Report Design Tips
  • Finding, Viewing, and Managing Reports
  • Adding Data to a Report
  • Tables, Matrices, and Lists
  • Report Parts
  • Charts
  • Sparklines and Data Bars
  • Gauges
  • Indicators
  • Maps
  • Images, Text Boxes, Rectangles, and Lines
  • Formatting Report Items
  • Parameters
  • Filtering, Grouping, and Sorting Data
  • Drillthrough, Drilldown, Subreports, and Nested Data Regions
  • Expressions
  • Interactive Sorting, Document Maps, and Links
  • Page Layout and Rendering
  • Exporting Reports
  • Printing Reports
  • Saving Reports
  • Troubleshooting Report
  • Deployment considerations

MDX (Optional)

  • What is MDX?
  • MDX Query Editor
  • Select Statement
  • Key Concepts
  • Sets
  • Functions

PerformancePoint Services 2010

  • Integration with SharePoint Server 2010
  • Common Service Application Framework
  • New PerformancePoint Features
  • KPI Details Report
  • Scorecards in PPS
  • KPI Collections
  • Dashboard Design Guidelines
  • Create a Basic Dashboard
  • Deploy the Dashboard
  • Explore the Dashboard in PPS
  • Dashboard Designer Internals
  • Dashboard Designer Interface
  • Dashboard Designer Features

Excel Services 2010

  • Integration with SharePoint Server 2010
  • Excel Web Services
  • New capabilities

Excel PowerPivot

  • Integration with SharePoint Server 2010
  • Understanding
  • Explore Excel PowerPivot
What You Can Expect

At the end of this course, delegates will be able to:

Who Should Take This Course

This course is designed for Business Professionals who need to use SharePoint 2010 Business Intelligence features.

Recommended Prerequisites

SharePoint 2010 End User class or equivalent experience

Training Style

Instructor led with 50% lecture and 50% lab

Related Courses
Code Course Title Duration Level
SSBIO
SQL Server 2012 Business Intelligence Overview
2 Days
I
Details
SPUSER
SharePoint 2010 for End Users
2 Days
I
Details

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.