AbstractBusiness Intelligence has become a very important in
business arena irrespective of
domain due to
fact that managers need to analyze comprehensively in order to face
challenges. To make
business intelligence effective, having a Data Warehouse is an essential thing, because without
power of a data warehouse, it is practically impossible to provide all
information, reports and views required by
management. There are many technical concerns when it comes to a technical implementation, but
business stakeholders need to show
right direction if they are to achieve success. This paper discusses business concerns related to a Business Intelligence initiative together with a Data Warehouse.
1 Introduction
Business Intelligence (BI) is an effort of increasing
competitive advantage of a business by intelligent use of available data in decision making. Irrespective of
domain that business is engaged in,
competition in today’s business world has increased as never before. Thus all sorts of facilities are required to face
challenge. Information Technology (IT) plays a major role in this regard and one of
main concerns within
overall IT strategy is Business Intelligence.
2 Business Intelligence & Data Warehousing in a Business Perspective - Body
2.1 Business Intelligence
Data sourcing, data analysing, extracting
correct information for a given criteria, assessing
risks and finally supporting
decision making process are
main components of BI.
In a business perspective, core stakeholders need to be well aware of all
above stages and be crystal clear on expectations. The person, who is being assigned with
role of Business Analyst (BA) for
BI initiative either from
BI solution providers’ side or
company itself, needs to take
full responsibility on assuring that all
above steps are correctly being carried out, in a way that it would ultimately give
business
expected leverage. The management, who will be
users of
BI solution, and
business stakeholders, need to communicate with
BA correctly and elaborately on their expectations and help him throughout
process.
Data sourcing is an initial yet crucial step that would have a direct impact on
system where extracting information from multiple sources of data has to be carried out. The data may be on text documents such as memos, reports, email messages, and it may be on
formats such as photographs, images, sounds, and they can be on more computer oriented sources like databases, formatted tables, web pages and URL lists. The key to data sourcing is to obtain
information in electronic form. Therefore, typically scanners, digital cameras, database queries, web searches, computer file access etc, would play significant roles. In a business perspective, emphasis should be placed on
identification of
correct relevant data sources,
granularity of
data to be extracted, possibility of data being extracted from identified sources and
confirmation that only correct and accurate data is extracted and passed on to
data analysis stage of
BI process. Business oriented stake holders guided by
BA need to put in lot of thought during
analyzing stage as well, which is
second phase. Synthesizing useful knowledge from collections of data should be done in an analytical way using
in-depth business knowledge whilst estimating current trends, integrating and summarizing disparate information, validating models of understanding, and predicting missing information or future trends. This process of data analysis is also called data mining or knowledge discovery. Probability theory, statistical analysis methods, operational research and artificial intelligence are
tools to be used within this stage. It is not expected that business oriented stake holders (including
BA) are experts of all
above theoretical concepts and application methodologies, but they need to be able to guide
relevant resources in order to achieve
ultimate expectations of BI, which they know best.
Identifying relevant criteria, conditions and parameters of report generation is solely based on business requirements, which need to be well communicated by
users and correctly captured by
BA. Ultimately, correct decision support will be facilitated through
BI initiative and it aims to provide warnings on important events, such as takeovers, market changes, and poor staff performance, so that preventative steps could be taken. It seeks to help analyze and make better business decisions, to improve sales or customer satisfaction or staff morale. It presents
information that manager’s need, as and when they need it.
In a business sense, BI should go several steps forward bypassing
mere conventional reporting, which should explain “what has happened?” through baseline metrics. The value addition will be higher if it can produce descriptive metrics, which will explain “why has it happened?” and
value added to
business will be much higher if predictive metrics could be provided to explain “what will happen?” Therefore, when providing a BI solution, it is important to think in these additional value adding lines.
2.2 Data warehousing
In
context of BI, data warehousing (DW) is also a critical resource to be implemented to maximize
effectiveness of
BI process. BI and DW are two terminologies that go in line. It has come to a level where a true BI system is ineffective without a powerful DW, in order to understand
reality behind this statement, it’s important to have an insight in to what DW really is.
A data warehouse is one large data store for
business in concern which has integrated, time variant, non volatile collection of data in support of management's decision making process. It will mainly have transactional data which would facilitate effective querying, analyzing and report generation, which in turn would give
management
required level of information for
decision making.
2.3 The reasons to have BI together with DW
At this point, it should be made clear why a BI tool is more effective with a powerful DW. To query, analyze and generate worthy reports,
systems should have information available. Importantly, transactional information such as sales data, human resources data etc. are available normally in different applications of
enterprise, which would obviously be physically held in different databases. Therefore, data is not at one particular place, hence making it very difficult to generate intelligent information. The level of reports expected today, are not merely independent for each department, but managers today want to analyze data and relationships across
enterprise so that their BI process is effective. Therefore, having data coming from all
sources to one location in
form of a data warehouse is crucial for
success of
BI initiative. In a business viewpoint, this message should be passed and sold to
managements of enterprises so that they understand
value of
investment. Once invested, its gains could be achieved over several years, in turn marking a high ROI.