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.6 / 5 (107 votes)
- 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
- rono solo(last updated: 08/08/2019 11:50)Excellent Model
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,311add_shopping_cartfreeby Daisy Deng
Ecommerce Business: Template for Cohort AnalysisEstimate lifetime value for an Ecommerce business using a sample cohort analysis.analysisstartuplifetime valueecommercetemplate3,107add_shopping_cartfreeby Jeremy Liew
Ecommerce Financial Fundraising Excel TemplateThis is the best excel model template you will find on fundraising for your ecommerce startupfinancialmodelfundraisingecommercetemplate2,425add_shopping_cart$356.00by Alexander Jarvis
Subscription E-Commerce Fundraising Financial ModelCombining an e-commerce product sales model & a subscription model to make one subscription e-commerce fundraising modelplanningfinancial modelstartupfundraisingsubscription1,257add_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.analysissalesaccountingchartsdashboards148add_shopping_cart$299.00by Steve Lindsey
Real Estate Property Cashflow AnalyzerHelps evaluate the characteristics of a property’s cashflow along with some explanations of the derived values.analysisratiosprofitabilitytemplateexcel2,297add_shopping_cartfreeby Michael Rogers
Conjoint Analysis Excel TemplateIdentify product attribute customer preferences, customer's willingness to pay, and product market share.analysistemplateexcelpricemethods2,333add_shopping_cartfreeby Alberto Scappini
Social Media Metrics Excel DashboardAn excel template for employees to understand the performance of social media channels for their organisation.salesmarketingsocial mediametricsdashboard10,024add_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 reportsalesreportmarketingkpismetrics2,943add_shopping_cartfreeby Bob Samii
Ultimate Startup Cap Table and Return Analysis Excel TemplateSample cap table excel template with exclusive waterfall return analysis.analysiswaterfallstartupcap tabletemplate3,762add_shopping_cart$9.00by Alexander Jarvis
Discussion feed for Modeling Sales Data For E-commerce Businesses
The user community and author are here to help. Go ahead!