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
- 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
- MyStyle Label(last updated: 05/08/2019 12:46)
- Larry Impollonia(last updated: 28/07/2019 18:21)
- BEng Tuks(last updated: 24/07/2019 09:40)
- Ruk Cavo(last updated: 21/07/2019 05:20)
- Devvrat Bharti(last updated: 15/07/2019 03:40)
- Yong JauDih(last updated: 24/06/2019 15:33)
- Hassan Bouchtoune(last updated: 21/06/2019 15:09)
- anand srikantaiah(last updated: 18/06/2019 03:55)
- Abida Noor(last updated: 04/06/2019 20:16)
- Jason Vu(last updated: 04/06/2019 10:06)
- Udaya M(last updated: 20/05/2019 21:08)
- Budi Santoso(last updated: 20/05/2019 10:35)
- Icee(last updated: 14/05/2019 13:48)
- Arthi M S(last updated: 10/05/2019 09:39)
- RUBENS COSTA(last updated: 05/05/2019 21:04)
- Thùy Phạm(last updated: 27/04/2019 07:06)
- Hani Elsallami(last updated: 24/04/2019 16:21)
- Samiran Kha(last updated: 08/04/2019 18:12)
- Bassam Abdulghani(last updated: 07/04/2019 20:16)
- Alok Kumar280(last updated: 31/03/2019 09:24)
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.analysisecommercetemplateexcelspreadsheet1,976free by Daisy Deng
Ecommerce Business: Template for Cohort AnalysisEstimate lifetime value for an Ecommerce business using a sample cohort analysis.analysisstartuplifetime valueecommercetemplate2,424free by 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 modelstartupfundraisingsubscription628$369.00 by Alexander Jarvis
Ecommerce Financial Fundraising Excel TemplateThis is the best excel model template you will find on fundraising for your ecommerce startupfinancialmodelfundraisingecommercetemplate1,476$356.00 by Alexander Jarvis
Real Estate Property Cashflow AnalyzerHelps evaluate the characteristics of a property’s cashflow along with some explanations of the derived values.analysisratiosprofitabilitytemplateexcel2,064free by Michael Rogers
Social Media Metrics Excel DashboardAn excel template for employees to understand the performance of social media channels for their organisation.salesmarketingsocial mediametricsdashboard7,216free by 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,386free by Bob Samii
Discounted Cash Flow (DCF) Model Template + InstructionsLearn how to build a simple DCF Model aligned with Investment Banking best practices.valuationdcfdiscounted cash flowtemplateexcel788free by Wall Street Prep
Conjoint Analysis Excel TemplateIdentify product attribute customer preferences, customer's willingness to pay, and product market share.analysistemplateexcelpricemethods1,234free by Alberto Scappini
Ultimate Startup Cap Table and Return Analysis Excel TemplateSample cap table excel template with exclusive waterfall return analysis.analysiswaterfallstartupcap tabletemplate3,519$9.00 by Alexander Jarvis
Discussion feed for Modeling Sales Data For E-commerce Businesses
The user community and author are here to help. Go ahead!