Database Processing for BIS Questions

• Business Intelligence (BI) reporting systems are used to make sophisticated mathematical and statistical calculations in order to prepare reports based on the data.
• RFM analysis is a BI reporting system.
• Business Intelligence (BI) systems fall into two broad categories: reporting and data warehousing.
• Formatting the report is part of authoring a report.
• BI reporting systems summarize the current status of business activities in order to predict future activities.
• The data warehouse DBMS needs to be the same DBMS used for the operational database.
• OLAP uses measures, dimensions and associations.
• Report types include static, dynamic, query and OLAP.
• In unsupervised data mining, explanations are created after patterns are found.
• In a common form of RFM analysis, customers are sorted in five groups and given a score of 1 to 5 depending on their group.
• OnLine Analytical Processing (OLAP) is a BI reporting system.
• Business Intelligence (BI) systems do not obtain data from operational databases.
• A data warehouse is a database system that is optimized for operational transaction processing.
• A data mart is a collection of data that, while smaller than a data warehouse, still addresses the entire business.
• The term neural networks as used in data mining is a misnomer.
• Most operational databases can be used for many BI applications.
• Data Mining uses simple arithmetic techniques such as sums, averages, and groupings to perform what-if analyses, to make predictions, and to facilitate decision making.
• Data warehouse data are usually normalized.
• The delivery function of a report management system allows reports to be delivered via e-mail, via the Web, via XML Web services, via hand delivery and other delivery means.
• Market basket analysis primarily uses the technique of conditional probabilities.