top of page
DALL·E 2024-06-20 17.07.55 - A detailed, horizontally wide image of a modern data warehous

Data Warehousing:
Store Analysis

Kimball Data Warehousing

Kimball data warehousing is a methodology developed by Ralph Kimball that focuses on the dimensional modeling approach for designing data warehouses. This approach aims to make data easily accessible and understandable for end users, particularly for business intelligence and reporting purposes.

Business Problem

The company I work for manufactures and sells products to make money. My company has asked me to help them analyze their sales history for Stores 5 & 8 and make recommendations to improve the company's sales profit. These are the following questions I want to answer:

​

  1. An overall assessment of Stores number 5 and 8’s sales.

    • How are they performing compared to target? Will they meet their 2014 target?

    • Should either store be closed? Why or why not?

    • What should be done in the next year to maximize store profits?

  2. Recommend separate 2013 and 2014 bonus amounts for each store if the total bonus pool for 2013 is $500,000 and the total bonus pool for 2014 is $400,000. Base your recommendation on how well the stores are selling Product Types of Men’s Casual and Women’s Casual.

  3. Assess product sales by day of the week at Stores 5 and 8. What can we learn about sales trends?

  4. Compare the performance of all stores located in states that have more than one store to all stores that are the only store in the state. What can we learn about having more than one store in a state?

My Approach

Steps followed:

  1. Determined Business Requirements

  2. Identified the Grain

  3. Identified the Dimensions

  4. Identified the Facts

  5. Created a snowflake schema

  6. Created  and loaded Staging Tables

  7. Designed and loaded the Dimension Tables

  8. Designed and loaded the Fact Tables

  9. Created Views based on business problem

  10. Used live connections to connect the views to Tableau

  11. Created visualizations to answer the business questions

​

Visualizations: link

GitHub: link

Snowflake Schema

image_edited.jpg

Part 1 Analysis

image_edited_edited.jpg

Part 2 Analysis

image_edited.jpg

Part 3 Analysis

image_edited.jpg

Part 4 Analysis

image_edited.jpg
bottom of page