Exam 9: Business Intelligence

Reporting and insight BPM software provides a wide range of BI capabilities such as trend analysis and drill-down analysis for users to gain complete visibility across all of an organization's business processes.

Data warehouses frequently hold a huge amount of data-often containing ____ years or more of data.

Databases built to support OLAP processing consist of data ____________________ that contain numeric facts called measures.

____ involves the interactive examination of high level,summary data in increasing detail to gain insight into certain elements-sort of like slowly peeling off the layers of an onion to reach the core.

Sometimes a data mart is simply created by extracting,transforming,and loading a portion of the data in a data warehouse.

In the retail industry,____ is used to help firms to predict better customer demand and maximize sales.

The most widely used BI software comes from Jasper,Pentaho,and Microsoft.

Data repository creation begins with an ETL process to create an appropriate set of data to support the data mining technique to be used.

Business managers often import data into a(n)____________________ program,which then can perform operations on the data based on formulas created by the end user.

The ETL process is generally run once per day.