Call for Latest Dates
Call us on 0870 7777 388 for availability on this course.
Have questions or need a better city/date? Ask now.
|
Course Overview This course has been written to give delegates with existing skills in Data Warehousing with SQL Server a framework of best practises. Delegates will gain a deep understanding of Cubes, Star Schemas, and Data Mining, using SQL Server 2005 Analysis Services (SSAS). Our hands-on Advanced SSAS training course has been developed for real-world, commercial scenarios by our expert instructors. See below for our detailed Advanced SQL Server 2005 Analysis Services training course syllabus. The course contains many SSAS tutorials based on real-world scenarios. Audience Existing Database specialists who need to get more out of SQL Server 2005 Analysis Services for Data Warehousing and Data Mining. Skills Gained By completing this course, delegates will be familiar with: - Cube design best practises and security
- A deep understanding of MOLAP / ROLAP / HOLAP
- MDX Queries and Scripts
- Learn how to use XMLA to create, process and back-up Cubes
- Effective Data Mining
Prerequisites - You should be able to understand table, column, data type design, and write SQL Select statements within any relational database
- also to write SQL Server stored procedures. You should have experience of populating a Star Schema
- and of designing, building and deploying simple SSAS cubes with the Cube Wizard.
Course Outline 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
- Using SSIS as an ETL Tool
- DataFlow tasks
Analysis Services programming - MDX queries and expressions
- DMX data mining queries
- ASSL and XMLA and AMO
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
Follow On Courses - SQL Server 2005 Applications Development training course
- SQL Server 2005 Database Administration Training Course
- SQL Server 2005 Comprehensive Upgrade Training Course for existing SQL Server 2000 / Oracle / MySQL users
- SQL Server 2005 Business Intelligence Training Course: SSAS & SSIS Analysis and Integration Services Training Course
- Advanced SQL Server Analysis Services Training Course
- SQL Server 2005 Business Intelligence Training Course: SSRS Reporting Services Training Course
- SQL Server 2008 Comprehensive Upgrade Training Course for existing SQL Server 2000 / SQL Server 2005 users
- SQL Server 2000 Applications Development training
- SQL Server 2000 Database Administration
- SQL Server Performance Tuning
- SQL Server OLAP, DTS & Cubes Training
- SQL Design and Information Retrieval
How to make a booking for the SQL0060 course
|
