Question

In: Computer Science

Explain Business Intelligence in three to four paragraphs. Focus upon what it is, its architecture and...

  1. Explain Business Intelligence in three to four paragraphs. Focus upon what it is, its architecture and purpose.

Solutions

Expert Solution

BUSINESS INTELLIGENCE

Business intelligence (BI) is a term used to describe a comprehensive, cohesive, and integrated set of tools and processes used to capture, collect, integrate, store, and analyze data with the purpose of generating and presenting information used to support business decision making.

PURPOSE

  • BI is a framework that allows a business to transform data into information, information into knowledge, and knowledge into wisdom.
  • Implementing BI in an organization involves capturing not only business data (internal and external) but also the metadata, or knowledge about the data.
  • BI provides a well-orchestrated framework for the management of data that works across all levels of the organization.

BI involves the following general steps:

  • Collecting and storing operational data.
  • Aggregating the operational data into decision support data.
  • Analyzing decision support data to generate information.
  • Presenting such information to the end user to support business decisions.
  • Making business decisions, which in turn generate more data that is collected, stored, etc. (restarting the process).
  • Monitoring results to evaluate outcomes of the business decisions (providing more data to be collected, stored, etc.).

Business Intelligence Architecture:

  • BI covers a range of technologies and applications to manage the entire data life cycle from acquisition to storage, transformation, integration, analysis, monitoring, presentation, and archiving.
  • BI functionality ranges from simple data gathering and extraction to very complex data analysis and presentation.
  • The BI architecture is composed of data, people, processes, technology, and the management of such components.

The different components of BI frame work are as follows.

ETL tools:

  • Data extraction, transformation, and loading (ETL) tools collect, filter, integrate, and aggregate operational data to be saved into a data store optimized for decision support.
  • For example, to determine the relative market share by selected product lines, you require data on competitors' products.
  • Such data can be located in external databases provided by industry groups or by companies that market the data. As the name implies, this component extracts the data, filters the extracted data to select the relevant records, and packages the data in the right format to be added to the data store component.

Data store:

  • The data store is optimized for decision support and is generally represented by a data warehouse or a data mart.
  • The data store contains two main types of data: business data and business model data.
  • The business data are extracted from the operational database and from external data sources. The business data is stored in structures that are optimized for data analysis and query speed. The external data sources provide data that cannot be found within the company but that are relevant to the business, such as stock prices, market indicators, marketing information (such as demographics), and competitors’ data.
  • Business models are generated by special algorithms that model the business to identify and enhance the understanding of business situations and problems.

Data query and analysis tools:

  • This component performs data retrieval, data analysis, and data-mining tasks using the data in the data store.
  • This component is used by the data analyst to create the queries that access the database. Depending on the implementation, the query tool accesses either the operational database, or more commonly, the data store.
  • This tool advises the user on which data to select and how to build a reliable business data model.
  • This component is generally represented in the form of an OLAP tool.

Data presentation and visualization tools:

  • This component is in charge of presenting the data to the end user in a variety of ways.
  • This component is used by the data analyst to organize and present the data.
  • This tool helps the end user select the most appropriate presentation format, such as summary report, map, pie or bar graph, or mixed graphs.
  • The query tool and the presentation tool are the front end to the BI environment.

Decision Support Data:

Although BI is used at strategic and tactical managerial levels within organizations, its effectiveness depends on the quality of data gathered at the operational level.


Related Solutions

Identify any four external factors that Business Intelligence must focus on for it to be effective...
Identify any four external factors that Business Intelligence must focus on for it to be effective as a tool by which the business obtains competitive advantage.
Explain what Business Intelligence is and highlight how it is likely to bring a business if...
Explain what Business Intelligence is and highlight how it is likely to bring a business if executed properly.
1. What are the three areas of focus in Community Nutrition? 2. What are the four...
1. What are the three areas of focus in Community Nutrition? 2. What are the four shared components of a community? 3. What is health disparities? 4. What is public health nutrition? 5. What is HP 2020? 6. What is the socioecological model? 7. What are the different types of studies and their advantages/disadvantages? 8. How is distribution vs. determinants? 9. What is considered vital statistics? 10. What are the behavior change theories? 11. What are the different ways to...
What is the focus of Business Analytics. Provide the three main levels and provide an example...
What is the focus of Business Analytics. Provide the three main levels and provide an example of their application. Many business are focusing on data harvesting as part of their core competency (Amazon, Facebook, and Google are perfect examples). How could these companies utilize this immense data along with Business Analytics to create and sustain competitive advantage.
Identify basic beliefs and practices of the various forms of historical Christianity. Focus upon the three...
Identify basic beliefs and practices of the various forms of historical Christianity. Focus upon the three main groups within Christendom (Protestantism, Roman Catholicism, and Eastern Orthodoxy). Do you identify with these?
(BIOPHYSICS) In four paragraphs describe what “reciprocal space” is as you are trying to explain it...
(BIOPHYSICS) In four paragraphs describe what “reciprocal space” is as you are trying to explain it to a peer or classmate.
in four paragraphs explain : What is the Greatest Type of Discrimination in the US-Wage, Employment,...
in four paragraphs explain : What is the Greatest Type of Discrimination in the US-Wage, Employment, or Occupational?
1-Write a paragraph about microStrategy Business Intelligence Tools 2-Demonstrate the functions of its Business Intelligence Tools
1-Write a paragraph about microStrategy Business Intelligence Tools 2-Demonstrate the functions of its Business Intelligence Tools
In Cloud architecture, what are the different phases involved? Explain each a. In cloud architecture, what...
In Cloud architecture, what are the different phases involved? Explain each a. In cloud architecture, what are the building blocks? Explain each
information process allows the company to focus on its core business processes and on what it...
information process allows the company to focus on its core business processes and on what it does best? A) True B) False
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT