apex supermarket data warehouse n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Apex Supermarket Data Warehouse PowerPoint Presentation
Download Presentation
Apex Supermarket Data Warehouse

Loading in 2 Seconds...

play fullscreen
1 / 21

Apex Supermarket Data Warehouse - PowerPoint PPT Presentation


  • 169 Views
  • Uploaded on

Apex Supermarket Data Warehouse. Presentation 2: Data Modeling. Presented By: Khalid Nour Muhammad Rizvi Raghuram Vempali Surekha Vemuri. Outline. Background Business Need Fact Table Dimension Tables Star Schema Snowflake Schema Data Dictionary Information Package

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 'Apex Supermarket Data Warehouse' - jaeger


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
apex supermarket data warehouse

Apex Supermarket Data Warehouse

Presentation 2: Data Modeling

Presented By:

Khalid Nour

Muhammad Rizvi

RaghuramVempali

SurekhaVemuri

outline
Outline
  • Background
  • Business Need
  • Fact Table
  • Dimension Tables
  • Star Schema
  • Snowflake Schema
  • Data Dictionary
  • Information Package
  • Table Hierarchies
background
Background
  • Apex Supermarket is a supermarket chain with 4 stores in South Texas, Central Texas, North Texas and East Texas
  • They have stores in:
    • South Texas: Laredo
    • Central Texas: Midland
    • North Texas: Denton
    • East Texas: Houston
business need
Business Need
  • Help executive staff study the sale of products by Categories, Regions, States, Cities, Stores, and Time
  • Executive Staff will be able to figure out sales revenue through the different dimension combinations
  • Give strategic information for the Executive Staff to make decisions on optimizing prices of products
data warehouse fact table
Data Warehouse Fact Table
  • Sales Fact Table
    • Keys
      • OrderID
      • CardID
      • ProductID
      • DateID
      • StoreID
    • Non-Key Columns
      • TotalSales
      • TotalCost
      • Gross Profit
data warehouse dimension tables
Data Warehouse Dimension Tables
  • Order Table
  • Product Table
  • Promotion Card Table
  • Store Table
  • Time Table
data dictionary
Data Dictionary
  • Sales Fact Table
  • Product Category Table
data dictionary cont d
Data Dictionary (Cont’d)
  • Product Table
  • Vendor Table
data dictionary cont d2
Data Dictionary (Cont’d)
  • Promotion Card Table
  • Region Table
data dictionary cont d3
Data Dictionary (Cont’d)
  • Time Table
  • Quarter Table
data dictionary cont d4
Data Dictionary (Cont’d)
  • Day of Week Table
  • Month Table
  • Year Table
order hierarchy
Invoice Number

Date Ordered

Date received

Package cost

Size

Small (1-3 billion turnover)

Medium (4-10 billion turnover)

Large (>11 billion)

Type

Organic Vendor

Traditional Vendor

Category

produce

beverages

staples

spices

canned

baby

condiments

paper

cleaning

personal

Frozen

diary

Order Hierarchy
store hierarchy
Store Hierarchy
  • Store name
  • City
  • State
  • Zip
  • Regions
    • South Texas
    • Central Texas
    • North Texas
    • East Texas

Each store location is in one region

time hierarchy
Date

Day of Week

Quarter

Year

Quarter Values

Quarter I

January

February

March

Quarter II

April

May

June

Quarter III

July

August

September

Quarter IV

October

November

December

Time Hierarchy
slide20

Product Hierarchy

Products

Categories

canned

baby

condiments

paper

cleaning

personal

frozen

diary

Produce

Beverages

Staples

spices

Fruits

Sodas

Cereals

Seasoning

Olives

Diapers

Ketchup

Plates

Bleach

Shampoo

Broccoli

Eggs

Beans

Milk

Veggies

Juices

Bread

Salt/pepper

Beans

Wipes

Mayo

Cups

Detergent

Conditioner

Peas

Water

Grits

Soups

Formula

Salad dressing

Napkins

Dish liquid

lotion

Cheese

Corn

Alcohol

Baby food

Olive oil

bags

Shaving cream

wipes

Potatoes

Baby water

Spinach