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 (111 votes)
- Rate this Downloadable Best Practice
Write a review
- Mohammad Sabir(last updated: 07/08/2020 05:40)
- Nathalia C. Bruzual R.(last updated: 03/08/2020 15:27)
- Jose Castillo Duarte(last updated: 27/07/2020 02:03)
- Talib Hussain Raja(last updated: 12/06/2020 21:43)
- Michael owor(last updated: 04/06/2020 14:13)
- Imran hossain, CITF, CSCAᵀᴹ(last updated: 03/06/2020 08:46)
- darshan vanpariya(last updated: 13/05/2020 06:08)
- Ajijola Habeeb(last updated: 05/05/2020 10:19)
- Punit Badal(last updated: 18/04/2020 06:39)
- Bonno Lebogang Motswaiso(last updated: 10/04/2020 16:14)
- Miroslav Laketic(last updated: 24/03/2020 13:33)
- Tianchu Zhang(last updated: 21/02/2020 18:46)
- 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)
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,370add_shopping_cartfreeby Daisy Deng
Ecommerce Business: Template for Cohort AnalysisEstimate lifetime value for an Ecommerce business using a sample cohort analysis.analysisstartuplifetime valueecommercetemplate3,202add_shopping_cartfreeby Jeremy Liew
Ecommerce Financial Fundraising Excel TemplateThis is the best excel model template you will find on fundraising for your ecommerce startupfinancialmodelfundraisingecommercetemplate2,639add_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 modelstartupfundraisingsubscription1,428add_shopping_cart$369.00by Alexander Jarvis
Ultimate Spreadsheet, Dashboard, and Chart Template Super Pack for the Restaurant and Hospitality IndustrySuper Pack of Excel Templates for the Hotel and Restaurant Industry.analysissalesaccountingchartsdashboards202add_shopping_cart$299.00by Steve Lindsey
Real Estate Property Cashflow AnalyzerHelps evaluate the characteristics of a property’s cashflow along with some explanations of the derived values.analysisratiosprofitabilitytemplateexcel2,327add_shopping_cartfreeby Michael Rogers
Conjoint Analysis Excel TemplateIdentify product attribute customer preferences, customer's willingness to pay, and product market share.analysistemplateexcelpricemethods2,461add_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 mediametricsdashboard10,790add_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 reportsalesreportmarketingkpismetrics3,012add_shopping_cartfreeby Bob Samii
Sales Pipeline Conversion Excel Model TemplateSales Pipeline Conversion Model to support assumptions behind long-term forecasts & aid sales team with forecasts.salesconversiontemplateexcelexcel model2,553add_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!