• 
• 
• 
• 
• 
• 
• 

Send to a friend

• linkedin
• twitter
• facebook
• google+
• code

Originally published: 25/01/2017 17:04
Last version published: 31/01/2017 14:22
Publication number: ELQ-27655-2
View all versions & Certificate

Modeling Sales Data for E-commerce businesses

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

by Ashish Mathur
Founder, Excel Enthusiasts

41 reviews3,070 views|2 comments|Bookmark

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

• Murthy Pujari(last updated: 08/10/2018 05:58)
  
• Umer Farooq(last updated: 20/09/2018 16:21)
  
• Prasann Shah(last updated: 16/09/2018 06:10)
  
• Jean Picard(last updated: 14/09/2018 23:49)
  
• Ali Madbouly(last updated: 09/09/2018 17:48)
  
• Stephen Wachira(last updated: 13/08/2018 09:09)
  
• Greejesh Prakash(last updated: 10/08/2018 08:32)
  
• Steave Gaskill(last updated: 29/07/2018 09:33)
  
• Thuy Tran Thi Bich(last updated: 27/07/2018 07:52)
  
• Edda Dena(last updated: 24/07/2018 23:11)
  
• Kenneth Gordon(last updated: 19/07/2018 16:22)
  
• Bilal Nakade(last updated: 13/07/2018 19:49)
  
• Yan Naung Lynn(last updated: 11/07/2018 03:51)
  
• Jai Rathore(last updated: 27/06/2018 17:58)
  
• Banjit Das(last updated: 22/06/2018 05:22)
  
• Andres Felipe Yepes(last updated: 14/06/2018 06:41)
  
• Liang Zhu24(last updated: 07/06/2018 13:33)
  
• Keo Morokort(last updated: 06/06/2018 08:42)
  
• Steven Crowthers(last updated: 05/06/2018 14:06)
  
• Ng Aaron(last updated: 04/06/2018 06:51)
  
• Shafan Hassan(last updated: 30/05/2018 19:13)
  
• Victor Nick(last updated: 26/05/2018 05:45)
  
• Cong Son Trinh, ACCA(last updated: 22/05/2018 15:03)
  
• Vivek Bafleh(last updated: 16/05/2018 07:05)
  
• Arya Abedinzadeh(last updated: 16/05/2018 06:26)
  
• Aliasgar Moaiyadi I CFA I CPA(last updated: 13/05/2018 04:52)
  
• Quyen Phan, ACCA(last updated: 11/05/2018 13:42)
  
• leela fashion(last updated: 08/05/2018 13:37)
  
• Satisha J B(last updated: 27/04/2018 08:53)
  
• Dev Singh(last updated: 27/04/2018 02:56)
  

People using this tool also downloaded

Post Comment

• 

  ABOLAJI OMITOGUN 5 months ago
  Tool Useredit

  how do i download this tool

  arrow_drop_uparrow_drop_downReply reply

  • 

    Eloquens Team 5 months ago
    Eloquens Authorschool

    Hi Abolaji! We have sent you a private message, please check your Eloquens inbox!

    arrow_drop_uparrow_drop_downReply reply