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
- Darwin Lorina(last updated: 26/04/2018 03:58)
- Yuhisern Navaratnam(last updated: 23/04/2018 20:57)
- SUROJIT DAS(last updated: 22/04/2018 07:06)
- William Böll496(last updated: 13/04/2018 13:32)
- Liang Zhu(last updated: 10/04/2018 14:39)
- Shady Saleh, Corporate Business(last updated: 02/04/2018 03:23)Thanks Asish, great job.
- mack maine(last updated: 05/03/2018 22:54)
- Inam Ur Rahim(last updated: 23/01/2018 02:11)
- Faiz Amer Abdat(last updated: 04/12/2017 08:00)
- S Mash(last updated: 09/08/2017 13:04)
People using this tool also downloaded
Ecommerce Business: Template for Cohort AnalysisEstimate lifetime value for an Ecommerce business using a sample cohort analysis.analysisstartuplifetime valueecommercetemplateexcelsamplefreecohort901 remove_red_eyefreeby Jeremy Liew
Cohort Analysis in 3 minutes: an Excel exampleA simple step-by-step explanation of how to do cohort analysis.analysisecommercetemplateexcelspreadsheetexamplecohortexplainedstep985 remove_red_eyefreeby Daisy Deng
Social Media Metrics Excel DashboardAn excel template for employees to understand the performance of social media channels for their organisation.salesmarketingsocial mediametricsdashboardkpitemplateexcelfree2,518 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,233 remove_red_eye
Ultimate Startup Cap Table and Return Analysis Excel TemplateSample cap table excel template with exclusive waterfall return analysis.analysiswaterfallstartupcap tabletemplateexcelspreadsheetfreedownloadreturn analysis2,693 remove_red_eye$9.00by Alexander Jarvis
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,007 remove_red_eyefreeby Bob Samii
Conjoint Analysis Excel TemplateIdentify product attribute customer preferences, customer's willingness to pay, and product market share.analysistemplateexcelpricemethodsrankingconjoint analysisattributescompositionaldecompositionalNew!
Quick Lesson: Build a Discounted Cash Flow (DCF) Model, Part 1Learn how to build a simple DCF Model aligned with Investment Banking best practices.valuationdcfdiscounted cash flowtemplateexcelvideohow todcf modellessonquick lesson44 remove_red_eye
Ecommerce Financial Fundraising Excel templateThis is the best excel model template you will find on fundraising for your ecommerce startupfinancialmodelfundraisingecommercetemplateexcel318 remove_red_eye$160.00by Alexander Jarvis
Discussion feed for Modeling Sales Data For E-commerce Businesses
The user community and author are here to help. Go ahead!