Data Handling and Business Intelligence

This document provides an in-depth analysis of data handling and business intelligence. It covers the tasks performed by Microsoft Excel, analysis and evaluation methods, advantages and disadvantages of SPSS, and more. The document also includes a descriptive analysis of rice consumption and gender, as well as the age group eating more rice.

Data handling and
business intelligence

Table of Contents
INTRODUCTION...........................................................................................................................3
PART 1............................................................................................................................................3
1. Identification and evaluation of the tasks that are performed by Microsoft Excel in pre-
processing, analysing, and visualising the data of a particular firm including examination of
the functions that it performs .....................................................................................................3
PART 2............................................................................................................................................7
2.1 Using the nutrition.csv provided in conjunction with SPSS give a specific example of
clustering. Show your workings with screenshots and explain you results................................7
2.2 Analysis and evaluation of the different methods that are used in common data mining and
relating it with the current market examples that are prevailing in the present scenario..........11
2.3 Advantages and disadvantages of SPSS over MS Excel....................................................13
CONCLUSION..............................................................................................................................13
REFRENCES.................................................................................................................................14

INTRODUCTION
Data handling is the process by which data is arranged in appropriate, systematic and
sequential manner. This is one of the most appropriate aspect within current scenario which
makes business to grow and prosper within market. Also due to this damage and disruption of
operations can be done within an organization, if not used in effective or efficient manner. Smile
clinic is an firm that operates within the industry of science since a considerable amount of time
and makes capturing of market in better manner with loyalty of customers base. In this report
things to be covered is based upon brief discussion of the organization which covers those
aspects in which value is presented within time. Further in this report various topics is been
covered that is related to Microsoft Excel and operations to be performed by the organization
for its well being in market. So, as to make sustainability in industry to be developed over long
period of time over its competitors that is prevailed within market. Further this report also covers
Excel’s importance in the company so that it can perform its activities in an appropriate manner.
PART 1
1. Identification and evaluation of the tasks that are performed by Microsoft Excel in pre-
processing, analysing, and visualising the data of a particular firm including examination
of the functions that it performs
Excel has various kinds of functions to be performed and makes an organization carrying
out its daily transactions in more effective manner so as to increase market value of an
organization in long turn. The main function of it is to help in storing and evaluating of facts,
figures within a business. This makes sustainability to be developed within market that helps in
taking better decision which makes market value to be increased with operations. Various
functions of Microsoft Excel are elaborated below-
 Analysing and storing data- It is one of the most important functions of Excel which
makes analysis, evaluation and helps in storing of relevant data in finest manner possible
for an organization over requirements to be fulfilled. This makes problems to be solved
over objectives and goals set by an organization. Different tools and techniques is to be
used over figures more accuracy within future and is helpful for firm (Zhou and et. al.,
2020).

 Data recovery- Also storing of data in Microsoft Excel is to be restored at times
according to the needs of the organization. In this process data lost of deleted can be
recovered which provides market environment with high competitiveness been developed
through dynamic nature in an organization.
 Making report- Reports can also be formed in Microsoft Excel which makes impact
with the help of various tools by prevailing over current market scenario and available
within it. This proves to be beneficial with the help of monitoring data that helps in
analyzing of data so as to remove errors and rectification to be needed within various
process of organization.
 Research- These are those essential elements with new aspects to be evaluated with the
help of Microsoft Excel for doing of research in more effective manner. This adds value
to market in an organization and makes it attain long terms success by improving
performance with productivity of firms. Also it makes sustainability to be developed
within more effective way possible. Through this value is added to organization in long
run by improving performance and productivity (Villar and et. al., 2018).
 Conditional formatting- Various things has to be formatted over things that has to be
done with perfection in Microsoft Excel according to requirement and demand of an
organization's owners. This is helpful in making adjustments to be applied within
working business over providing benefit to the firm form its view point for attaining
success.
 Security- As the facts and figures which are been stored in Microsoft Excel holds
importance towards firm with currently working in industry and aspects of security.
Excel provides all the information in effective and disciplined manner. Security cannot be
breached easily and thus provides for all necessary measures over enterprise and willing
to sell information to be stored with confidentiality. This means that data that has store is
secured and no information can be leaked or stolen of the enterprise with high
confidentiality matter.
Evaluating and analysing the use of IF function in Microsoft Excel- In this comma is also
included and divided into three parts that is known as IF features or IF declaration. Functions
that is been performed by it has been explained as follows:

 This helps in making analysis with evaluation to be performed within an organization
while developing revenue and income which is based through indicating level of sales
which is been achieved as per time period provided for it. This helps in making decision
process to be done in simple with step to be followed.
 Apart from that all the old figures that are stored in it can be rearranged so that new data
can be generated which can drastically improve and increase the value of the company in
the market in which it is performing (Vallurupalli and Bose, 2018).
Uses of the IF Element form- There are various kinds which has been discussed as follows:
 Form code can be shaped with the help of it.
 The codes of various cells are to be restrained and check again for removing copying of
work to examine and fulfilling needs with requirements or not.
Various functions have to be revealed with significance of B3 that makes importance to be
attained over value of B3 which is less then B3's variable. It indicates those parameters used in
B1 that the IF parameters is very important than B3 as function is seen. User which makes
operating to be obtained over cell which is B4 file when enter key is pressed. For seeing impact
of its users’ transfer is handled from D4 to cell D8400.
If there are application and user is required to learn about H Lookup and V Lookup factors in
elaborative manner. That is why firstly they should not be confused weather buyer wants it as an
important skill or not. Thus user is considered about all the things in detail if operating is being
done with minimum number possible. This is going to take long for locating and everything in
the data over extension of search (Singh and et. al., 2018).
Lookup Value- It is based upon quest of row that has afterwards development of base row
to the lookup value.
Table series- Series of table is helpful in storing the data with relevant forms within table
series.
Row index number- The number is shown after the sum up of numbering done after the
first row that is numbered as 1 and so on.
[Range_ lookup]- Since there are two sets in table and has to make sure that which one is
correct and which is not correct. In this only this is included.
Evaluation and analysis upon functions which makes lookup over references over scale of an
organization within which Smile clinic has been explained with the help of Microsoft as follows:

Lookup Value- Whether it is column or row input is taken that is generally a question which
provides answer over appropriate format after making examination of factors to be done in
detail. For time requested, selling and revenue various cell is being used that is G2, H2 and I2.
G3, H3 and I3 has to be obtained. Pick the Lookup and then set the cell H3 by using the Lookup
key as G3 cell (Mashingaidze and Backhouse, 2017).
Table series- Choose from A2 to C8400 (A2:C8400) for the whole set.
[Range_ lookup]- Select cell to be purchased, B2 to B8400 (B2:B8400).
Graphs and Charts- Different steps is being included within it and has been explained in
consecutive manner as follows:
Step1- A cell is picked so as line graph is to be prepared according to it with appropriateness.
This is the very first step that has to be followed for making graph and charts.
Step2- Choosing graph which is having line format within it is essential for making visibility to
increase. This is helpful in making data to be seen in appropriate manner possible.
As it can be observed in very clear way that from the above graph that profit in an
organization is maximum in the year 2009. Also it can be observed that fluctuations has taken
place during these years through constant ups and downs within an organization. That is why

organization has faced losses at time during the time it doing business (Kumar and Belwal,
2017).
Row
Labels
Sum of Order
Quantity
Sum of
Discount
Sum of Unit
Price
Sum of Shipping
Cost
2009 54508 105.39 232830.98 28481.76
2010 54379 105.81 162467.59 27354.26
2011 51413 101.67 159653.11 24939.85
2012 54480 104.32 195467.55 27055.17
Grand
Total 214780 417.19 750419.23 107831.04
The above table shows that how organization's profit and loss has been fluctuated from
time to time. This table has given clear information about sum of order quantity, sum of discount
, sum of price and sum of shipping cost.
Correlation was done using excel tool
Order
Quantity Discount
Unit
Price
Shipping
Cost
Sale
s
Order Quantity 1
Discount
0.92406
8 1
Unit Price
0.58372
5 0.229051 1
Shipping Cost
0.98981
3 0.969073 0.462179 1

Sales
0.85462
1 0.591255 0.920471 0.77
PART 2
2.1 Using the nutrition.csv provided in conjunction with SPSS give a specific example of
clustering. Show your workings with screenshots and explain you results.
Descriptive analysis
Relation between rice consumption and gender
Statisti
cs
Gender Rice
N Valid 100 100
Missing 9 9
Mean 1.50 .60
Median 1.50 1.00
Mode 1a 1
Std.
Deviati
on
.503 .492
Range 1 1
a.
Multipl
e modes
exist.
The
smallest
value is
shown

Gender
Frequency Percent
Valid
Percent
Cumulativ
e Percent
Valid 1 50 45.9 50.0 50.0
2 50 45.9 50.0 100.0
Total 100 91.7 100.0
Missing System 9 8.3
Total 109 100.0
Rice
Frequency Percent
Valid
Percent
Cumulativ
e Percent
Valid 0 40 36.7 40.0 40.0
1 60 55.0 60.0 100.0
Total 100 91.7 100.0
Missing System 9 8.3
Total 109 100.0
Interpretation: The values above shows that average mean of gender is 1.60 and rice is 0.6 which
states that all gender types are consuming the rice. The Std.d for both rice and gender is above
and approx. the standard value such as gender 0.538 and rice 0.493 which defines that
consumption of rice is done by both men and women (Zulfiqar and et. al., 2019).
Descriptive analysis between consumption of rice and the age group eating more rice
Statistics
Rice Age
N Valid 100 100
Missing 9 9
Mean .60 20.35
Median 1.00 19.00

Mode 1 22
Std.
Deviation .492 3.560
Range 1 13
Rice
Frequency Percent
Valid
Percent
Cumulativ
e Percent
Valid 0 40 36.7 40.0 40.0
1 60 55.0 60.0 100.0
Total 100 91.7 100.0
Missing System 9 8.3
Total 109 100.0
Age
Frequency Percent
Valid
Percent
Cumulativ
e Percent
Valid 13 5 4.6 5.0 5.0
15 5 4.6 5.0 10.0
17 8 7.3 8.0 18.0
18 13 11.9 13.0 31.0
19 20 18.3 20.0 51.0
20 5 4.6 5.0 56.0
22 21 19.3 21.0 77.0
23 1 .9 1.0 78.0
25 12 11.0 12.0 90.0
26 10 9.2 10.0 100.0
Total 100 91.7 100.0
Missing System 9 8.3
Total 109 100.0
Result- As per the table above it has been determined that each age group is very much
founded in eating rice as the basic food for their survival as it is one of the easiest dish to be

cooked in less time (Kiani Mavi and Standing, 2018). The value of standard deviation is 3.52
which clearly states that peoples of almost every age eat rice whenever needed.
Some of the other important statistical test are performed below which help in determined
the positive relation between selected variables:
Anova analysis between age and gender:
Correlation analysis:
One sample test
One-
Sample
Statistics

N Mean
Std.
Deviation
Std. Error
Mean
Gender 100 1.50 .503 .050
Rice 100 .60 .492 .049
One-
Sample
Test
Test Value
= 0
t df
Sig. (2-
tailed)
Mean
Difference
95%
Confidence
Interval of
the
Difference
Lower Upper
Gender 29.850 99 .000 1.500 1.40 1.60
Rice 12.186 99 .000 .600 .50 .70
2.2 Analysis and evaluation of the different methods that are used in common data mining and
relating it with the current market examples that are prevailing in the present scenario
Various methods have been used within data mining that has been discussed in brief manner
possible:
Data mining technique- This is one of the most crucial technique that helps in making
different kinds of classification, associated rule of learning, anomaly or making outline detection
with evaluation of cluster possible. It is regression within nature and mainly three steps are
involved and such techniques has been explained as follows in detail:

 Exploration- This is step that is particular information or data that has been transformed
over clearing results that has to be analysed in more efficient manner (El Bousty and et.
al., 2018).
 Pattern Recognition- As per the step strongest pattern has been evaluated and making
analysis by making market value of the firm to be increased in long term.
 Deployment- In this appropriateness and effectiveness has been deployed that helps in
improving performance of business.
Data mining technique- It is one of the most important technique that is helpful in making
growth of business possible with framework that makes an organization gain sustainability.
Further various division is done over parts through using various sub techniques which is
involved within the process and has been explained as follows:
 Statistical Techniques- These techniques are related to those statistic data within an
organization that makes value of the organization uplifted as per current circumstances in
market. In this future prospectus has helped in making analysis from future perspective
by making various aspects to be covered in it and is explained as follows:
What are current trends in data network?
For how many occasions it can take place?
What Patterns that is required to be carried and is important from firm's point of view?
What description is being found upon high level of things that is to be found in documents?
 Clustering Techniques- As per the technique clusters has been formed on the basis of
attaining similarity for making determination done in easy manner possible (Chaturvedi,
Mishra and Mishra, 2017). This is done according to requirements of business and
involves methods which is as follows:
Hierarchical methods
Model based methods
Divisional methods
Grid based methods
Destiny methods

 View- This is one of the most effective technique which is been used by an organization
in order to attain growth within long term perspective. Under it details are involved by
making elaborative analysis with evaluation of latest methods required for making
adjustments within near future possible.
 Induction Decision Tree Technique- In this technique like tree format is been used for
making aspects covered upon making sustainability to be reduced within time required
for decision making and makes focus to be developed on single issues.
 Neural Network- These techniques are related over using artificial intelligence and
technology which includes human beings up [on various aspects to be studied in detail
and depth that add value to firm by making long term success to be gained. Various
factors have been explained as follows:
Way nodes are included within it?
What is the amount of units that has to be produced?
When training is going to get completed?
 Association Rule Technique- As per this technique there are two factors which is
associated with each other by making evaluation of the aspects to be covered within it
(Batra, 2018).
2.3 Advantages and disadvantages of SPSS over MS Excel
SPSS is a technical characteristic which might be more demanding for all observation that
actually requires a specialised procedure it includes R amount and other knowledge that may
beneficial in making useful results. Some of the advantages and disadvantages over excel are as
follows:
Advantages: SPSS is considering to be a simple and user software which help in making
valuable reliable and quick outputs for large range of data which help in making decision or
interpreting the research problems or questions.
Disadvantages: The major disadvantage of SPSS is that many time the data results are so
much confusing that can lead to wrong decision because of misleading figures (Banerjee and
Mishra, 2017).

CONCLUSION
From the above discussion it can be concluded that Microsoft Excel is having different kinds
of tools and techniques that has to be possessed by an individual to learn it. It holds importance
for each organization with its operations as per the current scenario. Also it holds various
advantages and disadvantages. Though its advantages are more than its disadvantages which
makes it better as a tool to be used in an organization.

REFRENCES
Books and Journals
Banerjee, M. and Mishra, M., 2017. Retail supply chain management practices in India: A
business intelligence perspective. Journal of Retailing and Consumer Services. 34.
pp.248-259.
Batra, D., 2018. Agile values or plan-driven aspects: Which factor contributes more toward the
success of data warehousing, business intelligence, and analytics project
development?. Journal of Systems and Software. 146. pp.249-262.
Chaturvedi, S., Mishra, V. and Mishra, N., 2017, September. Sentiment analysis using machine
learning for business intelligence. In 2017 IEEE International Conference on Power,
Control, Signals and Instrumentation Engineering (ICPCSI) (pp. 2162-2166). IEEE.
El Bousty, H and et. al., 2018, June. Investigating business intelligence in the era of big data:
Concepts, benefits and challenges. In Proceedings of the Fourth International
Conference on Engineering & MIS 2018 (pp. 1-9).
Kiani Mavi, R. and Standing, C., 2018. Cause and effect analysis of business intelligence (BI)
benefits with fuzzy DEMATEL. Knowledge Management Research & Practice. 16(2).
pp.245-257.
Kumar, S.M. and Belwal, M., 2017, August. Performance dashboard: Cutting-edge business
intelligence and data visualization. In 2017 International Conference On Smart
Technologies For Smart Nation (SmartTechCon) (pp. 1201-1207). IEEE.
Mashingaidze, K. and Backhouse, J., 2017. The relationships between definitions of big data,
business intelligence and business analytics: a literature review. International Journal of
Business Information Systems. 26(4). pp.488-505.
Singh, A and et. al., 2018. Bloom filter based optimization scheme for massive data handling in
IoT environment. Future Generation Computer Systems. 82. pp.440-449.
Vallurupalli, V. and Bose, I., 2018. Business intelligence for performance measurement: A case
based analysis. Decision Support Systems. 111. pp.72-85.
Villar, A and et. al., 2018. Integrating and analyzing medical and environmental data using ETL
and Business Intelligence tools. International journal of biometeorology. 62(6).
pp.1085-1095.
Zhou, C and et. al., 2020. A data-driven business intelligence system for large-scale semi-
automated logistics facilities. International Journal of Production Research. pp.1-19.
Zulfiqar, M and et. al., 2019, December. Use of Macro/Micro Models and Business Intelligence
tools for Energy Assessment and Scenario based Modeling. In 2019 4th International
Conference on Emerging Trends in Engineering, Sciences and Technology
(ICEEST) (pp. 1-7). IEEE.