Data Handling and Business Intelligence

Data handling and business intelligence
1

Table of Contents
INTRODUCTION...........................................................................................................................3
PART 1............................................................................................................................................3
PART 2............................................................................................................................................6
2.1 Specific example of clustering...............................................................................................6
2.2 Data mining methods that are used in business...................................................................10
2.3 Pros and cons of using SPSS over Ms- Excel.....................................................................11
CONCLUSION..............................................................................................................................13
REFERENCES..............................................................................................................................15
2

INTRODUCTION
There are large data set which contains huge data and info in it. the data is raw one that
needs to be analysed and evaluated in order to gain useful info from it. So, data mining has
emerged as new concept in it. With use of various tools data can be easily interpreted and info
is generated. Besides that, it has made it easy for business to take effective decisions with help
of it. Also, data is presented in visuals and graphs to understand patterns and trends in it (Chen,
and et.al., 2018).
In this report it will be described about analysing data set of super market. furthermore, it
will be examined about data mining tools used by business and pros of SPSS over Excel.
PART 1
Pivot tables
Year 2012
Interpretation- From above table it is stated that average of sales from delivery truck is 5274
and from express air is 1312 whereas by regular air it is 1190. Besides that, average of profit by
delivery truck is 137 and express air is 218 and regular is 160. However, total average sales of
year 2012 is 1767 and profit is 162.
Year 2011
3

Interpretation- it is analysed that average sales during year 2011 is 1716 and profit earned is
190. However, average sales through delivery truck is 5634 and profit is 351. From express air
average sale is 1000 and profit is 114. Also, from regular air sales is 1145 and profit is 175.
Year 2010
Interpretation- it is evaluated that in year 2010 average sale was 1662 and profit was 170.
Besides that, sales via delivery truck is 5042 and profit is 240. From express air sales is 1276 and
profit are 198 whereas via regular air sales are 1091 and profit is 153.
Year 2009
4