• 
• 
• 
• 
• 
• 
• 

Send to a friend

• linkedin
• twitter
• facebook
• 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 67

107 reviews6,204 views|4 comments|Bookmark download for free

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 Best Practice includes
1 Excel file, 1 Video

Ashish Mathur offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Reviews

• • 
    4.6 / 5 (107 votes)

    • 73%
    • 21%
    • 3%
    • 1%
    • 2%
  • Rate this Downloadable Tool
    

    Write a review

• Michael owor(last updated: 04/06/2020 14:13)
  
• Imran hossain, CITF, CSCAᵀᴹ(last updated: 03/06/2020 08:46)
  
• darshan vanpariya(last updated: 13/05/2020 06:08)
  
• Ajijola Habeeb(last updated: 05/05/2020 10:19)
  
• Punit Badal(last updated: 18/04/2020 06:39)
  
• Bonno Lebogang Motswaiso(last updated: 10/04/2020 16:14)
  
• Miroslav Laketic(last updated: 24/03/2020 13:33)
  
• Tianchu Zhang(last updated: 21/02/2020 18:46)
  
• MÁRCIO FEIJÓ(last updated: 16/01/2020 17:03)
  
• Amit Das594(last updated: 13/01/2020 09:47)
  
• Joy Con(last updated: 16/12/2019 04:07)
  
• Александр Попов(last updated: 22/11/2019 10:16)
  
• Khady Fall(last updated: 21/11/2019 19:59)
  
• Yosef Yomtov(last updated: 22/10/2019 09:35)
  
• Hammad Hasan(last updated: 18/10/2019 09:02)
  
• Dawn Joseph(last updated: 15/10/2019 12:10)
  
• Hamdy Ghoraba(last updated: 15/10/2019 11:17)
  
• Jookaplee Shaaibon(last updated: 09/10/2019 04:44)
  
• vivek kumar138(last updated: 19/09/2019 12:10)
  
• pradeep kumar791(last updated: 19/09/2019 10:08)
  
• anupam kashyap(last updated: 17/09/2019 13:51)
  
• Hashem Amer(last updated: 16/09/2019 06:00)
  
• Le Van Thuy(last updated: 15/09/2019 14:55)
  
• Velayudham B(last updated: 11/09/2019 18:14)
  
• Bibars(last updated: 11/09/2019 16:54)
  
• ADARSH KUMAR(last updated: 03/09/2019 07:39)
  
• alexa alexa(last updated: 31/08/2019 11:36)
  
• rahul dwivedi122(last updated: 27/08/2019 21:18)
  
• iostar infotech(last updated: 11/08/2019 06:09)
  

  QUERY FOR MR ASHISH

  UNABLE TO FIND THE SALES WORKSHEET IN YOUR EXCEL .PLS ADVISE HOW TO PROCEED
• rono solo(last updated: 08/08/2019 11:50)
  

  Excellent Model

  Very nice

keyboard_arrow_downShow all

People using this Best Practice also downloaded

Post Comment

• 

  ABOLAJI OMITOGUN 2 years ago
  Downloadable Tool Useredit

  how do i download this tool

  arrow_drop_uparrow_drop_downReply reply

  • 

    Manager Timothée Demoures 2 years ago
    Eloquens Member

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

    arrow_drop_uparrow_drop_downReply reply
• 

  Hesan Raj K. Rajandiran 1 year ago
  Eloquens Member

  how do i download this excel

  arrow_drop_uparrow_drop_downReply reply

  • 

    Ashish Mathur 1 year ago
    Downloadable 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