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
- Gabriel Adjei Mensah(last updated: 02/02/2019 13:54)
- William Böll(last updated: 24/01/2019 14:17)
- Ramy Yehia Shaaban(last updated: 20/01/2019 07:59)
- karthikeyan j(last updated: 09/01/2019 03:01)
- Sylvia Luchian(last updated: 08/01/2019 01:17)
- Mohamed AlMahroos(last updated: 03/01/2019 05:37)
- Jack White(last updated: 24/12/2018 08:16)Very Helpful
- Sanish Karki(last updated: 21/12/2018 07:40)
- Olid Sarker(last updated: 18/12/2018 18:36)
- Ya Cheng(last updated: 21/11/2018 10:16)
- lims conference(last updated: 16/11/2018 08:40)
- Dinesh Singh(last updated: 14/11/2018 07:34)
- Hoang P(last updated: 10/11/2018 15:46)
- Taiwo Abioye(last updated: 20/10/2018 19:46)
- 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)
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,623 remove_red_eyefreeby Daisy Deng
Ecommerce Business: Template for Cohort AnalysisEstimate lifetime value for an Ecommerce business using a sample cohort analysis.analysisstartuplifetime valueecommercetemplateexcelsamplefreecohort1,603 remove_red_eyefreeby 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 modelstartupfundraisingsubscriptionecommercetemplateexcelspreadsheetgrowing344 remove_red_eye
Ecommerce Financial Fundraising Excel TemplateThis is the best excel model template you will find on fundraising for your ecommerce startupfinancialmodelfundraisingecommercetemplateexcel965 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,642 remove_red_eye
Ultimate Startup Cap Table and Return Analysis Excel TemplateSample cap table excel template with exclusive waterfall return analysis.analysiswaterfallstartupcap tabletemplateexcelspreadsheetfreedownloadreturn analysis3,059 remove_red_eye$9.00by Alexander Jarvis
Social Media Metrics Excel DashboardAn excel template for employees to understand the performance of social media channels for their organisation.salesmarketingsocial mediametricsdashboardkpitemplateexcelfree4,640 remove_red_eye
Sales Pipeline Conversion Excel Model TemplateSales Pipeline Conversion Model to support assumptions behind long-term forecasts & aid sales team with forecasts.salesconversiontemplateexcelexcel modelsales pipelinesales funnel662 remove_red_eyefreeby Ben Murray
Conjoint Analysis Excel TemplateIdentify product attribute customer preferences, customer's willingness to pay, and product market share.analysistemplateexcelpricemethodsrankingconjoint analysisattributescompositionaldecompositional469 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,783 remove_red_eyefreeby Bob Samii
Discussion feed for Modeling Sales Data For E-commerce Businesses
The user community and author are here to help. Go ahead!