Data Handling and Business Intelligence

DATA HANDLING AND
BUSINESS INTELLIGENCE
1

TABLE OF CONTENTS
TABLE OF CONTENTS................................................................................................................2
PART A...........................................................................................................................................3
Evaluate the use of Excel for pre-processing the data, analysing the data and visualising the
data...............................................................................................................................................3
PART 2............................................................................................................................................7
2.1................................................................................................................................................7
2.2 Describing the most common data mining methods............................................................13
2.3..............................................................................................................................................14
Advantages and disadvantages of SPSS over Excel..................................................................14
REFERENCES..............................................................................................................................17
2

PART A
Evaluate the use of Excel for pre-processing the data, analysing the data and visualising the data
Excel is utilized for various purposes in turn ability to accomplish the objectives can
become successful. Data processing is the procedure which is concerned with converting the raw
information is understandable manner. The reason behind it is to get the ability to have analyse
data in order to formulate appropriate decision. There are several features available in excel that
provides assistance in exerting data mining, analysing and decision making procedure efficient.
Use of excel in data processing become possible due to presence of different kind of
features such as is number, find, mid, if error, if, trim, count blank, etc. These widely contribute
in achieving ability identify the relevant pattern, lacking areas so that strategic decision can be
formulated (Irafahmi and Williams, 2021). Data analysis is concerned with evaluating each
segment of provided data to have sufficient & reliable kind of information for gaining accuracy.
Spreadsheet is great tool for fitting solutions as it emphasizes on extracting actionable insights.
This allows to get the various advantages to establish relationship so that relevant pattern can be
identified. It organizes the raw data into readable format that permits the user to customize field
and functions for gaining proper visualization. Full scale data product can be built by applying
any of the suitable function into cells which allows to obtain proper format that can be visualized
by using different displaying tools like charts, etc. in order to match the changing requirement
of customers excel pay attention on upgrading its features which is highly beneficial for users.
Data analysis can be done by applying pivot table tool available in excel which provides
assistance in making large statistical into desirable manner. Establishing relationship can be done
by users through taking data analytical tool pivot table, graph, harts, etc. These mentioned
course of action allows to convert the data in organized and analyzable structure so that relevant
interpretation can be done. In excel there is availability of features like sorting, conditioning
formatting, filter, what if analysis, solver, etc. that permits the company to convert data
according to requirement. Advance excel play crucial role in all functional areas of organization
which allows to get significant amount of efficiency and accuracy. Report formulation by
utilizing the specified manner of tactics available in excel which provides different kinds of
aspects that are essential in obtaining higher level of accuracy & efficiency in turn strategic
3

decision can be taken. It is essential for the companies to draw conclusion regarding data via
utilizing advance analytical tool like excel for having ability to make proper strategic decision.
Excel is powerful and flexible tool used for analytical activity to get broad data
evaluation and visualization capabilities. For the purpose of presenting data graph, charts play
crucial role in reflecting complex and critical information in understandable manner. Making
comparison via setting relationship among two or more variables through graphical presenting
chart and bars can be exerted in effectual manner (Dunbar, 2020). From the evaluation it can be
articulated that company of any scale can use excel in order to make proper evaluation and
analysis of the projected data. In addition to this, it can be evaluated that companies in order to
make proper evaluation via conducting data analysis via taking the excel tool into practices.
These can give several different kinds of pros to organization which includes best way to store,
transform, clean, visualize, etc. which largely contribute in making appropriate decision. Data
analysis can be done by firm for making evaluation of market trends, competitors performance,
time consuming, proper integration, implication, streamlining, etc.
In excel there are several functions which can be used by companies to make proper
evaluation in turn higher productivity and profitability via considering the significant
components through identifying with help of available options. There are certain options in
excel that ensures accuracy and reliability which motivates the different kinds of users to utilize
this tool. These benefits can help in having capabilities of achieving the desire level of
information that can contribute in maximizing profitability & sales.
Pivot table can be sued by organization to have proper evaluation and analysis sales and
profit. It is widely sued by business analyst and other users to have proper ability to make
evaluation of vast static data to summarize, analyze and interpret in significant manner. It is one
of the systematic procedure that advanced features which enables user to get efficiency in
arranging data according to requirement (Harvey, 2018.). It includes few steps which can be
used to get guidance for making comparing of prevailing trends. The steps are as follows:
 Click on the cells of table range and then go to insert option available in the ribbon of
excel in next to home tab.
 In the next step pivot table option will be displayed which need to be selected in order to
obtain summarize data. For creating pivot table two questions will appear in form of
4