Data Handling: Trends in Data Warehousing, Business Intelligence, and Data Mining

DATA HANDLING
1

Table of Contents
INTRODUCTION...........................................................................................................................3
PART 1............................................................................................................................................3
Current trend in data warehousing, business intelligence and data mining...........................3
For pre-processing and determining the data uses of excel are evaluated.............................4
PART 2............................................................................................................................................7
2.1 Providing the conjunction with Weka through an example.............................................7
2.2 Explain the most common methods associated with data mining which are used by the
organization............................................................................................................................9
2.3 Critically evaluating the advantages and disadvantages of Weka over Excel................10
CONCLUSION.............................................................................................................................11
REFERENCES..............................................................................................................................12
2

INTRODUCTION
\ Data handling is considered to be as one of the most effective platform which is very
beneficial in storing and disposing off the information within the safe and secure manner. As it
is one of the most important measure which used to help them in handling the different large set
of data effectively in the organization (Obeidat, and et.al., 2015). This report has explain
Different trend which are generally prevailing in data warehousing, business intelligence and
data mining in the current scenario. Report will also highlight the use of excel for pre processing
and data determining in the organization. After that in the second part of the report explains the
different advantage of Weka over excel in the organization. Also, report explain common
methods associated with data mining.
PART 1
Current trend in data warehousing, business intelligence and data mining
There are many different type of trends which are generally prevailing in context of Data
warehousing, business intelligence and data mining in the organization. This eventually used to
help Organization in achieving the different goals and objective very efficiently in an
organization. This trend are very important for the business to look at this trend as this trend will
help the organization in making the variety of the decision in regards to data collection, analysis
and interpret data which generally provide good basis for decision making in the company.
Data Warehousing: Data warehousing as the name suggest is the name of process which
used to help in constructing and effectively usage of data warehouses in an organization. This
process generally help on achieving the different goal and objective of the business very
effectively in an organization, as data warehousing used to help in taking different decision very
effectively in an organization (Vanani and Jalali, 2017). Data Warehouse generally used to help
the organization in analysing and understand complex data in the organization as it used to
provide important information regarding the technology in the market. At the same time it used
to help organization in protecting the complex data in the nation as warehousing used to play a
very crucial role in enhancing the practice of an organization.
Business Intelligence: It is the process in the organization which is generally used by the
organization to convert the raw data into meaningful information. Business intelligence software
in the organization generally help the organization in creating different relevant, important and
3

value out of large amount of complex data of an organization. As it is very important for all the
organization to make different decision correctly in the organization, Business intelligence
generally help the manager in the organization to improve the quality of different decision which
are made in an organization. Business intelligence is generally preferred by the firm as it help in
reducing cost and attaining economies if scale for the organization in the long run. There are
many different benefit which is provided by the Business intelligence for the organization to see
a good amount of the growth as well as open up opporurtunity for development, as business
intelligence used to help in identify different error in the process. There are many different type
of the trend in data intelligence trend, data quality management is one of the same as it has been
identified that for carrying out different data intelligence work in the organization machine
learning and artificial learning are two trend which are present and associated with business
intelligence and analysis (Sathiyamoorthi, 2017).
Data mining: Data mining is one of the process in the organization which is used for the
purpose of using raw material and collect important information from the data which has been
collected. It is one of the most prominent way of collecting different information which can be
used by the organization in finding out the solution of the different issue which is being seen by
the individual in the market. It generally help the organization in solving the variety of complex
information very prominently in an organization. There are many different type of the trend
which are prevailing in the Data mining. Some of the trend which are commonly seen in the data
mining are multi media data mining, as it generally collects the raw data from various sources
and present in different numeric form in organization.
For pre-processing and determining the data uses of excel are evaluated.
Excel is generally used in the organization to present the data in more accurate way in the
organization, as with the help of excel organization can record and analysis the different data in
better way to get more accurate outcome of the same. Excel also can help the organization in
understanding the numerical values as this application used to help the organization in
understanding the reason behind decline in sales and profit of different superstore. As a result to
determine the answer of the reason which has been identified this software is generally used in
an organization (Choi, Chan and Yue, 2016).
4