Business Intelligence: Data Analysis and Visualization with Excel and SPSS

Business Intelligence

Contents
INTRODUCTION...........................................................................................................................3
Part 1................................................................................................................................................3
Decline in sales over the years with data analysis.......................................................................3
Pre-processing analysis and data visualising with excel.............................................................5
PART 2............................................................................................................................................7
Number of customers of smile clinic who eat rice in their daily meal for healthy diet...............7
Number of male and female customers of Smile clinic.............................................................10
Mean and median value of age of Smile clinic customers........................................................12
K mean clustering......................................................................................................................14
Different data mining methods, used by real world businesses.................................................15
Advantages and disadvantages of using excel and SPSS..........................................................16
CONCLUSION..............................................................................................................................16
REFERENCES..............................................................................................................................18

INTRODUCTION
Business intelligence can be known as technical infrastructure that helps companies in
collecting, analyzing and storing big data an improving decision-making process (Marian and
et.al., 2018). This study is going to discuss effectiveness of Microsoft excel tool and ways in
which it can help employees in analyzing and visualizing data. It will identify declining in sales
of superstore with the help of excel. Further, it will discuss effectiveness of SPSS software and
ways in which it can help employees in knowing relation between two factors and knowing the
number of females and males that have visited smile clinic for dental treatment. On the basis of
data analysis and making use of SPSS as well as excel, it becomes easier in taking decision and
providing better suggestions to customers.
Part 1
Decline in sales over the years with data analysis
Years Sales
2009 4209896
2010 3560087.04
2011 3429944.98
2012 3715671.65

Interpretation: Superstore wanted to know its sales of 2009-2012. The main reasons of knowing
sales is to take actions for improving sales as it can help it out in knowing decreasing in sales and
increasing in sales. Accordingly, it can know some reasons of decline as well as increasing in
sales. On the basis of reasons, it can take better decisions of taking actions for improving sales.
As this superstore operates to the great extent and have big data. It becomes difficult to analyse
big data but excel has number of great features and this feature has been used for analysing its
big data and knowing sales of this superstore of 2009-2012. On the basis of above graph, it can
clearly be said that sales in the year of 2010 declined. As compared to 2009, sales of superstore
decreased to 649809. It is the huge decline in sales. It is important for this superstore to identify
all those factors that has declined its sales (Pingping, 2017). There are number of internal and
external factors that may affect sales and performance of company. Internal factors can be
identified with number of ways. Feedback from customers and employees can be known as one
of the best ways. By doing so, superstore can know all those areas where it needs to make
improvements. It can help this superstore in increasing sales by improving all those areas in
which it is lacking behind. Along with this, it can make use of SWOT analysis. It can help this
superstore out in identifying internal factors that may create barriers in accomplishing goals.
With SWOT analysis, it can identify its own strengths, weaknesses, opportunities and threats as
well. Overall, it can be said that data analysis can help this supermarket out in increasing sales by
identifying reasons of decline in sales.
As compared to 2010, sales in 2011 again declined to the great extent. In 2010, sales of
this supermarket were: 3560087 and in 2011, it declined and sales were: 3429944. Sales declined