Introduction to OLAP cubes

1
Introduction to OLAP cubes

• My name ZULFIQAR SYED
• Holds BSEE from Illinois Institute of Technology,
  Chicago, ILLINOIS.
• MCP in ASP.net (C)
• SQL SERVER, ASP.NET, C, DATA MINING, ANALYSIS
  SERVICES.
• CONTACT
• DATAGIG_at_GMAIL.COM
• HTTP//ZULFIQAR.TYPEPAD.COM

2
In this session we will cover

• OLAP cubes basics
• Why do we need olap cubes??
• Measures, Dimensions, Hierarchies
• Demo..
• Define measures, dimensions etc.
• Development environment
• Report based on olap cube.

3
Meeting with the CEO

• CEO Developer, How much money we made last year?
• Developer 1 billion dollars Sir !
• CEO
• How much did we make per year per quarter?
• Which products did well and which failed?
• What are the sales by region, country, by year,
  by quarter etc. etc. etc.
• Developer (thinking..) Hmm.. What is the best
  way to do this?? (

4
Excel Demo
5
Olap cube basics

• Measures
• Dimensions
• Hierarchies
• Levels

6
Hierarchical Cube

• Route
• Non Ground
• Air
• sea
• Ground
• Road
• rail

7
Measures and Dimensions..

• Measures
• Look at Sales by Customers (Numerical)
• Stored in fact tables (physical tables).
• Examples Sales amount, Shipping amount etc.
• Dimensions
• Look at Sales by Customers
• Stored in relational tables called dimensional
  tables.
• Example Product, Time, Geography, etc.
• Contains Attributes, Hierarchies, and Members.

8
More on dimensions

• Dimension Attribute
• Table Column
• Example Product dimension, ProdName, ProdColor,
  etc.
• Members
• Actual data value in an attribute.
• Example ProdName Bike, Shirt, Bike Stand,
  Helmet etc.
• Hierarchies
• Formed by Attributes.
• Contain single or multi LEVELS. Example Color is
  single level and Time (Year, Quarter, Month) are
  multi level

9
Demo..
10
Demo. Recap.

• Browsed dimensions, fact tables.
• Created a Dimension, hierarchy.
• Built and browsed a cube.
• Created cube driven SSRS report.

11
Name ZULFIQAR SYED

• Recommendations
• Delivering Business Intelligence with Microsoft
  SQL Server 2005 by Brian Larson
• Fast Track to MDX by Mark Whitehorn, Robert Zare,
  and Mosha Pasumansky
• Please fill out the evaluations forms.
• My Contact
• DATAGIG_at_GMAIL.COM
• http//ZULFIQAR.TYPEPAD.COM