• 
• 
• 
• 
• 
• 
• 

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 EnthusiastsFollow 48

70 reviews3,949 views|4 comments|Bookmark

analysissalesecommercee-commercetemplateexceldatasetvideoaccess

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

• anand srikantaiah(last updated: 18/06/2019 03:55)
  
• Abida Noor(last updated: 04/06/2019 20:16)
  
• Jason Vu(last updated: 04/06/2019 10:06)
  
• Udaya M(last updated: 20/05/2019 21:08)
  
• Budi Santoso(last updated: 20/05/2019 10:35)
  
• Icee(last updated: 14/05/2019 13:48)
  
• Arthi M S(last updated: 10/05/2019 09:39)
  
• RUBENS COSTA(last updated: 05/05/2019 21:04)
  
• Thùy Phạm(last updated: 27/04/2019 07:06)
  
• Hani Elsallami(last updated: 24/04/2019 16:21)
  
• Samiran Kha(last updated: 08/04/2019 18:12)
  
• Bassam Abdulghani(last updated: 07/04/2019 20:16)
  
• Alok Kumar280(last updated: 31/03/2019 09:24)
  
• Amir Ganic(last updated: 28/02/2019 15:50)
  
• Rafi Jatto(last updated: 17/02/2019 10:42)
  
• Gabriel Adjei Mensah(last updated: 02/02/2019 13:54)
  
• William Böll(last updated: 24/01/2019 14:17)
  
• Ramy Yehia Shaaban(last updated: 20/01/2019 07:59)
  
• karthikeyan j(last updated: 09/01/2019 03:01)
  
• Sylvia Luchian(last updated: 08/01/2019 01:17)
  
• Mohamed AlMahroos(last updated: 03/01/2019 05:37)
  
• Jack White(last updated: 24/12/2018 08:16)
  

  Very Helpful

  Thank you for such a nice work. May you stay blessed always.
• Sanish Karki(last updated: 21/12/2018 07:40)
  
• Olid Sarker(last updated: 18/12/2018 18:36)
  
• Ya Cheng(last updated: 21/11/2018 10:16)
  
• lims conference(last updated: 16/11/2018 08:40)
  
• Dinesh Singh(last updated: 14/11/2018 07:34)
  
• Hoang P(last updated: 10/11/2018 15:46)
  
• Taiwo Abioye(last updated: 20/10/2018 19:46)
  
• Murthy Pujari(last updated: 08/10/2018 05:58)
  

People using this tool also downloaded

Post Comment

• 

  ABOLAJI OMITOGUN 1 year ago
  Tool Useredit

  how do i download this tool

  arrow_drop_uparrow_drop_downReply reply

  • 

    Eloquens Team 1 year ago
    Eloquens Authorschool

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

    arrow_drop_uparrow_drop_downReply reply
• 

  Hesan Raj K. Rajandiran 6 months ago
  Eloquens Member

  how do i download this excel

  arrow_drop_uparrow_drop_downReply reply

  • 

    Ashish Mathur 6 months ago
    Tool Authorstar

    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