Introduction - SSAS
Database Design
Review of third normal form and traditional OLTP databases
Introduction to designing OLAP star and snowflake schemas
Introduction to designing cubes
Analysis Services (using Business Intelligence Development Studio - BIDS)
Building fact tables
Building dimensions
Building cubes
Pivot Tables and Matrices
Browsing cubes in BIDS and Management Studio (SSMS)
Browsing cubes in Excel
Browsing cubes in Web Pages
Cubes in Reporting Services (SSRS)
Maintaining data warehouses
Backup and restoring star schemas
Backup and restoring of cubes
Cube security
Updating cubes
SQL Server Integration Services (SSIS)
Using SSIS Wizards
Using SSIS Designer
Using SSIS to normalise data
Using SSIS to denormalise data
Using SSIS to process cubes
Analysis Services programming
MDX queries and expressions
DMX data mining queries
ASSL and XMLA and AMO
SSIS Programming
SSIS and TSQL (Transact SQL)
SSAS and VB.NET & C#
SSIS and VB.NET
Running and saving SSIS
Scheduling SSIS packages
Running from stored procedures
Saving to SQL Server
Saving to file
Advanced Analysis Services
Data mining
Deployment
Perspectives
Actions
Write-back
Introduction to SQL Server 2005 Reporting Services
Architecture
Reporting Services
Report Server
Report Server databases
Report Designer
Report Manager
Report Models
Report Builder
Designing a simple report
Report wizards
Report Designer
Basic formatting
Using templates
Previewing
Deploying
Working with data
SQL queries
Query Builder
MDX queries
DSV (data source views)
Grouping
Advanced reports
Formatting
Using expressions
Page breaks
Matrices
Headers
Graphics
Interactive reports
Parameters
Drill through
Report Builder
Tables and matrices
Adding clickthrough
Sorting and filtering
Administration
Report Manager
Configuration Manager
Management areas
Managing Report Server
Managing security
Managing subscriptions
Managing Report Models
Managing deployment
Managing access
Comments