Giter Club home page Giter Club logo

big-mart-sales-retail-tableau-powerbi's Introduction

Big-Mart-Sales-Retail

Category:

  • Retail

  • Supermarket

Overview:

The data scientists at Big Mart have collected 2013 sales data for 1559 products across 10 stores in different cities. Also, certain attributes of each product and store have been defined. The aim is to build a predictive model and predict the sales of each product at a particular outlet.

Using this model, Big Mart will try to understand the properties of products and outlets which play a key role in increasing sales.

Please note that the data may have missing values as some stores might not report all the data due to technical glitches. Hence, it will be required to treat them accordingly.

Target:

Visualizing multiple charts of all significant fields from the train set to analyze and report insights of how Outlet Sales is driven by store & product’s attributes at a retail store and on which variables should be focused further

Dataset:

Train and Test sets: https://www.kaggle.com/akashdeepkuila/big-mart-sales?select=Train-Set.csv

Variable Description

ProductID : unique product ID

Weight : weight of products

FatContent : specifies whether the product is low on fat or not

Visibility : percentage of total display area of all products in a store allocated to the particular product

ProductType : the category to which the product belongs

MRP : Maximum Retail Price (listed price) of the products

OutletID : unique store ID

EstablishmentYear : year of establishment of the outlets

OutletSize : the size of the store in terms of ground area covered

LocationType : the type of city in which the store is located

OutletType : specifies whether the outlet is just a grocery store or some sort of supermarket

OutletSales : (target variable) sales of the product in the particular store

Tool:

  • Tableau

  • Power BI

Visualization in Tableau:

Establishment Year vs Sum Outlet Sales

Establishment Year vs Sum Outlet Sales

Establishment Year vs Sum Outlet Sales

The first Establishment Year experience the highest ever-recorded Total Sum of Outlet Sales at over 3.6 million. Other Establishment Years fluctuated around the Average Total Sum of Outlet Sales at 2,065,861. Only the 1998 saw the lowest Total Sales at 188,340. There might be a significant crisis among the Big Mart or an external factor in this year.

Outlet Size vs Sum Outlet Sales

Outlet Size vs Sum Outlet Sales

Outlet Size vs Sum Outlet Sales

Medidum-sized Outlets contributed slightly more than half the Total Sum of Outlet Sales. Low and High-sized outlets gained moderately at 32.16% and 15.09%, respectively. This medium size can be aimed to expand other Big Mart's properties. Other sizes can be maintained or expanded at a low extent to guarantee the market domination.

Product Type vs Average Product Visibility

Product Type vs Average Product Visibility

Product Type vs Average Product Visibility

(Analysis to be continued)

Fat Content vs Average Product Visibility

Fat Content vs Average Product Visibility

Fat Content vs Average Product Visibility

As the 5 groups are duplicated and can be categorized into 2 groups: Regular and Low Fat. I will select the relevant Fate Content and group them together as below.

Fat Content's 2 groups vs Average Product Visibility (revised)

Fat Content vs Average Product Visibility

Sum Outlet Sales by Estb Year, Outlet ID, Product Type

Sum Outlet Sales by Estb Year, Outlet ID, Product Type

Sum Outlet Sales by Estb Year, Outlet ID, Product Type

Sum Outlet Sales by Estb Year, Outlet ID, Product Type (2)

Sum Outlet Sales by Estb Year, Outlet ID, Product Type (2)

Sum Outlet Sales by Estb Year, Outlet ID, Product Type (2)

Sum Outlet Sales by Estb Year, Outlet ID, Product Type (3)

Sum Outlet Sales by Estb Year, Outlet ID, Product Type (3)

Sum Outlet Sales by Estb Year, Outlet ID, Product Type (3)

Sum Outlet Sales by Estb Year, Outlet ID, Product Type (4)

Sum Outlet Sales by Estb Year, Outlet ID, Product Type (4)

Sum Outlet Sales by Estb Year, Outlet ID, Product Type (4)

Product Type by Average Maximum Retail Price

Product Type by Average Maximum Retail Price

Product Type by Average Maximum Retail Price

Outlet Type by Average MRP

Outlet Type by Average MRP

Outlet Type by Average MRP

Outlet Type by Average MRP (selected healthy products)

Outlet Type by Average MRP (selected healthy products)

Outlet Type by Average MRP (selected healthy products)

Outlet Type by Average MRP (selected non-healthy products)

Outlet Type by Average MRP (selected non-healthy products)

Outlet Type by Average MRP (selected non-healthy products)

Product Type by Average Weight

Product Type by Average Weight

Product Type by Average Weight

Location Type / Outlet Size by Sum Outlet Sales

Location Type - Outlet Size by Sum Outlet Sales

Location Type - Outlet Size by Sum Outlet Sales

Dashboard - Outlet Type

Dashboard - Outlet Type

Dashboard - Total Outlet Sales

Dashboard - Total Outlet Sales

Dashboard - Outlet Type by Average MRP (healthy vs non-healthy)

Dashboard - Outlet Type by Average MRP (healthy vs non-healthy)

Dashboard - Product Type

Dashboard - Product Type

big-mart-sales-retail-tableau-powerbi's People

Contributors

daiphuongngo avatar

Stargazers

 avatar

Watchers

 avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.