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 (99 votes)
- Rate this Downloadable Tool
Write a review
- 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
- 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)
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,205add_shopping_cartfreeby Daisy Deng
Ecommerce Business: Template for Cohort AnalysisEstimate lifetime value for an Ecommerce business using a sample cohort analysis.analysisstartuplifetime valueecommercetemplate2,919add_shopping_cartfreeby Jeremy Liew
Ecommerce Financial Fundraising Excel TemplateThis is the best excel model template you will find on fundraising for your ecommerce startupfinancialmodelfundraisingecommercetemplate2,056add_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 modelstartupfundraisingsubscription948add_shopping_cart$369.00by Alexander Jarvis
Real Estate Property Cashflow AnalyzerHelps evaluate the characteristics of a property’s cashflow along with some explanations of the derived values.analysisratiosprofitabilitytemplateexcel2,250add_shopping_cartfreeby Michael Rogers
Conjoint Analysis Excel TemplateIdentify product attribute customer preferences, customer's willingness to pay, and product market share.analysistemplateexcelpricemethods1,925add_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 mediametricsdashboard8,795add_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,769add_shopping_cartfreeby Bob Samii
Ultimate Startup Cap Table and Return Analysis Excel TemplateSample cap table excel template with exclusive waterfall return analysis.analysiswaterfallstartupcap tabletemplate3,708add_shopping_cart$9.00by Alexander Jarvis
Discounted Cash Flow (DCF) Model Template + InstructionsLearn how to build a simple DCF Model aligned with Investment Banking best practices.valuationdcfdiscounted cash flowtemplateexcel1,126add_shopping_cartfreeby Wall Street Prep
Discussion feed for Modeling Sales Data For E-commerce Businesses
The user community and author are here to help. Go ahead!