Data Handling and Business Intelligence-2

DATA HANDLING AND
BUSINESS INTELLIGENCE-2
1

Table of Contents
INTRODUCTION...........................................................................................................................3
Part 1................................................................................................................................................3
Examining decline in the Sales/ Profits from data.......................................................................3
Excel in pre-processing the data..................................................................................................5
Analysing data in excel................................................................................................................5
Visualising data in excel..............................................................................................................6
PART 2............................................................................................................................................7
2.1 Example of clustering............................................................................................................7
2.2 Data mining methods that are used in business...................................................................11
2.3 Advantage and disadvantage of using SPSS over Excel.....................................................12
CONCLUSION..............................................................................................................................14
REFERENCES..............................................................................................................................16
2

INTRODUCTION
Excel is the software program made by Microsoft which uses spreadsheet for organising
numbers and the data using formula and functions. The excel analysis very ubiquitous around
world and is used by businesses of different sizes for performing financial analysis. It is useful
tool that provide number of functions to be performed using them on single platform. SPSS is
short name of Statistical Package that is used by different researchers to carry out the complex
and critical statistical data analysis. SPSS was created for managing and the statistical analysis of
various types of the social science data. It delivers robust features which lets the organisation to
extract actionable insights from the data
Part 1
Examining decline in the Sales/ Profits from data.
Pivot tables
2009
Deliv-
ery
Truck Express Air Regular Air
Total Average
of Sales
Total Average
of Profit
Aver-
age of
Sales
Average of
Profit
Average of
Sales
Aver-
age of
Profit
Average of
Sales
Average
of Profit
5373.84
4278 230.9169802 1202.55979
148.9
76814
5 1199.483994
177.0726
953 1775.878179 181.1844243
2010
Delivery
Truck
Express
Air
Regular
Air
Total Aver-
age of Sales
Total Aver-
age of Profit
Average
of Sales
Aver-
age of
Profit
Average
of Sales
Aver-
age of
Profit
Average of
Sales
Average
of Profit
5042.8567
05
240.925
1007
1276.676
037
198.054
6341
1091.5801
14
153.03707
58 1662.81506 170.4424708
3

2011
Delivery
Truck Express Air Regular Air
Total Average of
Sales
Total Aver-
age of Profit
Average of
Sales
Average of
Profit
Average of
Sales
Average of
Profit
Average of
Sales
Average of
Profit
5634.580167 351.9902281 1000.050176 114.9705818 1145.915478 175.4247671 1716.68918 190.3455956
2012
Average
of Sales
Average of
Profit
Total aver-
age of Sales Total Average of Profit
Delivery
Truck
Ex-
press
Air
Reg
u-
lar
Air
Delivery
Truck
Ex-
press
Air
Re
gu-
lar
Ai
r
5274.782
1312.59
1
119
0.5
8
137.567766
3
218.67
89604
16
0.4
96
43
26 1767.953 162.9134776
Interpretation
It could be analysed from the above analysis that in year 2009 sales were 1775 and the
profits were 181. Profits by the delivery truck are 230 and sales are 5373. In 2010 the profits
were 170 and sale were 1662. Delivery trucks profits are 240 and sales 5042. Sales through
express ways are 1276 and profits 198 and sales through regular way are 1091 and profits at 153.
In 2011 total sales were 1716 and profits were 190. In year 2012 profits by truck are 5274,
express air is 1312 and regular air is 1190. While average profits of delivery truck are 137,
express air 218 and regular air at 160. Total average sales were 1767 and profits were 162.
4