Data Analytics for Ecommerce Company: Analyzing Sales and Data for Product Segments and Geographic Regions

2018
748944 –DATA ANALYTICS

Executive summary
In this scenario we are working as a Data Scientist in a big ecommerce
company. The main product are latest gadgets, books, toys, household,
stationaries, home appliances items and clothes etc.
The company’s performance is profitability decreased due to increased
competition and also the changing customer expectations and mind sets.
And offers given other company’s also very high. Sathiyavathi.R (2015).
The company has well qualified board of directors but they believe in
The power of data analytics in solving problems and its make important
Business decisions and task. Belarc.com. (2018)
Due to our data analytics skills and data science capability, the company
representatives have giving us a special task in analyse the company’s
sales and data for each product segment and each geographic region.
Lakshadipathi t and Kumar raj t (2016)
1

TABLE OF CONTENTS PAGE.NO
1. LIST OF ABBREVIATIONS AND ASSUMPTIONS
MADE
2
2. INTRODUCTION 3
3. RESEARCH METHODOLOGY 3
4. RECOMMENDATIONS TO THE COMPANY 4
5. ANALYTICAL FINDINGS 5
5.1. PROFIT ANALYSIS
5.2. DESCRIPTIVE STATISTICS FOR NUMBER OF
CUSTOMER
5.3. TWO SAMPLE T_TESTS
5.4. ONE WAY ANOVA
5.5. REGRESSION ANALYSIS
5.5CORRELATION ANALYSIS
5
6
7
8
8
6. IMPLEMENTATIONS 9
7. CONCLUSION 10
8. LIST OF REFERENCE 11
9. APPENDIX 12
2

1. List of Abbreviations and assumptions made
1. CSV-comma separator value
2. COD-cash on delivery
3. DCP-debit card payment
4. CCP-credit card payment
5. SC-sub category
6. No .of –number of
7. CN –customer name
8. CT – customer type
3