introduction to olap cubes n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Introduction to OLAP cubes PowerPoint Presentation
Download Presentation
Introduction to OLAP cubes

Loading in 2 Seconds...

play fullscreen
1 / 11

Introduction to OLAP cubes - PowerPoint PPT Presentation


  • 336 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Introduction to OLAP cubes' - Lucy


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
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
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
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?? :=(
olap cube basics
Olap cube basics
  • Measures
  • Dimensions
  • Hierarchies
  • Levels
hierarchical cube
Hierarchical Cube…
  • Route
    • Non Ground
      • Air
      • sea
    • Ground
      • Road
      • rail
measures and dimensions
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.
more on dimensions
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
demo recap
Demo. Recap.
  • Browsed dimensions, fact tables.
  • Created a Dimension, hierarchy.
  • Built and browsed a cube.
  • Created cube driven SSRS report.
name zulfiqar syed
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