Introduction to OLAP cubes My name ZULFIQAR SYED

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@GMAIL. COM HTTP: //ZULFIQAR. TYPEPAD. COM

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.

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. • Developer (thinking. . ) : Hmm. . What is the best way to do this? ? : =(

Excel Demo

Olap cube basics • • Measures Dimensions Hierarchies Levels

Hierarchical Cube… • Route – Non Ground • Air • sea – Ground • Road • rail

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

More on dimensions… • Dimension Attribute: – Table Column – Example: Product dimension, Prod. Name, Prod. Color, etc. • Members – Actual data value in an attribute. – Example: Prod. Name: 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

Demo. .

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

Name: ZULFIQAR SYED • Recommendations: 1. Delivering Business Intelligence with Microsoft SQL Server 2005 by Brian Larson 2. Fast Track to MDX by Mark Whitehorn, Robert Zare, and Mosha Pasumansky • Please fill out the evaluations forms. • My Contact: – DATAGIG@GMAIL. COM – http: //ZULFIQAR. TYPEPAD. COM