Page 13 - DCAP606_BUSINESS_INTELLIGENCE

Business Intelligence

Notes 6. The data fed to the data warehouse from the .................................. was converted to a format
significant to the data warehouse.
7. The job of ................................................ is to request a series of rules to extracted data so that
it is properly formatted for loading into the data warehouse.
8. The .................................. function permits the consolidation of multiple data sources into a
well-structured database for use in complex analysis.

9. In compare to offline ETL, ....................................... supplies present but varying answers to
successive queries.
10. .............................. represents a pattern that connects information and usually presents a
high grade of predictability as to what is recounted or what will happen next.
11. A ............................... is a special type of a data warehouse focused on a single subject (or
functional area), such as Sales, Finance, or Marketing.

12. The primary use for a data mart is .................................. applications.
1.3 Purpose of Business Intelligence Systems

‘The purpose of business intelligence systems is to utilise all your underlying business data to
help executives make better business decisions,’ said Tony Banham, technology and solutions
director for Oracle Greater China.
Business Intelligence process consists of 3 distinct tasks:
1. The first task BI has to do is to gather the necessary data about the business. The key to this
is automating the process. Gathering data was very time and money consuming in the
past, but todays with the usage of modern computers, it’s much easier to collect data from
various sources.

2. The second task is to analyse the collected data and then further extract information from
it. The extracted information is then transformed into knowledge.
3. The final task is to use the newly gathered knowledge to improve the business.

There are many business intelligence tools to complete the process of gathering knowledge
related to business like Cognos, BizTools, Hummingbird and Informatica.

1.4 Structure of Intelligence Systems

A business intelligence system has three key advantages:
1. It not only supports the latest information technologies, but also provides pre-packaged
application solutions.
2. It focuses on the access and delivery of business information to end users, and support
both information providers and information consumers.
3. It support access to all forms of business information, and not just the information stored
in a data warehouse.
Figure 1.6 gives an overview of Structure of Business Intelligent System.

1.4.1 Business Intelligence Applications

Business intelligence applications provide integrated business applications, hardware, software,
and consulting services. Decision Edge from IBM, for example, analyses customer information
and based on that assists in the creation of tailored customer marketing programs.

8 LOVELY PROFESSIONAL UNIVERSITY