Apex supermarket data warehouse
This presentation is the property of its rightful owner.
Sponsored Links
1 / 13

Apex Supermarket Data Warehouse PowerPoint PPT Presentation


  • 65 Views
  • Uploaded on
  • Presentation posted in: General

Apex Supermarket Data Warehouse. Presentation 3: Demonstration and OLAP. Presented By: Khalid Nour Muhammad Rizvi Raghuram Vempali Surekha Vemuri. Outline. Background Business Need Dimensions and Fact Relational Database Cube Implementation BI information. Background.

Download Presentation

Apex Supermarket Data Warehouse

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 3: Demonstration and OLAP

Presented By:

Khalid Nour

Muhammad Rizvi

RaghuramVempali

SurekhaVemuri


Outline

Outline

  • Background

  • Business Need

  • Dimensions and Fact

  • Relational Database

  • Cube Implementation

  • BI information


Background

Background

  • Apex Supermarket is a supermarket chain with 4 stores in Texas

  • They have stores in:

    • North Texas: Denton

    • East Texas: Houston

    • South Texas: Laredo

    • Central Texas: Lufkin


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


Database and tools

Database and Tools

  • Online Transaction Processing (OLTP)

    • Microsoft SQL Server 2008 is used as the RDBMS

  • Online Analytical Processing (OLAP)

    • Microsoft SQL Server 2008 Analysis Services


Dimensions and fact tables

Dimensions and Fact tables

Dimension Tables:

  • Product

  • Store

  • Time

  • PromotionCard

    Fact Table:

  • Sales

    Excel File.


Relational database sql server

Relational Database - SQL Server


Cube implementation sql server

Cube Implementation – SQL Server


Business intelligence information

Business Intelligence Information

  • Gross Profit By Region

  • Gross Profit By Store By Month

  • Total Sales By Category By Store


Gross profit by store

Gross Profit By Store


Gross profit by store by month

Gross Profit By Store By Month


Total sales by product category by store

Total Sales By Product Category By Store


Questions

Questions


  • Login