






Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Management Information Systems course is not only part of management degree but other major fields as well like computer science. This lecture handout was designed and distributed by Prof. Govind Bihari at Bengal Engineering and Science University. It includes: Database, Management, System, Decision, Makers, Commodity, Cost-oriented, Communicating, Performance, Value, Benchmarking, Visionary, Challenges
Typology: Study notes
1 / 10
This page cannot be seen from the preview
Don't miss anything!







13.4.6 Measuring Performance Using Appropriate Metrics CI3Os express frustration that decision makers in their enterprises view technology as a commodity and use cost-oriented evaluations such as decreasing costs or ROI. Traditionally, organizations manage IT on a series of cost-driven, rather than value-driven, metrics. There is a great divide between the IT funding levels and existing performance measurement criteria. Most business executives measure the value of their business in terms of market share, debt-to-equity ratio, and inventory turns, but in information systems that is not the case. Regardless of what is on hand or what needs to be purchased for the proper connectivity strategy, the upper management needs a clear ROI projection before any of the actual work required to establish an IT organization can begin in earnest. Some pertinent questions could be: in the process of strategic integration, is it possible to merge the current channels – online sales, customer portals, salespeople, marketing efforts – into one platform? Is it possible to shift information systems resources to gain richer interactions with customers and increase cost-effectiveness? Is it possible to add another layer to the existing structure rather than overhauling the current set-up? Is it necessary to overhaul the infrastructure or is it possible to outsource the entire effort? The answers to these questions give the CIO an idea of ROI metrics in the medium and long term, but they also give solid parameters to judge how long such an initiative will take to be successfully implemented. This is the type of information CEOs and COOs need in order to determine whether the connected enterprise ‘ends’ will justify the fiscal ‘means’, even with annual budgets potentially shrinking by 10% over the next few years. After instituting measurement methods, it is vital to use the data to establish information systems metrics that highlight the value of IT. A ‘CIO dashboard’ or software can integrate the various streams of data into one place to show the important value indicators that help the CIO manage the performance of an organization, according to the right measures. The key here is to find the right things to measure, and modify targets based on experience and benchmarking. There are plenty of dashboards, for example, which measure mechanical things such as server and network uptime, how fast requests for enhancements get fulfilled, or help-desk metrics. But there are no dashboards for IT executives that tell them whether they are providing value for the money spent, and which would measure things such as staff utilization, the health of the application suites and infrastructure, and asset management by portfolio. If the top five or six people in the IT group can see those things relatively easily and use the dashboard to drill down further into the issues and problems, it will help add value. The key is to keep it relatively simple, and to make sure the data is timely. 13.4.7 Communicating Performance and Value Once IT executives get their performance measurements in place, they need to share the value metrics throughout the company. One of the first places where this should happen is at the executive committee meetings. Technology strategy should be absolutely transparent, in presentation form, with all the details (not only technical but also business/process) to which the
executives can relate. One way to build a well-rounded IT presentation is to use the balanced scorecard methodology, which is proving valuable to many companies. If a company uses the balanced scorecard already, the smart move is to embed IT initiatives and indicators within corporate strategic goals. 13.4.8 Benchmarking Against Peers CIOs need to look outside their walls and compare the performance of their IT organizations to those of other companies, both within their industry and category leaders from other arenas. Peer-to-peer or P2P benchmarking provides valuable insights for CIOs into gathering performance comparisons. Information systems executives should try to gather information across a wide range of topics. While spending is always the measure that most companies primarily compare, balanced scorecard variables can also be applied to the process. Researching on topics such as utilization of staff, how organizations satisfy their internal and external client needs, and whether or not they manage IT as a series of portfolios is suggested. This will give CIOs the depth of information necessary to truly track and compare performance, and implement the best new practices. 13.4.9 Acting as a Visionary Most CIOs have not been given the experience or the training to use IT to drive revenues. But that is how the leading CIOs of tomorrow will think. A CIO’s knowledge of a particular technology should make him the best person to help the CEO use that technology to win. The next several years will challenge IT leaders to become partners with their internal customers, sharing in the setting of corporate direction and seizing growth opportunities. They will have to broaden their visions and shift their priorities from saving money for the company to creating value for customers. Although excessive costs, process inefficiencies, legacy systems, software bugs, and laggard implementations will remain big concerns, IT’s greatest impact will continue to be in finding innovative business uses of technology. Cutting-edge technology, bigger and faster networks, and more ‘enabling’ devices may or may not be relevant. After three years of cutbacks, what counts for an IT organization is the ability to foster its innovative capability to exploit changing conditions, and then to imagine how the business and IT strategies interweave to create value. Examples are ICICI, MUL, and BPCL. Most top executives have already grasped this new reality. They see that the path to greater customer value and competitive differentiation is paved with real-time data and lit by customer insights derived from that data. CIOs must work even harder to escape the organizational status quo, and venture out of their technologist comfort zone to put the plan into action. A CIO must keep enhancing his influence by making sure that he and his team understand the strategies of the internal customers and finding people who can help them. As better information inevitably shifts market power toward customers, the innovative use of this information will be at the heart of differentiation. And as the shift takes hold, the CIO is in a better position to offer ideas than other top managers.
· Persistent corporate instability due to takeovers, mergers, and acquisitions. · The outdated view of the CIO as only a high-class technician. · Poorly articulated or non-existent evaluation system for CIOs (in Europe). · Poor incentives in the CIO’s remuneration package (particularly in Europe), including the lack of deferred remuneration and inadequate salaries. · The CIOs’ own ambivalence about their new role and their reluctance to change the status quo. It is the human factor that is sometimes overlooked in the rush to examine the structural impediments to corporate change. It is not just organizations that will have to change to adapt to the brave new world of knowledge management. To negotiate successfully the sea change that corporate IT functions are experiencing, CIOs will have to take a hard look at their own beliefs, attitudes, and convictions, formed at a time when their jobs call for skills very different from those demanded today. Self Assessment Questions: True or False
· Leading the transformation of the CIO role is an important human resource challenge for companies. After reading this unit you will be able to describe the evolution of the information systems function. 13.7 Terminal Questions
14.6 Terminal Questions 14.7 Answers to SAQs and TQs 14.1 Introduction In the earlier unit you have learnt about the challenges by the CIO. You have also learnt about the new trends of the organizations in IT. In this unit you will learn about the database management systems which is essential for the maintenance of information and also it helps in accessing the information for analysis purpose. Table 14.1: Concepts of DBMS Data Data is a raw fact which can be recorded and has specific meaning. DBMS-Definition A DBMS is a complex set of software programs that controls the organization, storage and retrieval of data in a database. What does it consist of? · Collection of related data · Set of programs to access those data. · A complete definition or description of the database Structures and Constraints. Where are the DBMS used? · All areas where computers are used, including business, engineering, law, education, banking, hotel and airline reservation. Examples of DBMS · Multimedia databases can store pictures, video clips and sound messages. · Geographic information system can store and analyze maps, weather data and satellite images. Learning Objectives After studying this unit, you will be able to: · Explain the scope of technology in supporting Information Technology and MIS. · Describe Processing of Data, Transaction, Application and Information for MIS. · Examine the role and importance of human factors in IS Design. · Explain the relevance of IT to MIS Design.
· Enumerate the steps in a quality assurance programme. 14.2 Types of databases users Different persons who are involved in the design, use and maintenance of a large database having many users are:
data is complex. The main problem with flat file is, it is prone to error. The locking mechanism is not there which is inherent that can detect when a file is deleted or modified. For instance, a flat model database includes only zip codes. Within the database, there will only be one column and each new row within that one column will be a new zip code. The Hierarchical database: It resembles tree structure. In this database, each link is nested to the order to keep data organized in a particular order on a same level list. For instance, a hierarchal database of sales, may list each days sales as a separate file. Within this nested file are all of the sales (same types of data) for the day. The Network database: In this type of database, a record is stored with a link to other records – in effect networked. They are sometimes referred to as a pointer that means it can be a variety of different types of information such as node numbers or even a disk address. The relational database: The relational model represents the database as a collection of relations having a set of rows and columns, each of which is assigned a unique name. Relation consists of a relational schema [structure of table] and relational instance [data in a table at the particular time]; there is a close correspondence between the concept of table and the mathematical concept of relation. In relational model we use certain conventions. For instance, a row is called a tuple and a column is termed as an attribute. The domain of a relational schema is a pool of legal values. Student [Reg. No, name, Addr, Phone, Dbirth, GPA] In this example, Student is a relation and the attributes [columns] are RegNo, Name, Addr, Phone, Dbirth. A possible tuple for the Student relation is [‘MBA02C1101', ' Nupur Rastogi’, '440, 1- main, 2nd cross, Airport Road, Kodenahalli, Bangalore-560008', 25256789, 11-Jan-1986]. The domain of each attribute is as follows: RegNo. : 10 alphanumeric characters Name : characters Addr : Alphanumeric characters Phone : 7 digits Dbirth : Date Characteristics of a relation: