Business Intelligence MCTS BootCamp

Hilton Computer Strategies
Houston, Texas, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This five day instructor-led boot camp teaches students how to prepare for the 70-445 Microsoft Certification Exam covering how to implement an Analysis Services solution in an organization. The course discusses how to use the Analysis Services development tools to create an Analysis Services database and an OLAP cube, and how to use the Analysis Services management and administrative tools to manage an Analysis Services solution. How to implement an Integration Services solution in an organization and how to develop, deploy, and manage Integration Services packages. How to use the Reporting Services development tools to create reports, and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution.



Audience
This course is intended for information technology (IT) professionals and developers who need to become certified as Microsoft Technology Specialist in Business intelligence.



At Course Completion
After completing this course, students will be able to:

Describe how SQL Server Analysis Services can be used to implement analytical solutions.

Create multidimensional analysis solutions with SQL Server Analysis Services.

Implement dimensions in an Analysis Services solution.

Implement measures and measure groups in an Analysis Services solution.

Query a multidimensional Analysis Services solution.

Customize an Analysis Services cube.

Deploy and Secure an Analysis Services database.

Maintain a multidimensional Analysis Services solution.

Describe SQL Server Integration Services and its tools.

Create an Integration Services package.

Implement control flow in an Integration Services package.

Implement data flow in an Integration Services package.

Implement logging in an Integration Services package.

Debug and implement error handling in an Integration Services package.

Implement checkpoints and transactions in an Integration Services package.

Deploy an Integration Services package.

Describe SQL Server Reporting Services and its components.

Create a Reporting Services report.

Enhance a Reporting Services report.

Create and manipulate data sets.

Use report models to implement reporting for business users.

Configure report publishing and execution settings.

Implement subscriptions for reports.

Administer Reporting Services.

Implement custom Reporting Services applications.




Prerequisites
Before attending this course, students must have:

Conceptual understanding of OLAP solutions.

Experience navigating the Microsoft Windows Server environment.

Experience with Windows services (starting and stopping).

Experience creating service accounts and permissions.

Experience with Microsoft SQL Server, including:

SQL Server Agent.

SQL Server query language (SELECT, UPDATE, INSERT, and DELETE).

SQL Server System tables.

Exposure to enterprise data import and export scenarios.

Experience navigating the Microsoft Windows Server environment.

Experience with Microsoft SQL Server, including:

SQL Server Agent.

SQL Server query language (SELECT, UPDATE, INSERT, and DELETE).

SQL Server System tables.

Exposure to creating reports in Microsoft Access or other third-party reporting products, such as Crystal Reports.



Course Outline
Module 1: Introduction to Microsoft SQL Server 2005 Analysis Services

Lessons

Overview of Data Analysis Solutions

Overview of SQL Server 2005 Analysis Services

Installing SQL Server 2005 Analysis Services


Module 2: Creating Multidimensional Analysis Solutions

Lessons

Developing Analysis Services Solutions

Data Sources and Data Source Views

Creating a Cube


Module 3: Working with Dimensions

Lessons

Configuring Dimensions

Defining Hierarchies

Sorting and Grouping Attributes


Module 4: Working with Measures and Measure Groups

Lessons

Working with Measures

Working with Measure Groups


Module 5: Querying Multidimensional Analysis Solutions

Lessons

MDX Fundamentals

Adding Calculations to a Cube


Module 6: Customizing Cube Functionality

Lessons

Implementing Key Performance Indicators

Implementing Actions

Implementing Perspectives

Implementing Translations


Module 7: Deploying and Securing an Analysis Services Database

Lessons

Deploying an Analysis Services Database

Securing an Analysis Services Database


Module 8: Maintaining a Multidimensional Solution

Lessons

Configuring Processing Settings

Logging, Monitoring, and Optimizing an Analysis Services Solution

Backing Up and Restoring an Analysis Services Database


Module 9: Introduction to Data Mining

Lessons

Overview of Data Mining

Creating a Data Mining Solution

Validating Data Mining Models


Module 10: Introduction to SQL Server 2005 Integration Services

Lessons

Overview of Integration Services Solutions

Integration Services Tools


Module 11: Developing Integration Services Solutions

Lessons

Creating an Integration Services Solution

Using Variables

Building and Running a Solution


Module 12: Implementing Control Flow

This module introduces the tasks and precedence constraints that you can use to implement control flow in an Integration Services package.

Lessons

Control Flow Tasks

Control Flow Precedence Constraints

Control Flow Containers


Module 13: Implementing Data Flow

Lessons

Data Flow Sources and Destinations

Data Flow Transformations

Data Flow Paths


Module 14: Implementing Logging

Lessons

Overview of Integration Services Logging

Implementing Logging


Module 15: Debugging and Error Handling

Lessons

Debugging a Package

Implementing Error Handling


Module 16: Implementing Checkpoints and Transactions

Lessons

Implementing Checkpoints

Implementing Transactions


Module 17: Deploying Packages

This module discusses how to create Package Configurations and how to deploy Integration Services packages to production servers.

Lessons

Package Configurations

Deploying Packages


Module 18: Managing and Securing Packages

Lessons

Managing Packages

Securing Packages


Module 19: Introduction to Microsoft SQL Server Reporting Services

Lessons

Overview of SQL Server Reporting Services

Installing Reporting Services

Reporting Services Tools


Module 20: Authoring Basic Reports

Lessons

Creating a Basic Table Report

Formatting Report Pages

Calculating Values


Module 21: Enhancing Basic Reports

Lessons

Interactive Navigation

Displaying Data


Module 22: Manipulating Data Sets

Lessons

Defining Report Data

Using Parameters and Filters

Using Parameter Lists


Module 23: Using Report Models

Lessons

Creating Report Models

Using Report Builder


Module 24: Publishing and Executing Reports

Lessons

Publishing Reports

Executing Reports

Creating Cached Instances

Creating Snapshots and Report History


Module 25: Using ...''

Phone:1-800-324-7415

School Address:

Hilton Computer Strategies, 6001 Savoy, Suite 207, Houston, TX 77036

Jobs & Resumes: Houston
Houses & Roommates: Houston

Business Intelligence MCITP BootCamp
Certified Ethical Hacking BootCamp
ITSM Service Manager Certification BootCamp
MCITP Vista Enterprise Support Technical BootCamp
MCTS Microsoft Exchange Server 2007, Configuration BootCamp
Microsoft Office SharePoint Server 2007 Configuration
Web Application Developer MCTS BootCamp
Web Application Developer MCPD BootCamp
C# Programming for .NET

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: If you want to post any message on this website, please do not include your real name, phone number, email address in the message body area. You should enter them in line text boxs respectively, if needed.