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.

accessanalysisdatasete-commerceecommerceexcelsalestemplatevideo

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
    please wait...