|
Click on a date to register
|
 |
Live@DL |
SQL-447 -
4 days -
Instructor-led (classroom)
Designing and Developing Solutions with SQL Server 2008 Analysis Services
Price: 2,795
Table of Contents
Introduction
Audience
At Course Completion
Prerequisites
Microsoft Certified Professional
Exams
Student Materials
Course Outline
Introduction - 4 Day Intensive Course
During this 4-day course, you will learn to design, develop, and deploy an analytical solution using SQL Server 2008 Analysis Services (SSAS). This course demonstrates design and development best practices as you build a fully working analytical solution.
SQL Server 2008 Analysis Services (SSAS) enables IT Professionals to rapidly build and deploy powerful analytical solutions that enable business users to analyze business data and achieve competitive advantage. SSAS enables rapid application development, increases performance and functionality, and reduces the costs and complexity of operation. This course focuses on teaching IT professionals the skills and best practices required to design and develop a well performing and successful analytical solution using SQL Server 2008 Analysis Services.
Return to Top
Audience
This course is intended for IT Professionals that are responsible for designing, developing, and deploying business intelligence solutions. The target audience for this course is database warehouse, decision support, and business intelligence solution architects, IT professionals, and business intelligence developers who want to learn the details of how to use the new capabilities provided by SSAS to build analytical applications.
Return to Top
At Course Completion
After Completing this course, the student will be able to:
- Describe the process of building a business intelligence solution and identify where and how SSAS fits into the process.
- Create effective SSAS cubes complete with calculations, actions, aggregations, and more.
- Design solutions in SSAS that are both scalable and secure.
- Successfully manage and deploy SSAS cubes in a development/test/production environment.
Return to Top
Prerequisites
While this course is targeted at database professionals with some experience with data warehouse solutions, this workshop requires no prior experience with any version of SQL Server Analysis Services.
A basic understanding of relational design and theory is helpful, as is basic familiarity with Structured Query Language (SQL).
Return to Top
Microsoft Certified Professional Exams
No MCP exam currently exists for this course.
Return to Top
Student Materials
The student kit includes a comprehensive workbook and other necessary materials
for this class.
Return to Top
Course Outline
Section A: BI Solutions Overview
Module 00: Housekeeping
Introductions, course hours, and facilities information
Module 01: Introduction to BI Solutions
The components of a BI Solution, ETL (SSIS), Relational Data Warehouse (SQL Server), Cubes (SSAS), and Delivery (PPS, SSRS, ProClarity, Excel, and more)
Lab 1: Examining the end result of a BI solution
Module 02: Dimensional Modeling
An examination of the design of a dimensional model, including Dimension Tables, Fact Tables, and Star and Snowflake Schemas
Lab 2: Examining a dimensional model
Section B: SSAS Core Design Elements
Module 03: Getting Started With SSAS
And introduction to BIDS, The SSAS Project Lifecycle, Running the Cube Wizard, Examining the Files Created, Deployment and Processing
Lab 3: Building a Cube
Module 04: Working with Dimensions
Creating Dimensions, Working with Dimension Properties, Creating Hierarchies, Working with Hierarchy Properties
Lab 04: Building and Maintaining Hierarchies
Module 05: Extending Dimensions
Attribute Relationships and their Properties, Parent-Child Hierarchies and their Properties, Handling Slowly-Changing Dimensions
Lab 5: Extending Dimensions
Module 06: Building Cubes
Creating Cubes, Cube Properties, Measure Groups, Measures
Lab 6: Cubes and Measure Groups
Module 07: Measure Groups and Dimensions
Regular Dimensions, Referenced Dimensions, Fact Dimensions, Many-to-Many Dimensions
Lab 7: Dimensions and Meaure Groups
Section C: Storage and Maintenance
Module 08: Storage Modes, Aggregations, and Proactive Caching
Storage Modes (MOLAP, HOLAP, and ROLAP), Aggregation Design, Proactive Caching
Lab 8: Cube Storage Modes and Aggregations
Module 09: Basic Maintenance and Administration
Managing with SSMS, Backup and Restore, Synchronization, Deployment
Lab 9: Backing Up, Restoring, and Deploying
Section D: Enhancing the Cube
Module 10: Calculations and KPIs
The Basics of MDX, Creating Calculated Members, Named Sets, KPIs
Lab 10: Creating Calculations and KPIs
Module 11: Actions and Perspectives
Actions, Perspectives
Lab 11: Creating Actions and Perspectives
Module 12: Security
The Default SSAS Security Model, APSE, Custom Security
Lab 12: Securing the Cube
Module 13: Translations
Dimension Translations, Cube Translations
Lab 13: Translations
Module 14: Scalability and Performance
Server Properties, Optimizing Many-to-Many, Reading Queries in Profiler
Lab 14: Examining Queries in Profiler
Return to Top
|