University E-commerce Sales Analysis and Strategic Recommendations

This report, focusing on e-commerce sales, utilizes data mining techniques and the Python programming language to analyze sales datasets and provide strategic recommendations for improving organizational profitability. The report explores the background of an e-commerce organization, its introduction to data analytics, and the research methodology employed, including descriptive research and the application of both quantitative and qualitative approaches. Analytical findings are presented, including dataset details, data mining processes (divisive and agglomerative methods), and the identification of key geographic regions for targeted marketing efforts. The report also prioritizes products, examines the impact of free shipping, and offers comprehensive recommendations to enhance sales, including scalable data storage, improved data cleaning, and better advertising strategies. Python codes and screenshots are included to demonstrate the implementation of linear regression models and sales predictions, culminating in a conclusion and a list of references. The report aims to provide actionable insights to boost sales and improve overall business performance.

ICT 706

Executive Summary
The platform which allows organizations to do trading of their products through an online portal
is called e-commerce or electronic commerce. E-commerce offers so many services like selling
products, online reservations, transactions and so much more.
The main target of this assignment is to cover all the information that is related to e-commerce
and to analyse the methodology used in this assignment.
SWOT is the most effective way to make strategic plans for the profit for the organization. It
could be done by SWOT examination process, all the information regarding the profit domains
could be gathered by process.
The miles have an insight building which is known as shopper driver that is very beneficial. This
is useful in increasing the association execution. For your business endeavour, Improvement in
the site design and the substance should be facilitated.
The main aim of organization should be that they advertise their product in such a way that the
customer finds it easy and simple and they think that they actually need it. The costs of delivery
should not be as high or after a certain amount, it should be free of cost which lures the
customers to get to that amount.
1

Contents
Executive Summary.........................................................................................................................1
Background......................................................................................................................................3
Introduction......................................................................................................................................5
Research Methodology....................................................................................................................6
Descriptive Research....................................................................................................................6
Fundaments available...................................................................................................................6
Quantitative or Qualitative...........................................................................................................6
Conceptual or Empirical..............................................................................................................7
Analytical Findings:.........................................................................................................................8
Dataset..........................................................................................................................................8
Data Mining.................................................................................................................................9
Divisive method:........................................................................................................................11
Agglomerative method:..............................................................................................................11
Recommendation for the Company:..............................................................................................14
Implementation plan:.....................................................................................................................15
Python Codes with Screenshots.....................................................................................................16
Conclusion:....................................................................................................................................20
References......................................................................................................................................21
Appendex.......................................................................................................................................22
Working Python Codes..............................................................................................................22
2

List of Figures:
Figure 1: Sales Dataset....................................................................................................................9
Figure 2: Training Graph over Sales Data.....................................................................................10
Figure 3: Test Graph over Sales Data............................................................................................10
Figure 4: Output Prediction...........................................................................................................12
Figure 5: Product to be prioritized.................................................................................................12
Figure 6: Linear Regression Graph on Sales................................................................................16
Figure 7: Final Prediction Graph...................................................................................................16
Figure 8: Code for test and train....................................................................................................18
Figure 9: Main Module..................................................................................................................19
3

Background
It was long time ago when this organization was set up. The time when no one ever heard of this
organization before as it was new and had just started and as a newbie, they could only reach to a
very fewer region near them and that too with very fewer products. As the time passed this
organization started to get recognition and started to reach regions a bit far thus they started to
expand their business as wide as possible with more products in their hand and this was the time
when it was growing every day.
Their products varied from toys, gadgets, books to so much more and they also delivered all
these products to the doorsteps of their customers and with so many other factors they became
one of the top organizations of that time. Then there came the time when this organization too
had to go through bad graphs of sales and this was the time when they needed to work on
improving their strategic goals and it was all made possible when they used Data Analytics
which actually made me regain their position in the market thus they were once again leading the
market. Data Analytics gave them an exact graph of which regions were the one where the sales
graph was going downhill and where the organization needed to improve also from which region
there was the highest profit which helped them make their way to top.
4

Introduction
The current situation is like this that every organization wants to go e-commerce. So many
organizations are competing with each other to provide the best e-commerce experience. A
report will be made in this assignment which will focus on improving the profitability
of organization. To calculate the monthly sales of book is the main aim of organization.
Complete sales of products in the last month is recorded in report.
The aim of this assignment report is to focus on the techniques that will help the
organization increase its sales. The Technique widely used is Python programming language.
Techniques for producing the result are also present in the report (Turban et al., 2017).
5

Abbreviations and Assumption List
The abbreviations used in this report are:
 Tab Separated Value
 Comma Separated Value
Assumptions made for assignment are as follow
 Test dataset development for process
 Training set and test set are two parts of Test dataset
 Geographic location is an addition
 Unique product available
 Delivery person required
6

Research Methodology
The process used to identify, select and analyze information and gather all the data available
about a particular topic. Research is done to improve the currently existing data or gather a new
one with the updated information. After a research is done it is easy to compare, observe and
experiment (Andam, 2017).
Descriptive Research
It is the research that includes all the surveys and all the inquiries about the facts that are being
found. This research basically focuses on what has happened and is happening at the moment. In
these research things like preferences of people, the frequency of shopping is being measured.
While on the other hand, the analytical research works on the data that is available at the current
time for more critical evaluation using it
Fundaments available
The research which works on the solution quickly to resolve the problem for the organization.
The research related to fundaments deals with theory.
Quantitative or Qualitative
Quantitative research deals with the measurement of quantity. Works with anything that may be
related to quantity in any way. Qualitative research, on the other hand, deals with the quality of
the subject which includes the science of behaviour in which research
about behaviour of human beings is being carried out. In comparison, the qualitative research is a
bit difficult to carry out and requires psychologist's guidance.
7

Conceptual or Empirical
Conceptual research is the one which mainly focuses on conceptual ideas. All the philosophers
before developing any idea or thought take conceptual research into consideration for better
results. Empirical research, on the other hand, focuses on the data that is being obtained by
experiments or observations. It works according to the data that is being verified by experiment
or observations.
8

Analytical Findings:
This assignment will be using a dataset of books. Information of the books sold by the
organization is in the dataset.
Dataset
The dataset includes:
 Books ID,
 Books Name,
 Type of Customer,
 Book Price,
 Monthly Sale,
 Geographic Region for Delivery,
 Number of Customers Who Bought the Book,
 Language,
 Shipping Type
9

Figure 1: Sales Dataset
Figure 1 shows the Sales Dataset Chosen for the process of prediction. The above figure shows
the part of the dataset which includes the metadata in a dataset of books.
Data Mining
Data mining is the strategy that organizations use to turn their unrefined data into the valuable
one. By using additional assistance in the form of programming, illustrations which help in a
very strong way to refine the data.
Data mining helps in choosing the arrangements and conveys high acquiring. It is used by
undertaking partnerships of net business. It depends on data amassing and setting ceaselessly.
The aim of this is to grab records from dataset and pass on it to such an extent in such a way
that it becomes sensible. Data mining helps by providing the ways to conquer loss and gain
profit. Data mining helps to focus on which areas does improvement is needed, what regions
10

must be focused to improve the business, what if detached transporting methodology can be
situated in real ways of life (Wu et al., 2014).
Figure 2: Training Graph over Sales Data
Figure 3: Test Graph over Sales Data
11