Data Handling and Business Intelligence

Data Handling and Business
Intelligence
1

Contents
INTRODUCTION...........................................................................................................................3
PART 1............................................................................................................................................3
Identify the sales and profit over years, evaluate the use of Excel for pre-processing the data or
information..................................................................................................................................3
Demonstrate that how can practical ways to perform operation by using Excel function such as
Pivot table, if, Lookup, graph and chart......................................................................................6
PART 2..........................................................................................................................................11
Audileadership data in the conjunction by using Weka software and perform clustering........11
Describe about the data mining methods that can be used within a business............................14
Advantage and disadvantage of Weka over Excel....................................................................15
CONCLUSION..............................................................................................................................17
REFERENCES..............................................................................................................................18
2

INTRODUCTION
Data Mining is consider as a process of identifying the different patterns, interrelation
between large volume data or information. this process is mainly used the large organization
where every day collecting large information within system. It will support for filtering data on
the basis of categorising. Marketing assistant will participate in the business expansion so that
they will use data mining software to gather relevant information or data. In order to cut the
cost / price while improving the customer relationship. Moreover, it will minimise the various
type of risk, threat in the organization. Data mining is an important factor for exploring and
analysing the large amount of data. It provide the facilities to discover the meaningful pattern,
facts, and figures. The documentation will describe about the sales information and also
calculating the profit, sales over years. The primary vision is to predict the future outcome or
result through data mining concept. In additional, data mining is a type of appropriate technique
which help for building the machine learning model in term of artificial intelligence.
PART 1
Identify the sales and profit over years, evaluate the use of Excel for pre-processing the data or
information.
Row Labels Average of Profit Sum of Sales
Furniture 68.11660673 5178590.542
2009 140.1369955 1469508.194
2010 20.65391403 1250043.046
2011 115.326226 1258336.514
2012 -5.173357143 1200702.788
Office Supplies 112.3690738 3752762.1
2009 153.4285381 1031244.56
2010 97.14263473 885095.79
2011 80.42802855 816902.13
2012 117.6447423 1019519.62
Technology 429.2075157 5984248.182
2009 337.0125974 1668572.052
2010 474.5130402 1416503.546
2011 518.2162105 1380213.417
2012 398.3725568 1518959.168
3

Grand Total 181.1844243 14915600.82
Table:1
Figure 1
Figure 2
4