Management Information Systems
Stronger-?and Redundant Claude Phillips, program director of major events at Autos Origin, the lead IT contractor for the Olympic Games, likes to be prepared. “We were ready before August, but we were still testing, because we wanted to be sure that every stupid thing that can happen was planned for,” Phillips said. “In a normal IT project, we could have delivered the application to the customer almost eight months earlier. ” But the Olympic Games was far from a normal IT project.
The deadline was nonnegotiable, and there were no second chances: Everything must work, from the opening ceremony on August 13 right to the end, said Phillips, whose previous experience Includes developing the control system for the world’s first computerized nuclear power plant. With all that pressure, Philippic’s team was doing its utmost to ensure that the network would not fail. They were building multiple layers of security and redundancy, using reliable technology, and then testing it rigorously. In the weeks before the games, the team went through two technical rehearsals In which 30
Autos Origin staffers put the network through its paces. The team spent a full week stimulating the busiest days of the games, Phillips said, dealing with “crazy
Need essay sample on "Management Information Systems"? We will write a custom essay sample specifically for you for only $ 13.90/page
The two major components of he software that were run over the Olympic network were Autos Origin’s GSM (Games Management system a customized suite of applications that acts as kind of ERP for the Olympics, and the IDS (Information Diffusion System). GSM ran on Windows 2000 servers in Athens, an upgrade from the Windows NT 4 used at the Salt Lake City games In 2002. “We’re not using sexy technology,” Phillips said. “The mall goal for us was to reduce the amount of risk. ” Together, GSM and IDS Imposed exacting requirements on the network.
GSM was, among other things, used to manage access accreditations for the games, so security was vital. Speed, too, was important: Philippic’s goal was to have the results on commentators’ screen 0. 3 seconds after the athletes had crossed the line, complete with rankings, statistics, and biographies-? everything that helps commentators during a live broadcast. Yang Inkblot, information security manager at Autos Origin, said the key to that was to build in redundancy-?and lots of it. “We doubled everything, because we needed 100 percent availability at games time,” he said. And when he said everything, he meant it.
There was backup redundancy for the routers and switches at each site, the decanters that processed he results, and event the PC’s on the desks in the control room. Too keep things orderly, Autos designed three different LANA configurations: one for the largest venues, Including the Olympic stadium and the water sports center; another for mid-sloe venues such as the equestrian center; and one for the many smaller venues. Autos used Plans both to simplify troubleshooting and to limit damage if anyone managed 1 org information system, information diffusion applications, and the game management system.
Technical services, directories, management and monitoring, and the on- menu results system each had their own Plans too, sometimes several per venue for the same function. “The purpose was to segment the traffic so we could monitor it and contain potential issues,” Inkblot said. “If someone brought in a virus, it would be contained on systems on the same PLAN and could not spread to other Plans. ” Event results and data from the games management system were stored in two physically distant data centers hosted by TOTE, which also supplied the SD network.
The primary data center was located near Tote’s headquarters in Amorous, Just across the main highway from the Olympic stadium; the other was another several hundred miles away, still in Greece but in a different earthquake zone. What makes the Olympic Games a unique project is that the athletes aren’t going to stop running Just because the server does. As Phillips said, “When we speak about fixing something, it might be a work-around or a decrease of functionality, but the key thing is that the show must go on. ” Questions 1.
Could the 2004 Athens Olympics have been a success without all of the networks and backup technologies? 2. The 2004 Olympics is a global business. Can a business today succeed without information technology? Why or why not? 3. Claude Phillips said dealing with “crazy scenarios of what might happen in every area: a network problem, staff stopped in traffic Jam, security attack… Everything that might happen,” was the reason for so much testing. Can you think of other business that would require “crazy scenario” testing? Explain. CASE – 2 Argosy Gaming Co. Challenges in Building a Data Warehouse When you’ve got half a dozen riverboat gambling operations, it’s important that everyone plays by the same rules. Argosy Gaming Co. (wry. Originations. Com), with headquarters in Alton, Illinois, and a fleet of six Mississippi riverboat casinos, had decided that bringing all customer data together would enhance management’s view of operations and potentially help strengthen customer relationships. To accomplish those goals, though, the company needed to access a variety of databases and develop an extract, transform, and load (TTL) system to help construct and maintain a central data warehouse.
Jason Fortunately, a data-warehousing analyst, came aboard at Argosy Just as the company’s data warehouse project started in 2001. His Job was made easier, he says, by the adoption of Hummingbird Ltd. ‘s Genie TTL software tool, such projects, he learned the hard way that preparing for the TTL process is Just as important as having the right software. The riverboats each had unique and incompatible ways of defining a host of operational activities and customer characteristics-?in essence, the floating casinos were each playing the same game but with different rules.
But those problems remained hidden until reports from the company’s data warehouse began to turn up inconsistent or troubling data. That’s hen Fortunately and his staff discovered conflicting definitions for a wide range of data types-?problems he wished he had identified much earlier. Effrontery’s troubles-?and his successes-?are typical of TTL, the complex and often expensive prelude to data warehouse success. TTL is often problematic because of its inherent complexity and underlying business challenges, such as making sure you plan adequately and have quality data to process.
Analysts, users, and even vendors say all bets are off if you don’t have a clear understanding of your data resources and what you want to achieve with them. Then there are choices, like whether to go for a centralized architecture-?the simplest and most common configuration – or a distributed system, with TTL processing spread across various software tools, system utilities, and target databases, which is sometimes a necessity in larger, more complicated data warehouses.
Even if you navigate those waters successfully, you still need to ensure that the TTL foundation you build for your data warehouse can meet growing data streams and future information demands. As the term implies, TTL involves extracting data from various sources, transforming it (usually the riskiest part), and loading it into the data warehouse. A transformation could be as simple as reordering the fields of a record from a source system.
But as Philip Russo, a Gaga Information Group analyst, explains, a data warehouse often contains data values and data structures that never existed in a source system. Since many analytical questions a business user would ask of a data warehouse can be answered only with calculated values (like averages, rankings or metrics), the TTL tool must calculate these from various data sources and load them into the warehouse. Similarly, notes Russo, a data warehouse typically contains “time-series” data.
The average operational application keeps track of current state of a value such as a bank account balance. It’s the Job of the TTL tool to regularly add new states off value to the series. For his year-long TTL project, Argosy Fortunately says Hummingbird’s Genie Suite, a data integration and TTL tool, quickly became the project’s “central nervous system,” coordinating the process for extracting source data and loading the warehouse. But for Argosy, getting all that data into the warehouse didn’t produce immediate usable and dependable results. The lesson was that people thought that they were talking about the same thing, but they actually were not,” says Fortunately. For example, riverboats calculated visits differently. One riverboat casinos would credit a customer with a visit only if he actually played at a slot machine or table. Another had an expanded definition and credited customers with visits when they redeemed coupons, even if they didn’t play. So identical customer activity might have on riverboat reporting 4 player visits and another reporting 10. This type of coverer was repeated for everything from defining what a ‘player’ is to calculating a player’s profitability,” says Fortunately. IT played a lead role in identifying problems define and use many categories of data, he says. Now, the data warehouse is running smoothly and producing dependable results for business analysis and management reporting, so the number of problem-resolution meetings has dropped dramatically. Still, Fortunately reckons that three-quarters of the meetings he attends nowadays have a business focus. For our part, we now know better what questions to ask cuisines users as we continue with the data warehouse development process,” he says. 1. What is the business value of data warehouse? Use Argosy Gaming as an example. 2. Why did Argosy use a TTL software tool? What benefits and problems arose? How were they solved? 3. What are some of the major responsibilities that business professionals and managers have in data warehouse development? Use Argosy Gaming as an example.
CASE -3 Allocate Insurance, Aviva Canada, and Others: Centralized Business Intelligence at Work The most common approach to business intelligence is to assemble a team of pullovers to build a data warehouse or data mart for a specific project, buy a reporting tool to use with it, and disassemble the team upon the project’s completion. However, some companies are taking a more strategic approach: standardizing on fewer business-intelligence tools and making them available throughout their organizations even before projects are planned.
To execute these strategies, companies are creating dedicated groups, sometimes called competency centers or centers of excellence, to manage business-intelligence projects and provide technical and analytical expertise to other employees. Competency centers are usually staffed with people who have a variety of technical, business, and data-analysis expertise, and the centers become a repository of business-intelligence-related skills, best practices, and application standards. About 10 percent of the 2,000 largest companies in the world have some form of business-intelligence competency center, Gardner Inc. ND Howard Dresser says. Yet approaches vary. While most are centralized in one location, a few are virtual, with staff scattered throughout a company. Some are part of the IT department – or closely tied to it-?while others are ore independent, serving as a bridge between IT and business-unit managers and employees. Allocate Insurance Co. ‘s Enterprise Business Intelligence Tools Team is responsible for setting business-intelligence technology strategy for the company’s 40,000 employees and 12,000 independent agents, says Jim Young, the team’s senior manager.
Based in Lactate’s Northrop, Illinois, headquarters, the center was business-intelligence products used in different parts of the company. The center serves as a central repository for business-intelligence expertise, providing services ND training for Allocate employees, and is developing a set of standard best practices for building and using data warehouses and business-intelligence applications. “That way, we can execute on a common strategy,” Young says. The center maintains a common business-intelligence infrastructure and manages software vendors and service providers.
At Aviva Canada Inc. , a property and casualty insurance company, the primary role of its Information Management Services department is to bridge the communication gap between business- intelligence-tool users and Avis’s IT department. “Business intelligence isn’t a technology issue. Bal is a business issue,” says Gerry Lee, information management services UP. Centralization is critical, because Avis’s goal is to grow by 50 percent over the next five years, partly through additional acquisitions, Lee says.
The center also impacts the company’s numerous customer relationship-management initiatives. “We couldn’t get into CRM until we had solid data-management and business- intelligence capabilities,” he says. Cost reduction is often the driving factor for companies to create competency centers and consolidate business-intelligence systems. Standard technology and implementation practices can reduce the cost of mom business-intelligence projects up to 95 percent, says Chris Amos, reporting solutions manager at British Telecoms.
BET established a center of excellence around Actuates reporting software three years ago and is developing business-intelligence systems for the telecommunications company’s wholesale, retail, and global services operations. Despite the potential savings, funding can be an issue for creating and running business-intelligence centers of excellence. Start-up costs for a business- intelligence competency center can be $1 million to $2 million, depending on a company’s size, Garter’s Dresser says. Many believe the payoffs are worth it.
General Electric Co. ‘s energy products business formed its Business Data-Modeling Center of Excellence last year to improve data-management and business- intelligence practices for GE Energy 8,000 employees. That has helped the business move beyond simple reporting o financial and supplier data to more advanced forecasting and predictive analysis. “The data’s become more actionable. The visibility of this data to the business has brought millions in savings,” says Rich Richardson, manager of business data modeling and delivery, who manages the center.
That’s a business-intelligence competency center that’s more than paid for itself. 1. What is business intelligence? Why are business-intelligence systems such a popular business application of IT? 2. What is the business value of the various BI applications discussed in the case? 3. Is a business-intelligence system an MIS or a ADS? Service Web Systems When Web-based self-service is good, it’s really good. Customer satisfaction soars and call center costs plummet as customers answer their own questions, enter their own credit card numbers, and change their own passwords without expensive live elf.
But when Web-based self-service is bad , it’s really bad. Frustrated customers click to a competitor’s site or dial up your call center-?meaning you’ve paid for both a self-service website and for a call center, and the customer is still unhappy. A poorly designed Web interface that greets self-service users with a confusing sequence of options or asks them questions they can’t answer is a sure way to force them to call a help center. Blue Cross-Blue Shield. For Blue Cross-Blue Shield of Minnesota (wry. Blueberries. Mom), developing Web self-service capabilities for employee lath insurance plans meant the difference between winning and losing several major clients, including retailer Target, Northwest Airlines, and General Mills. “Without it, they would not do business with us,” explains John Ninja, CIO and senior vice president of information systems and corporate adjudication services at the $5 billion insurance provider. So when Ninja explained to executives that the customer relationship management (CRM) project that would enable Web-based self- service by client employees would cost $1 5 million for the first two phases, they didn’t blink.
Blue Cross-Blue Shield also learned the importance of communicating with business units during the design phase of its Web self-service system. Ninja and his technical team designed screen displays that featured drop-down boxes that they thought were logical, but a focus group of end users that examined a prototype system found the feature cumbersome and the wording hard to understand. “We had to adjust our logic,” he says, of the subsequent redesign. AT & T Wireless. When AT & T Wireless services (www. Twats. Mom) began rolling out its new high-bandwidth wireless networks, its self-service website required customers to say whether their hones used the older Time Division Multiple Access (TDMA) network or the newer, third generation network. Most people didn’t know which network they used, only which calling plan they had signed up for, says Scott Central, e-business IT program manager at AT & T Wireless. So AT & T had to redesign the site so the customer Just enters his user ID and password, “and the application follows built-in rules to automatically send you to the right website,” Central says.
According to Gardner Inc. , more than a third of all customers or users who initiate queries over the Web eventually get frustrated and end up calling help center to get their questions answered. Whether a self-service application is aimed at external customers or internal users such as employees, two keys to success remain the same: setting aside money and time for maintaining the site, and designing flexibility into application interfaces and business rules so the site can be changed as needed. Strictures. Strictures (wry. Disorienting. Com) is a global benefit services provider managing over $170 billion in savings and pension funds and is owned by Citreous and State Street Corp.. Strictures is using the Cruses software development tool to make rules based employee self-service. Cruses manages thousands of business rules related to client policies, government regulations, and customer preferences. Previously, business analysts developed the required business rules for each business process, and IT developers did the coding.
But now analysts use Cruses to create and change rules, without the help from developers, says Andy Marsh, Citrate’s CIO. “We’ve effectively eliminated the detail design function and 80 percent of the development unction,” says Marsh. IT is involved in managing the systems and platforms, but it’s less involved in rules management, he says. The software helps speed the development process for new business systems or features, says Marsh. For example, it used to take Strictures six months to set up benefit plans for clients; it now takes three months.
Strictures can also react more quickly to market changes and new government regulations. It has used the rules development software to quickly revise business rules to accommodate the changes in pension programs required by new legislation. And Marsh says that when a client company recently added a savings plan to its benefits program, Strictures was able to easily develop and implement changes with Cruses. 1. Why do more than a third of all Web self-service customers get frustrated and end up calling a help center?
Use the experiences of Blue Cross-Blue Shield and AT & T Wireless to help you answer. 2. What are some solutions to the problems users may have with Web self-service? Use the experiences of the companies in this case to propose several solutions. 3. Visit the websites of Blue Cross-Blue Shield and AT & T Wireless. Investigate the details of obtaining and individual health plan or a new cell phone plan. What is your appraisal of the self-service features of these websites?
Explain your evaluations. CASE -5 Avon Product and Guardian Life Insurance: Successful Management of IT Project It’s dJ iv again at many companies when it comes to track record in using IT to help achieve business goals. Consider the following: ; At companies that aren’t among the top 25 percent of IT users, three out of 10 IT projects fail on average. ; Less than 40 percent of IT managers say their staffs can react rapidly to changes in cuisines goals or market conditions. Less than half of all companies bother to validate an IT project’s business value after it has been completed. Those are Just a few of the findings from a survey of IT managers at about 2,000 companies, including more than 80 percent of the Fortune 1,000, released in June 2003 by the Hackett Group in Atlanta. However, top-tier IT leader didn’t reach the top of their professions by being softies. Indeed, a vast majority of them regularly rely upon hard-dollar metrics to consistently demonstrate to top brass the business value IT investments are expected to yield.
That’s what sets them apart from so many of management, but it’s amazing how many companies fall short here,” says Stephen J. Mandrill, a professor of business technology at Violation University and consultant at Cutter Consortium. The lack of good project management at such companies may also lead to business units taking on IT development projects without the knowledge or oversight of a company’s IT department. Business units may initiate such “rogue projects” because they see the IT department as too slow, or a source of too much red tape and extra costs. Avon Products.
We apply all of the analytical rigor and financial ROI tools against each or our IT projects as well as other business projects,” says Harriet Delano, senior vice president and CIO at Avon Products Inc. (www. Avon. Com) in New York. Those tools include payback, NP, and AIR calculations, as well as risk analyses on every investment, she says. The $6 billion cosmetics giant also monitors each IT project to gauge its efficiency and effectiveness during the course of development and applies a red/yellow/green coding system to reflect the current health of a project, says Delano.
A monthly report about the status of projects that are valued at more than $250,000 and deal with important strategic content is presented to senior line managers, the CEO, and the chief operating officer. In addition, Avon uses an investment-tracking database for every IT project to monitor project costs on a rolling basis. The approach makes its easier for the company’s IT and business managers to quickly determine whether a project should be accelerated, delayed, or canceled and assists the finance organization in forecasting requirements.
Guardian Life Insurance. Dennis S. Callahan says he has “put a strong emphasis on governance” since becoming CIO at The Guardian Life Insurance Company (www. Glib. Com) two years ago, Callahan has done so, in part, by applying NP and AIR calculation to all IT projects with a five-year cash flow. “The potential fallout from inaction could result in loss of market share,” says Callahan, who was promoted to executive vice president recently. So Guardian’s approach to IT investments “is very hare-dollar- and metrics oriented, with a bias toward action,” he says.
Still, Callahan and his team do have a process for incorporating “soft” costs and benefits into their calculations. They do that, Callahan says, by encouraging their business peers “to discuss how an investment can impact market share and estimate how those numbers are going to change. Same thing with cost avoidance – if we invest in a project that’s expected to help us avoid hiring 10 operations staffer to handle growing business transaction volumes. ” Callahan also keeps close tabs on capital spending throughout the course of a project.