Page 211 - DCAP307_PLANNING_AND_MANAGING_IT_INFRASTRUCTURE

Unit 12: Business Intelligence

12.5 Summary Notes

 Business Intelligence (BI) is a broad category of applications and technologies for gathering,
storing, analysing, and providing access to data to help enterprise users make better
business decisions.
 Business Intelligence is a decisions support system and database that can provide
professionals with the information they need to make the most effective decisions for
their organisation.

 A business intelligence data warehouse is an enterprise-wide store of cleansed, reconciled
data extracted from a wide variety of operational systems and optimised for reporting,
analysis, and monitoring.

 Without an effective data warehouse, organisations cannot extract the data required for
information analysis in time to facilitate expedient decision-making.

 Business intelligence (BI) tools are add-on software applications that a company uses to
consolidate and make sense of the mountains of data it develops, such that managers can
act intelligently upon that data.
 There are a range of business intelligence tools available in the commercial software
market, and selecting the correct solution requires a good understanding of reporting
requirements and long-term business needs.
 Business performance management allows companies to more efficiently collect data
from their various sources, analyse it and take appropriate action.

 Business Performance Management is the next phase in the evolution of decision support
systems, enterprise information systems and business intelligence.

12.6 Keywords

Business Intelligence Data Warehouse: A business intelligence data warehouse is an enterprise-
wide store of cleansed, reconciled data extracted from a wide variety of operational systems and
optimised for reporting, analysis, and monitoring.
Business Intelligence: Business Intelligence (BI) is a broad category of applications and
technologies for gathering, storing, analysing, and providing access to data to help enterprise
users make better business decisions.
Business Performance Management: Business performance management allows companies to
more efficiently collect data from their various sources, analyse it and take appropriate action.

Data Mining Tool: A data mining tool is software that is automated to search data, seeking out
ways that the data correlates to other data.
Data Warehousing: Data warehousing is a data repository designed to support an organisation’s
decision making.
ETL Tool: ETL tools bring in data from outside sources, transform it to meet your specified
operational needs, and then load the results into your company database.
Multidimensional Analysis Tool: A multidimensional analysis tool, also called Online Analytical
Processing (OLAP), is software that allows the user to view the same data from different aspects.
Query Tool: A query tool is software setup for users to ask questions about the data.

LOVELY PROFESSIONAL UNIVERSITY 205