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.
Demonstrate your specialized technical expertise with a Microsoft Certified Technology Specialist (MCTS) credential. By earning this credential, you can prove your ability to successfully implement, build on, troubleshoot, and debug a particular Microsoft technology, such as a Windows operating system, Microsoft Exchange Server, Microsoft SQL Server, and Microsoft Visual Studio.
The Microsoft Certified Technology Specialist (MCTS) certifications provide the foundation for Microsoft Certification. These certifications are designed to validate your skills on the features and functionality of key technologies. You can show your depth of knowledge in one specific technology, earn multiple MCTS certifications to show breadth across different products, or build on the MCTS to earn a Microsoft Certified IT Professional (MCITP) credential.
MCTS candidates are capable of implementing, building, troubleshooting, and debugging a particular Microsoft technology.
AUDIENCE PROFILE:
Candidates for this exam are responsible for creating business intelligence (BI) solutions by using Microsoft SQL Server 2008 for their organizations. Candidates typically work with the full suite of BI technologies in SQL Server 2008, including Reporting Services, Analysis Services, and Integration Services. The qualified candidate for this exam typically has:
- One to two years of experience working with the Microsoft .NET Framework
- Two to three years of experience using SQL Server 2005 BI components
- Six months to one year of experience using SQL Server 2008
- Experience using the SQL Server 2008 Business Intelligence Development Studio (BIDS)
- Experience using Microsoft SQL Server Management Studio (SSMS)
- Knowledge of relational and multi-dimensional database schemas
- Experience creating and deploying a cube in SQL Server Analysis Services (SSAS)
- Experience creating and deploying a data mining model in SSAS
- Experience writing relational and multi-dimensional database queries
- Experience creating and deploying SQL Server Reporting Services (SSRS) reports
- Experience authoring and deploying SQL Server Integration Services (SSIS) packages
- Experience debugging, monitoring, and troubleshooting BI solutions
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-448
Course Introduction
Intro
Module 1: Implementing Business Solutions
Module Overview
BI Concepts
Designing an OLAP System
Designing an Architecture
Module Review
Module 2: Creating SSIS Packages
Module Overview
Creating Packages
Using Control Flow
Implementing Constraints
Module Review
Module 3: Data Flows
Module Overview
Sources and Destination
Transformations
Transactions
Debugging
Module Review
Module 4: Package Management
Module Overview
Event Handlers and Logging
Working with Code
Module Review
Module 5: Deploying SSIS Packages
Module Overview
Deploying Packages
Securing Packages
Executing Packages
Module Review
Module 6: Implementing Cubes
Module Overview
Data Sources and Data Source Views
Creating Cubes
Configuring Dimensions
Setting up a Cube
Module Review
Module 7: Configuring Cubes and Measures
Module Overview
Configuring Measures
MDX
Adding Functionality
Module Review
Module 8: SSA Solutions
Module Overview
Configuring Security
Configuring Storage
Processing Cubes
Deploying Cubes
Module Review
Module 9: Data Mining
Module Overview
Data Mining Basics
Building a Data Mining Model
Module Review
Module 10: Creating Reports
Module Overview
Creating Basic Reports
Interactive Reports
Coding Reports
Module Review
Module 11: Managing a Report Server
Module Overview
Configuring Reporting Services
Deploying Reports
Controlling Report Execution
Using Subscriptions
Securing Reporting Services
Module Review
Module 12: Implementing the Report Builder
Module Overview
Report Models
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