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.
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.
(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
4.7 / 5 (124 votes)
- Rate this Downloadable Best Practice
Write a review
- Iyanu Akinladenu(last updated: 05/04/2021 21:46)
- Shamila shamila(last updated: 06/03/2021 02:35)
- Erica Son(last updated: 30/01/2021 05:56)
- 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)
People using this Best Practice also downloaded
Cohort Analysis in 3 minutes: an Excel exampleA simple step-by-step explanation of how to do cohort analysis.analysisecommercetemplateexcelspreadsheet2,682add_shopping_cartfreeby Daisy Deng
Ecommerce Business: Template for Cohort AnalysisEstimate lifetime value for an Ecommerce business using a sample cohort analysis.analysisstartuplifetime valueecommercetemplate3,530add_shopping_cartfreeby Jeremy Liew
Subscription E-Commerce Fundraising Financial ModelCombining an e-commerce product sales model & a subscription model to make one subscription e-commerce fundraising modelplanningfinancial modelstartupfundraisingsubscription2,016add_shopping_cart$369.00by Alexander Jarvis
Ultimate Spreadsheet, Dashboard, and Chart Template Super Pack for the Restaurant and Hospitality IndustrySuper Pack of Excel Templates for the Hotel and Restaurant Industry.analysissalesaccountingchartsdashboards480add_shopping_cart$299.00by Steve Lindsey
Ecommerce Financial Fundraising Excel TemplateThis is the best excel model template you will find on fundraising for your ecommerce startupfinancialmodelfundraisingecommercetemplate3,256add_shopping_cart$356.00by Alexander Jarvis
Conjoint Analysis Excel TemplateIdentify product attribute customer preferences, customer's willingness to pay, and product market share.analysistemplateexcelpricemethods3,101add_shopping_cart$3.00by Alberto Scappini
Real Estate Property Cashflow AnalyzerHelps evaluate the characteristics of a property’s cashflow along with some explanations of the derived values.analysisratiosprofitabilitytemplateexcel2,423add_shopping_cartfreeby Michael Rogers
Social Media Metrics Excel DashboardAn excel template for employees to understand the performance of social media channels for their organisation.salesmarketingsocial mediametricsdashboard13,275add_shopping_cartfreeby Joakim Nilsson
How to Create a Real Estate Marketing Report with Sample TemplateMeasure the following 8 metrics to track the success of your marketing performance and learn to build a marketing reportsalesreportmarketingkpismetrics3,383add_shopping_cartfreeby Bob Samii
Sales Pipeline Conversion Excel Model TemplateSales Pipeline Conversion Model to support assumptions behind long-term forecasts & aid sales team with forecasts.salesconversiontemplateexcelexcel model3,402add_shopping_cartfreeby Ben Murray
Discussion feed for Modeling Sales Data For E-commerce Businesses
The user community and author are here to help. Go ahead!