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:(F1043) Fast Track: Customisation, Configuration and Workflows in Microsoft Dynamics CRM 2011/CRM Online - Microsoft Training Courses in London and South West
Microsoft Dynamics CRM Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(3373) First Look: Getting Started with Windows SharePoint Services 3.0 Hands-On Lab - Microsoft Training Courses in London and South West
ASP.NET Training Course Index - F1Computing Microsoft Training Courses London South West UK
Windows Server 2008 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(6317) Upgrading Your SQL Server 2000 Database Administration Skills to SQL Server 2008 - Microsoft Training Courses in London and South West
Windows 7 Training Course Index - F1Computing Microsoft Training Courses London South West UK
F1 Computing - Microsoft CRM Gold Partner
Windows 2003 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Web Development Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(0828) Deploying and Supporting Microsoft Systems Management Server 2.0 (SMS) - Microsoft Training Courses in London and South West
Course:(1934) Principles of Modeling Windows DNA-based Applications with Rational Rose - Microsoft Training Courses in London and South West
Visual FoxPro Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8020) Microsoft Business Solutions CRM 1.2 Customization - Microsoft Training Courses in London and South West
BizTalk Server Training Course Index - F1Computing Microsoft Training Courses London South West UK
Business Training Course Index - F1Computing Microsoft Training Courses London South West UK
Windows Training Course Index - F1Computing Microsoft Training Courses London South West UK
FoxPro Training Course Index - F1Computing Microsoft Training Courses London South West UK
Hyper-V and Virtualisation Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(6446) Implementing and Administering Windows Essential Business Server 2008 - Microsoft Training Courses in London and South West
Course:(2840) Implementing Security for Applications - Microsoft Training Courses in London and South West
Exchange Server Training Course Index - F1Computing Microsoft Training Courses London South West UK
C Sharp Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(50511) The Microsoft Intelligence 2010 Stack - Microsoft Training Courses in London and South West
Office 2007 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(50257) Upgrading to Microsoft ASP.NET 3.5 - Microsoft Training Courses in London and South West
SQL Server Training Course Index - F1Computing Microsoft Training Courses London South West UK
Security Training Course Index - F1Computing Microsoft Training Courses London South West UK
Windows Vista Training Course Index - F1Computing Microsoft Training Courses London South West UK
F1 - Training and Technology Blogs
Course:(6463) Visual Studio 2008 Connected Systems: ASP.NET 3.5 - Microsoft Training Courses in London and South West
Course:(7034) Implementing Microsoft Office Live Communications Server 2005 - Microsoft Training Courses in London and South West
Course:(2520) Deploying Microsoft Windows XP Professional - Microsoft Training Courses in London and South West
SharePoint Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(10215) Implementing and Managing Microsoft Server Virtualization - Microsoft Training Courses in London and South West
Course:(10508) Planning, Deploying, and Managing Microsoft Exchange Server 2010 Unified Messaging - 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
Certification Fast-Track Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(10337) Updating Your Microsoft SQL Server 2008 BI Skills to SQL Server 2008 R2 - Microsoft Training Courses in London and South West
Course:(10267) Introduction to Web Development with Microsoft Visual Studio 2010 - Microsoft Training Courses in London and South West
CRM Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(F1044) Learning to Program using Microsoft C# 2010 - Microsoft Training Courses in London and South West
Course:(2310) Developing Web Applications Using Microsoft Visual Studio 2008 - Microsoft Training Courses in London and South West
Course:(50429) Microsoft SharePoint 2010 Business Intelligence - Microsoft Training Courses in London and South West
Course:(10534) Planning and Designing a Microsoft Lync Server 2010 Solution - Microsoft Training Courses in London and South West
Course:(80442) Introduction to Microsoft Dynamics CRM 2011 - Microsoft Training Courses in London and South West
Visual Basic .NET Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(50229) Understanding the Microsoft Solutions Framework - Microsoft Training Courses in London and South West
Windows Services 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
Course:(5929) Managing Projects and Programs Using Microsoft Office Project Server 2007 - Microsoft Training Courses in London and South West
Silverlight 4 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Office (inc SharePoint) Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(50219) Introduction to Microsoft Windows 7 for Developers - Microsoft Training Courses in London and South West
Fast-Track Courses Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8036) Designing IT Platform Collaborative Applications with Microsoft SharePoint 2003 Workshop - Microsoft Training Courses in London and South West
SQL Server 2008 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(10232) Designing and Developing Microsoft SharePoint Server 2010 Applications - Microsoft Training Courses in London and South West
Course:(F1048) Microsoft BizTalk Server 2010 Administration - Microsoft Training Courses in London and South West
Knowledge Management Training Course Index - F1Computing Microsoft Training Courses London South West UK

Compare Recently Viewed Course Dates


Premier
SQL Server 2008

The Microsoft Intelligence 2010 Stack
(Microsoft Training Course: 50511) - 5 days - £2095 exc VAT

 MayJunJulAugSepOctNovDecJanFebMarApr
London21 13 19 17 14 11 11
Ask a Question ?Print 2 Page PDF


> Target Audience
This course provides students with the knowledge and skills to develop Microsoft End-to-End business solutions using SQL Server 2008 R2 in an integrated environment with SharePoint 2010 and Office 2010.The course is intended for BI Project Managers, BI Developers, I.T. Professionals, end-user ombudsman and BI analysts.
> Course outline
  1. The Business Intelligence Stack
  2. Unified Data Model
  3. SQL Server Integration Services
  4. SQL Server Analysis Services
  5. SQL Server Reporting Services
  6. MDX (optional)
  7. PerformancePoint Services 2010
  8. Excel Services, Business Connectivity Services
  9. Excel PowerPivot
  10. Data Mining
Module 1: The Business Intelligence Stack
  • SQL 2008R2 Business Intelligence Platform
  • SQL Analysis Services
  • SQL Reporting Services
  • Performance Management Tools
  • SharePoint 2010
  • Multidimensional Space
  • MDX
  • Data Mining
  • Understanding the Terminology
  • Lab: The Business Intelligence Stack
Skills
  • Explore Business Intelligence Development Studio
  • Connect into a SQL Server Analysis Services Cube
  • Use SQL Server Management Studio
  • Explore SharePoint 2010
top
Module 2: Unified Data Model
  • UDM Defined
  • User Experience: Relational vs. UDM
  • Advantages
  • Trouble in River City
  • Lab: Unified Data Model
Skills
  • Creating a Data Mart using Business Intelligence Development Studio.
  • Enabling Table Compression
top
Module 3: SQL Server Integration Services
  • Major Components
  • New or Changed Features
  • Script Task
  • SSIS and ETL
  • Transformers
  • Best Practices 1
  • Best Practices 2
  • Lab: Lab SSIS Projects
Skills
  • Create A SSIS Project
  • Add a Data Source
  • Create A Data Flow
  • Create Another Data Flow
  • Load Data via a SQL Statement
  • Populating the Fact Table
  • Loading Manufacturing Facts
  • Handling Errors
  • Inventory Fact Flow
top
Module 4: SQL Server Analysis Services
  • Key Concepts
  • Schemas
  • Measures
  • Dimensions
  • Cube Processing
  • Partitions
  • Proactive Caching
  • Aggregations
  • Lab: Lab SQL Server Analysis Services
Skills
  • Define an OLAP Cube
  • Working with Measures and Measure Groups
  • Time and Hierarchies
  • Relating Dimensions
  • Build Deploy and Browse the Cube
  • Multiple Partitions
  • Set Storage
  • Design Aggregations
  • Default Members
top
Module 5: SQL Server Reporting Services
  • Integration with SharePoint
  • Report Builder 3.0
  • Differences Between Environments
  • Tablix
  • Charts
  • Lab: Lab SQL Server Reporting Services
Skills
  • SSRS Projects Report Wizard
  • Report Builder 3.0
  • Creating Charts
top
Module 6: MDX (optional)
  • What is MDX?
  • MDX Query Editor
  • Select Statement
  • Key Concepts
  • Sets
  • Functions
  • Time Intelligence
  • Lab: MDX (Optional Module)
Skills
  • Understand the Cell
  • Write a Tuple
  • MDX Sets
  • Write a SELECT statement
  • Write a Function
  • Implement Time
top
Module 7: PerformancePoint Services 2010
  • Integration with SharePoint Server 2010
  • Common Service Application Framework
  • New PerformancePoint Features
  • Storage Security
  • Time Intelligence and Dynamic Filters
  • Linking of Web Parts
  • KPI Details Report
  • Retired Features
  • Scorecards in PPS
  • KPI Collections
  • Dashboard Design Guidelines
  • Dashboard Designer Internals
  • Dashboard Designer Interface
  • First Class Objects
  • Main Window
  • Properties
  • Dashboard Designer Features
  • Lab: PerformancePoint Services 2010
Skills
  • Use SharePoint to create a site collection
  • Configure Central Administration for PerformancePoint Services
  • Create and Explore a PerformancePoint Business Intelligence Center
  • Create a Basic Dashboard
  • Deploy the Dashboard
  • Explore the Dashboard in PPS
top
Module 8: Excel Services, Business Connectivity Services
  • Integration with SharePoint Server 2010
  • Storage Security
  • Single version of the truth
  • Excel Web Services
  • New capabilities in Excel Services
  • Business Connectivity Services
  • Lab: Excel Services 2010
Skills
  • Deploy a Excel spread sheet for a single version of the truth
  • Utilize Excel Web Services
  • Business Connectivity Services
top
Module 9: Excel PowerPivot
  • Integration with SharePoint Server 2010
  • Understanding Modeling
  • Lab: PowerPivot 2010
Skills
  • Explore Excel PowerPivot
top
Module 10: Data Mining
  • Key Terms in Data Mining
  • Types of Data Mining Algorithms
  • The Algorithm
  • Excel and The BI Extensions
  • Visio 2010
  • Lab: Lab Excel 2010 and Data Mining BI
Skills
  • Utilize the Excel Data Mining Tools
top
> Pre-Requisites
Before attending this course, students must have the following pre-requisites:
  • • A working knowledge of RDBMS
  • • A working knowledge of Business Intelligence Studio
  • • A working knowledge of Excel and the Office Ribbon
  • • Understanding of the goals of Business Intelligence
> Purpose
After completing this course, students will be able to describe the role of each component in the Microsoft Business Intelligence stack so that a better informed estimate of resources might be made in the BI project; explain the Unified Data Model, understand limitations and implementations and when it is appropriate to use in BI deployment; explain what SQL 2008 and the R2 release change in Microsoft BI and how to leverage these technologies; gain a knowledge of SQL Integration Services and understand why the Extract Transform and Load process use 40% or more of the entire project budget; get an explanation of Multidimensional space in SQL Server Analysis Services; learn to plan for the on-going maintenance of BI projects and their expansion across the enterprise.
> EXAMS
There are no exams directly associated with this course