Review the Opening Vignette: 3.1 “Targeting Tax Fraud with Business Intelligence

Review the Opening Vignette: 3.1 “Targeting Tax Fraud with Business Intelligence

Review the Opening Vignette: 3.1 “Targeting Tax Fraud with Business Intelligence and Data Warehousing” from Chapter 3, Business Intelligence, Analytics, and Data Science: A Managerial Perspective.  Reflect on the advantage the IRS and U.S. state government’s can gain from implementing a data warehouse? Would you have used a traditional information system (e.g. operational/transactional system) instead of a data warehouse to solve the IRS and U.S state government’s problem? Explain why. In addition, how can other companies apply similar solutions to the same problem? Can these other companies apply the same business intelligence solution for their advantage or disadvantage?
Resources:
Business Intelligence, Analytics, and Data Science: A Managerial Perspective Chapter 3
Chapter 3 topics of current interest in data warehousing
Reply

1.  After reading this case study, there are definite advantages that the IRS an

1. 
After reading this case study, there are definite advantages that the IRS an

1. 
After reading this case study, there are definite advantages that the IRS and U.S. state governments can gain from implementing a data warehouse. One advantage is the ability to consolidate data from multiple sources. This would allow a more complete view of tax records and transactions, using advanced analytics, to help detect fraudulent activity in a timely manner. Additionally, with advanced analytics, the IRS and U.S state governments can develop more accurate models for detecting fraudulent returns, which will help limit the number of false positives and ensure legitimate tax payers receive their refunds without any delays.
I believe that sticking with a traditional information system rather than migrating over to a data warehouse would be detrimental. This is because with a traditional information system, trying to run complex analytics on transactional systems will greatly impact the performance of said systems, slowing down day to day operations. In addition, traditional information systems mainly focus on current transactions and do not maintain historical data, while data warehouses are built to store and analyze historical data, which per this case study, aided the state of Maryland in identifying particular trends and patterns of fraud. As previously mentioned, data warehouse helps consolidate data from multiple sources however, with a traditional information system, data is usually isolated in different locations, making it hard for said data to be consolidated in one central location.
Other companies that decide to implement a data warehouse will experience great benefits and can resolve similar challenges that the IRS and U.S state governments were facing. For example, banks can utilize data warehousing and BI to detect fraud transactions by analyzing transaction patterns and customer behavior; Retail stores can use BI tools to detect fraud transactions, return fraud, and make inventory management more efficient; Healthcare companies will be able to detect fraudulent claims by analyzing patient records and insurances claims data. While these examples detail some of the advantages of implementing a BI solution, there are also disadvantages to this. Implementing and maintaining a data warehouse and BI tools can be expensive. Additionally, there can be privacy and security risks when handling a vast amount of sensitive data. Lastly, companies can face resistance from their staff who are use to their current systems and are not comfortable with change. However, I believe that when implemented right, the advantages outweigh the disadvantages when it comes to implementing a data warehouse and BI tools.
2.
Implementing a data warehouse offers substantial benefits for the IRS and U.S. state governments. Data warehouses integrate data from multiple sources, providing a holistic view of taxpayer information, which is important l for identifying fraud patterns and anomalies. They ensure that data is clean, accurate, and standardized, which is essential for reliable analysis and decision-making. Additionally, data warehouses support sophisticated analytical techniques, including predictive modeling and machine learning, which are vital for detecting complex and evolving fraud schemes. They store large amounts of historical data, enabling trend analysis and the detection of long-term fraud patterns. Furthermore, data warehouses are designed for complex queries and analysis, allowing for faster data retrieval and more timely insights compared to traditional systems. Their scalability also allows them to manage large volumes of data, accommodating the extensive datasets associated with tax returns and other financial records.
Using a traditional information system, such as an operational/transactional system, would not be as effective for solving the IRS and state governments’ problems with tax fraud. Traditional systems often operate in isolation, making it difficult to integrate data from various sources and obtain a comprehensive view. They are optimized for day-to-day transactions and typically do not store extensive historical data needed for detecting fraud trends. Moreover, traditional systems are not designed for complex queries and analytics, which can significantly slow down performance and hinder timely fraud detection. They also lack the capabilities to support advanced analytics, such as predictive modeling and machine learning, which are essential for identifying sophisticated fraud schemes.
Other companies can apply similar business intelligence (BI) and data warehousing solutions to address various issues. For instance, banks and insurance companies can use data warehouses to detect fraudulent transactions, manage risk, and comply with regulatory requirements. Retailers can analyze customer data to detect fraudulent activities, such as returns fraud, and optimize supply chain management. Healthcare providers can identify fraudulent claims, improve patient care by analyzing treatment outcomes, and optimize resource allocation. The advantages of implementing data warehouses include the ability to leverage them for identifying and preventing fraudulent activities, improving decision-making through access to integrated and high-quality data, streamlining operations by identifying inefficiencies and optimizing processes, and gaining deeper insights into customer behavior and preferences. However, there are disadvantages as well, including the cost of implementing and maintaining a data warehouse, which can be expensive, particularly for smaller companies. Setting up a data warehouse also requires significant technical expertise and resources. Additionally, companies must ensure that they comply with data privacy regulations and protect sensitive information from breaches.

The company’s data is spread across multiple independent database silos making i

The company’s data is spread across multiple independent database silos making i

The company’s data is spread across multiple independent database silos making it difficult to aggregate, reconcile, and facilitate the decision-making process in the organization. The company needs to ensure that everyone in the organization speaks the same business language and agrees on a standard definition of data terms in order to find a ‘Single Version of the Truth to drive to the right conclusion’. To overcome these challenges, the company made the decision to implement a BI solution. As a recently hired BI Manager in the company, you are tasked to lead and oversee the creation of the BI solution. Prepare and submit a 5 to 6 slide Power Point presentation (APA format) that includes the following:
Your proposed High-level IS Architecture Diagram of Steel Wheels’ BI solution
A description of each component in this Architecture.
Your High-level IS Architecture diagram should look similar to the diagram found on page 138 or slide #13 from Chapter 3 of Business Intelligence, Analytics, and Data Science: A Managerial Perspective. Create your own diagram and be as creative as you want in your presentation! Also, on page 138 you will find the definitions of the components of High-Level IS Architecture for your reference. You may consider as well new trends like Big Data, Event-Processing, and On-Demand Delivery as part of the company’s BI Architecture.  Before you start with the assignment, please read the company overview PowerPoint presentation (Steel-Wheels-Overview.pptx Download Steel-Wheels-Overview.pptx). The company is a fictitious company made up for this class. Throughout this class, we will complete case studies and solve problems for the company. Please make sure to first read and review the company’s overview so that you get familiarized with the company. After you review the company overview, start completing the Week 2 Case Study assignment as directed in the above instructions.
Resources:
Chapter 3 – Descriptive Analytics II: Nature of Data, Statistical Modeling, and Visualization from Business Intelligence, Analytics, and Data Science: A Managerial Perspective – Chapter 3 provides an overview of typical high-level IS architecture of a data warehouse.
Oracle Data warehousing Approach and ConceptsLinks to an external site. – This is a good reference describing the business intelligence approach.https://docs.oracle.com/cd/B10500_01/server.920/a96520/concept.htm
Steel-Wheels Company PowerPoint Overview Download Steel-Wheels Company PowerPoint Overview 
Big Data: This massive gathering and analyzing of data in real time is allowing us to not only address some of humanity biggest challenges but is also helping create a new kind of planetary nervous system. Yet as Edward Snowden and the release of the Prism documents have shown, the accessibility of all this data collection comes at a STEEP price!!https://youtu.be/bIY3LUZ7i8Y?si=18toh1YzlZ3tas9fLinks to an external site.

Complete the following problems using Microsoft Excel. List each question and an

Complete the following problems using Microsoft Excel. List each question and an

Complete the following problems using Microsoft Excel. List each question and answer on ONE sheet. Be sure to keep data in the same units. 
Problems:
John takes two hours to paint a room, and Sarah takes three hours to paint the same room. If they work together, how long will it take them to paint the room?
Alex can complete a project in five days, while Emily can complete the same project in seven days. How long will it take them to finish the project if they work together?
Mike can mow a lawn in four hours, and Lisa can mow the same lawn in six hours. How long will it take them to mow the lawn if they work together?
David can assemble a bicycle in one hours, and Emma can assemble the same bicycle in two hours. How long will it take them to assemble the bicycle if they work together?
Amy can bake a batch of cookies in 30 minutes, and Jake can bake the same batch of cookies in 45 minutes. How long will it take them to bake the batch of cookies if they work together?
Submit your Microsoft Excel file – clearly labeling your worksheet and problems, your answers, and any conclusions you draw. Your spreadsheets are expected to include the complete data set used and a complete copy of all calculations or other work you have performed to derive your answers for each problem.  No credit will be granted for work that is not completed using Excel, for which your Excel worksheet is not fully interactive, or for which your work shown is incomplete.

Step 1: Choose a Company In the first Competency Assessment, you completed a SWO

Step 1: Choose a Company
In the first Competency Assessment, you completed a SWO

Step 1: Choose a Company
In the first Competency Assessment, you completed a SWOT analysis on a successful company that demonstrated a sustainable competitive advantage in the
marketplace. Now you will shift your focus to look at a company that is failing or experiencing challenges in the area of financial performance.
Select and research a company that is having financial difficulties or is on the brink of bankruptcy. You may also choose to use your current employer or a
company you’ve worked for in the past as long as you have sufficient data to complete the assignment.
Review “Where Can I Find a Company’s Annual Report and Its SEC Filings?” from Investopedia.
You can also access specific information about a variety of businesses in the University Library by searching the following databases:
• University Library > Databases > B > Business Source Complete
• University Library > How Do I > Company Information > Find Annual Reports > EDGAR (SEC Filings)
• University Library > Databases > P > Plunkett Research Online
Step 2: Write an Analysis
Conduct a strategic analysis of the company’s current financial operations. Determine strategies for achieving a sustainable competitive advantage in the
marketplace and increasing financial performance.
Write a 750- to 1000-word strategic analysis. When writing your analysis, complete the following:
• Evaluate the company’s current financial plan, including charts and/or graphs showing financial data from the struggling company and make
recommendations for improvement.
• Determine strategies for achieving a sustainable competitive advantage in the marketplace and increasing financial performance.
• Create a plan to implement the strategies you selected.
• Include at least 3 sources.

1. The article I found online was titled, “A GENERALIZED SYMBIOTIC SIMULATION MO

1. The article I found online was titled, “A GENERALIZED SYMBIOTIC SIMULATION MO

1. The article I found online was titled, “A GENERALIZED SYMBIOTIC SIMULATION MODEL OF AN EMERGENCY DEPARTMENT FOR REAL-TIME OPERATIONAL DECISION-MAKING” and was written by Alexander R. Heib, Christine S. M. Currie, Bhakti Stephan Onggo, and Honora K. Smith (University of Southampton) and James Kerr (Hampshire Hospitals NHS Foundation Trust). This article was found from the provided link, Winter Simulation Conference ArchiveLinks to an external site., and the link to the article is 087.pdf (informs-sim.org)Links to an external site..
The simulation application was designed to improve short term decision making in emergency rooms in the United Kingdom in Europe. The overall aim being to more efficiently admit patients in the ER while saving time for both the workers and the patients. According to Heib et al, “By examining the outputs of the model, we were able to verify visually that patients were being placed into the appropriate queues and exiting the system. As the simulation-optimization routine will need to have a small execution time, ideally under 20 minutes, another aspect of the simulation validation was ensuring that the model ran fast enough. One simulation run took on average 0.05 seconds to complete.” (Heib et al, 2023) The benefits on the simulation have shown that they are reducing inefficiencies in the emergency room.
I chose this article because although this article specifically addresses the emergency rooms in Europe and the United Kingdom, I have waited a long time in an emergency room in the United States, so I think this is a very good simulation idea. It makes a lot of sense that a simulation could be built for majority of patients/cases to provider a quicker experience for all.
References:
A Generalized Symbiotic Simulation Model of an Emergency Department for Real-Time Operational Decision-Making
2.
Title Autonomic Orchestration of In-Situ and In-Transit Data Analytics for Simulation Studies
Author Xiaorui Du (Technical University of Munich); Adriano Pimpini (Sapienza, University of Rome); Andrea Piccione (Huawei Munich Research Center); Zhuoxiao Meng and Anibal Siguenza-Torres (Technical University of Munich); Stefano Bortoli (Huawei Munich Research Center); Alois Knoll (Technical University of Munich); and Alessandro Pellegrini (University of Rome Tor Vergata)
Source WSC
Link https://informs-sim.org/wsc23papers/065.pdfLinks to an external site.
This article discusses how modern distributed simulations produce large amounts of data. Performing analyses on the end of simulations can cause bottlenecks. Processing data produced by simulations can also impair computational performance and overload the network. The authors present a methodology and architecture for constructing an autonomic control system to determine best runtimes for data processing. Allowing a tradeoff between load on the simulation’s path and data system. This allows for improved processing time of data, reducing end-to-end completion time for evaluating queries.
I selected this article because it was based on data analytics. In an environment where businesses are transitioning to AI, machine learning and data analytics, this will lead to processing more and more data. Most data requires extensive cleaning and filtering before it can be processed leading to many delays in processing times. 

Review the Opening Vignette: 2.1 “Sirius XM Attracts and Engages a New Generatio

Review the Opening Vignette: 2.1 “Sirius XM Attracts and Engages a New Generatio

Review the Opening Vignette: 2.1 “Sirius XM Attracts and Engages a New Generation of Radio Consumers with Data-Driven Marketing” from Chapter 2, Business Intelligence, Analytics, and Data Science: A Managerial Perspective. Write a 3 to 4 page paper describing the challenge presented and the BI solution implemented. Also, include an answer to the following question: What do you think were the dependencies on the information technology infrastructure that gave success to the BI solution? Submit this assignment as a Microsoft Word document using APA format. Be sure to include an introduction and a conclusion in this assignment.
2.1 Opening Vignette: SiriusXM Attracts and Engages a New Generation of Radio Consumers with Data-Driven Marketing
SiriusXM Radio is a satellite radio powerhouse, the largest radio company in the world with $3.8 billion in annual revenues and a wide range of hugely popular music, sports, news, talk, and entertainment stations. The company, which began broadcasting in 2001 with 50,000 subscribers, grew to 18.8 million subscribers in 2009, and today has nearly 29 million.
Much of SiriusXM’s growth to date is rooted in creative arrangements with automobile manufacturers; today, nearly 70% of new cars are SiriusXM-enabled. Yet the company’s reach has extended far beyond car radios in the United States to a worldwide presence on the Internet, on smartphones and through other services and distribution channels, including SONOS, JetBlue, and Dish.