
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.
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
Reviews
4.7 / 5 (121 votes)- 74%
- 21%
- 2%
- 1%
- 2%
- Rate this Downloadable Best Practice
Write a review
Suppamit Yuvatana(last updated: 14/12/2020 04:21)
Ragavan T(last updated: 11/12/2020 09:44)
Christine Salazar(last updated: 08/12/2020 23:25)
Vasile Popovici the Excel guru(last updated: 01/12/2020 19:51)
Roelof Delport(last updated: 26/11/2020 13:04)
Riaz Mahmud(last updated: 26/09/2020 07:00)
Abhimanyu Jayakanth(last updated: 26/09/2020 06:25)
Rosario Ragusa(last updated: 17/09/2020 21:17)
Kaan Senol(last updated: 24/08/2020 13:23)
Carlos De Azevedo(last updated: 15/08/2020 17:10)
Mohammad Sabir(last updated: 07/08/2020 05:40)
Nathalia C. Bruzual R.(last updated: 03/08/2020 15:27)
Jose Castillo Duarte(last updated: 27/07/2020 02:03)
Talib Hussain Raja(last updated: 12/06/2020 21:43)
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)
People using this Best Practice also downloaded
Cohort Analysis in 3 minutes: an Excel example
A simple step-by-step explanation of how to do cohort analysis.analysisecommercetemplateexcelspreadsheet2,589Discussadd_shopping_cartfreeby Daisy Deng
Ecommerce Business: Template for Cohort Analysis
Estimate lifetime value for an Ecommerce business using a sample cohort analysis.analysisstartuplifetime valueecommercetemplate3,4101add_shopping_cartfreeby Jeremy Liew
Subscription E-Commerce Fundraising Financial Model
Combining an e-commerce product sales model & a subscription model to make one subscription e-commerce fundraising modelplanningfinancial modelstartupfundraisingsubscription1,8411add_shopping_cart$369.00by Alexander Jarvis
Ultimate Spreadsheet, Dashboard, and Chart Template Super Pack for the Restaurant and Hospitality Industry
Super Pack of Excel Templates for the Hotel and Restaurant Industry.analysissalesaccountingchartsdashboards3551add_shopping_cart$299.00by Steve Lindsey
Ecommerce Financial Fundraising Excel Template
This is the best excel model template you will find on fundraising for your ecommerce startupfinancialmodelfundraisingecommercetemplate3,061Discussadd_shopping_cart$356.00by Alexander Jarvis
Conjoint Analysis Excel Template
Identify product attribute customer preferences, customer's willingness to pay, and product market share.analysistemplateexcelpricemethods2,876Discussadd_shopping_cartfreeby Alberto Scappini
Real Estate Property Cashflow Analyzer
Helps evaluate the characteristics of a property’s cashflow along with some explanations of the derived values.analysisratiosprofitabilitytemplateexcel2,390Discussadd_shopping_cartfreeby Michael Rogers
Social Media Metrics Excel Dashboard
An excel template for employees to understand the performance of social media channels for their organisation.salesmarketingsocial mediametricsdashboard12,455Discussadd_shopping_cartfreeby Joakim Nilsson
How to Create a Real Estate Marketing Report with Sample Template
Measure the following 8 metrics to track the success of your marketing performance and learn to build a marketing reportsalesreportmarketingkpismetrics3,293Discussadd_shopping_cartfreeby Bob Samii
Sales Pipeline Conversion Excel Model Template
Sales Pipeline Conversion Model to support assumptions behind long-term forecasts & aid sales team with forecasts.salesconversiontemplateexcelexcel model3,088Discussadd_shopping_cartfreeby Ben Murray
Related categories
Discussion feed for Modeling Sales Data For E-commerce Businesses
The user community and author are here to help. Go ahead!
- Hi Abolaji! We have sent you a private message, please check your Eloquens inbox!
- how do i download this excel
- 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!
User