C175 - Business
Intelligence
1. Business intelligence: describes 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 to support business decision making.
2. B I - is a framework that allows a business to transform data into information, information into
knowledge, and knowledge into wisdom.: B I - is not a product by itself, but a framework of
concepts, practices, tools, and technologies that help a business better understand its core
capabilities, provide snapshots of the company situation, and identify key opportunities to
create competitive advantage.
3. ETL: extraction, transformation, and loading
4. ETL tools: collect, filter, integrate, and aggregate internal and external data to be saved into
a data store optimized for decision support.
5. Internal data is generated by the company during its day-to-day operations, such as product sales
history, invoicing, and payments.: external data sources provide data that cannot be found within
the company but is relevant to the business, such as stock prices, market indicators, marketing
information (such as demograph- ics), and competitors' data.
6. Data store: The data store is optimized for decision support and is generally represented by
a data warehouse or a data mart. The data is stored in structures that are optimized for data
analysis and query speed.
7. Data Store is: Optimized for decision support and query analysis
8. Query and reporting: Performs data selection and retrieval, and it is used by the data analyst
to create queries that access the database and create the required reports.
9. Depending on the implementation, the query and reporting tool accesses the operational
database, or more commonly, the data store.: Blank
10.Data visualization: This component presents data to the end user in a variety of meaningful
and innovative ways. This tool helps the end user select the most appropriate presentation
format, such as summary reports, maps, pie or bar graphs, mixed graphs, and static or
interactive dashboards.
11.Data monitoring and alerting: allows real-time monitoring of business activi- ties. The BI
system will present the concise information in a single integrated view for the data analyst.
12.This integrated view could include specific metrics about the system performance or activities,
such as number of orders placed in the last four hours, number of customer complaints by product by
month, and total revenue by region.: Alerts can be placed on a given metric; once the value of a
metric goes below or above a certain baseline, the system will perform a given action, such as
emailing shop floor managers, presenting visual alerts, or starting an application.
1/
3
Intelligence
1. Business intelligence: describes 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 to support business decision making.
2. B I - is a framework that allows a business to transform data into information, information into
knowledge, and knowledge into wisdom.: B I - is not a product by itself, but a framework of
concepts, practices, tools, and technologies that help a business better understand its core
capabilities, provide snapshots of the company situation, and identify key opportunities to
create competitive advantage.
3. ETL: extraction, transformation, and loading
4. ETL tools: collect, filter, integrate, and aggregate internal and external data to be saved into
a data store optimized for decision support.
5. Internal data is generated by the company during its day-to-day operations, such as product sales
history, invoicing, and payments.: external data sources provide data that cannot be found within
the company but is relevant to the business, such as stock prices, market indicators, marketing
information (such as demograph- ics), and competitors' data.
6. Data store: The data store is optimized for decision support and is generally represented by
a data warehouse or a data mart. The data is stored in structures that are optimized for data
analysis and query speed.
7. Data Store is: Optimized for decision support and query analysis
8. Query and reporting: Performs data selection and retrieval, and it is used by the data analyst
to create queries that access the database and create the required reports.
9. Depending on the implementation, the query and reporting tool accesses the operational
database, or more commonly, the data store.: Blank
10.Data visualization: This component presents data to the end user in a variety of meaningful
and innovative ways. This tool helps the end user select the most appropriate presentation
format, such as summary reports, maps, pie or bar graphs, mixed graphs, and static or
interactive dashboards.
11.Data monitoring and alerting: allows real-time monitoring of business activi- ties. The BI
system will present the concise information in a single integrated view for the data analyst.
12.This integrated view could include specific metrics about the system performance or activities,
such as number of orders placed in the last four hours, number of customer complaints by product by
month, and total revenue by region.: Alerts can be placed on a given metric; once the value of a
metric goes below or above a certain baseline, the system will perform a given action, such as
emailing shop floor managers, presenting visual alerts, or starting an application.
1/
3
