Typical charts, graphs, and other visual elements used in visualization-based applications usually involve ________ dimensions. - Answer- two
________ c... [Show More] harts or network diagrams show precedence relationships among the project activities/tasks. - Answer- PERT
________ regression is a very popular, statistically sound, probability-based classification algorithm that employs supervised learning. - Answer- Logistic
________ charts are a special case of horizontal bar charts that are used to portray project timelines, project tasks/activity durations, and overlap among the tasks/activities. - Answer- Gantt
________ plots are often used to explore the relationship between two or three variables (in 2-D or 2-D visuals). - Answer- Scatter
________ management reports are used to manage business performance through outcome-oriented metrics in many organizations. - Answer- Metric
________ charts are effective when you have nominal data or numerical data that splits nicely into different categories so you can quickly see comparative results and trends within your data. - Answer- Bar
Information dashboards enable ________ operations that allow the users to view underlying data sources and obtain more detail. - Answer- drill-down/drill-through
A(n) ________ is a communication artifact, concerning business matters, prepared with the specific intention of relaying information in a presentable form. - Answer- report
When validating the assumptions of a regression, ________ assumes that the errors of the response variable are normally distributed. - Answer- normality
Dashboards present visual displays of important information that are consolidated and arranged on a single ________. - Answer- screen
________ statistics is about drawing conclusions about the characteristics of the population. - Answer- Inferential
________ series forecasting is the use of mathematical modeling to predict future values of the variable of interest based on previously observed values. - Answer- Time
A(n) ________ data store (ODS) provides a fairly recent form of customer information file. - Answer- operational
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. - Answer- Kimball
In ________ oriented data warehousing, operational databases are tuned to handle transactions that update the database. - Answer- product
Given that the size of data warehouses is expanding at an exponential rate, ________ is an important issue. - Answer- scalability
________ describe the structure and meaning of the data, contributing to their effective use. - Answer- Metadata
________ 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. - Answer- Enterprise information integration (EII)
A(n) ________ data mart is a subset that is created directly from the data warehouse.. - Answer- dependent
The ________ data warehouse architecture involves integrating disparate systems and analytical resources from multiple sources to meet changing needs or business conditions. - Answer- federated
Most data warehouses are built using ________ database management systems to control and manage the data. - Answer- relational
________ is a mechanism that integrates application functionality and shares functionality (rather than data) across systems, thereby enabling flexibility and reuse. - Answer- Enterprise application integration (EAI)
Data ________ comprises data access, data federation, and change capture. - Answer- integration
The three main types of data warehouses are data marts, operational ________, and enterprise data warehouses. - Answer- 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. - Answer- data warehouse administrator (DWA)
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. - Answer- transaction processing
________ modeling is a retrieval-based system that supports high-volume query access. - Answer- Dimensional
To respond to its market challenges, SiriusXM decided to focus on manufacturing efficiency. - Answer- False
Visualization differs from traditional charts and graphs in complexity of data sets and use of multiple dimensions and measures. - Answer- True
The data storage component of a business reporting system builds the various reports and hosts them for, or disseminates them to users. It also provides notification, annotation, collaboration, and other services. - Answer- False
Google Maps has set new standards for data visualization with its intuitive Web mapping software. - Answer- True
Interval data are variables that can be measured on interval scales. - Answer- True
Data source reliability means that data are correct and are a good match for the analytics problem. - Answer- False
Descriptive statistics is all about describing the sample data on hand. - Answer- True
One of SiriusXM's challenges was tracking potential customers when cars were sold. - Answer- True
Structured data is what data mining algorithms use and can be classified as categorical or numeric. - Answer- True
Data is the main ingredient for any BI, data science, and business analytics initiative. - Answer- True
When telling a story during a presentation, it is best to avoid describing hurdles that your character must overcome, to avoid souring the mood. - Answer- False
Data is the contextualization of information, that is, information set in context. - Answer- False
Dashboards provide visual displays of important information that is consolidated and arranged across several screens to maintain data order. - Answer- False
Data accessibility means that the data are easily and readily obtainable. - Answer- True
There are basic chart types and specialized chart types. A Gantt chart is a specialized chart type. - Answer- True
Data warehouses are subsets of data marts. - Answer- False
The data warehousing maturity model consists of six stages: prenatal, infant, child, teenager, adult, and sage. - Answer- True
User-initiated navigation of data through disaggregation is referred to as "drill up." - Answer- False
Without middleware, different BI programs cannot easily connect to the data warehouse. - Answer- True
The "islands of data" problem in the 1980s describes the phenomenon of unconnected data being stored in numerous locations within an organization. - Answer- True
OLTP systems are designed to handle ad hoc analysis and complex queries that deal with many data items. - Answer- False
The BPM development cycle is essentially a one-shot process where the requirement is to get it right the first time. - Answer- False
One way an operational data store differs from a data warehouse is the recency of their data. - Answer- True
Properly integrating data from various databases and other disparate sources is a trivial process. - Answer- False
The hub-and-spoke data warehouse model uses a centralized warehouse feeding dependent data marts. - Answer- True
With the balanced scorecard approach, the entire focus is on measuring and managing specific financial goals based on the organization's strategy. - Answer- False
With key performance indicators, driver KPIs have a significant effect on outcome KPIs, but the reverse is not necessarily true. - Answer- True
Because the recession has raised interest in low-cost open source software, it is now set to replace traditional enterprise software. - Answer- False
Because of performance and data quality issues, most experts agree that the federated architecture should supplement data warehouses, not replace them. - Answer- True
Data warehouse administrators (DWAs) do not need strong business insight since they only handle the technical aspect of the infrastructure. - Answer- False
Describe the difference between simple and multiple regression. - Answer- If the regression equation is built between one response variable and one explanatory variable, then it is called simple regression. Multiple regression is the extension of simple regression where the explanatory variables are more than one.
According to Eckerson (2006), a well-known expert on BI dashboards, what are the three layers of information of a dashboard? - Answer- 1. Monitoring. Graphical, abstracted data to monitor key performance metrics.2. Analysis. Summarized dimensional data to analyze the root cause of problems.3. Management. Detailed operational data that identify what actions to take to resolve a problem.
Describe the difference between descriptive and inferential statistics. - Answer- The main difference between descriptive and inferential statistics is the data used in these methods—whereas descriptive statistics is all about describing the sample data on hand, and inferential statistics is about drawing inferences or conclusions about the characteristics of the pop [Show Less]
