1 / 11

Introduction to OLAP cubes

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….

Lucy
Download Presentation

Introduction to OLAP cubes

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

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

More Related