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 business tool includes
1 Excel file, 1 Video
Ashish Mathur offers you this business tool for free!
download for free
Add to bookmarks
- Bilal Nakade(last updated: 13/07/2018 19:49)
- Yan Naung Lynn(last updated: 11/07/2018 03:51)
- Jai Rathore(last updated: 27/06/2018 17:58)
- Banjit Das(last updated: 22/06/2018 05:22)
- Andres Felipe Yepes(last updated: 14/06/2018 06:41)
- Liang Zhu24(last updated: 07/06/2018 13:33)
- Keo Morokort(last updated: 06/06/2018 08:42)
- Steven Crowthers(last updated: 05/06/2018 14:06)
- Ng Aaron(last updated: 04/06/2018 06:51)
- Shafan Hassan(last updated: 30/05/2018 19:13)
- Victor Nick(last updated: 26/05/2018 05:45)
- Cong Son Trinh, ACCA(last updated: 22/05/2018 15:03)
- Vivek Bafleh(last updated: 16/05/2018 07:05)
- Arya Abedinzadeh(last updated: 16/05/2018 06:26)
- Aliasgar Moaiyadi I CFA I CPA(last updated: 13/05/2018 04:52)
- Quyen Phan, ACCA(last updated: 11/05/2018 13:42)
- leela fashion(last updated: 08/05/2018 13:37)
- Satisha J B(last updated: 27/04/2018 08:53)
- Dev Singh(last updated: 27/04/2018 02:56)
- Lu(last updated: 26/04/2018 15:34)
- Darwin Lorina(last updated: 26/04/2018 03:58)
- Yuhisern Navaratnam(last updated: 23/04/2018 20:57)
- SUROJIT DAS(last updated: 22/04/2018 07:06)
- William Böll496(last updated: 13/04/2018 13:32)
- Liang Zhu(last updated: 10/04/2018 14:39)
- Shady Saleh, Corporate Business(last updated: 02/04/2018 03:23)Thanks Asish, great job.
- mack maine(last updated: 05/03/2018 22:54)
- Inam Ur Rahim(last updated: 23/01/2018 02:11)
- Faiz Amer Abdat(last updated: 04/12/2017 08:00)
- S Mash(last updated: 09/08/2017 13:04)
People using this tool also downloaded
Ecommerce Business: Template for Cohort AnalysisEstimate lifetime value for an Ecommerce business using a sample cohort analysis.analysisstartuplifetime valueecommercetemplateexcelsamplefreecohort1,226 remove_red_eyefreeby Jeremy Liew
Cohort Analysis in 3 minutes: an Excel exampleA simple step-by-step explanation of how to do cohort analysis.analysisecommercetemplateexcelspreadsheetexamplecohortexplainedstep1,193 remove_red_eyefreeby Daisy Deng
Sales Pipeline Conversion Excel Model TemplateSales Pipeline Conversion Model to support assumptions behind long-term forecasts & aid sales team with forecasts.salesconversiontemplateexcelexcel modelsales pipelinesales funnel193 remove_red_eyefreeby Ben Murray
Social Media Metrics Excel DashboardAn excel template for employees to understand the performance of social media channels for their organisation.salesmarketingsocial mediametricsdashboardkpitemplateexcelfree3,322 remove_red_eye
Real Estate Property Cashflow AnalyzerHelps evaluate the characteristics of a property’s cashflow along with some explanations of the derived values.analysisratiosprofitabilitytemplateexcelspreadsheetreal statecashflowcashflow analyzer1,520 remove_red_eye
Ultimate Startup Cap Table and Return Analysis Excel TemplateSample cap table excel template with exclusive waterfall return analysis.analysiswaterfallstartupcap tabletemplateexcelspreadsheetfreedownloadreturn analysis3,079 remove_red_eye$9.00by Alexander Jarvis
Conjoint Analysis Excel TemplateIdentify product attribute customer preferences, customer's willingness to pay, and product market share.analysistemplateexcelpricemethodsrankingconjoint analysisattributescompositionaldecompositional93 remove_red_eye
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 reportsalesreportmarketingkpismetricstemplateexcelreal statesampledownload1,316 remove_red_eyefreeby Bob Samii
Discounted Cash Flow (DCF) Model Template + InstructionsLearn how to build a simple DCF Model aligned with Investment Banking best practices.valuationdcfdiscounted cash flowtemplateexcelvideohow todcf modellessonquick lesson204 remove_red_eye
Ecommerce Financial Fundraising Excel templateThis is the best excel model template you will find on fundraising for your ecommerce startupfinancialmodelfundraisingecommercetemplateexcel516 remove_red_eye$189.00by Alexander Jarvis
Discussion feed for Modeling Sales Data For E-commerce Businesses
The user community and author are here to help. Go ahead!