SharePoint 2010 Business Intelligence

Course:  SP10BI
Duration:  4 Days
Level:  II
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.

« Hide The Details
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:

  • Describe the SharePoint 2010 Business Intelligence capabilities
  • Understand Dimensions, Measures and Cubes
  • Create and deploy reports using Report Builder 3.0
  • Load and Manage Reports with SharePoint
  • Utilize the Business Intelligence add-ins for Excel
  • Discover, design and implement KPIs
  • Understand the role of SQL Server Analysis Services in measurement for KPIs
  • Use Excel Services and Excel Workbooks in Scorecards or as a data source
  • Utilize the document management capabilities of SharePoint 2010 for objects for versioning, document retention and reverting.
  • Use Dashboard Designer
  • Gain a generalized understanding of MDX to write basic queries
  • Generate Visual Reports and tie them into Dashboards
  • Utilize decomposition trees
  • Understand what the advantages of having SharePoint as the platform are.
  • Use dynamic hierarchies in Scorecards
  • Implement User Menus in Scorecards
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

« Hide The Details
Related Courses
Code Course Title Duration Level
SQL Server 2012 Business Intelligence Overview
2 Days
SharePoint 2010 for End Users
2 Days

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.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]