Data Handling and Business Intelligence - Smile Clinic

Data Handling and business
intelligence - Smile clinic

TABLE OF CONTENTS
INTRODUCTION...........................................................................................................................1
PART 1 ...........................................................................................................................................1
PART 2............................................................................................................................................5
2.1 Specific example of clustering...............................................................................................5
2.2 Common data mining methods with examples......................................................................8
2.3 Advantages and disadvantages of SPSS over excel...............................................................9
CONCLUSION..............................................................................................................................11
REFERENCES..............................................................................................................................12

INTRODUCTION
Business intelligence combines the data mining, business analytics, data visualisation,
data tools and the infrastructure and the best practices for helping organisation to make the data
driven decisions. BI had strangled history as the buzzword. The traditional BI, capital letters and
others were developed as sharing information system. More than specific BI covers methods and
processes for storing, collecting and analysing the data from the business operations or the
activities for optimising performance. It helps the business in better decision making by
presenting the historical and current data within business context. The analysts could leverage
the BI for providing performance and competitors the benchmarks for making organisation to
run more efficiently and smoother. Businesses are using data handling processes and BI for
identifying the ways through which it could increase the profits analysing customer behaviour,
tracking performance and optimising the operations and several other business issues. Present
report will discuss about the different data mining tools and techniques of Smile Clinic using the
different tools like excel and SPSS. It would provide how visualisation helps in making data
easier and simpler to understand by the different users.
PART 1
Presentation of Data using Pivot table
Pivot table in the excel is an important tool which is used to sort, summarise, group,
reorganise, or to compute average of the data stored in table. It allows the users in transforming
rows to columns and vice versa. It also allows the grouping by field and using the advanced
calculation over them (Sun, Sun and Strang, 2018). It is statistical tool which is used by the
business to make various decisions and also to summarise the large data sets into groups so that
they could be presented in the graphical format properly.
2009
Delivery Truck Express Air Regular Air Total
Average of
Sales
Average of
Profit
Average of
Sales
Average of
Profit
Average of
Sales
Average of
Profit
Average of
Sales
Average of
Profit
5373.84 230.91 1202.55 148.97 1199.48 177.07 1775.87 181.18
Analysis
1

From the above table it could be assessed that smile clinic had average sales in 2009 is
1775 and the profits earned are 181. The average sales through the delivery trucks are 5373 and
profits of 230. It had sales from the express air of 1202 and the profits of 148 are earned. On the
other sales by regular air has been 1199 and the profits are 177.
2010
Delivery Truck Express Air Regular Air Total
Average of
Sales
Average of
Profit
Average of
Sales
Average of
Profit
Average of
Sales
Average of
Profit
Average of
Sales
Average of
Profit
5042.86 240.93 1276.68 198.05 1091.58 153.04 1662.82 170.44
Analysis
It could be seen that the total average sales in year 2010 were 1662 and the profits 170.
Considering the sales from individual department it could be evaluated that the Regular air sales
were 1091 and profits are 153. Express air had the sales from express air as 1276 and the profits
at 240. While the delivery truck has sales are 5042 with profits of 240.
2011
Delivery Truck Express Air Regular Air Total
Average of
Sales
Average of
Profit
Average of
Sales
Average of
Profit
Average of
Sales
Average of
Profit
Average of
Sales
Average of
Profit
5634.58 351.99 1000.05 114.97 1145.92 175.42 1716.69 190.35
Analysis
It could be seen that the delivery truck had the profits of 351 and the sales of 5634.
Express truck had the profits of around 114 and the sales of 1145. and the profits from 175 where
the sales are of 1145. Computing the total average sales of the business were 1716 and the
profits of 190. The average total sales and profits have increased as compared with previous
years which shows there has been growth.
2012
2