Data Handling And Business Intelligence-2

Data Handling And Business
Intelligence-2

TABLE OF CONTENTS
INTRODUCTION...........................................................................................................................3
MAIN BODY..................................................................................................................................3
PART 1............................................................................................................................................3
Evaluate the use of Excel for pre-processing the data.................................................................3
Analysing the data and visualising the data.................................................................................4
PART 2............................................................................................................................................7
Numbers of customers of Smile clinic who eat rice along with mean, median and mode..........7
Number of male and female customers of Smile Clinic..............................................................9
Mean and median of the ages....................................................................................................10
Specific example of clustering by showing what does K means...............................................11
The most common data mining methods used in businesses....................................................12
Advantages and limitations of SPSS over excel........................................................................12
CONCLUSION..............................................................................................................................13
REFERENCES................................................................................................................................1

INTRODUCTION
Data Handling And Business Intelligence is the process for storing the data, gathering,
access and secure data with various software technology. Employment data management enables
for the efficient access of data insights and they are usually required for having the biggest
solution. This report will explain about use of excel for pre-processing data and use of excel with
having one function such as chart and graph. Along with this also examined about the
smile_clinic.csv provided conjunction with SPSS and various methods of data mining that could
used in business context. Also, discuss the advantage and disadvantage of SPSS in excel.
MAIN BODY
PART 1
Evaluate the use of Excel for pre-processing the data
Data processing that could prefer the raw data which could converted into the
understandable format data. This could also help the business for processing their dataset and
make sure for highly securing their data (Venkatesh and Rengaraj, 2021). As employee can
prefers their dataset for having the excel sheet and that could contain the frequency about various
terms in working with dataset. Data processing techniques such as feature sealing, encoding data,
importing and finding missing data. Alongside this will help the business and data processing
about the important has increased more accuracy of using models. This might be more helpful
for having their identification about those data which are missing with the securing data sources
and that could also come to know about those activities which could make their better terms and
policies. Excel this could with the great tool and that could make sure for having those tools
which could help the business or organization for working with having their proper connection.
While having such kind of software this could led with having the proper estimation in
dataset and make sure about their sufficient uses. This could also helpful for knowing about how
the data will work and completion over those things which could keep those activities for
working with more effectiveness (Dabhade and et.al., 2021). Being able for applying their
techniques for dealing with many common problems and that could led with having their various
impacts. This could also make sure for having their many possible things and that might be more
raw data including those missing data and data from the various multiple sources. While such
kind of activities helpful for the business in keeping their working records and that could be

useful for having various types of submission in process. Data pre-processing consists about
those variable data steps up for transferring many sources for the data and keeping them for
working with many more future aspects. Pre-processing aims at assessing and improving the
quality of data to allow for reliable statistical analysis. As the excel keep working with many
more things that could led them for working with many more processing terms and make sure for
having their high effective process.
During pre-processing those activities make sure about their statistical concepts and kind
of activities which could keep them for working with high effectiveness. Similarly, avoid the
reaching out various other sources and that might be more helpful for concepts and effectively
come to know about those things which could working. Moreover, significant about the trial and
error on differently pre-process about those sources which are might be important for the
business (Bang and Kim, 2020). As data processing is also seems important steps about the data
mining which could keep the business methods for using those further activities which could
help for making the organization for working with high process. While this should resulting out
of range and income sources about the impossible data those combination process. Sometime,
this could keep affected the ways for finding out the results for working and keeping high
measure effective.
Analysing the data and visualising the data
Below graph states about that in 2019, the sales and profits for the organization have been
neutral and that could also important for keeping with proper estimation. While this could also