Last Updated on March 29, 2021 by Editorial Team

Author(s): Juhi Sharma

Data Analysis

E-commerce Data Analysis Using Tableau

K-mart sales strategy for the year 2020 based on the insights from the sales data in 2019.

Introduction

Kmart is a leading online retailer in the US and as part of their annual sales review meeting, they need to decide on their sales strategy for the year 2020 based on the insights from the sales data in 2019.

Data is related to sales for each month of 2019 and the task is to generate key insights which will help the sales team of Kmart to take some key business decisions towards Fine-tuning their sales strategy.

Data Understanding

1.Data Belongs to Kmart -a leading online retailer in the US.

2.Time Period — January 2019 — December 2019

3.Unique Product — 19

4.Total Orders — 178437

5.Cities — 9

6.KPI’s — Total Sales, Total Products Sold

Tableau Worksheets

The best Month for sales in 2019 was DECEMBER. Total sales in December is $ 4619297

31017.0 quantity of AAA Batteries (4-pack) was sold in 2019. It is sold in maximum number because it is the cheapest product

The sale of Mackbook Pro Laptop was Highest.

At Around 7:00 pm Sale is Maximum.

Tableau Dashboard

We can apply a Filter of City, Product, and Time Period on the Dashboard.

Business Suggestions Based on Analysis

1. Company should provide offers and discounts in the months like January and September to increase sales in 2020 as these months have the lowest sales in 2019.

2. Austin, Portland, and Dallas have fewer sales as compared to other cities. The company should look for the reasons behind it to boost up the sales in 2020.

3. Around 12:00 pm and 7:00 pm is the most appropriate time to display advertising to maximize the likelihood of customers buying the product/s.

4.AAA Batteries (4-pack) was sold maximum number in 2019 . Company should take care of inventory of AAA Batteries (4-pack).

5. Company can work on price — strategy as per insights from 2019.

Before You Go

Thanks for reading! If you want to get in touch with me, feel free to reach me at jsc1534@gmail.com or my LinkedIn Profile.

---

E-commerce Sales Strategy Using Tableau was originally published in Towards AI on Medium, where people are continuing the conversation by highlighting and responding to this story.

Published via Towards AI