OLAP example

Views:
 
Category: Education
     
 

Presentation Description

No description available.

Comments

By: gulday (41 month(s) ago)

hi this is a very gud exaple on olap can u please mail me this ppton jockeysam0001212@gmail.com

By: IssacMiracle (42 month(s) ago)

This is a good OLAP example.

By: s.hamzezadeh (33 month(s) ago)

pleae mail me this examle :s.hamzezade@gmail.com

 

Presentation Transcript

Slide1: 

Example: Olap Usage of an Automobile Marketer

Slide2: 

Example: The Multidimensional Database Used Sales Volumes Blue Red White Van Coupe Sedan Miller Clyde Smith COLOR DEALERSHIP MOD E L

Slide3: 

OLAP Features: “Dicing“ - Ranging of Data Sales Volumes Blue Red White Van Coupe Sedan Miller Clyde Smith COLOR DEALERSHIP MOD E L Color: Blue and White Model: Coupe only Dealership: Clyde only Choosing a range out of each dimension:

Slide4: 

OLAP Features: “Slicing“ - Rotation of Data Sales Volumes Blue Red White Van Coupe Sedan COLOR MOD E L Different Users will require different views (cross tables or “slices“) of the multidimensional cube – OLAP allows easy rotation of data

Slide5: 

OLAP Features: Drill-Down and Roll-Up Data can be disaggregated and aggregated along a dimension according to their natural hierarchy Drill-Down Roll-Up State Region Dealership Miller Smith Clyde Lucas Gleason Atlanta Athens Georgia Sales Volumes by Organization Dimension - three level hierarchy -