Exam 9: Business Intelligence

When using the Plan-Do-Check-Act process,data is gathered to see if the implemented solution has solved the problem and achieved the desired goal in the ___________________ step.

In the Balanced Scorecard,the customer perspective defines those internal business processes that indicate how well the business is running and whether its products and services are meeting customer requirements.

Discuss business performance management.

When using the Plan-Do-Check-Act process,the problem-solving team selects the problem to be analyzed,clearly defines the problem,sets a measurable goal for the problem-solving effort,and gathers further data related to the problem in the ____ step.

In the Balanced Scorecard,the learning and growth perspective identifies what must be done from the customer's perspective in order to meet organizational objectives using measures such as percent of on-time deliveries.

Data _____ can be built to summarize unit sales of a specific item on a specific day for a specific store.

An effective ETL process is essential to ensure data warehouse success.

Effective use of a Balanced Scorecard can provide greater customer satisfaction,improved financial results,more effective information systems and business processes,and more motivated and better educated employees.

The data in a data warehouse typically comes from numerous operational systems and external data sources.

The ____ step in the ETL process updates the existing data warehouse with the data that have passed through the extract and transform steps.

End users can even employ tools such as the ____ to find the optimal solution to a problem with multiple constraints.

Dashboards are simple tools used to provide entry level personnel of the organization the information they need to make decisions.

________________________________________ can be used to model work processes and predict future performance under various what-if scenarios.

Why are spreadsheets useful?

____ is an application of BI that enables the continuous and real-time analysis of operational data to measure actual performance and forecast future performance.

Many of the reporting and querying tools enable end users to make their own data requests and format the results without the need for additional help from the IT organization.

____ is a method to analyze multidimensional data from many different perspectives.

BI tools frequently operate on data stored in a data warehouse or data ____________________.

A data ___________________ is a smaller version of a data warehouse-scaled down to meet the specific needs of a business unit.

What is online analytical processing (OLAP)?