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 (94 votes)
- Rate this Downloadable Tool
Write a review
- 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)
- 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)
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,076add_shopping_cartfreeby Daisy Deng
Ecommerce Business: Template for Cohort AnalysisEstimate lifetime value for an Ecommerce business using a sample cohort analysis.analysisstartuplifetime valueecommercetemplate2,628add_shopping_cartfreeby Jeremy Liew
Ecommerce Financial Fundraising Excel TemplateThis is the best excel model template you will find on fundraising for your ecommerce startupfinancialmodelfundraisingecommercetemplate1,712add_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 modelstartupfundraisingsubscription740add_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,175add_shopping_cartfreeby Michael Rogers
Social Media Metrics Excel DashboardAn excel template for employees to understand the performance of social media channels for their organisation.salesmarketingsocial mediametricsdashboard8,058add_shopping_cartfreeby Joakim Nilsson
Conjoint Analysis Excel TemplateIdentify product attribute customer preferences, customer's willingness to pay, and product market share.analysistemplateexcelpricemethods1,569add_shopping_cartfreeby Alberto Scappini
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,544add_shopping_cartfreeby Bob Samii
Ultimate Startup Cap Table and Return Analysis Excel TemplateSample cap table excel template with exclusive waterfall return analysis.analysiswaterfallstartupcap tabletemplate3,637add_shopping_cart$9.00by Alexander Jarvis
Sales Pipeline Conversion Excel Model TemplateSales Pipeline Conversion Model to support assumptions behind long-term forecasts & aid sales team with forecasts.salesconversiontemplateexcelexcel model1,561add_shopping_cartfreeby Ben Murray
Discussion feed for Modeling Sales Data For E-commerce Businesses
The user community and author are here to help. Go ahead!