Our E-learning curriculum is specifically designed with the busy professional in mind. All of our programs are produced using advanced learning concepts that encompass learning techniques that are designed for adult learning. E- learning is very popular today for a very good reason – It Works! People everywhere are discovering that they can fulfill their learning objectives conveniently (at their own pace, on their own time) and affordably (online classes start at a fraction of the cost of traditional classroom training).
Our easy-to-use delivery format allows you to concentrate on the lesson at hand and not how to run the delivery software – saving you time and frustration. Our comprehensive course materials are delivered in an easy-to- understand format – allowing you to get the most out of your time online.
The Microsoft Certified IT Professional (MCITP) credential validates that an individual has the comprehensive set of skills necessary to perform a particular job role, such as database administrator or enterprise messaging administrator. MCITP certifications build on the technical proficiency measured in the Microsoft Certified Technology Specialist (MCTS) certifications. Therefore, you will earn one or more MCTS certifications on your way to earning an MCITP credential.
MCITP candidates are capable of deploying, building, designing, optimizing, and operating technologies for a particular job role. They make the design and technology decisions necessary to ensure successful technology implementation projects.
AUDIENCE PROFILE:
Candidates for this exam are IT professionals who design and plan business intelligence (BI) solutions by using Microsoft SQL Server 2008 BI tools. The qualified candidate for this exam typically has two to three years of experience in the following:
- Working with SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS)
- Using the SQL Server 2005 and SQL Server 2008 Business Intelligence Development Studio (BIDS)
- Designing both relational and multidimensional database schemas
- Writing both relational and multidimensional queries
- Designing and building cubes
- Designing and creating reports
- Applying data mining algorithms to business problem domains
- Aggregating data from multiple sources into a data warehouse in a heterogeneous data environment
- Designing and managing enterprise-level solutions for multidimensional databases
- Collecting and interpreting business requirements
COURSE FEATURES:
- Instructor led training by the industry’s finest experts delivered via streaming video online or DVD
- Software demonstrations where the instructor shows you how to perform a task onscreen.
- Interactive multimedia presentations
- Easy to navigate controls
- Course bookmarking which allows you to resume training where you left off the last session.
- Hands-on activities and labs
- Review Questions
- Practice Exam Simulators with three different training and testing modes. These simulators can also be used for pre- and post-testing.
- Free technology upgrades for one year
- Educational support
COURSE OUTLINE
Course: 70-452
Instructor Introduction
Course Overview
Module 1: Designing a BI Solution
Module Overview
Data Management
Obtaining Data
BI Clients
Managing Development and Upgrades
Module Review
Module 2: Designing Integration Services
Module Overview
Control Flow
Data Flow
Transactions
Designing Custom Code
Package Design
Server Options
Module Review
Module 3: Designing Analysis Services
Module Overview
Cube Creation
Designing Dimensions and Measures
Enhancing Cubes
Performance
Cube Maintenance
Module Review
Module 4: Designing Data Mining Models
Module Overview
Model Design
Accessing Data and Setting Up a Mining Model
Module Review
Module 5: Designing report Services
Module Overview
Designing Reports
Designing a Report and Setting Up a Template
Designing Servers
Configuring Server Based Reports
Configuring Security
Implementing Report Builder
Module Review
Course Review
Exam Preparation
To order contact Specialized Solutions at:
Specialized Solutions
Corporate Training Division
3727 Jonlen Drive
Cincinnati, OH 45227
Toll Free – 1-877-291-9797
Direct – 513-878-1116