Microsoft ProClarity Administrator Training Analysis Services 2005

Prerequisites:

Before attending this course, students must have:

MCDBA (Microsoft Certified Database Administrator SQL 2000) or MCTS (Microsoft Certified Technology Specialist SQL Server) certification or equivalent knowledge.
Understanding of relational database concepts.
Use of the MS SQL 2005 tools (Microsoft SQL Server Management Studio SSMS and Business Intelligence Development Studio) would be a great advantage.

Course Description:

This three-day ILT course is aimed at administrators and developers who will be creating and maintaining an analytics solution for their organisation that will employ both Microsoft SQL Server Analysis server and ProClarity technologies. The course will allow the delegates to gain the knowledge to correctly design and build MSAS 2005 cubes which will lead to efficient and maintainable cubes that will perform well when browsed using ProClarity applications.

Delegates will learn how to:

• Design a data warehouse structure geared towards Analysis Server
• Design a data warehouse structure geared towards Analysis Server
• Create dimensions and cubes
• Use the Business Intelligence Enhancements
• Browse the created cubes using ProClarity Standard client
• Create calculated items (KPI, members and sets)
• Design the storage structure for dimensions and cubes (MOLAP, ROLAP and HOLAP)
• Secure the cube structure
• Design the deployment infrastructure

This course includes the following modules:

Microsoft SQL Server Analysis 2005 overview

• Review of AS 2005 architecture
• Review of DW architecture
• Review AS 2005 features and services

Introduction to cube design

• Good schema design
• Create a database
• Data Source and Data Source View
• Create a dimension and cube
• Measure Groups
• Perspectives
• Process, build and deploy

Advanced cube design concepts

• Time dimensions
• Business Intelligence Enhancements
• Actions
• Distinct counts
• Linked items

Calculations, sets and KPIs

• Calculated members
• KPI
• Business Logic Server

Visualisation with ProClarity

• View SSAS cube using ProClarity
• Integrate ProClarity with MS SQL Reporting Services

Processing and Storage

• Processing options
• Aggregations
• Usage based optimisation
• Storage modes
• Proactive caching
• Write-back

Security

• Security architecture
• Security database objects
• Dimension data security
• How ProClarity products work with the AS 2005 security

Deployment

• Archive and restore cube data
• Managing development to production environments
• Using profiler to monitor query access