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 |
|
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.
|
