Modeling Sales Data for E-commerce businesses
  • Modeling Sales Data for E-commerce businesses
  • Modeling Sales Data for E-commerce businesses
  • Modeling Sales Data for E-commerce businesses
  • Modeling Sales Data for E-commerce businesses
  • Modeling Sales Data for E-commerce businesses
  • Modeling Sales Data for E-commerce businesses
  • Modeling Sales Data for E-commerce businesses
Originally published: 25/01/2017 17:04
Last version published: 31/01/2017 14:22
Publication number: ELQ-27655-2
View all versions & Certificate
certified

Modeling Sales Data for E-commerce businesses

Using MS Excel's Business Intelligence features to analyse sales data.

Description
Given a sales data worksheet of a E-commerce company, we try to analyse and visualize the given data from different perspectives based on what the user selects.

The workbook is given for 3 months, and has columns headed with the data about:

1. Dates/Time of orders
2.Cities to where the orders are shipped.
3. Number of Orders
4. Type of payment: cash, Net banking or EMIs
5. Status of the orders- Delivered? Cancelled?
6. SKU's that the ordered items fall into.
7. The products in which the SKU's fall into.
8. Categories of the products.

So if you ask yourself: "what was the revenue earned for the top 5 products in the A100 category in April for orders shipping to New Delhi?"

The content will answer it: the following video goes along with the workbook to answer such type of questions. The video also includes how I made figures for the revenue flow from categories to shipping cities during different periods of the orders using custom visuals.

- Ashishmathur.com

(More information on this topic here : http://www.ashishmathur.com/sales-data-modelling-and-interactive-visualisations-of-an-e-commerce-company/)

This business tool includes
1 Excel file, 1 Video

Ashish Mathur offers you this business tool for free!

download for free

Add to bookmarks

Discuss

Reviews


keyboard_arrow_leftkeyboard_arrow_right

Discussion feed for Modeling Sales Data For E-commerce Businesses

The user community and author are here to help. Go ahead!

  • ABOLAJI OMITOGUN
    how do i download this tool
    arrow_drop_uparrow_drop_downReply reply
    • Eloquens Team
      Hi Abolaji! We have sent you a private message, please check your Eloquens inbox!
      arrow_drop_uparrow_drop_downReply reply
    • Hesan Raj K. Rajandiran
      how do i download this excel
      arrow_drop_uparrow_drop_downReply reply
      • Ashish Mathur
        Hi Hesan, simply click on "Download for Free" on this page, the go to your "Library", click on the blue title and then on the big blue "Download Button". Hope this helps!
        arrow_drop_uparrow_drop_downReply reply
      please wait...