How did medihelps use of a traditional database limit

Assignment Help Business Management
Reference no: EM131253864

Case One
Medihelp: Transforming Traditional Databases into Business Intelligence

Medihelp is South Africa's third largest health insurance company. It covers about 220,000 people with plans ranging from R828 to R2,700 (about U.S. $80 to $260) per month per person. Medihelp needed a better way to access and analyze data on customers, claims, and third-party providers in order to monitor the effectiveness of its insurance products and to fine-tune and create new products as needed.
Medihelp's problem was that its data was stored in a traditional database. As discussed in this chapter, traditional databases are not designed to support decision making. They're not efficient at the types of information retrieval that decision making uses. With Medihelp's existing database, reports took unacceptably long times to run. Reports based on the content of the full database couldn't be run at all.

This inefficiency detracted from Medihelp's ability to make informed business decisions.

For example, Medihelp's claim file had about 55 million rows. Each row contained about 35 data values describing medical conditions, treatments, and payments. Each row was associated with one of 15 million rows of historical member data, which held another 15 or so data values describing the member and his or her coverage. For claim processing, accessing the data for a single claim was fast and efficient. Combining data from thousands of rows, as decision support calls for, was not.

"Logging into our [traditional] database ... was not providing us the information we needed to make the best business decisions," explains Jan Steyl, senior manager of business intelligence at Medihelp. "We needed a dedicated, high-performance data warehouse."

After looking at several options, Medihelp made a preliminary selection of Sybase IQ as the basis for its data warehouse. Working with B.I. Practice, a Sybase subsidiary in South Africa, Medihelp carried out a proof of concept to confirm that Sybase IQ could deliver the needed performance at an acceptable cost. This procedure involved loading a subset of the tables from the operational database into Sybase IQ, executing queries that used only that subset of the data, and evaluating the results

Because these queries now used a database designed for queries, performance improved dramatically. Response time was reduced by an average of 71:5 percent. Response time for ad hoc queries, those which were not programmed into the database system ahead of time, was reduced by an average of 74:1 percent. One query's response time dropped by 92:8 percent.

Theo Els, Medihelp's senior manager of client relations, likes the new system. "Health insurers supply data to mployer groups. These demographic and claims profiles are essential for employer groups seeking to understand their employees' health risks ... and the consequent impact that risk can have on business productivity. Brokers and healthcare consultants also use this information in their annual client reviews to ensure that employees receive the most suitable coverage. It is imperative that the ... data warehouse provide accurate information in a format that is easily understood."

The biggest beneficiary of Medihelp's data warehouse is its product development team. The team uses data from the data warehouse to understand trends in claims by benefit code, condition, area, age group, and other factors. Medihelp also uses its data warehouse to determine what financial effects changes to a benefit in a specific product will have. This provides the sales force with the right offering at the right price for specific target markets in South Africa.

Discussion Questions
1. How did Medihelp's use of a traditional database limit what it could do with its data?

2. How does Medihelp's Salesforce now use the information in the company's data warehouse?

Critical Thinking Questions
1. How did B.I. Practice improve the efficiency of queries run by Medihelp employees?

2. How does the new query system help Medihelp make better decisions for the company? Does Medihelp also use the system to help their clients make better decisions? If so, how?

Verified Expert

The work is in 2000 words in Harvard format where the focus is on how BI is able to handle the decision main process. it includes the details which are related ot the system standards and to check on the system query with the proper planning. this is effectively able to measure the standards that could be effective to work on the improvement of teh panning of the system and then handling the system functioning effectively.

Reference no: EM131253864

Questions Cloud

Average age of accounts receivable : If company officials notice that the average age of accounts receivable is getting older, what type of remedial actions can be taken? How does a company reduce the average number of daysthat are required to collect receivables so that cash is avai..
What is the expected growth in the number of such positions : Do research to find what career opportunities are available in the field of competitive intelligence. - What is the expected growth in the number of such positions and what are typical salaries?
Describe the role of seniors in the chosen minority groups : Describe the role of seniors in the chosen minority groups. Explain the changes in the role of seniors over the years. Explain any future challenges for the selected minority groups in the years ahead.
Hundreds of thousands of separate receivables : A company such as Dell Inc. must have thousands or even hundreds of thousands of separate receivables. The accounts receivable T-account maintains the total dollar amount owed to the companybut does not indicate the balance due from each individua..
How did medihelps use of a traditional database limit : How did Medihelp's use of a traditional database limit what it could do with its data? - How does Medihelp's Salesforce now use the information in the company's data warehouse?
What is the cournot equilibrium market price : Calculate and compare the profit of each firm under the Cournot and Stackelberg equilibria. Under which equilibrium is overall industry profit the greatest, and why?
Percentage of receivables method : Officials havelooked at all available evidence and come to the conclusion that 15 percent of ending accounts receivable($160,000 ×15 percent or $24,000) is most likely to prove to be uncollectible. How does application ofthe percentage of receivab..
Describe the traits and characteristics of diversity : Describe the traits and characteristics of diversity within this organization. What leadership techniques would you, as the administrator, engage to promote a more diverse organization
Value of the price elasticity of demand for cigarettes : In the mid 1900s, the government in the uk announced that for every 10 per cent rise in the price of cigarettes, the demand is likely to fall by 6 per cent. If this information is correct what is the value of the price elasticity of demand for cig..

Reviews

Write a Review

 

Business Management Questions & Answers

  Illustrate what could legally do if you found discrepancy

This is for a strategic staffing class: If you were a hiring manager, illustrate what could you legally do if you found discrepancies in an application.

  Determine the impact of canadian cross cultural issues

Determine the impact of Canadian cross cultural issues on change and analyze the impact of resistance to change by a US company working in Canada.

  An analyst was developing a cost factor to estimate

an analyst was developing a cost factor to estimate non-recurring tooling as a function of the recurring tooling cost.

  Housing bubble that burst four years ago

In a speech in late 2011, President Barack Obama argued that: "Probably the single greatest cause of the financial crisis and this brutal recession has been the housing bubble that burst four years ago. Discuss in 500 words " What did president mea..

  Question 1 explain three essential differences between

question 1 explain three essential differences between employee capabilities and company core competencies. why is it

  Responsibility of keeping patients

Compare and contrast electronic medical records with personal health records. Justify the ethical responsibility of keeping patients' medical and personal health records confidential. Provide a rationale for your response.

  What would you have done differently in terms of scope

Now, it is time to reflect on what went well and what didn't go so well. Based on feedback throughout the course, what would you have done differently in terms of scope, resources, and / or schedule, and why?

  Find the web site for roi institute

Use a search engine of your choice and find the web site for ROI Institute, Inc. Once you have found the website, click on "Tool," and review the "Nations Hotels-Measuring the ROI in Business Coaching."

  Cognitive mistakes affect the negotiation

If cognitive mistakes were made, how did they affect the negotiation? How might the parties have acted differently?

  Overall performance of a project

As you have read in this unit's assigned reading, earned value management (EVM) assists project managers when measuring the overall performance of a project. EVM can be very useful in project forecasting and is used for cost and schedule control.

  Find two forecasts of big data growth

Describe the relationship between enterprise archi-tecture and organizational performance. visit Oracle.com . Describe the types of virtualiza-tion services offered by Oracle. Copyright | Wiley | Information Technology for Managemen

  Roles and interrelationships among physicians

Given the roles and interrelationships among physicians, nurses, and other health service professionals, distinguish the health information management profession.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd