

1 877 849 1850	0808 234 2132	1 800 550 311	0 800 022 6730	+1 678 648 3113

SharePoint User Training

SharePoint Administrator Training

SharePoint Developer Training

Live Online Training

Home

About

Please contact us
for GSA pricing.

Contract #
GS-35F-0307T

Recent Training Venues

Accelebrate has recently trained for clients in the following cities:

Huntsville, Alabama
Montgomery / Birmingham, Alabama
Anchorage, Alaska
Edmonton & Calgary, Alberta
Phoenix, Arizona
Tucson, Arizona
Fayetteville / Little Rock, Arkansas
Amsterdam, The Netherlands / Brussels, Belgium
Vancouver, British Columbia
Oakland / San Jose / San Francisco, California
Sacramento, California
San Diego, California
Orange County / Los Angeles, California
Boulder / Colorado Springs / Denver, Colorado
Washington, DC
Wilmington, Delaware
Manchester / London, England
Orlando, Florida
Fort Lauderdale / Miami, Florida
Jacksonville, Florida
Saint Petersburg / Tampa, Florida
Alpharetta & Atlanta, Georgia
Augusta & Savannah, Georgia
Boise, Idaho
Chicago, Illinois
Indianapolis, Indiana
Cedar Rapids / Des Moines, Iowa
Dublin, Ireland
Wichita, Kansas
Lexington / Louisville, Kentucky
Baton Rouge/New Orleans, Louisiana
Portland, Maine
Hagerstown & Frederick, Maryland
Annapolis / Baltimore, Maryland
Boston / Cambridge, Massachusetts
Hartford, Connecticut / Springfield, Massachusetts
Ann Arbor / Detroit, Michigan
Grand Rapids, Michigan
Saint Paul / Minneapolis, Minnesota
Jackson, Mississippi
St. Louis, Missouri
Kansas City, Missouri
Lincoln / Omaha, Nebraska
Reno and Las Vegas, Nevada
Fredericton / Moncton / Saint John, New Brunswick
Albuquerque, New Mexico
Princeton, New Jersey & Philadelphia, Pennsylvania
Albany, New York
Buffalo, New York
White Plains / New York City, New York
Charlotte, North Carolina
Durham / Raleigh, North Carolina
Canton / Akron, Ohio
Cincinnati, Ohio
Cleveland & Columbus, Ohio
Dayton, Ohio
Tulsa / Oklahoma City, Oklahoma
Toronto, Ontario
Portland, Oregon
Pittsburgh, Pennsylvania
San Juan, Puerto Rico
Providence, Rhode Island
Saskatoon / Regina, Saskatchewan
Edinburgh / Glasgow, Scotland
Columbia & Charleston, South Carolina
Spartanburg & Greenville, South Carolina
Knoxville, Tennessee
Memphis / Nashville, Tennessee
Houston, Texas
El Paso, Texas
San Antonio / Austin, Texas
Dallas, Texas
Salt Lake City, Utah
Fairfax / Dulles / McLean / Herndon / Reston, Virginia
Richmond / Alexandria / Arlington, Virginia
Virginia Beach / Norfolk, Virginia
Tacoma / Seattle, Washington
Charleston, West Virginia
Madison / Milwaukee, Wisconsin

SharePoint Training: SharePoint 2010 Business Intelligence

Course Number: SHPT-234
Duration: 5 days
view class outline

SharePoint Training Overview

Accelebrate's SharePoint Training: SharePoint 2010 Business Intelligence teaches attendees how to successfully build and deliver BI applications using SharePoint 2010.

Location and Pricing

Most Accelebrate courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs Please visit our client list to see organizations for whom we have recently delivered training These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses To receive a customized proposal and price quote for private training at your site or online, please contact us.

In addition, some courses are available as live, online classes for individuals To see a schedule of online courses, please visit http://wwwaccelebratecom/online_training/?action=category&page=sharepoint.

SharePoint Training Prerequisites

Some prior NET development experience is required.

Hands-on/Lecture Ratio

This SharePoint training class is 70% hands-on, 30% lecture, with the longest lecture segments lasting 20 minutes.

SharePoint Training Materials

All attendees receive a copy of Wrox's SharePoint 2010 Business Intelligence 24-Hour Trainer.

Software Needed on Each Student PC

Please contact us for a detailed setup sheet.

SharePoint Training Objectives

All attendees will learn how to:

Share reports and documents for collaboration
Connect your data sources with Business Connectivity Services
Use SharePoint lists and libraries for data source repositories in your BI projects
Control data sources, reports and business intelligence content with permissions and workflow approvals
Use PerformancePoint dashboards including Interactive reporting with Excel, PowerPivot advanced analytics, and Visio strategy maps and heat map analytics
Configure and secure SharePoint 2010 business intelligence applications
Integrate Office 2010 and SharePoint for intelligent reporting
Create reports and dashboards within MS Office 2007 and 2010 and publish them to SharePoint
Implement advanced analytics through PerformancePoint and business connectivity services
Tune and scale SharePoint SQL databases and applications to support the new load that the reports, analytics and dashboards will place on the system
Use best practices for planning and implementing your SharePoint business intelligence project plan

SharePoint Training Outline

Why SharePoint for business intelligence?

Kick start your business intelligence
SharePoint features that enhance your business
Extending Office into SharePoint
Customizing SharePoint 2010 to match your company

SharePoint 2010 technical overview

A new SharePoint experience

System requirements
Key servers and server rolls
Central administration

Say goodbye to shared service providers
Improved authentication control

Claims based authentication

SharePoint authentication
Additional SharePoint features

SharePoint central administration overview

What is central administration?
BI service applications
Basics of site management

Data security overview in SharePoint 2010

Managed accounts
Unattended service account
Best practices

Creating and configuring Excel Services applications

Creating an Excel Services application
Enabling Excel Services
Configuring Excel Services security and authentication
Reporting and caching options

Creating and configuring PerformancePoint Services applications

Enabling PerformancePoint Services
Configuring services security and authentication

Kerberos, per-user, unattended service account

Reporting and caching options

Creating and configuring Visio Services applications

Creating a Visio Services application
Enabling Visio Services
Configuring Visio Services security and authentication
Reporting and caching options
Other considerations

Creating and configuring PowerPivot for SharePoint Services applications

SQL Server and SharePoint installations

Stand alone vs. existing farm
Installing SQL Sever PowerPivot for SharePoint
Deploying the PowerPivot solution to SharePoint
Creating the PowerPivot service application
Activating the PowerPivot feature on site collections

PowerPivot authentication
Testing your configuration

Creating your first SharePoint site for business intelligence

Understanding web applications, site collections, and sites
Creating a site in SharePoint 2010
Site options and templates
Business intelligence sites

Configuring reporting services for SharePoint integration

Configuring reporting services for SharePoint integrated mode
Configuring the SharePoint 2010 reporting services add-in
Testing the reporting services configuration

Implementing business connectivity services in SharePoint

What is BCS?
Business Connectivity Services vs. BDC
Design principals in BCS
Installing and configuring BCS
Creating a new BCS list in SharePoint 2010

Developing and deploying Excel Services analytics applications

Developing an Excel Service report

Datasources
Displaying data

Deploying and managing Excel Services reports

Deployment options

Developing and deploying PowerPivot analytics applications

Choosing the right tool for the job
Developing a PowerPivot report
Introduction to Data Analysis Expressions
Creating and deploying reports to a PowerPivot gallery

Developing and deploying Visio Services analytics applications

Creating a diagram with data connectivity
Developing and interactive Visio diagram for SharePoint
Deploying a Visio diagram

Implementing data refresh in Excel Services and PowerPivot

Implementing and Excel Services data refresh
Scheduling a PowerPivot data refresh
Monitoring data refresh failures

Developing and deploying PerformancePoint analytic reports

Types of reports

Analytic charts
Analytic grid
Decomposition tree
Show details
Excel Services
KPI Details
ProClarity Analytics Server Page
Reporting services
Strategy map
Web page

Creating your first report
Extending the report

Developing and deploying PerformancePoint scorecards

Terminology
Creating KPIS
- Filtering KPIS
Using different sources for scorecards
Creating and formatting a scorecard

Creating and deploying PerformancePoint dashboards

Dashboards vs web part pages
Building a PerformancePoint dashboard
Adding interactivity to your dashboard

Developing and deploying PerformancePoint and SharePoint filters

PerformancePoint filters vs. SharePoint filters
Common filters

Time intelligence filters
Member selection filter
Named set filter
Custom MDX filter
SQL Server analysis services filter

Strategy mapping with Visio and PerformancePoint

Why do we map strategy?
Creating a strategy map
Deploying and testing a strategy map

Developing and deploying reporting services reports to SharePoint

Creating a report using BIDS
Configuring BIDS for SharePoint deployment
Deploying a report from BIDS to SharePoint

Theming and personalizing your business intelligence site

Themes in SharePoint: an introduction
Using PowerPoint to create SharePoint themes
Navigating a SharePoint site

Using SharePoint Designer to customize master pages

Introduction to SharePoint Designer
Master page concepts
Master pages in SharePoint
CSS in master pages

Controlling your reporting with versioning, auditing, and content expiration

SharePoint governance as applied to business intelligence
Reporting lifecycle for self-service BI Environment
Using analytics and content expiration

Managing report approval with SharePoint workflow

Introduction to SharePoint workflow
Building simple workflows for report approval
Using Visio to build workflows

Setting up SharePoint search to catalog analytics and reports

Why do you need search?

SharePoint search options

SharePoint foundation search
Basic search administration
Extending your search configuration
- What do you need from scratch?

Managing and optimizing SharePoint SQL Server databases

Overview of SharePoint 2010 databases
Types of content in the SharePoint 2010 databases
Optimization techniques for each content type

Tuning and scaling SharePoint service applications

Tuning and scaling PerformancePoint
Tuning and scaling Excel Services
Tuning and scaling PowerPivot

Planning your SharePoint business intelligence project

Priority drivers

Why are you doing this?
End users are important
Systems and people

Preparing your business intelligence implementation

Infrastructure concerns
Storage and SQL concerns
Licensing concerns
End user technology

Creating your SharePoint project checklist and kickoff plan

Round up the troops
Plan the schedule
Checklist creation 101
Putting things in motion

Conclusion

Java^® and all Java-based marks are registered trademarks of the Oracle Corporation in the U.S. and other countries.

Accelebrate^®
Focuses on You!

Accelebrate’s courses are taught for private groups of 3 or more people at your site or online anywhere worldwide.

Don't settle for a "one size fits all" public class! Have Accelebrate deliver exactly the training you want, privately at your site or online, for less than the cost of a public class.

For pricing and to learn more, please contact us via information request form or phone, or email us at info@accelebrate.com today.

VB.NET, C#, ASP, & ASP.NET Training Java Training SQL Server Training
SharePoint Training Adobe Training PHP Training XML Training Perl Training Sitemap

“Accelebrate,” “Accelerated Learning Celebrated Results,” and the Accelebrate logo are registered trademarks of Accelebrate, Inc. All other product names and trademarks are property of their respective owners. Course outline content may mirror or be derived from the book that each student receives with the course. Otherwise, all content is copyright © 2003- by Accelebrate, Inc. of Atlanta, Georgia, USA. To contact us, please use the contact form, email info@accelebrate.com us, or call 1 877 849 1850 in the US and Canada, 0808 234 2132 in the UK, 1 800 550 311 in Ireland, or +1 678 648 3113 from all other locations.