Business Intelligence

Designing and administering data cubes using ProClarity (Course Code: 1292)

Course Schedule:

Please call 8622 8900 or email us for further information

Overview:

This course is designed to provide a comprehensive exposure to the concepts of cubes and measures used in data warehousing, as well the use of ProClarity, a leading toolset for data analysis and presentation, to design build and share data cubes.

Learning method:

Instructor led.
Participants will work through hands-on practical sessions and exercises in a PC equipped laboratory.

Who will benefit from this course?

Data analysts
DBA’s wishing to extend their skill set
OLAP designers

Pre-requisites:

Familiarity with OLAP databases and data warehousing concepts would be helpful but is not mandatory.

What can you expect to gain from this course?

A thorough understanding of OLAP concepts
Proficiency in designing and building data warehouses
Skills in the use of Business Intelligence enhancements to improve the application of standard cubes

Course Content:

Module 1:AS 2005 overview

Reviewing AS 2005 architecture
Reviewing DW architecture
Reviewing AS 2005 features and services
Exercise/Discussion

Module 2:Introduction to cube design

Why good schema design is important
Creating a database
Defining the difference between ‘data source’ and ‘data view’
Creating a cube
Creating a dimension
Definition of a measure group
Creating a perspective
Process of building and deploying the cube
Viewing a cube through ProClarity
Exercise/Discussion

Module 3:Advanced cube design concepts

Discussion of the value of keys
Creating time dimensions
Creating business intelligence enhancements
Creating actions
Reviewing distinct counts
Creating linked items
Browsing data using ProClarity
Exercise/Discussion

Module 4:Calculations, sets, and KPI's

Creating calculated members
Leveraging sets in your solution
Creating KPIs to add visualisation to your data
Using BLS to maximize the cube usefulness

Module 5:Visualization with ProClarity

Viewing AS 2005 (briefing book and notes provided)
Integrating ProClarity with reporting services
PAS administration
Exercise/Discussion

Module 6:Processing and storage

Discussing and creating processing options
Creating diagram aggregations
Adjusting usage based optimisation
Discussion into storage modes
Evaluating proactive caching (real time)
Set-up write-back
Exercise/Discussion

Module 7:Security

Security architecture
Instance level security
Server role (fixed)
OLAP database administrator
Discussion on security database objects

Module 8:Deployment

Archiving and restoring cube data
Managing development to production environments
Using profiler to monitor query access
Dimension data security
Integrating ProClarity products with AS 2005 security
Exercise/Discussion