Sharepoint 2010 Business Intelligence Course

Overview

Readify is pleased to offer our clients the Sharepoint 2010 Business Intelligence Course,; curriculum developed by Architecting Connected Systems in the USA. We recognise that many of our clients wish to extend the power of their Sharepoint Platform, benefit from exposing information from disparate systems to the business, and drive down the cost of BI activities within the organisation. This course is ideal.

The course coveres how to use SharePoint as your platform for business intelligence. Journey through the SharePoint Business Intelligence Center, Excel Services, Reporting Services, Analysis Service, Performance Point and PowerPivot to implement your BI Strategies and enable your decision makers to see data in new and dynamic ways!

  Explore the new Business Intelligence Center, Analysis Services, Excel Services, Business Connectivity Services, Visio Services, Access Services, Power Pivot, Performance Point and Bing Maps.

Who Should Attend

Senior Business Intelligence Architects and Consultants, Senior Business Analysts, anyone responsible for implmenting BI with SharePoint.

Course Prerequisites

Understanding of SharePoint 2010 User Interface, database reporting concepts and familiarity with Data Marts and Data Warehouses.

Course Author

Chris Givens

Course Outline

Business Intelligence

• Answer Business Intelligence Questions

Business Intelligence Center

• Explore SharePoint Business Intelligence Center
• Understand a Key Performance Indicator
• Explore Dashboard Designer

Data Mart & Data Warehouses

• Explore Data Formats
• Create a Simple Data Warehouse
• Explore the Extract stage
• Explore Transform & Load stages
• Realize the importance of primary/unique keys
• Create Data Warehouse Granularity Levels
• Create a Data Mart

Business Connectivity Services

• Explore External Content Types
• Create a new External Content Type
• Create an External List
• Create a new External Content Type
• Create an External List
• Filters and External lists
• Entity Profile Pages
• Explore Office and BCS Integration

Analysis Services

• Create Dimension and Fact tables
• Create an Analysis Services Database
• Create a Analysis Services Database
• Create a Cube
• Create Dimensions
• Create Fact Tables
• Create a KPI

Filter Web Parts

• Use each of the Filter Web Parts

Excel Services

• Create An Excel Report
• Learn to use Excel Services
• Create/Publish to Excel Services
• Configure Excel Services
• Shared Data Connections
• Explore Excel 2010 MDX features
• Create a Slicer
• Create an MDX Set
• Use Excel 2010 Sparklines
• Explore Filter Web Parts and Excel Services
• Explore REST features of Excel Services
• Explore the Excel Services Web Service

PowerPivot

• Install PowerPivot for Excel
• Install PowerPivot for SharePoint 2010
• Configure PowerPivot for SharePoint
• Explore PowerPivot Functions
• Use Basic PowerPivot
• Use PowerPivot with Large DataSets
• Create PowerPivot Linked Tables
• Publish to SharePoint
• Automating Data Refresh
• Analyzing Usage Data

Reporting Services

• Configure Reporting Services
• Create a Reporting Services Report
• Configure Reporting Services Web Part
• Create Advanced Reporting Services report
• Filter Web Parts and Reports
• Create Report Part Gallery
• Create a Report Library
• Create Report Parts
• Create a Report using Report Parts
• Automated Report Delivery

Performance Point

• Explore Performance Service Application
• Explore the Dashboard Designer
• Create A Scorecard
• Create A PP KPI
• Explore Time Intelligence
• Create Performance Point Reports
• Create Filters
• Create A Dashboard

Visio & Access Services

• Use Visio Services
• Publish a Visio to SharePoint
• Tie report process to Visio
• Explore Access Services
• Publish Access Database To SharePoint

GeoSpatial Data with Charts & Maps

• Utilize the new Spatial Data Types in SQL Server
• Explore new features of SQL Server Management Studio
• Utilize Bing Maps API
• Create a Simple Map With Content Editor Web Part
• Create an Advanced Map with Data Views
• Explore Filters, Data Views and Bing Maps integration
• Integrate Geospatial Customer data into SharePoint Sites
• Utilize .NET Charts

Course Details

Occasionally we propose a date window to aid organisations with scheduling and budget preparation. If you would like more information about this training, please contact your Readify Account Manager, or phone our national hotline, 1300 666 287, to be connected you to your local representative.