Page 83 - ICDEBI2018

International Journal of Trend in Scientific Research and Development (IJTSRD) ISSN: 2456Trend in Scientific Research and Development (IJTSRD) ISSN: 2456Trend in Scientific Research and Development (IJTSRD) ISSN: 2456-6470 | IF: 4.101

or a product seller can use it to predict the movement or a product seller can use it to predict the movement l language. Here the transformed data is having anguage. Here the transformed data is having
of product prices, or it can be used to detect trends of product prices, or it can be used to detect trends different coding, quality than the source data.quality than the source data.
such as in banks if a manager wish to recognize the er wish to recognize the Non-relevant (repeat & missing) data are relevant (repeat & missing) data are
most profitable customers, or alert a credit card most profitable customers, or alert a credit card excluded. The data warehouses technology is The data warehouses technology is
customer to a probable fraudulent charge. Thus the customer to a probable fraudulent charge. Thus the subject-oriented, integrated,integrated, time-variant and non-
volatile collection of data which supports the olatile collection of data which supports the
business analytics help in answering many questions business analytics help in answering many questions v
such as what will happen if the demands of products demands of products management’s decision-making process [10].making process [10].
decrease. Or if suppliers’ prices increaseincrease, what is the
risk to lose money in a new business? 3. Data Analysis/Application layer Data Analysis/Application layer
I It consists of tools which are used for analysis of t consists of tools which are used for analysis of
Structure of Business Analytics integrated data. This analysThis analys is identify trends,
patterns and exceptions also.atterns and exceptions also. OLAP (Online
The organization has to understand the business need p
A
thoroughly so that the state of the art solution can be thoroughly so that the state of the art solution can be Analytical Processing databases) are used to nalytical Processing databases) are used to
p
found out. BA is not a common solution to a business common solution to a business process the data and provides different point of rocess the data and provides different point of
problem but varies according to the individual problem but varies according to the individual v
view from all angles of the same data.iew from all angles of the same data. Sales data
business need. Data mining is part of Business Data mining is part of Business c
can be collected within one particular territory,an be collected within one particular territory,
intelligence functionalities as defined by Gartner who intelligence functionalities as defined by Gartner who within a limited time frame and of a particular me frame and of a particular
product or product line.roduct or product line. The most significant
described BI as a software platform delivering 14 described BI as a software platform delivering 14 p
capabilities divided into three three groups groups of of c
component of the application layer is data mining omponent of the application layer is data mining
functionalities including integration, information functionalities including integration, information a computational process involving the discovery computational process involving the discovery
a
o
delivery and analysis functionality which contain the delivery and analysis functionality which contain the of patterns in large data setsf patterns in large data sets [11] .It involves using
methods that are at the inteethods that are at the intersection of artificial
data mining and predictive modeling. m
intelligence, machine learning, statistics, and ligence, machine learning, statistics, and
While data mining is considered as the automated While data mining is considered as the automated d
database systems to present useful information to atabase systems to present useful information to
users [12]. The outcomes of the data mining are sers [12]. The outcomes of the data mining are
process to detect the un known patterns in the known patterns in the u
used for prediction and descriptionsed for prediction and description (describes
structured data of the organization (7) (8). The other u
r
scientists also describe data mining as the process to scientists also describe data mining as the process to reality).The already known variables areality).The already known variables are used to
collect, filter, prepare, analyze, and store data that will and store data that will predict the future outcome.redict the future outcome. The data mining uses
p
be used to create useful knowledge and supporting the be used to create useful knowledge and supporting the v
various techniques and some of these are listed by arious techniques and some of these are listed by
business analytics and predictive modeling.modeling. Hen et al. (2011) in their publication Data Mining: en et al. (2011) in their publication Data Mining:
H
Concepts & Techniques and analyzed in Stodand analyzed in Stodder’s
The generalized structure of data analytics is divided analytics is divided research text Customer Analytics in the age oesearch text Customer Analytics in the age of
r
into different elements social media(2012)are Cluster Analysis, Anomaly ocial media(2012)are Cluster Analysis, Anomaly
s
1. Data Source/Data Layer Detection, Association Rule mining,Association Rule mining, Classification
The internal source of data is generated from ERP,The internal source of data is generated from ERP, methods, Regression analysis & natural language Regression analysis & natural language
CRM, or SCM systems or other or SCM systems or other soft ware’s, processing.
spreadsheets, HTML & XML documents,HTML & XML documents, other
files and spreadsheets. The external data sources and spreadsheets. The external data sources 4. The presentation or display layerThe presentation or display layer
are statistical public reports. The other inputs of are statistical public reports. The other inputs of It presents the data in usert presents the data in user-friendly manner. The
I
data are discussions, videos, graphics and other graphics and other outcome in different performance ere ports performance ere ports which
user generated content.(9) is used to monitor the performance of business.s used to monitor the performance of business.
i
T
The reports can be customized as per the need of he reports can be customized as per the need of
2. ETL Process/Integration layer the final user. Results are in the form of Results are in the form of
s
Extract, Transform, Load This layer extracts the Extract, Transform, Load This layer extracts the spreadsheet or dashboards.preadsheet or dashboards. The strategic decisions
a
data from different original data sources,ta from different original data sources, clear the are derived from these dre derived from these dashboards. The
d
inconsistent data, keep the data in required form keep the data in required form dashboards measures the business performance ashboards measures the business performance
and structure, integrate all the data together and integrate all the data together and e
effectively which is a multiffectively which is a multi-layered applications
upload it in defined data warehouse or data mart. upload it in defined data warehouse or data mart. b
built on business intelligence and data integration uilt on business intelligence and data integration
The data processing or transformation is done by The data processing or transformation is done by infrastructure [13]
using programming language, scripting or SQL scripting or SQL

@ IJTSRD | Available Online @ www.ijtsrd.comwww.ijtsrd.com | Conference Issue: ICDEBI-2018 | | Oct 2018 Page: 75