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:(2810) Fundamentals of Network Security - Microsoft Training Courses in London and South West
Course:(2210) Updating Systems Engineer Skills from Microsoft Windows 2000 to Windows Server 2003 - 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:(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:(2092) Populating a Data Warehouse with Microsoft SQL Server 2000 Data Transformation Services - Microsoft Training Courses in London and South West
Course:(2786) Designing a Microsoft SQL Server 2005 Infrastructure - Microsoft Training Courses in London and South West
Course:(5056) First Look: Windows Vista for IT Professionals - Microsoft Training Courses in London and South West
Course:(2278) Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure - Microsoft Training Courses in London and South West
Microsoft Dynamics CRM Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2954) First Look: Microsoft BizTalk Server 2006 for Developers - 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:(8526) Microsoft CRM 3.0 Installation and Configuration - Microsoft Training Courses in London and South West
Course:(5927) Managing Projects Using Microsoft Office Project 2007 - Microsoft Training Courses in London and South West
Course:(2794) Designing a Business Intelligence Solution for the Enterprise Using Microsoft SQL Server 2005 - Microsoft Training Courses in London and South West
Course:(1313) Microsoft Exchange Server 5.5 Series - Accelerated Training for Admin and Implementation - Microsoft Training Courses in London and South West
Course:(2789) Administering and Automating Microsoft SQL Server 2005 Databases and Servers - 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:(6232) Implementing a Microsoft SQL Server 2008 R2 Database - Microsoft Training Courses in London and South West
Course:(2019) Building Solutions in Microsoft Exchange 2000 with the Web Storage System - 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:(2381) Planning Collaborative Solutions With Microsoft Office XP Technologies - 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:(5119) Supporting Windows Vista Computers with Desktop Images and Application Packages - 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:(1140) Microsoft SQL Server 7.0 Overview - 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:(2074) Designing and Implementing OLAP Solutions with Microsoft SQL Server 2000 - 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
Course:(8521) Microsoft CRM 3.0 Sales Management - Microsoft Training Courses in London and South West
Course:(8913) Applications in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2400) Implementing and Managing Microsoft Exchange Server 2003 - Microsoft Training Courses in London and South West
Course:(5116) Configuring Windows Vista Mobile Computing and Applications - Microsoft Training Courses in London and South West
Course:(10175) Microsoft SharePoint 2010, Application Development - Microsoft Training Courses in London and South West
Visual Studio 2010 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(50429) Microsoft SharePoint 2010 Business Intelligence - Microsoft Training Courses in London and South West
Course:(2788) Designing High Availability Database Solutions Using Microsoft SQL Server 2005 - Microsoft Training Courses in London and South West
Course:(2933) Developing Business Process and Integration Solutions Using Microsoft BizTalk Server 2006 - Microsoft Training Courses in London and South West
Course:(2505) Deploying Microsoft Office XP - Microsoft Training Courses in London and South West
Windows Server 2008 Training Course Index - F1Computing Microsoft Training Courses London South West UK
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:(2731) Deploying and Managing Microsoft Identity Integration Server (MIIS) 2003 - Microsoft Training Courses in London and South West
Course:(5058) Deploying Microsoft Office 2007 Professional Plus - Microsoft Training Courses in London and South West
Course:(1582) Building Web Applications Using Microsoft Visual InterDev 6 - Microsoft Training Courses in London and South West
Knowledge Management Training Course Index - F1Computing Microsoft Training Courses London South West UK
Visual Basic .NET Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(1609) Designing Data Services and Data Models - Microsoft Training Courses in London and South West
Course:(2934) Deploying and Managing Business Process and Integration Solutions Using Microsoft BizTalk Server 2006 - Microsoft Training Courses in London and South West
Course:(2830) Designing Security for Microsoft Networks - Microsoft Training Courses in London and South West
Visual Studio 2008 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(F1017) Visual FoxPro 8.0 Intensive - Microsoft Training Courses in London and South West
Course:(2289) Deploying Business Desktops with Microsoft Windows XP and Microsoft Office 2003 - Microsoft Training Courses in London and South West
Course:(2276) Implementing a Microsoft Windows Server 2003 Network Infrastructure: Network Hosts - Microsoft Training Courses in London and South West
Course:(2299) Managing and Maintaining a Microsoft Windows Server 2003 Environment for an MCSA on Windows 2000 - 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
Course:(4003) Summarizing Microsoft Office Excel 2003 Data to Make Better Business Decisions - 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:(50050) Architecting Documents and Records Management Solutions with Microsoft Office SharePoint 2007 - Microsoft Training Courses in London and South West
Course:(8525) Microsoft CRM 3.0 Customization - Microsoft Training Courses in London and South West
Course:(4004) Managing Critical Business Information Using Microsoft Office Access 2003 - Microsoft Training Courses in London and South West
Course:(5105) Deploying Microsoft Windows Vista Business Desktops - 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
Course:(10174) Configuring and Managing Microsoft SharePoint 2010 - 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:(F1028) Introduction to Microsoft Dynamics CRM 4 for Small and Medium Businesses - 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:(2433) Microsoft Visual Basic Scripting Edition and Microsoft Windows Script Host Essentials - Microsoft Training Courses in London and South West
Course:(2008) Designing a Microsoft Exchange Server 2003 Organization - 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:(8912) Customisation and Configuration in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Application Architecture Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2300) Developing Security-Enhanced Web Applications - 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:(2151) Microsoft Windows 2000 Network and Operating System Essentials - 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
Course:(2778) Writing Queries Using Microsoft SQL Server 2008 Transact-SQL - Microsoft Training Courses in London and South West
NET Framework Development Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(F1024) What's New in Microsoft CRM 3.0 - Applications - 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:(1131) SQL Server 7.0 Upgrade and Migration - Microsoft Training Courses in London and South West
Course:(7197) Managing Enterprise Desktops Using the Microsoft Desktop Optimization Pack - Microsoft Training Courses in London and South West
Course:(F1016) Upgrading to Visual FoxPro 8.0 from Visual FoxPro 7.0 - 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:(1573) Designing Microsoft Exchange 2000 for the Enterprise - 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
Course:(5061) Implementing Microsoft Office SharePoint Server 2007 - 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:(2013) Optimizing Microsoft SQL Server 7.0 - Microsoft Training Courses in London and South West
Visual Basic 6.0 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(3087) First Look: Microsoft Windows Vista for Developers - Microsoft Training Courses in London and South West
Systems Management Server Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8522) Microsoft CRM 3.0 Marketing Automation - Microsoft Training Courses in London and South West
Course:(50354) Microsoft SharePoint 2010 SharePoint Designer - Microsoft Training Courses in London and South West
Course:(1026) Microsoft Exchange Server 5.5 Series - Concepts and Administration - Microsoft Training Courses in London and South West
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
Course:(F1001) Visual FoxPro 6.0 Intensive - 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:(8910) What's New in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(50049) Architecting Web Content Management Solutions with Microsoft Office SharePoint 2007 - Microsoft Training Courses in London and South West
Application Centre Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8531) Extending Microsoft CRM 3.0 - Microsoft Training Courses in London and South West
Course:(2277) Implementing Managing and Maintaining a Microsoft Windows Server 2003 Network Infrastructure: Network Services - Microsoft Training Courses in London and South West
Course:(2733) Updating Your Database Administration Skills to SQL Server 2005 - 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:(2827) Deploying Microsoft Windows Rights Management Services - 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:(2795) Designing an ETL Solution Architecture Using Microsoft SQL Server 2005 Integration Services - Microsoft Training Courses in London and South West
Course:(2796) Designing an Analysis Solution Architecture Using Microsoft SQL Server 2005 Analysis Services - Microsoft Training Courses in London and South West
Course:(2275) Maintaining a Microsoft Windows Server 2003 Environment - 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:(2093) Implementing Business Logic with MDX in Microsoft SQL Server 2000 - 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:(80141) Integrating Microsoft Dynamics CRM 4.0 and Microsoft Office SharePoint Server 2007 - Microsoft Training Courses in London and South West
Course:(5115) Installing and Configuring the Windows Vista Operating System - Microsoft Training Courses in London and South West
Course:(F1004) FoxPro 2.6 Intensive - 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:(2823) Implementing and Administering Security in a Microsoft Windows Server 2003 Network - Microsoft Training Courses in London and South West
Course:(F1012) Visual FoxPro 7.0 Programming - 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
Visual Studio 6.0 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2274) Managing a Microsoft Windows Server 2003 Environment - Microsoft Training Courses in London and South West
Course:(6331) Deploying and Managing Microsoft System Center Virtual Machine Manager - Microsoft Training Courses in London and South West
Course:(1017) Developing Web Applications with Visual Interdev - Microsoft Training Courses in London and South West
Course:(5928) Managing Projects Using Microsoft Office Project Server 2007 - Microsoft Training Courses in London and South West
Course:(2840) Implementing Security for Applications - 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:(2783) Designing the Data Tier for Microsoft SQL Server 2005 - 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:(F1013) Visual FoxPro 7.0 Intensive - 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:(2591) Implementing Replication Using Microsoft SQL Server 2000 - Microsoft Training Courses in London and South West
Course:(2780) Maintaining a Microsoft SQL Server 2005 Database - Microsoft Training Courses in London and South West
Course:(80047) Using Microsoft Dynamics Sure Step - 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:(5060) Implementing Windows SharePoint Services 3.0 - Microsoft Training Courses in London and South West
Course:(50046) Introduction to Development Using Windows SharePoint Services 3.0 - Microsoft Training Courses in London and South West
Course:(2279) Planning Implementing and Maintaining a Microsoft Windows Server 2003 Active Directory Infrastructure - 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:(6290) First Look: Windows 7 Beta for IT Professionals - Hands-on Lab - Microsoft Training Courses in London and South West
Course:(6158) Updating Your SQL Server 2005 Skills to SQL Server 2008 - Microsoft Training Courses in London and South West
Course:(2791) Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services - Microsoft Training Courses in London and South West
Course:(2208) Updating Support Skills from Windows NT 4.0 to Windows Server 2003 - Microsoft Training Courses in London and South West
Course:(2439) Scripting Microsoft Windows Management Instrumentation - 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:(80003) Workflow in Microsoft Dynamics CRM 4.0 - 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
Visual Studio 2005 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2071) Querying Microsoft SQL Server 2000 with Transact-SQL. - 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
Mobile Internet Toolkit Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(F1002) Visual FoxPro 6.0 Enterprise - 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:(2273) Managing and Maintaining a Microsoft Windows Server 2003 Environment - 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:(2787) Designing Security for Microsoft SQL Server 2005 - 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:(2297) Planning Implementing Managing and Maintaining a Microsoft Windows Server 2003 Environment for an MCSE on Windows 2000 - Microsoft Training Courses in London and South West
Course:(2209) Updating Systems Administrator Skills from Microsoft Windows 2000 to Windows Server 2003 - Microsoft Training Courses in London and South West
Course:(F1014) Visual FoxPro 7.0 Enterprise - Microsoft Training Courses in London and South West
Exchange Server 2010 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(50051) Architecting Microsoft Office SharePoint Server 2007 Portals and Collaboration Solutions - 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:(6292) Installing and Configuring Windows 7 Client - Microsoft Training Courses in London and South West
Course:(5179) Implementing and Maintaining Telephony Using Microsoft Office Communications Server 2007 - Microsoft Training Courses in London and South West
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:(2091) Building XML-Enabled Applications Using Microsoft SQL Server 2000 - Microsoft Training Courses in London and South West
Course:(5117) Installing, Configuring, Troubleshooting, and Maintaining Windows Vista - Microsoft Training Courses in London and South West
Course:(2018) Creating and Customizing Team Folders - Microsoft Training Courses in London and South West
Course:(2355) Upgrading from Microsoft Exchange Server 5.5 to Microsoft Exchange 2000 - Microsoft Training Courses in London and South West
Course:(2779) Implementing a Microsoft SQL Server 2005 Database - Microsoft Training Courses in London and South West
Course:(5177) Implementing and Maintaining Instant Messaging Using Microsoft Office Communications Server 2007 - Microsoft Training Courses in London and South West
Course:(6236) Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services - 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:(6294) Planning and Managing Windows 7 Desktop Deployments and Environments - 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:(8911) Installation and Deployment in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2955) First Look: Microsoft BizTalk Server 2006 for IT Professionals - Microsoft Training Courses in London and South West
Course:(2657) Programming Microsoft Access 2002 - 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:(4009) Setting Up Projects for Success Using Microsoft Office Project 2003 - 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
Course:(5178) Implementing and Maintaining Audio/Visual Conferencing and Web Conferencing Using Microsoft Office Communications Server 2007 - 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:(8969) Extending Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2207) Updating Systems Administrator and Systems Engineer Skills from Microsoft Windows 2000 to Windows Server 2003 - Microsoft Training Courses in London and South West
Course:(F1015) Visual FoxPro 7.0 Upgrade - Microsoft Training Courses in London and South West
Course:(8529) Microsoft CRM 3.0 Administration - Microsoft Training Courses in London and South West

Compare Recently Viewed Course Dates


Exclusive
SQL Server 2005

Designing an Analysis Solution Architecture Using Microsoft SQL Server 2005 Analysis Services
(Microsoft Training Course: 2796) - 3 days - £1700 exc VAT

 FebMarAprMayJunJulAugSepOctNovDecJan
London13
Ask a Question ?Print 2 Page PDF


> Target Audience
This course is designed to teach Business Intelligence (BI) professionals working in enterprise environments to design a multidimensional solution architecture that supports their BI solution. It is intended for experienced BI professionals.
> Course outline
  1. Capturing Business and Technical Requirements
  2. Designing and Implementing a Logical OLAP Solution Architecture
  3. Designing Physical Storage for a Multidimensional Solution
  4. Creating Calculations
  5. Extending Cube Functionality
  6. Designing an Analysis Services Infrastructure
  7. Deploying a Multidimensional Solution into Production
  8. Optimizing an OLAP Solution
  9. Implementing Data Mining
Supplementary Information Our trainers recommend that students should have attend Course 2791: Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services before sitting on this course.
Module 1: Capturing Business and Technical Requirements
  • In this module, students will first learn about key design principles that they should consider when you define the scope of a BI project. They will then learn how to identify the business and technical requirements to ensure that their solution meets the needs of its users.
  • Planning a Multidimensional Solution
  • Identifying Requirements and Constraints
  • Lab: Capturing Business and Technical Requirements
Skills
  • Describe the purpose of a multidimensional solution.
  • Identify requirements and constraints when designing a multidimensional solution.
top
Module 2: Designing and Implementing a Logical OLAP Solution Architecture
  • This module describes considerations and guidelines for designing an OLAP solution, including a relational data warehouse and an Analysis Services cube.
  • Planning a Unified Dimensional Model
  • Designing and Implementing Fact and Dimension Tables
  • Designing and Implementing Cubes
  • Lab: Designing and Implementing a UDM
Skills
  • Describe design considerations for a UDM solution.
  • Describe design considerations for the relational schema of an OLAP solution.
  • Describe considerations for designing and implementing OLAP cubes.
top
Module 3: Designing Physical Storage for a Multidimensional Solution
  • In this module, students will learn how to design an effective physical storage solution for a multidimensional application.
  • Designing Physical Storage
  • Partitioning Relational Data
  • Partitioning Multidimensional Data
  • Lab: Designing and Implementing Physical Storage
Skills
  • Design an effective physical storage solution for dimensions and measures.
  • Partition relational data.
  • Partition multidimensional data.
top
Module 4: Creating Calculations
  • In this module, students will learn how to create Multidimensional Expression (MDX) calculations. The module describes how to create calculated members, named sets, and scoped assignments.
  • Implementing Calculated Members
  • Implementing Named Sets
  • Implementing Scoped MDX Scripts
  • Lab: Implementing Calculations
Skills
  • Create calculated members.
  • Create named sets.
  • Create scoped assignments.
top
Module 5: Extending Cube Functionality
  • In this module, students will learn about the benefits of KPIs, actions, and stored procedures. They will also learn how to implement KPIs, actions, and stored procedures in an Analysis Services cube.
  • Key Performance Indicators
  • Actions
  • Stored Procedures
  • Lab: Implementing Advanced Functionality
Skills
  • Create KPIs.
  • Create actions.
  • Create stored procedures.
top
Module 6: Designing an Analysis Services Infrastructure
  • In this module, students will learn how to design an appropriate infrastructure for an OLAP application.
  • Considerations for Analysis Services Resource Requirements
  • Considerations for Analysis Services Scalability
  • Considerations for Analysis Services Availability
  • Lab: Designing and Implementing Analysis Services Infrastructure
Skills
  • Specify appropriate hardware and software resources for an Analysis Services solution.
  • Design an Analysis Services infrastructure that supports high scalability.
  • Design an Analysis Services infrastructure that supports high availability.
top
Module 7: Deploying a Multidimensional Solution into Production
  • In this module, students will learn about and compare the different deployment methods available in SQL Server 2005 Analysis Services. They will also learn about how security in Analysis Services functions and how to protect their company’s critical business information.
  • Deploying an Analysis Services Database
  • Managing Analysis Services Security
  • Lab: Deploying Analysis Services into Production
Skills
  • Deploy an Analysis Services solution.
  • Secure an Analysis Services solution.
top
Module 8: Optimizing an OLAP Solution
  • In this module, students will learn how to monitor Analysis Services and how to optimize performance of their Analysis Services solutions.
  • Monitoring Analysis Services
  • Optimizing Performance
  • Lab: Optimizing Analysis Services
Skills
  • Monitor Analysis Services.
  • Optimize Analysis Services performance.
top
Module 9: Implementing Data Mining
  • In this module, students will learn what a data mining solution is and how to design and implement data mining functionality with SQL Server Analysis Services.
  • Introduction to Data Mining
  • Implementing a Data Mining Solution
  • Using Data Mining in a BI Solution
  • Lab: Implementing Data Mining
Skills
  • Plan a data mining solution.
  • Implement a data mining solution.
  • Use data mining in a BI solution.
top
> Pre-Requisites
Before attending this course, students must have the following pre-requisites:
  • Have hands-on experience with database development tasks.
  • Have foundational conceptual understanding of data warehousing, data marts, and Business Intelligence.
  • Conceptual understanding of OLAP technologies, multi-dimensional data, MDX, and relational database modeling.
  • Be familiar with SQL Server 2005 features, tools, and technologies.
  • Have foundational understanding of Microsoft Windows security.
  • Have foundational understanding of Web-based architecture.
  • Must understand the difference between replication and ETL.
> Purpose
After completing this course, students will be able to capture the business and technical requirements for a BI solution; design and implement a logical Online Analytical Processing (OLAP) solution architecture; design physical storage for a multidimensional solution; create calculated members and named sets; implement Key Performance Indicators (KPIs), actions, and stored procedures; design the infrastructure for an OLAP solution; deploy and secure an Analysis Services solution in a production environment; monitor and optimize an Analysis Services solution; implement a Data Mining Solution.
> Supplementary Information
Our trainers recommend that students should have attend Course 2791: Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services before sitting on this course.
> EXAMS
There are no exams directly associated with this course