WGU C175 - BUSINESS INTELLIGENCE STUDY GUIDE
Business intelligence - Answers - 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.
B I - is a framework that allows a business to transform data into information,
information into knowledge, and knowledge into wisdom. - Answers - 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.
ETL - Answers - extraction, transformation, and loading
ETL tools - Answers - collect, filter, integrate, and aggregate internal and external data
to be saved into a data store optimized for decision support.
Internal data is generated by the company during its day-to-day operations, such as
product sales history, invoicing, and payments. - Answers - 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 demographics),
and competitors' data.
Data store - Answers - 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.
Data Store is - Answers - Optimized for decision support and query analysis
Query and reporting - Answers - 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.
Depending on the implementation, the query and reporting tool accesses the
operational database, or more commonly, the data store. - Answers - Blank
Data visualization - Answers - 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.
Business intelligence - Answers - 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.
B I - is a framework that allows a business to transform data into information,
information into knowledge, and knowledge into wisdom. - Answers - 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.
ETL - Answers - extraction, transformation, and loading
ETL tools - Answers - collect, filter, integrate, and aggregate internal and external data
to be saved into a data store optimized for decision support.
Internal data is generated by the company during its day-to-day operations, such as
product sales history, invoicing, and payments. - Answers - 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 demographics),
and competitors' data.
Data store - Answers - 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.
Data Store is - Answers - Optimized for decision support and query analysis
Query and reporting - Answers - 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.
Depending on the implementation, the query and reporting tool accesses the
operational database, or more commonly, the data store. - Answers - Blank
Data visualization - Answers - 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.
