Font size
WorksheetsBIS POP QUIZ 2
Total questions: 102
Worksheet time: 51mins
What is the primary objective of Business Intelligence (BI)?
To increase data storage capacity
To enable easy access to data and models for decision making
To reduce the cost of IT infrastructure
To improve internet speed
In what decade was the term Business Intelligence (BI) coined?
1970s
1980s
1990s
2010s
Which of the following is a component of BI Architecture?
Data Analysis
Data Storage
Data Warehouse
Data Transportation
Business Performance Management (BPM) within BI is used to:
Monitor and manage key performance indicators
Increase social media presence
Manage employee performance reviews
Oversee financial transactions
What is the role of data visualization in BI?
To decrease data usage
To represent data in visual formats for better understanding
To store large amounts of data
To encrypt sensitive data
What kind of analysis helps understand what happened historically in a business?
Operational
Predictive
Historical
Prescriptive
Which department uses BI for keeping track of sales pipelines and forecasts?
Human Resources
Sales
Finance
Operations
What is a primary challenge addressed by Business Intelligence systems?
Too few data
Data being too organized
Rich data but poor information
Overly efficient data processing
What does a data warehouse provide in a BI system?
Real-time decision support
Physical storage space for hardware
Security services for data protection
Personnel training for IT staff
Business analytics in BI helps transform data into:
Financial gains
Information and knowledge
Marketing strategies
Operational costs
Which of the following is not a described usage of BI within organizations?
To monitor employee personal emails
Historical analysis in the Sales department
Understanding campaign success in Marketing
Predictive analysis for future trends
What aspect of BI assists in competitive monitoring?
Manual record-keeping
Traditional advertising methods
Software that tracks competitor website activities
External consultancy services
The term "dataset" in BI refers to:
A collection of disconnected data points
An organized collection of data
Outdated information
Software tools for data analysis
Which analysis type answers "why did it happen?"
Historical
Operational
Analytical
Predictive
Strategic planning in an organization is a response to:
Decreasing data availability
The complex business environment
Internal conflicts within teams
A lack of business opportunities
Which of the following is a factor in the business environment?
Employee satisfaction
Technology
Office locations
Brand color scheme
The evolution of BI capabilities has included all except:
Data/Text/Web Mining
Social Media Analytics
Handwritten note analysis
Big Data
A data warehouse is a physical repository where relational data are specially organized to provide (a) -wide cleansed data in a standardized format.
Bill Inmon defined the data warehouse as a collection of integrated (a) -oriented databases designed to support DSS functions.
An Enterprise Data Warehouse (EDW) is used across the enterprise for decision support and integrates data from many sources into a standard format for effective (a) Intelligence and decision support applications.
The process of selecting data from one or more sources and reading the selected data during the ETL process is known as (a) .
(a) is converting data from their original form to whatever form the DW needs, often including cleansing of the data.
Putting the converted (transformed) data into the DW is referred to as (a) .
Data marts focus on a particular (a) or department, such as marketing operations.
Data warehouses are designed to be (a) , meaning they store data in a read-only format that does not change over time.
The ETL process stands for Extraction, Transformation, and (a) .
Metadata in a data warehouse context is often described as data about (a) .
A large-scale DW used across the enterprise for decision support is known as an (a) data warehouse.
Real-time data warehousing enables real-time data updates for real-time analysis and real-time (a) .
A (a) data mart is a subset that is created directly from a data warehouse.
The process used to standardize formats, resolve inconsistencies, and enrich the data with additional attributes during ETL is called data (a) .
One direct benefit of a data warehouse is the simplification of data (a) .
(a) is a major concern when implementing real-time data warehousing due to the potential for rapid data changes.
To ensure the success of a DW implementation, it is crucial to only load data that have been (a) .
(a) management is an essential aspect of data warehousing, involving maintaining data accuracy and integrity over time.
Implementing a DW requires understanding the (a) of source data to ensure quality and consistency.
What does ETL stand for in the context of
data warehousing?
Evaluation, Testing, Launching
Extraction, Transformation, Loading
Execution, Transmission, Linkage
Encryption, Transfer, Logging
Which of the following is a characteristic of data warehouses?
Volatile
Transaction-oriented
Time-variant
Unstructured
An Enterprise Data Warehouse (EDW) is:
A small-scale data warehouse for departmental use
Used to store data from a single business process
A large-scale data warehouse used across an enterprise for decision support
A temporary data storage for transactional data
What is the purpose of a data mart?
To store operational data
To process real-time transactions
To focus on a particular subject or department
To replace data warehouses
What role does metadata play in a data warehouse?
It encrypts sensitive data for security
It serves as data about data
It reduces the amount of data stored
It accelerates the data retrieval process
Which process involves cleansing the data to remove as many errors as possible?
Extraction
Transformation
Loading
Integration
What is a significant concern when implementing real-time data warehousing?
Data volume reduction
Decrease in data variety
Data update frequency
Simplification of queries
A dependent data mart:
Operates independently of the enterprise data warehouse
Is created directly from a data warehouse
Stores data unrelated to the enterprise data warehouse
Is used for archival purposes only
What does scalability in the context of data warehousing refer to?
The ability to decrease data storage costs
The ability to handle increasing amounts of data and complexity over time
The capacity to reduce the number of users
The process of simplifying user queries
Which is an indirect benefit of a data warehouse?
Enhanced system performance
Enhanced customer service and satisfaction
Simplification of data access
Allows end users to perform extensive analysis
Data mining is also known as:
Data storage
Knowledge extraction
Data compilation
Information indexing
One main advantage of data mining is:
Decreasing data security
Increasing data storage costs
Tracking customer behavior
Simplifying data structures
What type of data mining analysis aims to project future trends?
Descriptive
Predictive
Hypothesis Driven
Discovery Driven
CRISP-DM stands for:
Cross-Industry Standard Process for Data Mining
Comprehensive Research in Statistical Prediction for Data Management
Critical Review of Information Security and Privacy Data Mining
Current Regulations and Standards Procedure for Data Mining
Which process accounts for the majority of the project time in data mining?
Model Building
Data Understanding
Data Preparation
Deployment
Which is not a common data mining mistake?
Selecting the correct problem for data mining
Ignoring suspicious findings
Being sloppy about tracking the data mining process
Measuring results differently from the sponsor
A significant disadvantage of data mining is:
Enhanced customer service
Privacy concerns
Improved marketing campaigns
Trend analysis
Data preprocessing is crucial for:
Increasing data volume
Reducing data security
Enhancing data quality for mining
Simplifying user interfaces
SEMMA methodology in data mining does NOT include:
Sample
Model
Assess
Deploy
Data Mining involves all the following except:
Machine learning
Artificial intelligence
Data deletion
Statistical analysis
The primary source of data for data mining is often a:
Data lake
Data warehouse
Spreadsheet
Text document
Data mining refers to a process of data (a) , extracting, and evaluation.
Data mining originated from the field of (a) linguistics.
The aim of data mining is to extract data using computer programs analyses and implement intelligent methods from data sets to take (a) insights.
Data mining is a process that uses multi-disciplinary skills like machine learning, artificial intelligence, (a) , and database technologies.
The exponential increase in data processing and storage capabilities, along with a decrease in cost, has made data mining a crucial component for successful (a) initiatives.
Predictions in data mining focus mainly on the (a) datasets and databases.
Data Mining Process: The CRISP-DM methodology includes (a) Building as one of its steps.
One of the advantages of data mining is tracking customer behavior and (a) .
A common mistake in data mining is selecting the wrong (a) for data mining.
Data mining helps in identifying the customer response through some surveys, which is a benefit for (a) campaigns.
One disadvantage of data mining is the concern over (a) , as data mining systems can easily access a wide range of personal data.
(a) data contains measurements of simple codes assigned to objects as labels, which are not measurements.
In the data mining process, Data (a) accounts for approximately 85% of the total project time.
Which factor is crucial in determining a strategic planning horizon?
Financial reports
Market analysis
Timeframe
Resource allocation
In a performance dashboard, which feature is NOT commonly used for visualizing data?
Charts
Gauges
Filters
Which one of these is NOT an element required for effective performance measurement?
Targets
Strategy
Data mining
Time frames
A (a) is a physical repository where relational data is specially organized to provide enterprise-wide, cleansed data in a standardized format.
(a) is the process of reading data from multiple sources and converting them to a format suitable for the data warehouse.
(a) data marts are subsets created directly from an enterprise data warehouse.
The characteristics of a data warehouse include subject-oriented, time-variant, integrated, and (a) .
In a data warehouse, (a) describe the contents and acquisition of the data and how to effectively use them.
The process of converting data from its original form to the desired format while cleansing and enriching it is called (a) .
Data warehouse (a) involves setting up strategies to accommodate the warehouse's growth while maintaining performance.
The data mining technique that forecasts and predicts future trends based on existing data is called (a) analysis.
The (a) methodology includes steps like Sample, Explore, Modify, Model, and Assess.
(a) data includes measurements in simple codes, often representing labels but not actual measurements.
The four disciplines that intersect to form data mining are statistics, databases, artificial intelligence, and (a) learning.
Effective performance measures should balance the needs of all (a) , including employees and shareholders.
Lagging indicators look backward at past performance, while (a) indicators look forward at future activities.
Strategic goals are specific financial and non-financial objectives a company aims to achieve within a specified (a) period.
Reporting and (a) are crucial aspects of BPM for presenting data to support decision-making.
The major objective of BI is to enable easy access to data and models to help transform data into information and (a) .
The term BI was coined by the (a) Group in the mid-1990s.
In the 1980s, BI evolved from Executive (a) Systems (EIS).
BI encompasses high-level architectures, tools, databases, analytical tools, applications, and (a) .
Data (a) involves gathering data from various sources and integrating it into a unified dataset.
The BI methodology provides strategic direction for planning and creating solid (a) strategies.
Boris Evelson of Forrester Research compiled a list of analysis types, including Historical, Operational, Analytical, Predictive, Prescriptive, and (a) analysis.
In predictive analysis, BI is used to forecast what might happen in the (a) .
BI helps employees base decisions on datasets, experience, or (a) .
Business environment factors include markets, customer demands, technology, and (a) .
The (a) environment is becoming increasingly complex, creating new opportunities and challenges.
A data set is an organized collection of (a) that helps employees base their decisions.
Business Environment factors influencing organizations include markets, customer demand, (a) , and societal factors.
Business Intelligence (BI) refers to technologies, applications, and practices for the collection, integration, analysis, and presentation of business (a) .
