Skip to content

Kishp92/Supermarket-Sales-Optimization

Repository files navigation

Supermarket-Store-Optimization

ABSTRACT

Exploratory analysis to discover and investigate manipulable factors to optimize sales of a supermarket brand using 2019 sales data collected from one thousand customers over three branches.

Purpose

From 2010- 2016, I managed seven restaurants which assisted in growing my business analytical skills and interpersonal communication skills. While most of the stores were meeting typical sales expectations, there was definitely room for improvement. Through sales analysis, I was able to investigate what the issues were and work towards increasing profit margins by adjusting key features and marketing. From my experience in business management, I hope to help this supermarket brand achieve its optimal growth by finding adjustable variables and suggesting improvements.

Data

Analysis and Dashboards

Presentation/Full Analysis

Dash 1: Spend Location and Payment Type

Dash 2: Gender and Member Status Distribution

Dash 3: Brand Spending by Product Line and Tax

Dash 4: Brand Spending by Product Line and Tax

Dash 5: Product Line: Ratings, Gender, Member Status Influences

Dash 6: Cost of Goods and Gross Income

Dash 7: Spending by Day of the Week

Dash 8: Spending by Store Hours

Summary

Key Take Aways

About

Exploratory analysis to discover and investigate manipulable factors to optimize sales of a supermarket brand using 2019 sales data collected from one thousand customers over three branches.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors