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
- Murthy Pujari(last updated: 08/10/2018 05:58)
- Umer Farooq(last updated: 20/09/2018 16:21)
- Prasann Shah(last updated: 16/09/2018 06:10)
- Jean Picard(last updated: 14/09/2018 23:49)
- Ali Madbouly(last updated: 09/09/2018 17:48)
- Stephen Wachira(last updated: 13/08/2018 09:09)
- Greejesh Prakash(last updated: 10/08/2018 08:32)
- Steave Gaskill(last updated: 29/07/2018 09:33)
- Thuy Tran Thi Bich(last updated: 27/07/2018 07:52)
- Edda Dena(last updated: 24/07/2018 23:11)
- Kenneth Gordon(last updated: 19/07/2018 16:22)
- 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)
People using this tool also downloaded
Cohort Analysis in 3 minutes: an Excel exampleA simple step-by-step explanation of how to do cohort analysis.analysisecommercetemplateexcelspreadsheetexamplecohortexplainedstep1,494 remove_red_eyefreeby Daisy Deng
Ecommerce Business: Template for Cohort AnalysisEstimate lifetime value for an Ecommerce business using a sample cohort analysis.analysisstartuplifetime valueecommercetemplateexcelsamplefreecohort1,583 remove_red_eyefreeby Jeremy Liew
Sales Pipeline Conversion Excel Model TemplateSales Pipeline Conversion Model to support assumptions behind long-term forecasts & aid sales team with forecasts.salesconversiontemplateexcelexcel modelsales pipelinesales funnel462 remove_red_eyefreeby Ben Murray
Subscription E-Commerce Fundraising Financial ModelCombining an e-commerce product sales model & a subscription model to make one subscription e-commerce fundraising modelplanningfinancial modelstartupfundraisingsubscriptionecommercetemplateexcelspreadsheetgrowing146 remove_red_eye$199.00by Alexander Jarvis
Real Estate Property Cashflow AnalyzerHelps evaluate the characteristics of a property’s cashflow along with some explanations of the derived values.analysisratiosprofitabilitytemplateexcelspreadsheetreal statecashflowcashflow analyzer1,765 remove_red_eye
Social Media Metrics Excel DashboardAn excel template for employees to understand the performance of social media channels for their organisation.salesmarketingsocial mediametricsdashboardkpitemplateexcelfree4,243 remove_red_eye
Ultimate Startup Cap Table and Return Analysis Excel TemplateSample cap table excel template with exclusive waterfall return analysis.analysiswaterfallstartupcap tabletemplateexcelspreadsheetfreedownloadreturn analysis3,378 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 analysisattributescompositionaldecompositional263 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,697 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 lesson395 remove_red_eye
Discussion feed for Modeling Sales Data For E-commerce Businesses
The user community and author are here to help. Go ahead!