Implementing and Maintaining Microsoft SQL Server 2005 Analysis

Document Sample
Implementing and Maintaining Microsoft SQL Server 2005 Analysis Powered By Docstoc
					                                                Implementing and Maintaining
                                                Microsoft SQL Server 2005
                                                Analysis Services
COMPUTER TRAINING                               At the end of the course the delegate will be able to complete the following:
 The key to a better future
                                                Introduction to Microsoft                            Working with Measures and
                                                SQL Server 2005 Analysis                             Measure Groups
                                                Services                                              This module explains how to edit and
      SQL SERVER                                 This module introduces common analysis
                                                                                                         configure measures and measure groups.
                                                                                                      Working with Measures
                                                  scenarios and describes how Analysis Services       Working with Measure Groups
     Course No. 2791                              provides a powerful platform for
                                                  multidimensional OLAP solutions and data
                                                                                                      Lab: Configuring Measures and Measure
                                                                                                         Groups
                                                  mining solutions. The module then describes
             3 Days                               the main considerations for installing Analysis    Skills:
                                                                                                      Work with measures.
                                                  Services.
                                                 Overview of Data Analysis Solutions                 Work with measure groups.
                                                 Overview of SQL Server 2005 Analysis Services
Target Audience:                                 Installing SQL Server 2005 Analysis Services       Querying Multidimensional
This course teaches students how to
implement an Analysis Services solution in
                                                Skills:                                              Analysis Solutions
their organization. It is intended for
                                                 Describe data analysis solutions.                   This module introduces multidimensional
information technology (IT) professionals        Describe the key features of Microsoft SQL           expressions (MDX) and describes how to
and developers who need to implement              Server 2005 Analysis Services.                       implement calculated members and named
analysis solutions by using Microsoft SQL        Install SQL Server 2005 Analysis Services.           sets in an Analysis Services cube.
Server 2005 Analysis Services.                                                                        MDX Fundamentals
                                                Creating Multidimensional                             Adding Calculations to a Cube
Pre-requisites:                                 Analysis Solutions                                    Lab: Querying a Cube
Before attending this course, students must
                                                 This module introduces the development tools       Skills:
have the following pre-requisites:
                                                    you can use to create an Analysis Services        Describe Multidimensional Expression (MDX)
• Conceptual understanding of OLAP                                                                       fundamentals.
                                                    multidimensional analysis solution, and
  solutions.
                                                    describes how to create data sources, data        Add calculations to a cube.
• Experience navigating the Microsoft
                                                    source views, and cubes.
  Windows Server environment.
• Experience with Windows services
                                                   Developing Analysis Services Solutions           Customizing Cube
  (starting and stopping).
                                                   Data Sources and Data Source Views               Functionality
                                                   Creating a Cube
• Experience creating service accounts and
                                                   Lab: Creating a Multidimensional Analysis         This module explains how to customize a cube
  permissions.                                                                                           by implementing key performance indicators
• Experience with Microsoft SQL Server,
                                                    Solution
                                                                                                         (KPIs), actions, perspectives, and translations.
  including: SQL Server Agent; SQL Server       Skills:                                                 Implementing Key Performance Indicators
  query language (SELECT, UPDATE, INSERT,        Develop Analysis Services solutions.                  Implementing Actions
  and DELETE); SQL Server System tables          Create a data source and a data source view.          Implementing Perspectives
  and SQL Server accounts (users and             Create a cube.                                        Implementing Translations
  permissions).                                                                                         Lab: Customizing a Cube
                                                Working with Dimensions                              Skills:
Purpose:                                         This module describes how to edit dimensions          Implement Key Performance Indicators (KPIs).
After completing this course, students will
be able to describe how SQL Server Analysis
                                                    and to configure dimensions, attributes, and        Implement actions.
                                                    hierarchies.                                        Implement perspectives.
Services can be used to implement
                                                   Configuring Dimensions                              Implement translations.
analytical solutions; create multidimensional
                                                   Defining Hierarchies
analysis solutions with SQL Server Analysis
Services; implement dimensions in an
                                                   Sorting and Grouping Attributes                  Deploying and Securing an
Analysis Services solution; implement
                                                   Lab: Defining Dimensions
measures and measure groups in an Analysis      Skills:                                              Analysis Services Database
Services solution; query a multidimensional      Configure dimensions.                               This module describes how to deploy an
Analysis Services solution; customize an         Define hierarchies.                                  Analysis Services database to a production
Analysis Services cube; deploy and Secure        Sort and group attributes.                           server, and how to implement security in an
an Analysis Services database; maintain a                                                              Analysis Services multidimensional solution.
multidimensional Analysis Services solution;                                                          Deploying an Analysis Services Database
implement a Data Mining solution.                                                                     Securing an Analysis Services Database
                                                                                                      Lab: Deploying and Securing an Analysis
                                                                                                       Services Database
Skills:
 Deploy an Analysis Services database.
 Secure an Analysis Services database.
Maintaining a
Multidimensional Solution
 This module discusses the maintenance tasks
    associated with an Analysis Services solution, and
    describes how administrators can use the
    Analysis Services management tools to perform
    them.
   Configuring Processing Settings
   Logging, Monitoring, and Optimizing an Analysis
    Services Solution
   Backing Up and Restoring an Analysis Services
    Database
   Lab: Maintaining an Analysis Services Database
Skills:
 Configure processing settings.                            F1 COMPUTER
 Log, monitor, and optimize an Analysis Services         TRAINING SERVICES
    solution.
 Back up and restore an Analysis Services
    database.
                                                                THE KEY TO A
Introduction to Data Mining                                    BETTER FUTURE
 This module introduces data mining, and
    describes how to implement data mining
    structures and models. It then explains how to
    validate data model accuracy.                           for further information…


    Overview of Data Mining
    Creating a Data Mining Solution                            call us on
   Validating Data Mining Models
   Lab: Implementing Data Mining                          0800 169 1890
Skills:
 Describe data mining.
 Create a data mining solution.
 Validate data mining models.                                F1 COMPUTING
                                                               SYSTEMS LTD
                                                                  3 Kelso Place
                                                                Upper Bristol Road
                                                                 BATH BA1 3AU

                                                               Fax: 01225 444728

                                                            training@f1comp.co.uk

                                                            www.f1comp.co.uk


                                                          LONDON BATH OR ONSITE




                                                            PARTICULARS
                                                                   Cost:
                                                               £1050 plus VAT
                                                                 Platform:
                                                                    Windows
                                                                   Numbers:
                                                         Maximum of 6 people on each
                                                         course at F1’s training facilities
                                                              in London and Bath
                                                Implementing and Maintaining
                                                Microsoft SQL Server 2005
                                                Integration Services
COMPUTER TRAINING                               At the end of the course the delegate will be able to complete the following:
 The key to a better future
                                                Introduction to SQL Server                            Implementing Data Flow
                                                2005 Integration Services                              This module describes the data flow sources,
                                                                                                          transformations, and destinations that you
                                                 This module introduces the role that                    can use to implement a data flow task in an
      SQL SERVER                                  Integration Services plays in extracting,
                                                  transforming, and loading data. This module
                                                                                                          Integration Services control flow. It also
                                                                                                          explains how to use data flow paths to direct
                                                  also describes the tools that you can use to
     Course No. 2792                              build and manage Integration Services               
                                                                                                          valid and invalid rows through the data flow.
                                                                                                          Data Flow Sources and Destinations
                                                  solutions.                                             Data Flow Transformations
             3 Days                              Overview of Integration Services Solutions             Data Flow Paths
                                                 Integration Services Tools                             Lab: Implementing Data Flows
                                                 Lab: Using SQL Server Integration Services
                                                                                                      Skills:
                                                Skills:
                                                 Describe Integration Services solutions.             Implement data flow sources and
Target Audience:                                                                                          destinations.
This course teaches students how to              Use Integration Services tools.                      Implement data flow transformations.
implement an Integration Services solution
                                                                                                       Implement data flow paths.
in their organizations. It is intended for      Developing Integration
information technology (IT) professionals
and developers who need to implement            Services Solutions                                    Implementing Logging
data transfer or extract, transform, and load    This module provides an overview of the              This module discusses how to use logging in
(ETL) solutions by using Microsoft SQL              development tasks that are involved in              an Integration Services package, and explains
Server 2005 Integration Services.                   creating an Integration Services package. After     how to configure and use logging providers to
                                                    completing this module, you will be able to         generate information about a package's
Pre-requisites:                                     create a basic package.                             execution.
Before attending this course, students must        Creating an Integration Services Solution          Overview of Integration Services Logging
have the following pre-requisites:                 Using Variables                                    Implementing Logging
• Exposure to enterprise data import and           Building and Running a Solution                    Lab: Implementing Logging
  export scenarios.                                Lab: Implementing an Integration Services         Skills:
• Experience navigating the Microsoft               Solution                                           Describe Integration Services logging.
  Windows Server environment.                   Skills:                                                Implement logging.
• Experience with Microsoft SQL Server,          Create a SQL Server Integration Services
  including: SQL Server Agent; SQL Server
                                                    solution.                                         Debugging and Error
  query language (SELECT, UPDATE, INSERT,
                                                 Use variables.                                      Handling
  and DELETE); SQL Server System tables
                                                 Build and run a solution.
  and SQL Server accounts (users and                                                                   This module describes how to debug
  permissions).
                                                Implementing Control Flow                               Integration Services packages by using the
                                                                                                        debugging tools in Business Intelligence
Purpose:                                         This module introduces the tasks and                  Development Studio. It then explains how to
After completing this course, students will         precedence constraints that you can use to          implement error-handling logic in an
be able to describe SQL Server Integration          implement control flow in an Integration            Integration Services package.
Services and its tools; create an Integration       Services package.                                  Debugging a Package
Services package; implement control flow in        Control Flow Tasks                                 Implementing Error Handling
an Integration Services package; implement         Control Flow Precedence Constraints                Lab: Debugging and Error Handling
data flow in an Integration Services package;      Control Flow Containers
implement logging in an Integration Services       Lab: Implementing Control Flow                    Skills:
package; debug and implement error
                                                Skills:                                                Debug a package.
handling in an Integration Services package;
                                                 Configure control flow tasks.                        Implement error handling.
implement checkpoints and transactions in
                                                 Configure control flow precedence constraints.
an Integration Services package; deploy an
Integration Services package; manage and         Configure control flow containers.                  Implementing Checkpoints
secure an Integration Services package.                                                               and Transactions
                                                                                                       This module explains what checkpoints are
                                                                                                        and how to implement them. It then discusses
                                                                                                        transactions, and describes how you can
                                                                                                        implement transactional data access logic in
                                                                                                        an Integration Services package.
                                                                                                       Implementing Checkpoints
                                                                                                       Implementing Transactions
                                                                                                       Lab: Implementing Checkpoints and
                                                                                                        Transactions
Skills:
 Implement checkpoints.
 Implement transactions.
Deploying Packages
 This module discusses how to create Package
  Configurations and how to deploy Integration
  Services packages to production servers.
 Package Configurations
 Deploying Packages
 Lab: Deploying Integration Services Packages
Skills:
 Implement package configurations.
 Deploy packages.
Managing and Securing
Packages
 This module describes the management tasks            F1 COMPUTER
  that relate to Integration Services packages and
  explains how to perform those tasks by using the    TRAINING SERVICES
  Integration Services management tools. It also
  describes how to secure Integration Services
  packages.                                                 THE KEY TO A
 Managing Packages
 Securing Packages                                        BETTER FUTURE
 Lab: Managing and Securing Packages
Skills:
 Manage packages.                                      for further information…
 Secure packages.
                                                           call us on
                                                       0800 169 1890

                                                          F1 COMPUTING
                                                           SYSTEMS LTD
                                                              3 Kelso Place
                                                            Upper Bristol Road
                                                             BATH BA1 3AU

                                                           Fax: 01225 444728

                                                        training@f1comp.co.uk

                                                        www.f1comp.co.uk


                                                      LONDON BATH OR ONSITE




                                                        PARTICULARS
                                                               Cost:
                                                           £1050 plus VAT
                                                             Platform:
                                                                Windows
                                                               Numbers:
                                                     Maximum of 6 people on each
                                                     course at F1’s training facilities
                                                          in London and Bath
                                              Implementing and Maintaining
                                              Microsoft SQL Server 2005
                                              Reporting Services
COMPUTER TRAINING                             At the end of the course the delegate will be able to complete the following:
 The key to a better future
                                              Introduction to Microsoft                              Skills:
                                                                                                      Define report data.
                                              SQL Server Reporting                                    Use parameters and filters.
                                              Services                                                Use parameter lists.
      SQL SERVER                               This module introduces the role that Reporting
                                                                                                     Using Report Models
                                                  Services plays in an organization’s reporting
     Course No. 2793                              life cycle, the key features offered by             This module describes how to create a report
                                                  Reporting Services, and the components that          model so that business users can create their
                                                  make up the Reporting Services architecture.         own reports without using the full Report
             3 Days                              Overview of SQL Server Reporting Services            Designer development environment. Students
                                                 Installing Reporting Services                        also learn how to use Report Builder to create
                                                 Reporting Services Tools                             a report from a report model.
                                                 Lab: Using Reporting Services Tools                 Creating Report Models
Target Audience:                              Skills:                                                 Using Report Builder
This course teaches students how to
                                               Describe the features of SQL Server Reporting         Lab: Working with Report Models
implement a Reporting Services solution in                                                           Skills:
                                                  Services.
their organizations. It is intended for
information technology (IT) professionals      Install Reporting Services.                           Create Report Models.
and developers who need to implement           Describe the Reporting Services tools.                Use Report Builder.
reporting solutions by using Microsoft SQL
Server 2005 Reporting Services.               Authoring Basic Reports                                Publishing and Executing
                                               This module introduces the fundamentals of           Reports
Pre-requisites:                                   report authoring, including configuring data        This module explains the various options you
Before attending this course, students must       sources and data sets, creating tabular reports,       can use to publish reports to the report server
have the following pre-requisites:                summarizing data, and applying basic                   and execute them.
• Exposure to creating reports in Microsoft       formatting.                                           Publishing Reports
  Access or other third-party reporting          Creating a Basic Table Report                         Executing Reports
  products, such as Crystal Reports.             Formatting Report Pages                               Creating Cached Instances
• Conceptual understanding of the push           Calculating Values                                    Creating Snapshots and Report History
  and pull distribution/subscription             Lab: Creating a Simple Report                         Lab: Publishing and Executing Reports
  paradigm.
                                              Skills:                                                Skills:
• Experience navigating the Microsoft          Create a basic table report.                            Publish reports.
  Windows Server environment.
                                               Format report pages.                                    Execute reports.
• Experience with Windows services             Calculate values for a report.
  (starting and stopping).                                                                              Create cached instances.
• Experience creating service accounts and                                                              Create snapshots and report history.
  permissions.
                                              Enhancing Basic Reports
• Experience with Microsoft SQL Server,        This module introduces navigational controls         Using Subscriptions to
  including: SQL Server Agent; SQL Server       and some additional types of data regions, and
  query language (SELECT, UPDATE, INSERT,       discusses how to use them to enhance a basic         Distribute Reports
  and DELETE); SQL Server System tables;        report.                                               This module describes how to implement
  SQL Server accounts (users and               Interactive Navigation                                   subscriptions so that you can distribute
  permissions).                                Displaying Data                                          reports either automatically by e-mail or by
                                               Lab: Enhancing a Report                                  publishing reports to a shared folder.
Purpose:                                      Skills:                                                   Introduction to Report Subscriptions
After completing this course, students will    Create reports with interactive navigation.             Creating Report Subscriptions
be able to describe SQL Server Reporting       Display data in various formats.                        Managing Report Subscriptions
Services and its components; create a                                                                   Lab: Implementing Subscriptions
Reporting Services report; enhance a
                                              Manipulating Data Sets                                 Skills:
Reporting Services report; create and
                                               This module explores data sets to a greater           Describe report subscriptions.
manipulate data sets; use report models to
                                                  depth, including the use of alternative data        Create report subscriptions.
implement reporting for business users;
configure report publishing and execution         sources and interacting with a data set through     Manage report subscriptions.
settings; implement subscriptions for             the use of parameters. Students learn how to
reports; administer Reporting Services;           dynamically modify the data set underlying a
implement custom Reporting Services               data region by allowing parameters to be sent
applications..                                    to the underlying query.
                                                 Defining Report Data
                                                 Using Parameters and Filters
                                                 Using Parameter Lists
                                                 Lab: Manipulating Data Sets
Administering Reporting
Services
 This module discusses how to administer the
    Reporting Services server, how to monitor and
    optimize the performance of the report server,
    how to maintain the Reporting Services
    databases, and how to keep the system secure.
   Server Administration
   Performance and Reliability Monitoring
   Administering Report Server Databases
   Security Administration
   Lab: Administering Reporting Services
Skills:
   Administer the reporting server.
   Monitor performance and reliability.
   Administer the Report Server databases.
   Administer security.

Programming Reporting                                      F1 COMPUTER
Services                                                 TRAINING SERVICES
 This module explains how to query Reporting
    Services information programmatically and how
    to automate report management tasks. Students              THE KEY TO A
    also learn how to render reports without relying          BETTER FUTURE
    on Report Manager, and how you can extend the
    feature set of a report server by creating custom
    code.
   Querying for Server Information Using a Web            for further information…
    Service


    Automating Report Management
    Rendering Reports
                                                              call us on


    Creating Custom Code
    Lab: Programming Reporting Services
                                                          0800 169 1890
Skills:
   Query server information by using a Web service.
   Automate report management.                              F1 COMPUTING
   Render reports.                                           SYSTEMS LTD
   Create custom code.
                                                                 3 Kelso Place
                                                               Upper Bristol Road
                                                                BATH BA1 3AU

                                                              Fax: 01225 444728

                                                           training@f1comp.co.uk

                                                           www.f1comp.co.uk


                                                         LONDON BATH OR ONSITE




                                                           PARTICULARS
                                                                  Cost:
                                                              £1050 plus VAT
                                                                Platform:
                                                                   Windows
                                                                  Numbers:
                                                        Maximum of 6 people on each
                                                        course at F1’s training facilities
                                                             in London and Bath
                                               Designing a Business Intelligence
                                               Solution for the Enterprise Using
                                               Microsoft SQL Server 2005
COMPUTER TRAINING                              At the end of the course the delegate will be able to complete the following:
 The key to a better future
                                               Introduction to Business                             Skills:
                                                                                                     Identify requirements and resources for
                                               Intelligence Architecture                              implementing and managing a Business
                                                In this module, students will learn about key        Intelligence development project.
      SQL SERVER                                 design principles that should be considered
                                                 when scoping a BI solution, and how to gather
                                                                                                     Manage a Business Intelligence development
                                                                                                      project.
                                                 business and technical requirements that will       Determine effective data management
     Course No. 2794                             ensure that the solution and architecture            processes.
                                                 meets the needs of its users.
             2 Days                             Overview of Business Intelligence                  Designing Business
                                                Overview of Business Intelligence Architecture
                                                Lab: Identifying Business Intelligence Solution    Intelligence Infrastructure
                                                 Requirements                                        This module describes how to identify
Target Audience:                               Skills:                                                  infrastructure requirements for a Business
This course will teach Business Intelligence    Describe the nature of a Business Intelligence         Intelligence solution, and how to design an
(BI) professionals working in enterprise           solution.                                            effective infrastructure to provide the
environments to design a BI solution            Identify the main components of a                      required levels of scalability and availability.
architecture. It is intended for experienced       comprehensive Business Intelligence                 Determining Infrastructure Requirements
BI and SQL Server DBA professionals.               architecture.                                       Designing the Infrastructure
                                                                                                       Planning for Scalability and Availability
Pre-requisites:                                Overview of the Business                                Lab: Supporting Business Intelligence
Before attending this course, students must                                                             Infrastructure growth
have the following pre-requisites:             Intelligence Project Lifecycle                       Skills:
• Have observed all phases of the BI project    This module examines the core processes and         Determine infrastructure requirements for a
  lifecycle                                        requirements to achieve a successful Business        Business Intelligence solution.
• Have foundational conceptual                     Intelligence project.                             Design the infrastructure for a Business
  understanding of data warehousing, data         Planning a Business Intelligence Project             Intelligence solution.
  marts, and Business Intelligence.               Determining Business Intelligence                 Plan for scalability and availability.
• Have practical experience with OLAP, ETL,        Requirements
  and Reporting on the Microsoft SQL              Revising and Updating a Business Intelligence    Managing Business
  Server Platform.                                 Project
• Have a conceptual understanding of the          Lab: Planning a Business Intelligence Project    Intelligence Operations
  components of SQL Server 2005 and be         Skills:                                               This module explains how to manage and
  familiar with SQL Server 2005 features,
                                                Describe the major components of a Business          operate a Business Intelligence solution.
  tools, and technologies.
                                                 Intelligence project lifecycle.                     Overview of Business Intelligence Operations
• Have foundational understanding of            Determine requirements for a Business               Managing Maintenance and Operations Tasks
  Microsoft Windows security.
                                                 Intelligence solution project.                      Managing Data Archiving
• Have foundational understanding of Web-       Revise and update a Business Intelligence           Managing Business Intelligence Operations for
  based architecture.                                                                                 Business Continuity
                                                 project plan.
• Must understand the difference between                                                             Lab: Using Microsoft Operations Framework
  replication and ETL.
                                               Introduction to Business                               (MOF) to Manage Business Intelligence
                                                                                                      Operations
Purpose:                                       Intelligence Development                             Skills:
After completing this course, students will     This module describes how to plan and               Describe Business Intelligence operations.
be able to capture the business and
technical requirements for a Business
                                                   manage the development process for a              Identify and plan maintenance and operations
                                                   Business Intelligence project. It discusses          tasks for a Business Intelligence solution.
Intelligence solution architecture; describe
the major stages and requirements of a
                                                   considerations for assembling the                 Plan and implement data archiving in a
                                                   development team, managing the                       Business Intelligence solution.
Business Intelligence project lifecycle;
determine Business Intelligence
                                                   development process, testing, and deploying       Describe business continuity and how it
development requirements and implement
                                                   the solution.                                        applies to Business Intelligence operations.
a Business Intelligence development project;
                                                  Overview of Business Intelligence
assess and design a Business Intelligence          Development
infrastructure; describe and plan Business        Managing Business Intelligence Development
Intelligence operations and their                 Determining Data Management Process
management.                                       Lab: Developing a Business Intelligence
                                                   Solution
   F1 COMPUTER
 TRAINING SERVICES

       THE KEY TO A
      BETTER FUTURE


   for further information…

      call us on
  0800 169 1890

     F1 COMPUTING
      SYSTEMS LTD
         3 Kelso Place
       Upper Bristol Road
        BATH BA1 3AU

      Fax: 01225 444728

   training@f1comp.co.uk

   www.f1comp.co.uk


 LONDON BATH OR ONSITE




   PARTICULARS
           Cost:
       £700 plus VAT
         Platform:
           Windows
          Numbers:
Maximum of 6 people on each
course at F1’s training facilities
     in London and Bath
                                                 Designing an ETL Solution
                                                 Architecture Using Microsoft SQL
                                                 Server 2005 Integration Services
COMPUTER TRAINING                                At the end of the course the delegate will be able to complete the following:
 The key to a better future
                                                 Planning for ETL                                       Logging, Error Handling, and
                                                  In this module, Students will learn how to plan      Reliability
                                                     the way in which data will be transferred and
                                                     staged in an ETL solution.                          In this module, students will learn how to
      SQL SERVER                                 
                                                 
                                                     Identifying Data Sources and Destinations
                                                     Evaluating Source Data
                                                                                                            incorporate logging, error handling, and
                                                                                                            reliability into your SSIS package designs. The
                                                                                                           module covers standard logging, custom
     Course No. 2795                             
                                                     Identifying Staging Requirements
                                                     Lab: Planning an ETL Solution                          logging, and log reporting. The module also
                                                                                                            teaches students how to implement error
                                                 Skills:
              2 Days                              Plan data access and load operations.
                                                                                                            handling and how to handle bad data. Finally,
                                                                                                            the module shows students how to
                                                  Evaluate source data.                                    implement a transaction strategy, use
                                                  Design the ETL staging environment.                      checkpoints, and handle restarts and
Target Audience:                                                                                            rollbacks.
This course will teach Business Intelligence
                                                 Planning an SSIS Solution                                 Logging ETL Operations
(BI) professionals working in enterprise          In this module, students will learn how to plan         Handling Errors in SSIS
environments to design an extract,                   an SSIS-based ETL solution. Specifically, they        Implementing Reliable ETL Processes with SSIS
transform, and load (ETL) solution that              will learn how to plan SSIS packages, how to          Lab: Implementing Reliable Packages
supports their BI solution. It is intended for       plan an effective package development              Skills:
experienced Business Intelligence (BI)               process, and how to design the control flow         Design and implement logging in an SSIS
professionals.                                       within the packages.                                   package.
                                                    Planning Packages                                   Design and implement error handling in an
Pre-requisites:                                     Planning Package Development                           SSIS package.
Before attending this course, students must         Designing Package Control Flow                      Design and implement reliability in an SSIS
have the following pre-requisites:                  Lab: Implementing SSIS Packages                        package.
• Have hands-on experience with database         Skills:
  development tasks.                              Plan SSIS packages.                                  Optimizing an SSIS Solution
• Have foundational conceptual                    Plan package development.                             In this module students will learn how to
  understanding of data warehousing, data         Design package control flow.                             monitor and optimize SSIS performance. They
  marts, and Business Intelligence.
                                                                                                            will also learn how to scale-out SSIS packages
• Have a conceptual understanding of ETL         Designing Data Flow                                       Monitoring SSIS Performance
  processes.
• Be familiar with SQL Server 2005 features,
                                                  In this module, students will learn how to              Optimizing SSIS Packages
  tools, and technologies. In particular, they
                                                     design data flows that extract, transform, and        Scaling Out SSIS Packages
  must have built an SSIS package.
                                                     load data. They will also learn about factors to      Lab: Optimizing Packages
• Have foundational understanding of
                                                     consider when working with slowly changing         Skills:
  Microsoft Windows security.
                                                     dimensions (SCDs) and when implementing             Monitor SSIS packages.
• Have foundational understanding of Web-
                                                     custom SCD transformations.                         Optimize SSIS packages.
  based architecture.
                                                    Understanding Data Flow                             Design scale-out solutions for SSIS packages.
• Must understand the difference between            Designing Data Flow Operations
  replication and ETL.
                                                    Handling Data Changes                              Deploying and Operating an
                                                    Lab: Implementing Data Flow
Purpose:                                         Skills:                                                SSIS Solution
After completing this course, students will       Describe how data flows work in SSIS.                 This module describes considerations for
be able to plan data transfer and staging         Design data flow operations                            deploying an SSIS solution into a production
solutions for an ETL operation; plan an SSIS      Design data flows for updated data.                    environment. It also discusses some of the
Solution; design and implement data flows;                                                                issues related to operations and management
incorporate logging, error handling, and                                                                  that you must consider when planning an SSIS
reliability into a package; optimize an SSIS                                                              solution.
solution; deploy and operate an SSIS                                                                     Deploying SSIS Packages
solution.                                                                                                Operating an SSIS Solution
                                                                                                         Lab: Deploying and Managing Packages
                                                                                                        Skills:
                                                                                                         Deploy an SSIS solution.
                                                                                                         Operate an SSIS Solution.
   F1 COMPUTER
 TRAINING SERVICES

       THE KEY TO A
      BETTER FUTURE


   for further information…

      call us on
  0800 169 1890

     F1 COMPUTING
      SYSTEMS LTD
         3 Kelso Place
       Upper Bristol Road
        BATH BA1 3AU

      Fax: 01225 444728

   training@f1comp.co.uk

   www.f1comp.co.uk


 LONDON BATH OR ONSITE




   PARTICULARS
           Cost:
       £700 plus VAT
         Platform:
           Windows
          Numbers:
Maximum of 6 people on each
course at F1’s training facilities
     in London and Bath
                                                 Designing an Analysis Solution
                                                 Architecture Using Microsoft SQL
                                                 Server 2005 Analysis Services
COMPUTER TRAINING                                At the end of the course the delegate will be able to complete the following:
 The key to a better future
                                                 Capturing Business and                               Creating Calculations
                                                 Technical Requirements                                In this module, students will learn how to
                                                                                                          create Multidimensional Expression (MDX)
                                                  In this module, students will first learn about        calculations. The module describes how to
      SQL SERVER                                   key design principles that they should consider
                                                   when you define the scope of a BI project.
                                                                                                          create calculated members, named sets, and
                                                                                                          scoped assignments.
                                                   They will then learn how to identify the           
     Course No. 2796                               business and technical requirements to ensure      
                                                                                                          Implementing Calculated Members
                                                                                                          Implementing Named Sets
                                                   that their solution meets the needs of its            Implementing Scoped MDX Scripts
              3 Days                               users.
                                                  Planning a Multidimensional Solution                  Lab: Implementing Calculations
                                                  Identifying Requirements and Constraints           Skills:
                                                  Lab: Capturing Business and Technical               Create calculated members.
                                                   Requirements                                        Create named sets.
Target Audience:                                                                                       Create scoped assignments.
This course is designed to teach Business        Skills:
                                                  Describe the purpose of a multidimensional
Intelligence (BI) professionals working in
enterprise environments to design a                  solution.                                        Extending Cube Functionality
multidimensional solution architecture that       Identify requirements and constraints when          In this module, students will learn about the
supports their BI solution. It is intended for       designing a multidimensional solution.               benefits of KPIs, actions, and stored
experienced BI professionals.                                                                             procedures. They will also learn how to

Pre-requisites:
                                                 Designing and Implementing                               implement KPIs, actions, and stored
                                                                                                          procedures in an Analysis Services cube.
Before attending this course, students must      a Logical OLAP Solution                                 Key Performance Indicators
                                                                                                         Actions
have the following pre-requisites:
• Have hands-on experience with database
                                                 Architecture                                            Stored Procedures
  development tasks.
                                                  This module describes considerations and              Lab: Implementing Advanced Functionality
                                                     guidelines for designing an OLAP solution,
• Have foundational conceptual                                                                        Skills:
                                                     including a relational data warehouse and an
  understanding of data warehousing, data
                                                     Analysis Services cube.                           Create KPIs.
  marts, and Business Intelligence.
                                                    Planning a Unified Dimensional Model              Create actions.
• Conceptual understanding of OLAP
                                                    Designing and Implementing Fact and               Create stored procedures.
  technologies, multi-dimensional data,
                                                     Dimension Tables
  MDX, and relational database modeling.
• Be familiar with SQL Server 2005 features,        Designing and Implementing Cubes                 Designing an Analysis
  tools, and technologies.                          Lab: Designing and Implementing a UDM            Services Infrastructure
• Have foundational understanding of             Skills:                                               In this module, students will learn how to
  Microsoft Windows security.                     Describe design considerations for a UDM               design an appropriate infrastructure for an
• Have foundational understanding of Web-          solution.                                              OLAP application.
  based architecture.                             Describe design considerations for the                Considerations for Analysis Services Resource
• Must understand the difference between           relational schema of an OLAP solution.                 Requirements
  replication and ETL.                            Describe considerations for designing and             Considerations for Analysis Services Scalability
                                                   implementing OLAP cubes.                              Considerations for Analysis Services
Purpose:                                                                                                  Availability
After completing this course, students will      Designing Physical Storage                              Lab: Designing and Implementing Analysis
be able to capture the business and                                                                       Services Infrastructure
technical requirements for a BI solution;        for a Multidimensional                               Skills:
design and implement a logical Online            Solution                                              Specify appropriate hardware and software
Analytical Processing (OLAP) solution
architecture; design physical storage for a
                                                  In this module, students will learn how to             resources for an Analysis Services solution.
multidimensional solution; create calculated
                                                     design an effective physical storage solution     Design an Analysis Services infrastructure that
members and named sets; implement Key                for a multidimensional application.                  supports high scalability.
Performance Indicators (KPIs), actions, and         Designing Physical Storage                        Design an Analysis Services infrastructure that
stored procedures; design the infrastructure        Partitioning Relational Data                         supports high availability.
for an OLAP solution; deploy and secure an          Partitioning Multidimensional Data
Analysis Services solution in a production          Lab: Designing and Implementing Physical
environment; monitor and optimize an                 Storage
Analysis Services solution; implement a Data     Skills:
Mining Solution.                                  Design an effective physical storage solution
                                                     for dimensions and measures.
                                                  Partition relational data.
                                                  Partition multidimensional data.
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.
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.
                                                         F1 COMPUTER
 Monitoring Analysis Services                         TRAINING SERVICES
 Optimizing Performance
 Lab: Optimizing Analysis Services
Skills:                                                      THE KEY TO A
 Monitor Analysis Services.                                BETTER FUTURE
 Optimize Analysis Services performance.
Implementing Data Mining
 In this module, students will learn what a data        for further information…
    mining solution is and how to design and
    implement data mining functionality with SQL
    Server Analysis Services.
                                                            call us on


    Introduction to Data Mining
    Implementing a Data Mining Solution
                                                        0800 169 1890
   Using Data Mining in a BI Solution
   Lab: Implementing Data Mining
Skills:                                                    F1 COMPUTING
 Plan a data mining solution.                              SYSTEMS LTD
 Implement a data mining solution.
 Use data mining in a BI solution.                            3 Kelso Place
                                                             Upper Bristol Road
                                                              BATH BA1 3AU

                                                            Fax: 01225 444728

                                                         training@f1comp.co.uk

                                                         www.f1comp.co.uk


                                                       LONDON BATH OR ONSITE




                                                         PARTICULARS
                                                                Cost:
                                                            £1050 plus VAT
                                                              Platform:
                                                                 Windows
                                                                Numbers:
                                                      Maximum of 6 people on each
                                                      course at F1’s training facilities
                                                           in London and Bath
                                                 Designing a Reporting Solution
                                                 Architecture Using Microsoft SQL
                                                 Server 2005 Reporting Services
COMPUTER TRAINING                                At the end of the course the delegate will be able to complete the following:
 The key to a better future
                                                 Designing a Reporting                                Deploying and Managing a
                                                 Solution                                             Reporting Solution
                                                  In this module, students will learn how to          In this module, students will learn how to
      SQL SERVER                                   identify user requirements and business
                                                   requirements for a reporting solution. They
                                                                                                        deploy a Reporting Services solution into a
                                                                                                        production environment, and how to manage
                                                   will then learn how to match the requirements        report distribution.
     Course No. 2797                               of the user to Reporting Services technologies,     Deploying a Reporting Services Solution
                                                   including the report model technology.              Managing Report Distribution
              2 Days                              Evaluating Business Requirements for a              Lab: Implementing Calculations
                                                   Reporting Solution                                 Skills:
                                                  Designing for Reporting Services                    Deploy a Reporting Services solution.
                                                  Lab: Designing a Reporting Solution                 Manage Report Distribution.
Target Audience:                                 Skills:
This course will teach Business Intelligence      Evaluate the business requirements for a           Designing Security for a
(BI) professionals working in enterprise           reporting solution.
environments to design a reporting solution       Design a Reporting Services implementation.        Reporting Solution
architecture that supports their BI solution.                                                          In this module, students will learn how to
It is intended for experienced BI
professionals.
                                                 Developing a Reporting                               
                                                                                                          secure a Reporting Services solution.
                                                                                                          Designing an Authentication Strategy
                                                 Solution                                                Designing an Authorization Strategy
Pre-requisites:                                   In this module, students will first identify how      Designing a Secure Communication Strategy
Before attending this course, students must        best to develop reports using the powerful            Lab: Securing Reporting Services
have the following pre-requisites:                 Business Intelligence Development Studio           Skills:
• Have hands-on experience with database           Report Designer tool. This will include a review    Design an authentication strategy for
  development tasks.                               of best practice for report layout, and how this       Reporting Services.
• Have foundational conceptual                     is affected by the various rendering formats        Design an authorization strategy for Reporting
  understanding of Business Intelligence           available. Secondly, they will identify the            Services.
  presentation architecture.                       considerations for effective development of a       Design a secure communication strategy for
• Have foundational understanding of Web-          report model to enable more experienced                Reporting Services.
  based architecture.                              users to create their own reports.
• Be familiar with SQL Server 2005 features,      Developing Reports                                 Optimizing Report
  tools, and technologies. In particular, they    Developing Report Models
  must have used Report Designer, Report          Lab: Developing a Reporting Solution               Performance
  Manager, and Report Builder.
                                                 Skills:                                               In this module, students will learn how to
• Have foundational understanding of              Create a Reporting Services solution.                  optimize a Reporting Services solution.
  Microsoft Windows security.
                                                  Create a report model and use it to create a          Monitoring Report Execution
• Have foundational understanding of Web-           report with Report Builder.                          Designing a Report Execution Strategy
  based architecture.                                                                                    Scaling Reporting Services
• Must understand the difference between
                                                 Integrating Reporting                                   Lab: Optimizing Performance
  replication and ETL.
                                                                                                      Skills:
                                                 Services with Applications                            Design a report execution strategy to optimize
Purpose:                                          In this module, students will review the               performance.
After completing this course, students will
be able to design a reporting solution;
                                                   options for integrating Reporting Services          Monitor report execution.
develop a reporting solution; collaborate
                                                   reports into a custom application. They will        Design a scalability strategy for Reporting
                                                   look at using direct URL access, the report            Services.
with application developers to complete            viewer controls provided by Microsoft Visual
reporting and analytical interfaces; deploy
                                                   Studio 2005, the Reporting Services SharePoint
and manage a Reporting Services solution;
                                                   Web Parts, and the Reporting Services Web
design security for a Reporting Services
solution; optimize report rendering
                                                   services. Lastly, they will discuss which
performance.                                       approach, or combination of approaches,
                                                   might suit different BI applications, and their
                                                   different kinds of user.
                                                  Integrating with Custom Applications
                                                  Controlling Reporting Services by Using Web
                                                   Services
                                                  Lab: Integrating Reporting Services with
                                                   Applications
                                                 Skills:
                                                  Integrate Reporting Services with custom
                                                    applications.
                                                  Design Web service clients for Reporting
                                                    Services.
   F1 COMPUTER
 TRAINING SERVICES

       THE KEY TO A
      BETTER FUTURE


   for further information…

      call us on
  0800 169 1890

     F1 COMPUTING
      SYSTEMS LTD
         3 Kelso Place
       Upper Bristol Road
        BATH BA1 3AU

      Fax: 01225 444728

   training@f1comp.co.uk

   www.f1comp.co.uk


 LONDON BATH OR ONSITE




   PARTICULARS
           Cost:
       £700 plus VAT
         Platform:
           Windows
          Numbers:
Maximum of 6 people on each
course at F1’s training facilities
     in London and Bath

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:4
posted:8/18/2012
language:English
pages:14