Business Intelligence, 4e Sharda/Delen/Turban) Chapte Descriptive Analytics 1: Nature of Data, Statistical Modeling andⅤ isualization 1)One of siriusXM's challenges was tracking potential customers when cars were sold Answer TRUE Diff: 1 Page Ref: 54 2)To respond to its market challenges, Sirius XM decided to focus on manufacturing efficiency Answer: FALSE Diff: 2 Page Ref: 55 3)Data is the contextualization of information, that is, information set in context Answer: FALSE Diff: 1 Page Ref: 98 4) Data is the main ingredient for any bl, data science, and business analytics initiative Answer: TRUE Diff: 2 Page Ref: 57 5)Predictive algorithms generally require a flat file with a target variable, so making data analytics ready for prediction means that data sets must be transformed into a flat-file format and made ready for ingestion into those predictive algorithms RUE Diff: 1 Page Ref: 58 6) 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, annotatio ts ar collaboration and other services Answer FALsE Diff: 2 Page Ref: 98 7)In the FEMA case study, the BureauNet software was the primary reason behind the increased speed and relevance of the reports Fema employees received Answer: TRUE Diff: 2 Page Ref: 100 8)Google Maps has set new standards for data visualization with its intuitive Web mapping software Answer: TRUE Diff: 2 Page Ref: 103 9) There are basic chart types and specialized chart types. A Gantt chart is a specialized chart type answe TRUE Diff: 2 Page Ref: 107 Copyright C 2018 Pearson Education, Inc
1 Copyright © 2018 Pearson Education, Inc. Business Intelligence, 4e (Sharda/Delen/Turban) Chapter 2 Descriptive Analytics I: Nature of Data, Statistical Modeling, and Visualization 1) One of SiriusXM's challenges was tracking potential customers when cars were sold. Answer: TRUE Diff: 1 Page Ref: 54 2) To respond to its market challenges, SiriusXM decided to focus on manufacturing efficiency. Answer: FALSE Diff: 2 Page Ref: 55 3) Data is the contextualization of information, that is, information set in context. Answer: FALSE Diff: 1 Page Ref: 98 4) Data is the main ingredient for any BI, data science, and business analytics initiative. Answer: TRUE Diff: 2 Page Ref: 57 5) Predictive algorithms generally require a flat file with a target variable, so making data analytics ready for prediction means that data sets must be transformed into a flat-file format and made ready for ingestion into those predictive algorithms. Answer: TRUE Diff: 1 Page Ref: 58 6) 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 Diff: 2 Page Ref: 98 7) In the FEMA case study, the BureauNet software was the primary reason behind the increased speed and relevance of the reports FEMA employees received. Answer: TRUE Diff: 2 Page Ref: 100 8) Google Maps has set new standards for data visualization with its intuitive Web mapping software. Answer: TRUE Diff: 2 Page Ref: 103 9) There are basic chart types and specialized chart types. A Gantt chart is a specialized chart type. Answer: TRUE Diff: 2 Page Ref: 107
10)Visualization differs from trad itional charts and graphs in complexity of data sets and use of multiple dimensions and measures Answer: TRUE Diff: 2 Page Ref: 110 11)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 Diff: 2 Page Ref: 113 12)Visual analytics is aimed at answering, " What is it happening? and is usually associated with business analytics Answer: FALSE Diff: 3 Page Ref: 112 13)Dashboards provide visual displays of important information that is consolidated and arranged across several screens to maintain data order Answer: FALSE Diff: 2 Page Ref: 117 14) In the Dallas Cowboys case study, the focus was on using data analytics to decide which players would play every week Answer: FALSE Diff: 2 Page ref: 118 15) Data source reliability means that data are correct and are a good match for the analytics problem Answer: FALSE Diff: 1 Page Ref: 59 16)Data accessibility means that the data are easily and readily obtainable Answer TRUE Diff: 3 Page Ref: 59 17) Structured data is what data mining algorithms use and can be classified as categorical or numerIc Answer: TRU Diff: 2 Page Ref: 61 18 ) Interval data are variables that can be measured on interval scales A TRUE Diff: 2 Page Ref: 62 19)Nominal data represent the labels of multiple classes used to divide a variable into specific group Answer FAlSE Diff: 2 Page Ref: 61 Copyright C 2018 Pearson Education, Inc
2 Copyright © 2018 Pearson Education, Inc. 10) Visualization differs from traditional charts and graphs in complexity of data sets and use of multiple dimensions and measures. Answer: TRUE Diff: 2 Page Ref: 110 11) 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 Diff: 2 Page Ref: 113 12) Visual analytics is aimed at answering, "What is it happening?" and is usually associated with business analytics. Answer: FALSE Diff: 3 Page Ref: 112 13) Dashboards provide visual displays of important information that is consolidated and arranged across several screens to maintain data order. Answer: FALSE Diff: 2 Page Ref: 117 14) In the Dallas Cowboys case study, the focus was on using data analytics to decide which players would play every week. Answer: FALSE Diff: 2 Page Ref: 118 15) Data source reliability means that data are correct and are a good match for the analytics problem. Answer: FALSE Diff: 1 Page Ref: 59 16) Data accessibility means that the data are easily and readily obtainable. Answer: TRUE Diff: 3 Page Ref: 59 17) Structured data is what data mining algorithms use and can be classified as categorical or numeric. Answer: TRUE Diff: 2 Page Ref: 61 18) Interval data are variables that can be measured on interval scales. Answer: TRUE Diff: 2 Page Ref: 62 19) Nominal data represent the labels of multiple classes used to divide a variable into specific groups. Answer: FALSE Diff: 2 Page Ref: 61
20)Descriptive statistics is all about describing the sample data on hand Answer: TRUE Diff: 2 Page Ref: 75 21)Which characteristic of data means that all the required data elements are included in the data set? a)data source reliability B)data accessibility C)data richness D)data granularity A Diff: 2 Page Ref: 59-60 22)Key performance indicators(KPIs) are metrics typically used to measure A)database responsiveness B)qualitative feed back C)external results D)internal results Answer: D Diff: 2 Page Ref: 99 23)Kaplan and Norton developed a report that presents an integrated view of success in the organization called A)metric management report B)balanced scorecard-type reports C)dashboard-type reports D)visual reports Answer: B Diff: 2 Page Ref: 99 24)Which characteristic of data requires that the variables and data values be defined at the lowest(or as low as required)level of detail for the intended use of the data? A)data source reliability B)data accessibility c)data richness D)data granularity Answer D Diff: 2 Page Ref: 59-60 25)Which of the following is LEAST related to data/information visualization? A)information graphics B)scientific visualization C)statistical graphics D)graphic artwork Answer D Diff: 2 Page Ref: 101 Copyright C 2018 Pearson Education, Inc
3 Copyright © 2018 Pearson Education, Inc. 20) Descriptive statistics is all about describing the sample data on hand. Answer: TRUE Diff: 2 Page Ref: 75 21) Which characteristic of data means that all the required data elements are included in the data set? A) data source reliability B) data accessibility C) data richness D) data granularity Answer: C Diff: 2 Page Ref: 59-60 22) Key performance indicators (KPIs) are metrics typically used to measure A) database responsiveness. B) qualitative feedback. C) external results. D) internal results. Answer: D Diff: 2 Page Ref: 99 23) Kaplan and Norton developed a report that presents an integrated view of success in the organization called A) metric management reports. B) balanced scorecard-type reports. C) dashboard-type reports. D) visual reports. Answer: B Diff: 2 Page Ref: 99 24) Which characteristic of data requires that the variables and data values be defined at the lowest (or as low as required) level of detail for the intended use of the data? A) data source reliability B) data accessibility C) data richness D) data granularity Answer: D Diff: 2 Page Ref: 59-60 25) Which of the following is LEAST related to data/information visualization? A) information graphics B) scientific visualization C) statistical graphics D) graphic artwork Answer: D Diff: 2 Page Ref: 101
26)The Internet emerged as a new medium for visualization and brought all the following EXCEPT A)world wide digital distribution of visualization B)immersive environments for consuming data C)new forms of computation of business logic D)new graphics displays through PC displays Answer: C Diff: 2 Page Ref: 101-103 27)Which kind of chart is described as an enhanced version of a scatter plot? A)heat map B)bullet D)bubble chart Answer: D Diff: 3 Page Ref: 107 28 )Which type of visualization tool can be very helpful when the intention is to show relative proportions of dollars per department allocated by a university administration A)heat B)bullet C) pie chart D)bubble chart Answer: C Diff: 3 Page Ref: 106 29)Which type of visualization tool can be very helpful when a data set contains location data? A)bar chart B)geographic map C) highlight table D)tree map Answer: B Diff: 2 Page Ref: 107 30)Which type of question does visual analytics seeks to answer? A)Why is it happening? B)What happened yesterday? C)What is happening today? D)When did it happen? Answer A Diff: 2 Page ref: 112 Copyright C 2018 Pearson Education, Inc
4 Copyright © 2018 Pearson Education, Inc. 26) The Internet emerged as a new medium for visualization and brought all the following EXCEPT A) worldwide digital distribution of visualization. B) immersive environments for consuming data. C) new forms of computation of business logic. D) new graphics displays through PC displays. Answer: C Diff: 2 Page Ref: 101-103 27) Which kind of chart is described as an enhanced version of a scatter plot? A) heat map B) bullet C) pie chart D) bubble chart Answer: D Diff: 3 Page Ref: 107 28) Which type of visualization tool can be very helpful when the intention is to show relative proportions of dollars per department allocated by a university administration? A) heat map B) bullet C) pie chart D) bubble chart Answer: C Diff: 3 Page Ref: 106 29) Which type of visualization tool can be very helpful when a data set contains location data? A) bar chart B) geographic map C) highlight table D) tree map Answer: B Diff: 2 Page Ref: 107 30) Which type of question does visual analytics seeks to answer? A) Why is it happening? B) What happened yesterday? C) What is happening today? D) When did it happen? Answer: A Diff: 2 Page Ref: 112
31)When you tell a story in a presentation, all of the following are true EXCEPT A)a story should make sense and order out of a lot of background noise B)a well-told story should have no need for subsequent discussion C) stories and their lessons should be easy to remember D)the outcome and reasons for it should be clear at the end of your story Answer: B Diff: 2 Page Ref: 113 32)Benefits of the latest visual analytics tools, such as Sas Visual Analytics, include all of the following EXCEPT A)mobile platforms such as the iPhone are supported by these products B)it is easier to spot useful patterns and trends in the data C) they explore massive amounts of data in hours, not days D)there is less demand on It departments for reports Answer: C Diff: 2 Page Ref: 115 33)What is the management feature of a dashboard? A)operational data that identify what actions to take to resolve a problem B)summarized dimensional data to analyze the root cause of problems C)summarized dimensional data to monitor key performance metrics D)graphical, abstracted data to monitor key performance metrics Al nswer Diff: 3 Page Ref:119 34)What is the fundamental challenge of dashboard design? A)ensuring that users across the organization have access to it B)ensuring that the organization has the appropriate hard ware onsite to support C)ensuring that the organization has access to the latest Web browsers D)ensuring that the required information is shown clearly on a single screen Diff: 3 Page Ref: 119 35)Contextual metadata for a dashboard includes all the following EXCEPT A)whether any high-value transactions that would skew the overall trends were rejected as a part of the load ing process B)which operating system is running the dashboard server software C) whether the dashboard is presenting"fresh"or"stale"information D)when the data warehouse was last refreshed Al nswer Diff: 2 Page Ref: 121 Copyright C 2018 Pearson Education, Inc
5 Copyright © 2018 Pearson Education, Inc. 31) When you tell a story in a presentation, all of the following are true EXCEPT A) a story should make sense and order out of a lot of background noise. B) a well-told story should have no need for subsequent discussion. C) stories and their lessons should be easy to remember. D) the outcome and reasons for it should be clear at the end of your story. Answer: B Diff: 2 Page Ref: 113 32) Benefits of the latest visual analytics tools, such as SAS Visual Analytics, include all of the following EXCEPT A) mobile platforms such as the iPhone are supported by these products. B) it is easier to spot useful patterns and trends in the data. C) they explore massive amounts of data in hours, not days. D) there is less demand on IT departments for reports. Answer: C Diff: 2 Page Ref: 115 33) What is the management feature of a dashboard? A) operational data that identify what actions to take to resolve a problem B) summarized dimensional data to analyze the root cause of problems C) summarized dimensional data to monitor key performance metrics D) graphical, abstracted data to monitor key performance metrics Answer: A Diff: 3 Page Ref: 119 34) What is the fundamental challenge of dashboard design? A) ensuring that users across the organization have access to it B) ensuring that the organization has the appropriate hardware onsite to support it C) ensuring that the organization has access to the latest Web browsers D) ensuring that the required information is shown clearly on a single screen Answer: D Diff: 3 Page Ref: 119 35) Contextual metadata for a dashboard includes all the following EXCEPT A) whether any high-value transactions that would skew the overall trends were rejected as a part of the loading process. B) which operating system is running the dashboard server software. C) whether the dashboard is presenting "fresh" or "stale" information. D) when the data warehouse was last refreshed. Answer: B Diff: 2 Page Ref: 121