Data Warehouse Concepts - Data Warehouse Systems: Design and Implementation - page 60

l m

Köln

Köln

Berlin

Berlin

Lyon

Lyon

Paris

Paris

Q1

Q1

Q2

Q2

Q3

Q3

Q4

Q4

Produce Seafood

Produce Seafood

Beverages Condiments Beverages Condiments

Product (Category) Product (Category)

n o

Köln Köln

Berlin Berlin

Lyon Lyon

Paris Paris

Q1

Q1

Q2

Q2

Q3

Q3

Q4

Q4

Produce Seafood

Produce Seafood

Beverages Condiments Beverages Condiments

Product (Category) Product (Category)

p

Köln

Berlin

Lyon

Paris

Q1

Q2

Q3

Q4

Produce Seafood

Beverages Condiments

Product (Category)

Fig. 3.4 (continued) ( l ) Maximum sales by quarter and city. ( m ) Top two sales by
quarter and city. ( n ) Top 70% by city and category ordered by ascending quarter.
( o ) Top 70% by city and category ordered by descending quantity. ( p )Rankquarter
by category and city ordered by descending quantity