Data Handling and Business Intelligence LCBB5000 Assessment 2

DATA HANDLING AND
BUSINESS INTELLIGENC
LCBB5000 ASSESSMENT 2

TABLE OF CONTENTS
PART 1............................................................................................................................................3
Evaluating use of of excel for pre processing , analysing and visualizing data........................3
PART 2............................................................................................................................................7
2.1.................................................................................................................................................7
2.2 Describing data mining methods.........................................................................................15
2.3 Describing the advantages and disadvantages of SPSS over excel....................................16
REFERENCES................................................................................................................................1

PART 1
Evaluating use of of excel for pre processing , analysing and visualizing data
Excel is one of the important tool that is utilized by various kinds of users to accomplish
certain objectives in effectual manner. It is widely taken into consideration for manipulating
rows and columns for conducting statistical analysis. This is found to be convenient as
provides features like simpler , faster and more intuitive. The particular specified tool
empowers users to get understandability by providing command for suing certain relatable
formulas which can accomplish objectives of users (Zhou, 2020.). It allows the users to get
features of providing ranks, trends, outlier, majority ,etc. This provides assistance in having
proper knowledge regarding particulars subject matter through storing, summarizing and
analysing selected range of data.
There are variety of functions available in excel that helps in proving various different abilities
to meet requirements in easy and manageable manner. In addition to this, it includes LEN,
count, net workdays, sum, average, if, error, v & h lookup, find, left and right, ranking, min,
max, sum product, etc. each function provides certain level of advantages to users that helps in
having capability of using advanced features. Concatenate aids in combing numbers, data and
test which is is helpful in obtaining excellent functions to attain the purpose in effective
manner. It becomes possible to have capability to store, analyse and summarize data in better
manner so that including complex data set of business practices can be exerted. With help of
mentioned functions user can get several distinct benefits which can help in attaining higher
efficiency in conducting complex practices in efficient manner. In order to coordinate with
changing circumstances excel upgrades and provide different new features and functions so that
modifying requirements of customers can be met. Recording, summarizing and analysing the
statical data becomes crucial in current business environment so that appropriate decision can
be taken.
In modern era, excel plays significant role in providing efficiency and accuracy by
conducting data evaluation in turn accurate decision can be taken. There are various distinct
kinds of functions available such as pivot table that provides ability to mold data as per
requirement. With help of pivot table it becomes possible to set relationship among two or
more variables so that significant result from this can be derived. Checking for miscreant data
become possible with this specified analytical tool. In order to store data excel provides higher

efficiency to drag and drop the set of information which can be easily summarized. For the
purpose of visualization, there are various types of chart, graph are present in excel that gives
larger emphasis on presenting information in understandable manner. Organizations usually
prefer to prepare reports on weekly, monthly and annually basis so that analysing data can
provide crucial factors to identifying prevailing irrelevant actions that can be eliminated in order
to have proper processing (Irafahmi and Williams, 2021). It provides users to get the proper
functioning by making reports with help of present features for deriving accurate & fair reports
in turn ascertainment of financial as well non monetary aspects can be recognised to boost
organizational performance.
The most crucial functions which are largely taken into practice are pivot table, v and h
lookup, conditional formatting, etc. Pivot table is used to summarize large data into short
manner. In addition to this, pivot table chart provides advanced patter of reflecting data set in
easily manner (Dunbar, 2020). Conditional formatting is as well one of the function utilized
analytics as it gives ability to provide information by highlighting according to set standard. In it
less or more than and equals requirement can be set to derive the data highlighted which aids
in formulating decisions in quicker manner. In addition to this, v & h look refers to vertical and
horizontal for looking information available in particular column and row respectively.
Irrespective of scale of operations conducted by companies these function largely contribute in
evaluating data in proper pattern. IF function gives ability to as well find that the particular
result or statement is true or false in turn less time need to be incurred for having accurate
assessment.
In organizational practices there are various changes occur due to different factors
which are required to focused for removing those practices that are not largely contributing in
success (Raubenheime, 2017). Excel can be used by firm to identifying prevailing trend by
setting relationship with various variables. There are distinct manner to reflect the data in
presentable manner like graphs, pie chart, etc so that visualization of complex data set can be
done in easy manner. In order to create pivot tables specified firm can take following steps:
 In order to create pivot table user is required to go to insert tab in which specific icon
will be reflected that will show a pop up will appear. Selection of table or range of data
will be done automatically as there is default feature in built in excel (Pivot Tables,2021).