DATA HANDLING AND BUSINESS INTELLIGENCE-2

DATA
HANDLING

Table of Contents
PART 1............................................................................................................................................3
1. Use of excel of pre-processing the data...................................................................................3
Use of IF function in Excel......................................................................................................4
Lookup.....................................................................................................................................5
Charts and Graphs....................................................................................................................6
PART 2............................................................................................................................................7
2.1 Using the smile_clinic.csv give a specific example of clustering.........................................7
2.2 Explain the most common data mining methods that can be used in business with real
world examples............................................................................................................................8
2.3 Advantages and disadvantages of SPSS over excel............................................................12
REFERENCES..............................................................................................................................13

PART 1
1. Use of excel of pre-processing the data
Microsoft Excel is utilized in business, for entrepreneurs, for housewives, for information
examination, in day by day progress reports, in profession advancement, in business. MS Excel
is broadly utilized in monetary exercises. The employments of Microsoft Excel are as per the
following:
1. Dissecting AND STORING DATA
Microsoft Excel is a superb apparatus for examining and putting away information in a
framework structure. It is permitted to enter information in different lines and segments of the
accounting page. Utilizing pie diagrams, outlines, tables adds mining to the information
(Pashazadeh and Navimipour, 2018).
Dominate can be utilized to bring information from various records and archives. You can store
the information in a deliberate manner. Doing this will help us save a great deal of time, aside
from this, the translation gets simpler for you to store the information. Isn't arranged makes
breaking down information simpler with the assistance of Pivot table.
2. Information RECOVERY
Microsoft encourages you recuperate your information if your information is lost. MS Excel
design causes you reestablish information.
3. MAKING REPORT
Reports should be possible with the assistance of MS Excel and MS Word MS Word gives the
report in a composed structure, while MS Excel gives the report in a table organization. MS
Excel can give correlations with various clients all at once.
MS Excel helps proprietors organizations report their business, however it additionally assists
workers with following their day by day progress reports, it likewise assists educators with

utilizing outlines, styles, shapes, recipes to help their understudies Helps to instruct, feature
significant cells and without a doubt (Young-Saver, and et.al., 2018).
4. Exploration
We normally take a gander at past patterns in greatness, yet greatness likewise causes us to finish
our exploration for what's to come. Following a couple of years what the situation will be for
sure on the off chance that we can accomplish our work along these lines. Exploration helps
answer your inquiry concerning what will occur and what will occur.
Through different recipes and past patterns, we can make prospects about our future. As
indicated by this examination work done by organizations, arranging and advancement will be
done (Hong, and et.al., 2019).
5. Restrictive FORMATTING
The utilization of restrictive arranging causes us to stamp exceedingly significant figures.
Contingent organizing likewise encourages us discover issues where we need to feature it. It can
likewise help in looking at changed qualities, in discovering copies.
Use of IF function in Excel
The IF work or IF explanation in dominate is comprised of three sections isolated by a comma.
Condition
 What to show when the condition is met
 What to show if the condition isn't met
In this model, we will discover on which date deals and benefit declined and on which date
increments from superstore deals 2, and afterward perceive how to make the "IF Function" bit by
bit.
 Most importantly reorder date of request, deals and benefits on independent sheet.
 Presently modify the information taking old date first through arranging capacity of
dominate sheet.
 Select the cell where you need to make the "IF Function".