PDF:
Course Length:
5
days
Price:
$2,500
Summary
In this course, you will learn how to use Microsoft SQL Server 2008
Analysis Services (SSAS) to design and implement OnLine Analytical
Processing (OLAP) cubes and data mining models to support Business
Intelligence (BI) solutions. This course includes concepts, procedures
and practices based on real-world experience giving both the novice and
experienced SQL Server 2008 developer the tools to build data cubes and
forecasting solutions. This course also provides information on
end-user tools including Microsoft Excel 2007, Office Visio 2007
Professional Edition, SQL Server Business Intelligence Development
Studio (BIDS) Microsoft SQL Server 2005 Integrated Services and
Reporting Services.
Who Should Attend?
This course does not require any prior experience with Analysis Server
2008. It is assumed that students have working experience with SQL
Server 2005 or 2008; basic relational database concepts (e.g., tables,
queries, and indexing); data transformation services; Excel 2007; and
SharePoint Server 2007.
Course Outline
What Is Microsoft Business
Intelligence?
- Define Business Intelligence
- Understand the Cube Structure
- Deploy and View a Sample Cube
- View a Cube by using Excel
- View a Cube by using SQL Reporting Services
OLAP Modeling
- Understand Basic OLAP Modeling (star schema)
- Understand Dimensional Modeling (stars and
snowflakes)
- Understand Measure (fact) and Cube Modeling
- Model with SQL Server Business Intelligence
Development Studio (BIDS)
Using SSAS in BIDS
- Understand the Development Environment
- Create Data Sources
- Create Data Source Views
- Create Cubes by using the Cube Wizard
Intermediate SSAS
- Create Key Performance Indicators (KPIs)
- Create Perspectives
- Create Translations for Cubes and Dimensions
- Review the three SSAS Action Object Types: Regular,
Drillthrough, and Reporting
Advanced SSAS
- Work with Multiple Fact Tables and the Dimension
Usage Subtab in BIDS
- Explore Advanced Dimension Types
- Business Intelligence Wizard
- Understand Writeback in Dimensions
- Review Semi-Additive Measures in OLAP Cubes
Cube Storage and Aggregation
- View Aggregation Designs
- Customize Aggregation Designs
- Implement Proactive Caching
- Use Relational and SSAS Partitions
- Customize Cube and Dimension Processing
Introduction to MDX Queries
- Understand Basic MDX Syntax
- Use the MDX Query Editor in SSMS
- Understand Common MDX Functions and Tasks
- Review MDX Functions New to SSAS 2008
MDX Expressions
- Understand the Calculation Subtab
- Adding Calculated Members
- Explore how to add MDX Script Commands
- Discover how to add .NET Assemblies
Introduction to Data Mining
- Understand Data Mining Concepts
- Review the Algorithms that SSAS Includes
- Consider Data Mining Clients
- Understand Mining Structure Processing
SSAS Administration
- Implement SSAS Security
- Implement XMLA Scripts in SSMS
- Deploy and Synchronize Databases
- Understand SSAS Database Backup and Restore
Advanced Administration and Optimization
- Implement SSIS to Manage SSAS Datbases
- Explore Clustering
- Explore Scalability Options
- Understand Performance Tuning and Optimization
Introduction to SSAS Clients
- Design Reports using Reporting Services
- Design Reports by using Report Builder
- Implement Excel 2007 Pivot Tables and Charts
- Use Excel 2007 as a Data Mining Client
- Review Microsoft Office SharePoint Server 2007
