www.eloquens.com
Open in
urlscan Pro
2a01:4ff:f0:dde8::1
Public Scan
Submitted URL: https://www.eloquens.com/tool/x7jimr/startups/e-commerce/modeling-sales-data-for-e-commerce-businesses
Effective URL: https://www.eloquens.com/tool/X7jImR/startups/e-commerce/modeling-sales-data-for-e-commerce-businesses
Submission: On October 12 via api from US — Scanned from DE
Effective URL: https://www.eloquens.com/tool/X7jImR/startups/e-commerce/modeling-sales-data-for-e-commerce-businesses
Submission: On October 12 via api from US — Scanned from DE
Form analysis 3 forms found in the DOM
POST /catalog
<form class="inline" method="post" action="/catalog"><span class="search"><input type="text" name="query" class="filterSearch" value="" placeholder="What are you looking for?"><button type="submit" class="icofont-after"> </button></span></form>POST /catalog
<form class="inline" method="post" action="/catalog"><span class="search"><input type="text" name="query" class="filterSearch" value="" placeholder="What are you looking for?"><button type="submit" class="icofont-after"> </button></span></form>POST #
<form class="pure-form pure-form-stacked api-form" method="post" action="#" data-action="guest/login" data-cb="Guest.login" data-btn-disabledxxx="true">
<div class="row margin-top-20">
<div class="col s12 m5 show-on-hover text-center">
<p><a data-text="Sign in with LinkedIn" class="linkedin-btn btnSignUp" href="/sso/linkedin/init" rel="nofollow" data-type="modal-login"></a></p><img class="hide-on-small-only"
src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" data-src="https://static.eloquens.com/common/img/mascot/computer.png" alt="eloqoon computer" width="215" height="215">
<p class="text-center to-be-shown hide-on-mobile"><a rel="nofollow noopener" class="grey-active-link" href="http://about.eloquens.com/eloqoon-a-mascot-to-foster-trust-all-versions/" target="_blank">View all Eloqoons</a></p>
</div>
<div class="col hide-on-small-only m2 text-center">
<div class="separator-or h-250"></div>
</div>
<div class="col s12 m5">
<div class="input-field"><input autocomplete="username email" class="pure-input-1" type="email" name="email" id="siEmail" required="" placeholder="Email"><label for="siEmail">Email</label></div>
<div class="input-field"><input autocomplete="current-password" class="pure-input-1" type="password" name="password" id="siPasswd" required="" placeholder="Password"><label for="siPasswd">Password</label></div>
<a rel="nofollow" href="/forgot-password">Forgot your password?</a>
<p><button type="submit" class="btn text-upper blue right">Log in</button></p>
</div>
</div>
<p class="text-center"><a href="/register">New to Eloquens? Create an Account</a></p>
</form>Text Content
shopping_cart0
menu
*
* * Log in
* Sign up
* * Financekeyboard_arrow_right
* Chief financial officer
* Accounts receivable
* Accounts payable
* Excel lambda
* Invoicing
* Financial feasibility analysis
* Excel dynamic array
* Profit & loss statement excel
* Decentralized finance (defi)
* Commercial property
* Residential property financial models
* Insurance
* Sporting financials
* Inflation
* Airbnb financial
* Financial ratio analysis
* Oil & gas
* Financial planning models
* Treasury management
* Automotive business
* Integrated financial planning
* Joint ventures
* International financial reporting standards (ifrs)
* It (information technology) business
* Financial modeling world cup
* Financial reporting
* Stock market
* Hedge fund
* Agriculture finance
* Shipping financials
* Mining financials
* Construction
* Fundamental analysis
* Healthcare financials
* Portfolio optimization
* Wealth management
* Loan amortization
* Variance analysis
* Break-even analysis
* Comparable comps analysis
* Hotel financial models
* Personal finance
* Ipo (initial public offering)
* Economic value added
* Cash burn rates
* Budgeting excel
* Dividend discount models
* Manufacturing
* Risk analysis
* Weighted average cost of capital (wacc)
* Excel add-ins
* Wind energy project finance
* Bank financial models
* Trading
* Amortization & depreciation schedule
* Excel
* Retail finance
* Excel vba
* Modeloff samples
* Black-scholes models
* Monte carlo simulation
* Inventory management
* Balance sheet
* Solar energy project finance
* Cost analysis
* Scenario analysis
* Financial forecasting models
* Debt schedule
* Options pricing & valuation
* Accounting
* Capital budgeting
* Project finance models
* Financial markets
* Financial modeling
* Industry specific financial models
* Stock valuation
* Net present value (npv)
* Income statement
* Cash flow statement
* Renewable energy financials
* Sensitivity analysis
* Restaurant finance
* Return on investment (roi)
* Three statement financial models
* Leveraged buyout (lbo)
* Financial projections models
* Real estate financials
* Mergers & acquisitions (m&a)
* Venture capital
* Discounted cash flow (dcf)
* Private equity
* Investment banking
* Valuation models
* Corporate finance
* Strategykeyboard_arrow_right
* Total quality management
* Supply chain analysis
* Stakeholder analysis
* Vrio analysis
* Tender proposal
* Bain & company frameworks
* Core competencies analysis
* Organizational culture
* Esg
* Corporate purpose
* Strategic futures analysis
* Business scaling
* Digital transformation
* Organizational design
* Organizational transformation
* Process mapping
* Feasibility study excel
* Strategic key account management
* Breakthrough strategies
* M&a target screening
* Pest & pestle analysis
* Benchmarking
* Competitive advantage
* Negotiation
* Market entry
* Innovation management
* Value proposition
* Mission statement
* Problem solving
* Heat maps
* Mckinsey 7-s framework
* Smart goals
* Ansoff matrix
* Consulting interview
* Change management
* Post-merger integration (pmi)
* Asset management
* Market sizing
* Macroeconomics
* Value chain analysis
* Strategic management
* Strategic partnerships
* Coaching
* Crisis management
* Business development
* Swot analysis
* Porter's five forces
* Balanced scorecard
* Market research
* Consulting proposals
* Mckinsey frameworks
* Executive summary
* Competitor analysis
* Roadmaps
* Operations management
* Value creation
* Market analysis
* Bcg frameworks
* Business model canvas -
* Nine-box matrix
* Strategic analysis
* Bcg growth-share matrix
* Waterfall charts
* Logistics & supply chain management
* Strategic planning
* Sales
* 2x2 four quadrant matrix
* Microeconomics excel
* Due diligence
* Business plans
* Management consulting
* Kpi dashboards
* Startupskeyboard_arrow_right
* Design thinking process
* Startup lifestyle
* Growth hacking
* Entrepreneurship
* Startup studios
* Startup boards
* Mobile app finance
* Freemium
* Lifetime value (ltv)
* Cohort analysis
* Startup investors
* Lean startup
* Startup business plans
* Startup pitch decks
* Marketplaces
* Startup valuation
* E-commerce financial models
* Startup cap tables
* Software-as-a-service (saas)
* Raising capital
* Startup financial models
* Marketingkeyboard_arrow_right
* Public relations
* Customer centric design
* Strategic marketing
* 4ps & 7ps marketing mix
* Net promoter score (nps)
* Advertising
* Business networking
* Linkedin
* Personal branding
* Outbound sales
* Branding & brand management
* Inbound marketing
* Search engine optimization (seo)
* Corporate communication
* Business email
* Lead generation
* Product life cycle
* Growth marketing
* Customer success
* Industry landscape analysis
* Customer acquisition
* Public speaking
* Digital marketing
* Product launch
* Marketing plans
* Social media
* Pricing
* Legalkeyboard_arrow_right
* Compliance
* Code of conduct
* Articles of incorporation
* Internal audit
* Employee contracts
* Sales & purchase agreements (spa)
* Intellectual property (ip) agreements
* Non-disclosure agreements
* Operating (or founder) agreements
* Advisor agreements
* Shareholder agreements
* Startup term sheets
* Leadership & hrkeyboard_arrow_right
* Corporate event management
* Quality management plans
* Chief of staff
* Training excel
* Cross cultural management
* Effective communication
* Organizational culture
* Personal development
* Job search
* Organizational charts
* Team management
* Decision making
* Remote work
* Job descriptions
* Interviews
* Teamwork
* Career advancement
* Payroll
* Meetings
* Recruiting
* Cv (curriculum vitae) / resume
* Gantt charts
* Health & safety
* Performance reviews & appraisals
* Task management
* Leadership
* Project management
* Productivity
* Human resources
* Technologykeyboard_arrow_right
* Physics excel models
* Python in excel models
* Nft investment
* Cybersecurity
* Digital privacy
* Neural networks
* Genetic engineering
* Ui design
* Mathematical
* Ux design
* Blockchain technology
* Research and development (r&d)
* Artificial intelligence (ai)
* Machine learning
* Product management
* Data mining
* Javascript
* Data analysis
* Statistical
* Data science
* Power bi
* Electrical engineering
* Google sheets models
* Cryptocurrency
* Studentkeyboard_arrow_right
* Exam revision
* Dissertation writing
* Primary education
* Group work
* Student life
* Study note-taking
* University research
* Essay writing
* Otherkeyboard_arrow_right
* Politics & politicians
* Dynamic arrays
* Miscellaneous
* Elearning
* Eloquens authors
* Coronavirus (covid-19)
* Homepage
* Browse
* Explore Categories
* How it works
* Cart 0
* Bookmarks 0
* * Publish
* KEYBOARD_ARROW_LEFT
*
* explore
* shopping_cart0
* 0
* library_books0
* Log in
* Sign up
* Publish a Best Practice
1. Catalog
2. Startups
3. E-Commerce Financial Models
4. Sales Data Excel Model for E-commerce businesses
Ashish Mathur
Founder, Excel Enthusiasts Follow 77
129 reviews9,245 views|4 comments|Bookmark download for free
129 reviews9,245 views4 commentsadd_shopping_cart
*
*
*
*
*
*
*
Send to a friend
* linkedin
* twitter
* facebook
* code
Originally published: 25/01/2017 17:04
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.
by Ashish Mathur
Founder, Excel EnthusiastsFollow 77
129 reviews9,245 views|4 comments|Bookmark download for free
analysissalesecommercee-commercetemplateexceldatasetvideoaccess
Description
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.
- Ashishmathur.com
(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
Discuss
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*
* About Eloquens
* Home
* How it Works
* Publishing Best Practices
* Finding Best Practices
* About Us
* Blog
*
* Imprint
* Terms of Service
* FAQ
* Contact Us
* Categories
* Finance
* Strategy
* Startups
* Marketing
* Legal
* Leadership & HR
* Technology
* Student
* Other
*
*
* Browse Catalog
* Sign-Up
* Log In
Our Teams Work on
© 2023 Eloquens
We use cookies to understand how you use our site and to improve your
experience. This includes personalized content and Best Practices suggestions.
To learn more click here. By continuing to use our site, you accept our use of
cookies, revised Privacy Policy and Terms of Use.
I accept
%PRODUCT_ADD_CART_TITLE%
Contribute: $USDhelp%product_add_cart_label%
No thanks, I just want to %product_skip_link%
LOGIN
View all Eloqoons
Email
Password
Forgot your password?
Log in
New to Eloquens? Create an Account
CREATE AN ACCOUNT
View all Eloqoons
Why should I sign up with LinkedIn?help
sign up with email
I have read and agree to the Eloquens Terms of Service and Privacy Policy.
Why should I sign up with LinkedIn?help
sign up with email
I have read and agree to the Eloquens Terms of Service and Privacy Policy.
Have an account? Login
ARE YOU USING THIS BEST PRACTICE FOR...
* Businesshelp
* Consultinghelp
* Student / Non-Profithelp
Read detailed licenses
MESSAGE
OK
4.7 / 5 (129 votes)
* 76%
* 19%
* 2%
* 1%
* 2%
CERTIFICATE OF PUBLICATION DATE
Modeling Sales Data for E-commerce businesses
by Ashish Mathur
Version 1 (Original Version): 25/01/2017 17:04 GMT
Version 2 (Current Version): 31/01/2017 14:22 GMT
Publication Number: ELQ-27655-2
ADD TO YOUR LIBRARY TO REVIEW
download for free
ADD TO CART TO CONTINUE READING
download for free
ADD TO CART TO VIEW THE VIDEO
Ashish Mathur offers you this Best Practice for free!
download for free
Add to bookmarks
PLEASE SIGN-UP TO DOWNLOAD THIS FREE BEST PRACTICE
Sign up
--------------------------------------------------------------------------------
Have an account?
Log in
please wait...
2001:1b60:1010:2:1011:ab28:8f04:d107