Data Handling & Business Intelligence: Excel for Pre-processing, SPSS Analysis, and Common Data Mining Methods in Business

Data Handling & Business
Intelligence

TABLE OF CONTENTS
INTRODUCTION...........................................................................................................................3
MAIN BODY..................................................................................................................................3
PART 1............................................................................................................................................3
The decline in sales/profits over the years and the use of Excel for pre-processing the data......3
PART 2............................................................................................................................................7
The smile_clinic.csv provided in conjunction with SPSS...........................................................7
2.1 k means................................................................................................................................11
The most common data mining methods used in business........................................................13
Advantages/disadvantages of SPSS...........................................................................................14
CONCLUSION..............................................................................................................................14
REFERENCES................................................................................................................................1

INTRODUCTION
Data Handling & Business Intelligence is the process in which the technology and make
the use of strategies for analyzing more about the historical and current data. This report will
explain about the superstore data set which help for declining more about their sales or profits.
This will also demonstrate about the Excel function which make the proper use of various
concepts in business. Along with this conjunction of SPSS and various some common concepts
data mining which are used in business context. Furthermore, advantage and disadvantage of
SPSS which use for business context.
MAIN BODY
PART 1
The decline in sales/profits over the years and the use of Excel for pre-processing the data
The crude information contains missing in turn, uproarious and blunders, so this cannot
among the utilize that configuration in AI models. The better information pre-processing has
expanded precision of the model. So the information pre-processing is generally significant in AI
and profound learning models. The all necessary bundles are imported for information with high
value and make about their more easy way for calculation (Hamoud and et.al., 2021). The
utilized for cluster activity performed on the datasets. This could also important for knowing
about the Excel in which they can easily make sure for having some proper data collection and
sources for completion about the given their proper data collection.

From the above graph it had been come to know about how the sources have been taken
with having the high sales and profits. While having such things this could also important for
knowing about how the organization is working for their customer and making their superstore
for working with more high. This could also essential for taking the sales and profits data for the
organization while in which they can easily come to know about they can work and manage their
work with having many terms and condition. This might be important for taking their proper
sales about their products and services for which they can easily think about many strategy so
that could help them for increasing their sales volume with 76% in year and make sure for
having their high estimation about various things (Ali, Ramli and Awalin, 2020). The dataset has
increasing more high volumes in string design. The ai model just permitted arithmetical
qualities. The string changed over into the mathematical qualities esteem methods. While such
kind of things this could also important for knowing about their per years sales volumes in which
they can work and make sure about their sales volume to be growth. 34.56 sales have been taken
their high active places and keeping many major aspects about their sources in which those terms
and condition can work. In such kind of things this could also being so helpful for them for about
the profits can increased while by keeping employee for working with many activities in
organization. 45% to 89% superstore can easily their products and keeping more high
technology process for which they can easily come to know about their market strategy.
From the above it could be analysis that, organization need to work with their employee
for having the high estimation about their customer. This could also come to know about those