Case Study–A Practical Approach to Information Communications Technology IT Gove
ID: 3816119 • Letter: C
Question
Case Study–A Practical Approach to Information Communications Technology
IT Governance Committee:
Assume that you are part of the highly qualified IT Governance Committee employed by
one of the US’s largest pizza company named as ‘Mama’s Pizzeria’ a pizza company
which is internationally recognized and one of the delicious pizza company globally.
Your IT Governance team comprises of 5 members who are as follows:
IT Governance team
Member 1 - Chief Executive Officer (CEO)
Member 2 - Chief Financial Officer (CFO)
Member 3 - Chief Marketing Officer(CMO)
Member 4 - Chief Information Officer(CIO)
Member 5 - Chief Technology Officer CTO)
Your IT Governance Committee is in-charge of governing the overall development and
operation of IT/IS systems and has several important responsibilities such as:
Aligning IT investments to business strategy. Investing funds and resources in the
most beneficial IT systems will enhance the long-range goal of achieving the
business strategy.
Budgeting funds and personnel for the most effective use of the IT systems.
Overseeing and prioritizing changes to IT systems. Within organizations, many
user groups will concurrently request improvements or changes to their sub-
system within the IT system and prioritizing these requests according to the best
match to the business strategy and the feasibility of designing, developing and
implementing the necessary changes.
Developing, monitoring and reviewing all IT operational policies. The
organization will maintain policies and descriptions of procedures for operating
and developing its IT systems.
Developing, monitoring and reviewing security policies. The organization will
maintain policies and descriptions of procedures related to security.
Establishing systems development process that controls the initiation, approval,
development and maintenance of those changes. This process called the systems
development life cycle (SDLC) can be generally described as the systematic steps
undertaken to plan, prioritize, authorize, oversee, test and implement large-scale
changes to the IT system.
Your IT Governance Team comprising of the above members’ and positions’ has been
engaged to carry out its duties as per the requirements in the sections hereafter.
Section 4 – To be completed by the ‘Chief Information Officer’ of the IT
Governance Team
You are the Chief Information Officer of Mama’s Pizzeria involved as part of the IT
Governance team to provide your opinion and solutions for the following questions:
This section presents a process map (Exhibit 4.1), a document flowchart (Exhibit 4.2),
and a data flow diagram (Exhibit 4.3) for a small, local restaurant. In those exhibits
manual records and documents as well as manual processes are depicted. On the basis of
the case information and the 3 exhibits mentioned, complete the following requirements:
Required:
Read the article Peter Greyton mentioned regarding Anheuser-Busch at
http://www.cnn.com/2004/TECH/ptech/02/25/bus2.feat.beer.network/index.html.
Use this article regarding the sales and inventory management systems in place at
Anheuser-Busch, and answer the following questions:
Required:
1. Describe the purpose of a data warehouse and describe how Anheuser-Busch uses
data warehousing.
2. Describe the purpose and use of data mining and describe how Anheuser-Busch
uses data mining.
3. Describe how data warehousing and data mining can facilitate reporting and
analysis at Mama’s Pizzeria.
Now assume that you as part of Mama’s Pizzeria management you wish to upgrade its
accounting software to an ERP system.
To answer some of the questions here, you may have to do research about ERP
systems on the Internet. One example of a website with information about
accounting software is www.accountingsoftware411.com or
www.2020software.com
4. What advantages could Mama’s Pizzeria expect by upgrading to an ERP system?
5. As Mama’s Pizzeria considers modules to purchase, which four or five modules
do you believe would be most critical? Why?
6. Which method of implementation of an ERP system do you suggest for Mama’s
Pizzeria? Why?
7. Recommend two or three ERP systems that would be appropriate for Mama’s
Pizzeria. be specific with respect to the name of the ERP software system and the
provider company. When making these recommendations consider the size of
Mama’s Pizzeria and, therefore, what it might be able to afford.
Explanation / Answer
1. Data warehouse is the system which stores the organisation data i.e. current and historical data. It will be most helpful in getting reports and to access information about old data. It is mainly used For data analysis and to take reports.
It is the central system which collectsor stores information from the multiple sources.
Anheuser-Busch usesd datawarehousing to store the information about the traders, complete information about customers i.e. name, gender,what they bought,how much they paid etc like this and also they are storing their stock information etc .. They are using the system over all of their stores to enter the information and the all the systems in stores spanned across multiple places will connected to the same database that is nothing but data warehouse which gets their reports about the past transactions.
2. Data mining is mainly used to analyse and retrieve the data accordingly to our requirement. Data mining is just the process of retrieving the data from the warehouse.
In retrieving this data one can retrieve in many dimensions and angles. This is the main purpose of data mining. It will allow us to retrieve the data among many dimensions and angles to identify the relationships
Anheuser-Busch uses data mining to retrieve the data about the past transactions of the customer to identify them by retrieving information about last time what they bought and how much they paid and also in a way that keep tracking of the self space for the different brands etc like this. All this reports or information what they getting is nothing but data mining.
3. In Mamas pizzeria we will all the information about the transactions happened and the customer information and the orders information etc. Storing all this information is nothing but data warehousing. Now this might have many branches and the many branches may get many orders and can enter customer information all this are stored in the data warehouse.
And every day the CEO want to know the business status that day and he may want to compare the status with multiple days statuses. Or he want to see how many online order are getting booked every day and how much money they are getting everyday. To show all this information individually in a clear manner data mining is very much helpful it will give the reports according to your requirements on multiple dimensions and angles.
4. By upgrading to erp system all the different departments information will be centrally stored in one database only. And for every department there will be separate application options accordingly. It is very secure. Even it might have different branches on multiple places all this branches can be connected to single database.
And also reporting and data analysis all these are very easy and efficient.