Revenues are complex and have many sources. This variety and detail make understand ing the data difficult, hampering efficiency. The use of bi tools allows for better analysis, understand ing, and governance What were the challenges the state of Maryland was facing with regard to tax fraud? The state was facing tax fraud from fraudulent returns as other states were. and the process of detecting and investigating potential fraud was time consuming 3. What was the solution they adopted? Do you agree with their approach? Why? The state implemented a data warehouse from Teradata that allowed them to examine data and identify/flag traits that were consistent with fraudulent return 4. What were the results that they obtained? Did the investment in BI and data warehousing pay off? The team was able to flag a smaller number of potentially fraudulent returns, but those that they did identify were significantly more likely to be false. this allowed the state to recover $7 million more, making the investment pay off. 5. What other problems and challenges do you think federal and state governments are having that can benefit from BI and data warehousing? Student responses will vary but could include ideas relating to voter fraud med ical use. and other tax issues Section 3. 2 Review Questions What is a data warehouse? a data warehouse is defined in this section as"a pool of data produced to support decision making " This focuses on the essentials. leaving out characteristics that may vary from one dw to another but are not essential to the basic concept The same paragraph gives another definition: a subject-oriented, integrated time-variant, nonvolatile collection of data in support of managements decision making process. This definition adds more specifics, but in every case appropriately: it is hard, if not impossible, to conceive of a data warehouse that would not be subject-oriented, integrated, etc How does a data warehouse differ from a database? echnically a data warehouse is a database albeit with certain characteristics to facilitate its role in decision support. Specifically, however, it is(see previous Copyright C2018 Pearson Education, Inc.3 Copyright © 2018Pearson Education, Inc. Revenues are complex and have many sources. This variety and detail make understanding the data difficult, hampering efficiency. The use of BI tools allows for better analysis, understanding, and governance. 2. What were the challenges the state of Maryland was facing with regard to tax fraud? The state was facing tax fraud from fraudulent returns as other states were, and the process of detecting and investigating potential fraud was time consuming. 3. What was the solution they adopted? Do you agree with their approach? Why? The state implemented a data warehouse from Teradata that allowed them to examine data and identify/flag traits that were consistent with fraudulent return. 4. What were the results that they obtained? Did the investment in BI and data warehousing pay off? The team was able to flag a smaller number of potentially fraudulent returns, but those that they did identify were significantly more likely to be false. This allowed the state to recover $7 million more, making the investment pay off. 5. What other problems and challenges do you think federal and state governments are having that can benefit from BI and data warehousing? Student responses will vary but could include ideas relating to voter fraud, medical use, and other tax issues. Section 3.2 Review Questions 1. What is a data warehouse? A data warehouse is defined in this section as “a pool of data produced to support decision making.” This focuses on the essentials, leaving out characteristics that may vary from one DW to another but are not essential to the basic concept. The same paragraph gives another definition: “a subject-oriented, integrated, time-variant, nonvolatile collection of data in support of management’s decision￾making process.” This definition adds more specifics, but in every case appropriately: it is hard, if not impossible, to conceive of a data warehouse that would not be subject-oriented, integrated, etc. 2. How does a data warehouse differ from a database? Technically a data warehouse is a database, albeit with certain characteristics to facilitate its role in decision support. Specifically, however, it is (see previous