A Small Class Size is the Best Learning Environment*
Only F1 has no more than 6 Delegates in a Class
Everyone has Individual Attention from the Trainer

View Recent History

Course:(8911) Installation and Deployment in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2552) Designing, Planning, and Managing a Windows SharePoint Services Infrastructure - Microsoft Training Courses in London and South West
Course:(F1024) What's New in Microsoft CRM 3.0 - Applications - Microsoft Training Courses in London and South West
Course:(2732) Planning Deploying and Managing an Enterprise Project Management Solution - Microsoft Training Courses in London and South West
Course:(2505) Deploying Microsoft Office XP - Microsoft Training Courses in London and South West
indexes/Certification_courses_index.aspx Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2289) Deploying Business Desktops with Microsoft Windows XP and Microsoft Office 2003 - Microsoft Training Courses in London and South West
Course:(2830) Designing Security for Microsoft Networks - Microsoft Training Courses in London and South West
Course:(80054) Project Managing Microsoft Dynamics CRM Implementations with Microsoft Dynamics Sure Step - Microsoft Training Courses in London and South West
Course:(F1008) Developer Reskilling: Visual FoxPro to Visual Basic - Microsoft Training Courses in London and South West
Course:(2073) Programming a Microsoft SQL Server 2000 Database - Microsoft Training Courses in London and South West
Course:(F1002) Visual FoxPro 6.0 Enterprise - Microsoft Training Courses in London and South West
Course:(5060) Implementing Windows SharePoint Services 3.0 - Microsoft Training Courses in London and South West
Course:(8529) Microsoft CRM 3.0 Administration - Microsoft Training Courses in London and South West
Course:(2030) Creating Reporting Solutions using Microsoft SQL Server 2000 Reporting Services - Microsoft Training Courses in London and South West
Course:(2731) Deploying and Managing Microsoft Identity Integration Server (MIIS) 2003 - Microsoft Training Courses in London and South West
Course:(4009) Setting Up Projects for Success Using Microsoft Office Project 2003 - Microsoft Training Courses in London and South West
Course:(8522) Microsoft CRM 3.0 Marketing Automation - Microsoft Training Courses in London and South West
Course:(2553) Designing, Planning, and Managing a SharePoint Portal Server 2003 Infrastructure - Microsoft Training Courses in London and South West
Course:(2723) Microsoft SQL Server 2000 for Experienced Database Professionals - Microsoft Training Courses in London and South West
Course:(F1028) Introduction to Microsoft Dynamics CRM 4 for Small and Medium Businesses - Microsoft Training Courses in London and South West
Course:(2591) Implementing Replication Using Microsoft SQL Server 2000 - Microsoft Training Courses in London and South West
Course:(F1023) What's New in Microsoft CRM 3.0 - Technical - Microsoft Training Courses in London and South West
Course:(1131) SQL Server 7.0 Upgrade and Migration - Microsoft Training Courses in London and South West
Course:(6294) Planning and Managing Windows 7 Desktop Deployments and Environments - Microsoft Training Courses in London and South West
Course:(2093) Implementing Business Logic with MDX in Microsoft SQL Server 2000 - Microsoft Training Courses in London and South West
Course:(2071) Querying Microsoft SQL Server 2000 with Transact-SQL. - Microsoft Training Courses in London and South West
Exchange Server 2010 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8526) Microsoft CRM 3.0 Installation and Configuration - Microsoft Training Courses in London and South West
Visual Studio 2008 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2840) Implementing Security for Applications - Microsoft Training Courses in London and South West
Course:(2074) Designing and Implementing OLAP Solutions with Microsoft SQL Server 2000 - Microsoft Training Courses in London and South West
Course:(4005) Beyond the Spreadsheet: Managing Financial Information Using Microsoft Office Access 2003 - Microsoft Training Courses in London and South West
Course:(5061) Implementing Microsoft Office SharePoint Server 2007 - Microsoft Training Courses in London and South West
Course:(80003) Workflow in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Visual Basic .NET Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(5056) First Look: Windows Vista for IT Professionals - Microsoft Training Courses in London and South West
Course:(80002) Administration in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2015) Enabling Business Processes using XML Smart Documents and Smart Solutions within the Microsoft Office System - Microsoft Training Courses in London and South West
Visual Studio .NET Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8524) Microsoft CRM 3.0 Service Scheduling - Microsoft Training Courses in London and South West
Course:(1634) Accelerated Training for Microsoft SQL Server 7.0 - Microsoft Training Courses in London and South West
Application Architecture Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(F1032) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Power User in 3 Days Flat! - Microsoft Training Courses in London and South West
Course:(8912) Customisation and Configuration in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2014) Customizing Microsoft Office SharePoint Portal Server 2003 - Microsoft Training Courses in London and South West
Course:(4002) Forecasting and Trend Analysis Using Microsoft Office Excel 2003 - Microsoft Training Courses in London and South West
Course:(2151) Microsoft Windows 2000 Network and Operating System Essentials - Microsoft Training Courses in London and South West
Windows Server 2008 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8913) Applications in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2092) Populating a Data Warehouse with Microsoft SQL Server 2000 Data Transformation Services - Microsoft Training Courses in London and South West
Course:(8521) Microsoft CRM 3.0 Sales Management - Microsoft Training Courses in London and South West
Course:(F1033) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Developer in 5 Days Flat! - Microsoft Training Courses in London and South West
Course:(F1004) FoxPro 2.6 Intensive - Microsoft Training Courses in London and South West
Course:(4008) Building Better Microsoft Office Word 2003 Documents in Less Time - Microsoft Training Courses in London and South West
Course:(6064) Planning, Implementing, and Managing Windows Mobile 6 - Microsoft Training Courses in London and South West
Course:(8530) Microsoft CRM 3.0 Data Migration - Microsoft Training Courses in London and South West
Course:(6292) Installing and Configuring Windows 7 Client - Microsoft Training Courses in London and South West
Course:(6438) Implementing and Administering Windows SharePoint Services 3.0 in Windows Server 2008 - Microsoft Training Courses in London and South West
Course:(8525) Microsoft CRM 3.0 Customization - Microsoft Training Courses in London and South West
Course:(6289) First Look: Windows 7 Beta for IT Professionals - Clinic & Hands-on Lab - Microsoft Training Courses in London and South West
Course:(80141) Integrating Microsoft Dynamics CRM 4.0 and Microsoft Office SharePoint Server 2007 - Microsoft Training Courses in London and South West
Course:(50219) Introduction to Microsoft Windows 7 for Developers - Microsoft Training Courses in London and South West
Course:(6291) Updating Your Technology Knowledge of Microsoft Windows XP to Windows 7 Beta - Microsoft Training Courses in London and South West
Course:(3370) First Look: Getting Started with Microsoft Office SharePoint Server 2007 - Microsoft Training Courses in London and South West
Course:(6067) Developing Native Applications for Microsoft Windows Mobile 6 - Microsoft Training Courses in London and South West
Course:(2554) Designing, Planning, and Managing a Windows SharePoint Services and SharePoint Portal Server 2003 Infrastructure - Microsoft Training Courses in London and South West
Course:(50429) Microsoft SharePoint 2010 Business Intelligence - Microsoft Training Courses in London and South West
Course:(8910) What's New in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2013) Optimizing Microsoft SQL Server 7.0 - Microsoft Training Courses in London and South West
Course:(2810) Fundamentals of Network Security - Microsoft Training Courses in London and South West
Course:(6066) Developing Managed Applications for Microsoft Windows Mobile 6 - Microsoft Training Courses in London and South West
Course:(1140) Microsoft SQL Server 7.0 Overview - Microsoft Training Courses in London and South West
Course:(8036) Designing IT Platform Collaborative Applications with Microsoft SharePoint 2003 Workshop - Microsoft Training Courses in London and South West
Course:(F1030) Advanced Microsoft Dynamics CRM 4 for Small and Medium Businesses - Microsoft Training Courses in London and South West
Course:(4003) Summarizing Microsoft Office Excel 2003 Data to Make Better Business Decisions - Microsoft Training Courses in London and South West
Visual Studio 2010 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2439) Scripting Microsoft Windows Management Instrumentation - Microsoft Training Courses in London and South West
Course:(2088) Designing a Highly Available Web Infrastructure (IIS) - Microsoft Training Courses in London and South West
Course:(2264) Exam Preparation for the MCDST Certification - Microsoft Training Courses in London and South West
Course:(2381) Planning Collaborative Solutions With Microsoft Office XP Technologies - Microsoft Training Courses in London and South West
Course:(3374) First Look: First Look: Getting Started with Microsoft Office 2007 SharePoint Server Hands-On Lab - Microsoft Training Courses in London and South West
Course:(8879) Using the Microsoft Dynamics Sure Step Methodology for Microsoft Dynamics CRM - Microsoft Training Courses in London and South West
Course:(F1034) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Expert in 7 Days Flat! - Microsoft Training Courses in London and South West
Office (inc SharePoint) Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(10175) Microsoft SharePoint 2010, Application Development - Microsoft Training Courses in London and South West
Course:(2657) Programming Microsoft Access 2002 - Microsoft Training Courses in London and South West
Course:(4006) Time and Task Management Using Microsoft Office Outlook 2003 - Microsoft Training Courses in London and South West
Course:(F1037) Customisation of xRM/CRM for Microsoft Partners and Customers - Microsoft Training Courses in London and South West
Application Centre Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(6331) Deploying and Managing Microsoft System Center Virtual Machine Manager - Microsoft Training Courses in London and South West
Visual Basic 6.0 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(7197) Managing Enterprise Desktops Using the Microsoft Desktop Optimization Pack - Microsoft Training Courses in London and South West
Visual Studio 2005 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8969) Extending Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2300) Developing Security-Enhanced Web Applications - Microsoft Training Courses in London and South West
Course:(2016) Bringing Data into Desktop Programs using the Microsoft Office 2003 Editions Research and Reference Technologies - Microsoft Training Courses in London and South West
Course:(F1029) Intermediate Microsoft Dynamics CRM 4 for Small and Medium Businesses - Microsoft Training Courses in London and South West
Course:(6290) First Look: Windows 7 Beta for IT Professionals - Hands-on Lab - Microsoft Training Courses in London and South West
Course:(3373) First Look: Getting Started with Windows SharePoint Services 3.0 Hands-On Lab - Microsoft Training Courses in London and South West
Mobile Internet Toolkit Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(4004) Managing Critical Business Information Using Microsoft Office Access 2003 - Microsoft Training Courses in London and South West
Course:(2091) Building XML-Enabled Applications Using Microsoft SQL Server 2000 - Microsoft Training Courses in London and South West
Course:(2052) Using Microsoft Visual Studio Tools for the Microsoft Office System - Microsoft Training Courses in London and South West
Course:(4001) Team Collaboration Using Microsoft Windows SharePoint Services - Microsoft Training Courses in London and South West
Course:(50352) Microsoft SharePoint 2010 Overview for End Users - Microsoft Training Courses in London and South West
Course:(50218) Microsoft Windows 7 Training for Developers - Microsoft Training Courses in London and South West
Course:(10174) Configuring and Managing Microsoft SharePoint 2010 - Microsoft Training Courses in London and South West
Course:(2433) Microsoft Visual Basic Scripting Edition and Microsoft Windows Script Host Essentials - Microsoft Training Courses in London and South West
Course:(8531) Extending Microsoft CRM 3.0 - Microsoft Training Courses in London and South West
Course:(F1001) Visual FoxPro 6.0 Intensive - Microsoft Training Courses in London and South West
Course:(80047) Using Microsoft Dynamics Sure Step - Microsoft Training Courses in London and South West
Course:(F1035) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Guru in 10 Days Flat! - Microsoft Training Courses in London and South West
Course:(3087) First Look: Microsoft Windows Vista for Developers - Microsoft Training Courses in London and South West
Knowledge Management Training Course Index - F1Computing Microsoft Training Courses London South West UK
Microsoft Dynamics CRM Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2018) Creating and Customizing Team Folders - Microsoft Training Courses in London and South West
Visual Studio 6.0 Training Course Index - F1Computing Microsoft Training Courses London South West UK

Compare Recently Viewed Course Dates


Exclusive
SharePoint

Microsoft SharePoint 2010 Business Intelligence
(Microsoft Training Course: 50429) - 5 days - £2640 exc VAT

 FebMarAprMayJunJulAugSepOctNovDecJan
London05 23 21 18 02 06 03 01 05 03
Bath20
Ask a Question ?Print 2 Page PDF


> Target Audience
This course explores how to use SharePoint as a platform for Business Intelligence. It teaches students how to build a BI environment using the Microsoft BI Stack. It is intended for senior Business Intelligence Architects or Consultants, Senior Business Analysts or anyone responsible for implementing a business intelligence solution using SharePoint 2010.
> Course outline
  1. Business Intelligence
  2. Business Intelligence Center
  3. Data Mart and Data Warehouses
  4. Business Connectivity Services
  5. Analysis Services
  6. Filter Web Parts
  7. Excel Services
  8. PowerPivot
  9. Reporting Services
  10. Performance Point
  11. Visio and Access Services
  12. GeoSpatial Data with Charts and Maps
Module 1: Business Intelligence
  • This module explores how Microsoft BI tools are enabling more advanced Business Intelligence features to filter up/down to decision makers and Information Workers in general.
  • Business Intelligence
  • Lab: Business Intelligence Worksheet
Skills
  • Define Business Intelligence.
  • Understand what P=R-C means to BI.
  • Understand your BI will only be as good as your data, tools and processes.
top
Module 2: Business Intelligence Center
  • This module explores the Business Intelligence Center site definition that comes with SharePoint 2010.
  • SharePoint Business Intelligence Center
  • Dashboard Designer
  • Lab: Business Intelligence Center
Skills
  • Navigate the Business Intelligence Center Site Definition.
  • Understand what a SharePoint Dashboard is.
  • Understand what a KPI is and what data they can analyze.
  • Understand what integration points are compatible with the Business Intelligence Center.
top
Module 3: Data Mart and Data Warehouses
  • This module explores the definition of data and some of the many forms it can take. It also defines the terms Data Warehouse and Data Mart.
  • Understand Data and Data Formats
  • Data Marts and Data Warehouses
  • Extract stage
  • Transform and Load stages
  • The importance of primary/unique keys
  • Data Warehouse Granularity Levels
  • Populating SharePoint Lists with SQL Server data
  • Lab: Data and Data Formats
  • Lab: Build A Data Warehouse
  • Lab: Extract and Load
  • Lab: Transform and Load
  • Lab: Granularity
  • Lab: Build A Data Mart
  • Lab: SQL Server to SharePoint Lists
Skills
  • Differentiate between multiple data formats.
  • Understand differences between data warehouse and data marts.
  • Describe what happens in an Extract, Transform and Load (ETL) process.
top
Module 4: Business Connectivity Services
  • This module looks at the new Business Connectivity Services.
  • Business Connectivity Services
  • External Content Types
  • External Lists
  • Large External List using ECTs
  • Use Filters and External lists
  • Entity Profile Pages
  • Office and BCS Integration
  • Lab: BCS Basics
  • Lab: BCS with a Data Warehouse
  • Lab: Office and BCS for BI
Skills
  • Understand how BCS works.
  • Know how to build new BCS applications.
  • Upgrade older BDC applications to BCS.
top
Module 5: Analysis Services
  • This module explores SQL Server Analysis Services (SSAS).
  • Dimension and Fact tables with SSAS
  • Analysis Services Databases
  • Cubes
  • KPIs
  • Lab: Analysis Services
  • Lab: Building an Analysis Services Database
Skills
  • Describe OLAP terms.
  • Understand how to navigate Analysis Services.
  • How to build a simple cube.
  • How to write simple MDX queries.
  • How to use data mining models.
top
Module 6: Filter Web Parts
  • This module explores the important role Filter Web Parts play in building Business Intelligence portals.
  • Filter Web Parts
  • Integrate User Profiles with Filters and Reports
  • Lab: Filter Web Parts
  • Lab: UserProfiles and Filters
Skills
  • Describe the role of Filter Web Parts.
  • Work with Filter Web Parts.
  • Understand how to integrate Filter Web Parts into other BI technologies.
top
Module 7: Excel Services
  • This module works with the various features of SharePoint's Excel Services.
  • Excel Services
  • Excel Reporting
  • Shared Data Connections
  • MDX Features in Excel 2010
  • Excel 2010 Sparklines
  • Filter Web Parts and Excel Services
  • REST Features of Excel Services
  • Lab: Create An Excel Report
  • Lab: Excel Services
  • Lab: MDX
  • Lab: Sparklines
  • Lab: Filters and Excel Services
  • Lab: REST and Web Services
Skills
  • Setup and configure Excel Services.
  • Use the Excel Services Web Parts.
  • Use Excel to modify MDX queries.
  • Use Excel to create Sparklines.
  • Use Excel Services REST-ful APIs.
top
Module 8: PowerPivot
  • This module explores the new PowerPivot tools of SQL Server 2008 R2 and Excel 2010.
  • PowerPivot For SharePoint 2010
  • PowerPivot For Excel 2010
  • PowerPivot Linked Tables
  • Analyze Usage Data
  • Lab: Install Power Pivot
  • Lab: Use PowerPivot
Skills
  • Create PowerPivot enabled spreadsheets.
  • Utilize common PowerPivot functions and tools.
top
Module 9: Reporting Services
  • This module explores Reporting Services, its integration with SharePoint and how to build Reporting Services reports.
  • Reporting Services
  • Reporting Services Reports
  • Reporting Services Web Part
  • Automate Report Delivery
  • Reporting Services and PowerPivot
  • Lab: Install Reporting Services
  • Lab: Building Reports with Reporting Services
  • Lab: Automating Reports with Reporting Services
  • Lab: Reporting Services and PowerPivot
Skills
  • Understand and describe the integration between Reporting Services and SharePoint.
  • Build Reporting Services reports.
  • Use the Reporting Services web part.
  • Create Report and Report Part Libraries.
  • Integrate Reporting Services and PowerPivot.
top
Module 10: Performance Point
  • This module explores how Performance Point can enhance your BI Dashboards and Key Performance Indicators.
  • Performance Point Service Application
  • Dashboard Designer
  • Performance Point Reports
  • Lab: Performance Point
Skills
  • Describe the features of Performance Point.
  • Create Performance Point Scorecards and KPIs.
  • Use Time Intelligence features in your BI solutions.
top
Module 11: Visio and Access Services
  • This module looks at how Visio and Access Services can be integrated into a Report process.
  • Visio Services
  • Publishing a Visio Diagram to SharePoint
  • Access Services
  • Publishing an Access Database to SharePoint
  • Lab: Visio Services
  • Lab: Access Services
Skills
  • Create and deploy interactive Visio diagrams to SharePoint.
  • Create and deploy Access databases to SharePoint.
top
Module 12: GeoSpatial Data with Charts and Maps
  • This module explores GeoSpatial data and how to use the new .NET Charts and Mapping features of SharePoint 2010.
  • Charts and Maps
  • GeoSpatial Data
  • Spatial Data Types in SQL Server
  • Using Geospatial Data in a Reporting Services Report
  • Publishing Geospatial Data to SharePoint 2010.
  • Filters, Data Views and Bing Maps integration
  • .NET Charts
  • Lab: GeoSpatial Data with SQL Server
  • Lab: Bing Maps
  • Lab: .NET Charts
Skills
  • Understand how .NET Charts are used in SharePoint 2010.
  • Understand how to build geospatial maps using BI data.
top
> Pre-Requisites
Before attending this course, students must have the following pre-requisites:
  • An understanding of the SharePoint 2010 User Interface.
  • Understand database reporting concepts.
  • Familiarity with Data Marts and Data Warehouses.
> Purpose
After completing this course, students will be able to understand how business intelligence works; navigate the Business Intelligence Center in SharePoint 2010; understand data and data formats; build Business Connectivity Services (BCS) applications; use SQL Server Analysis Services (SSAS); work with Filter Web Parts; use Excel 2010 as a reporting tool; use PowerPivot with Excel 2010; automate reports with Reporting Services; integrate Reporting Services and PowerPivot; create Performance Point scorecards and KPIs; use Visio and Access services with SharePoint 2010; use .NET charts in SharePoint 2010; publish GeoSpatial data to SharePoint 2010.
> EXAMS
There are no exams directly associated with this course