isds 2001 test 2
________ is a mechanism for pulling data from source systems to satisfy a request for information. It is an evolving tool space that promises real-time data integration from a variety of sources, such as relational databases, Web services, and multidimensional databases.
Enterprise information integration (EII)
What is the definition of a data warehouse (DW) in simple terms?
In simple terms, a data warehouse (DW) is a pool of data produced to support decision making; it is also a repository of current and historical data of potential interest to managers throughout the organization.
The ________ Model, also known as the data mart approach, is a "plan big, build small" approach. A data mart is a subject-oriented or department-oriented data warehouse. It is a scaled-down version of a data warehouse that focuses on the requests of a specific department, such as marketing or sales.
Kimball
_______are typically used together with other charts and graphs, as opposed to by themselves and show postal codes, country names, ect.
Maps
Mehra (2005) indicated that few organizations really understand metadata, and fewer understand how to design and implement a metadata strategy. How would you describe metadata?
Metadata are data about data. Metadata describe the structure of and some meaning about data, thereby contributing to their effective or ineffective use.
______charts or network diagrams show precedence relationships among the project activities/tasks.
PERT
which of the following online analytical processing (OLAP) technologies does NOT require the precomputation and storage of information?
ROLAP
More data, coming in faster and requiring immediate conversion into decisions, means that organizations are confronting the need for real-time data warehousing (RDW). How would you define real-time data warehousing?
Real-time data warehousing, also known as active data warehousing (ADW), is the process of loading and providing data via the data warehouse as they become available.
________, or "The Extended ASP Model," is a creative way of deploying information system applications where the provider licenses its applications to customers for use as a service on demand (usually over the Internet)
SaaS (software as a service)
According to Kassam (2002), business metadata comprise information that increases our understanding of traditional (i.e., structured) data. What is the primary purpose of metadata?
The primary purpose of metadata should be to provide context to the reported data; that is, it provides enriching information that leads to the creation of knowledge.
what is the definition of a data mart
a data mart is a subset of a data warehouse, typically consisting of a single subject area.
what is six sigma?
a methodology aimed at reducing the number of defects in a business process
when you tell a story in a presentation, all of the following are true EXCEPT?
a well-told story should have no need for subsequent discussion
Online ________ is arguably the most commonly used data analysis technique in data warehouses.
analytical processing
Kaplan and Norton developed a report that presents an integrated view of success in the organization called
balanced scorecard-type reports
_________ charts are useful in displaying nominal data or numerical data that splits nicely into different categories so you can quickly see comparative results and trends.
bar
why is the customer perspective important in the balanced scoreboard methodology?
because dissatisfied customers will eventually hurt the bottom line
why is a performance management system superior to a performance measurement system?
because measurement alone has little use without action
which kind of chart is described as an enhanced variant of a scatter plot?
bubble chart
which component of a reporting system contains steps detailing how recorded transactions are converted into metrics, score cards, and dashboards?
business logic
a(n) _______ is a communication artifact, concerning business matters, prepared with the specific intention of relaying information in a presentable form.
business report
in which stage of extraction, transformation, and load (ETL) into a data warehouse are anomalies detected and corrected?
cleanse
travel and transport created an online BI self-service system that allowed ______ to access information directly.
clients
business performance management comprises a _______ set of processes that link strategy to execution with the goal of optimizing business performance.
closed-loop
what are 3 nonfinancial objectives of the balanced scorecard?
customer, internal business process, learning and growth
the three main types of data warehouses are data marts, operational________, and enterprise data warehouses.
data stores
The role responsible for successful administration and management of a data warehouse is the ________, who should be familiar with high-performance software, hardware, and networking technologies, and also possesses solid business insight.
data warehouse administrator (DWA)
in the Expedia case study what 3 steps were taken to convert drivers of departmental performance into a scorecard?
deciding how to measure satisfaction, setting the right performance targets, and putting data into context.
the "single version of the truth" embodied in a data warehouse such as Capri Casino's means all of the following EXCEPT
decision makers have unfettered access to all data in the warehouse
what are the steps knows as DMAIC?
define, measure, analyze, improve, control
________ modeling is a retrieval-based system that supports high-volume query access.
dimensional
when querying a dimensional database, a user went from summarized data to its underlying details. the function that served this purpose is
drill down
performance dashboards enable ______ operations that allow the users to view underlying data sources and obtain more detail.
drill down/drill through
what is the functional challenge of dashboard design?
ensuring that the required information is shown clearly on a single screeen
In the Michigan State Agencies case, the approach used was a(n) ________ one, instead of developing separate BI/DW platforms for each business area or state agency.
enterprise
which approach to data warehouse integration focuses more on sharing process functionality than data across systems
enterprise application integration
________ is a mechanism that integrates application functionality and shares functionality (rather than data) across systems, thereby enabling flexibility and reuse.
enterprise application integration (EAI)
for those executives who do not have the time to go through lengthy reports, the best alternative is the
executive summary
what is metric management reports
external: service level agreements (SLAs) internal: key performance indicators (KPIs)
Performing extensive ________ to move data to the data warehouse may be a sign of poorly managed data and a fundamental lack of a coherent data management strategy.
extraction, transformation, and load (ETL)
the ______ data warehouse architecture involves integrating disparate systems and analytical resources from multiple sources to meet changing needs or business conditions.
federated
which data warehouse architecture uses metadata from existing data warehouses to create a hybrid logical data warehouse comprised of data from the other warehouses?
federated achitecture
all of the following statements about metadata are true EXCEPT
for most organizations, data warehouse metadata are an unnecessary expense.
there are only a few categories of business report: informal, _______, and short.
formal
which type of visualization tool can be very helpful when a data set contain location data?
geographic map
which of the following is LEAST related to data/information visualization?
graphic artwork
all of the following are benefits of hosted data warehouses EXCEPT
greater control of data
how does the use of cloud computing affect the scalability of a data warehouse?
hardware resources are dynamically allocated as use increases
a(n)______ architecture is used to build a scalable and maintainable infrastructure that includes a centralized data warehouse and several dependent data marts.
hub-and-spoke
which data warehouse architecture uses a normalized relational warehouse that feeds multiple data marts
hub-and-spoke data warehouse architecture
data warehouses provide direct and indirect benefits to using organizations. Which of the following is an indirect benefit of data warehouses?
improved customer service
________ (also called in-database analytics) refers to the integration of the algorithmic extent of data analytics into data warehouse.
in-database processing
which kind of data warehouse is created separately from the enterprise data warehouse by a department and not reliant on it for updates?
independent data mart
The ________ Model, also known as the EDW approach, emphasizes top-down development, employing established database development methodologies and tools, such as entity-relationship diagrams (ERD), and an adjustment of the spiral development approach.
inmon
data _____ compromises data access, data federation, and change capture.
integration
the _______ perspective of the organization suggested by the balanced scorecard focuses on business processes and how well they are running.
internal business process
all of the following are true about in-database processing technology EXCEPT
it is the same as in-memory storage technology
which of the following statements is more descriptive of active data warehouses in contrast with traditional data warehouses?
large numbers of users, including operational staffs
in the Delta Lloyd Group case study; the______ is the stage of the reporting process in which consolidated figures are cited, formatted, and described to form the final text of the report.
last mile
______ describe the structure and meaning of the data, contributing to their effective use.
metadata
with a dashboard, information on sources of the data being presented, the quality and currency of underlying data provide contextual________ for users.
metadata
_______ management reports are used to manage business performance through outcome oriented metrics in many organizatons.
metric
what are the 3 major categories of business reports?
metric management, dashboard-type, and balanced scorecard-type
with dashboards, the layer of information that used graphical, abstracted data to keep tabs on key performance metrics is the _______ layer.
monitoring
according to Eckerson (2006) a well known expert on BI dashboards, what are the three layers of information of a dashboard
monitoring, analysis, and management
the internet emerged as a new medium for visualization and brought all the following EXCEPT
new forms of computation of business logic
what is the management feature of a dashboard?
operational data that identify what actions to take to resolve a problem
In the MultiCare case, how was data warehousing able to reduce septicemia mortality rates in MultiCare hospitals?
organized and simplified data from multiple sources; adressed 3 key bodies of work: standard of care definition, early identification, and efficient delivery of defined-care standard
which of the following BEST enables a data warehouse to handle complex queries and scale up to handle many more requests?
parallel processing
a strategically aligned metric is also known as a key _______.
performance indicator
which type of visualization tool can be helpful when the intention is to show realitve proportions of dollars per department allocated by a university administration?
pie chart
visual analytics is widely regarded as the combination of visualization and _______ analytics
predicitve
in_____oriented data warehousing, operational databases are turned to handle transactions that update the database.
product
with ______ data flows, managers can view the current state of their businesses and quickly identify problems.
real-time
most data warehouses are built using_______ databases management systems to control and manage the data.
relational
all of the following statement about balanced scorecards and dashboards are true EXCEPT
scorecards are best for real-time tracking of a marketing campaign
dashboards present visual displays of important information that are consolidated and arranged on a single _____.
screen
active data warehousing can be used to support the highest level of decision making sophistication and power. the major feature that enable this in relation to handling the data is
speed of data transfer
in the Mace case study, the IBM Cognos software enabled the rapid creation of integrated reports across 60 countries, replacing a large and complex________.
spreadsheet
in the Blastrac case study, Tableau analytics software was used to replace massive________ that were loaded with data from multiple ERP systems.
spreadsheets
when representing data in a data warehouse, using several dimension tables that are each connected only to a fact table means you are using which warehouse structure?
star schema
what are the 4 processes that define a closed loop BPM cycle?
strategize, plan, monitor/analyze, act and adjust
what are 5 distinguishing features of key performance indicators?
strategy, targets, ranges, encodings, time frames, benchmarks
operational or transaction databases are product oriented, handling transactions that update the database. In contrast data warehouses are
subject-oriented and nonvolatile
dashboards can be presented at all the following levels EXCEPT
the visual cube level
all of the following are true about external reports between businesses and government EXCEPT
their primary focus is government
benefits of the latest visual analytics tools, such as SAS Visual Analytics, include all of the following EXCEPT?
they explore massive amounts of data in hours, not days.
a Web client that connects to a Web server, which is in turn connected to a BI application server, is reflective of a
three tier architecture
Online ________ is a term used for a transaction system that is primarily responsible for capturing and storing data related to day-to-day business functions such as ERP, CRM, SCM, and point of sale.
transaction processing
in which stage of extraction, transformation, and load (ETL) into a data warehouse are data aggragated?
transformation
typical charts, graphs, and other visual elements used in visualization-based applications usually involved ________dimensions
two
There are several basic information system architectures that can be used for data warehousing. What are they?
two-tier and three-tier architectures are the most common,sometimes simply one tier.
in the Saudi Telecom company case study, information ______software allowed managers to see trends and correct issues before they became problems.
visualization
contexual metadata for a dashboard includes all the following EXCEPT
which operating system is running the dashboard server software
which type of questions does visual analytics seeks to answer?
why did it happen?