Preview

11 Steps to Successful Data Warehousing

Powerful Essays
Open Document
Open Document
1938 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
11 Steps to Successful Data Warehousing
http://my.advisor.com/Articles.nsf/aid/BLACP01
11 Steps to Successful Data Warehousing
Mining your corporate data for valuable customer information can improve your business performance. But it's not as simple as it sounds.
By Phillip Blackwood
There are 4 reader comments on this topic. Add yours!
More and more companies are using data warehousing as a strategy tool to help them win new customers, develop new products, and lower costs. Searching through mountains of data generated by corporate transaction systems can provide insights and highlight critical facts that can significantly improve business performance.
Until recently, data warehousing has been an option mostly for big companies, but the reduced costs of warehousing technology make it practical -- often even a competitive requirement for -- smaller companies as well. Turnkey integrated analytical solutions are reducing the cost, time, and risk involved in data warehouse implementations. While access to the warehouse was previously limited to highly trained analytical specialists, corporate portals now make it possible to grant data access to hundreds or thousands of employees.

Following are some steps to consider in implementing your data warehousing solution. 以下是一些措施,考虑在实施数据仓库解决方案

1. Recognize that the job is probably harder than you expect.

Experts frequently report that 30-to-50 percent of the information in a typical database is missing or incorrect. That situation may not be noticeable -- or may even be acceptable -- in an operational system that focuses on swiftly很快地and accurately processing current transactions. But that percentage of error is totally unacceptable in a data warehousing system designed to sort through millions of historical records to identify trends or select potential customers for a new product. And, even when the data is correct, it may not be usable in a data warehouse environment.

For example, legacy system programmers often use shortcuts to save disk space

You May Also Find These Documents Helpful

  • Powerful Essays

    Ibm 211 Week 3

    • 4383 Words
    • 18 Pages

    IBM® Telecommunications Data Warehouse V8.4 delivers the following capabilities to communication providers: • • • Common customer view: Helps integrate customer identifiers, organizational structures, and account hierarchies across lines of business and functions. Product life cycle management: Helps integrate product management and performance measurement across lines of business and functions. Campaign performance management: Helps improve program planning, tracking of sales and marketing activities, and performance metrics across channels and touch points. Service management: Helps analyze usage, availability, and customer experience of new services, self-service, and new monetary services.…

    • 4383 Words
    • 18 Pages
    Powerful Essays
  • Powerful Essays

    Rlht2 Task 3

    • 1508 Words
    • 7 Pages

    Datanal, Inc., was established by five IT entrepreneur colleagues in 2002. It enjoys a reputation for outstanding performance and presently employs some 350 IT specialists, most with proven skill in analyzing, organizing, and managing large, diversified streams of data and databases in logical, systematic form, transparently and effectively bridging present artificial separations. By enabling customers to assimilate a consistently large influx of new data while simultaneously drawing from previously unrealized complementary database…

    • 1508 Words
    • 7 Pages
    Powerful Essays
  • Satisfactory Essays

    This document is a proposal for building a data warehouse architecture that will consolidate and transform data into useful information for the purpose of decision-making and for establishing a new function that offers a broad array of decision support services to all units at ABC Retail Chain Corporation. Executives and decision-makers often need information to analyze the past, describe current circumstances, and anticipate the future. Presently, decision-makers across the Institute rely on hard copy reports or Excel Sheets to provide information. Typically, any request for information is forwarded to the operational areas of the Organization, which provide hard copy reports reflecting the data gathered in their functional area. To analyze and transform data into useful information, decision-makers and their staff have to manually re-enter the non-integrated data into their own mini-systems. This type of operation hinders the ability of decision making and the executives are either drowning in too much data with no option to analyze it or too little data, which means they are back to square one and must request additional information. Often executives receive multiple, conflicting information or information that is based on incomplete assumptions about the types of analysis required.…

    • 641 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    The bell hooks, chapter, "Feminist Politics: Where we Stand" the word feminism is described as a controversy. It started off by saying the word feminism is being misunderstood. For instance, it mentions that a mass of people think feminism is always and only about women seeking to be equal to men. Whether its equal pay, work, treatment, etc. There is much more than just that.…

    • 215 Words
    • 1 Page
    Satisfactory Essays
  • Good Essays

    The most important aspect of having data warehousing is the fact that it allows for data storage and presentation of this data enabling executives to make sound decisions. Another important use of data warehousing is it takes the separate areas the company is divided up in and takes it all and lumps it in to one single entity. One great benefit of data warehousing is that Huffman will be able to handle server task connected to all queries which is not commonly found in all systems. “Another powerful benefit of data warehouses is that they allow companies to use data modeling for querying tasks that are quite difficult for transaction processing” (Exforsys, 2007). Huffman trucking is already successful but by implementing a success data warehousing system they would be able to understand and analyze all data coming in and leaving the system better and at a more efficient rate. Attached to this report is a…

    • 891 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Many companies are successful in understanding how to meet customer expectations, gain new customers and increase productivity and efficiency by using business intelligence and data analytics. The tools and techniques used by business intelligence give real time insight so that companies can identify opportunities, risks and track trends quickly. Collecting data alone is useless until it is analyzed. This is where data analytics come in. Data analytics is the process of obtaining and evaluating data using specialized software with the purpose of extracting useful information. (4) Data analytics is used in many industries to allow companies and organizations to make better business decisions quickly. The speed at which data is collected, organized and evaluated is critical given the speed at which technology continues to change. I believe more and more companies are utilizing data analytics so they can gain advantages over their competitors. Technology is obtaining more data than in the past so companies are seeking better ways to receive value from that data. The term business…

    • 1233 Words
    • 4 Pages
    Powerful Essays
  • Powerful Essays

    Aside from simple annual financial reports, the information gathered while data mining is what has launched the company and allowed the Target Corporation to tweak procedures and improve certain areas to continue making profit year after…

    • 1688 Words
    • 7 Pages
    Powerful Essays
  • Good Essays

    Stop And Frisk

    • 2046 Words
    • 9 Pages

    This paper was written to take a look at both sides of the stop and frisk program. By examining both sides I hope to show the effectiveness of the program, but not to leave out the possible negative effects also. There is no doubt that this program has gain a lot of negative attention, the main controversial issue at hand is that the people feel that it gives the cops to much authority to stop anyone they can. This program is to believe that it is a way to make cities more safe, but the ones’ that are mostly stopped are African-American and Latino young men and they feel that the program is a way for the cops to use it for racial profiling. Not only is it used for profiling, but these people believe…

    • 2046 Words
    • 9 Pages
    Good Essays
  • Powerful Essays

    With the global marketplace becoming increasingly competitive and the insatiable appetite for business information, the volume of data that must be managed and assimilated is growing at an exponential rate. Global corporations require standard processes, consistent data to enable global consolidation and the ability to transform raw data into business intelligence to support better decision making. In many cases, regions, countries and even cities have different finance systems, computerized maintenance management systems, purchase order processing and call centre platforms with inconsistent data capture and coding. Just to add to the…

    • 3125 Words
    • 13 Pages
    Powerful Essays
  • Powerful Essays

    Cis 500 Data Mining Report

    • 2046 Words
    • 9 Pages

    This report is an analysis of the benefits of data mining to business practices. It also assesses the reliability of data mining algorithms and with examples. “Data Mining is a process that uses statistical, mathematical, artificial intelligence, and machine learning techniques…

    • 2046 Words
    • 9 Pages
    Powerful Essays
  • Powerful Essays

    A data warehouse is a database that stores current and historical data of potential interest to decision makers throughout the company. [1] After the events of September 11, 2001, the US Government determined the need for a comprehensive single source to identify and deter all persons either suspected to engage in terrorist activities against the US. Thus, the Terrorist Watch List and Database were created, bringing together all the information from various government agencies who had previously been maintaining separate lists of persons, into the Watch List in a standard format and available to all. This database is an example of data warehousing.…

    • 1645 Words
    • 7 Pages
    Powerful Essays
  • Better Essays

    Companies use a wide variety of applications to collect and process key data that is important to the successful operation of the business. It is often necessary to break data down into specific parts to then share it with unique departments within the company. At times this can require data to be copied or separated from one application to another in order to support consistent functioning of the value chain. Currently, these types of processes are becoming outdated, as companies find that a process like this “lacks visibility, hides supply chain risk, and inhibits quick reaction to unexpected supply chain events.” (Oracle, 2012).…

    • 1048 Words
    • 3 Pages
    Better Essays
  • Powerful Essays

    Data Warehousing Failures

    • 5385 Words
    • 22 Pages

    Eight studies of data warehousing failures are presented. They were written based on interviews with people who were associated with the projects. The extent of the failure varies with the organization, but in all cases, the project was at least a disappointment.…

    • 5385 Words
    • 22 Pages
    Powerful Essays
  • Best Essays

    Data Warehousing and Olap

    • 2507 Words
    • 11 Pages

    In the 1990s, as businesses grew more complex, corporation spread globally, and competition became fiercer, business executives became desperate for information to stay competitive and improve the bottom line. Data warehousing technologies have been successfully deployed in many industries: manufacturing (for order shipment and customer support), retail (for user profiling and inventory management), financial services (for claims analysis, risk analysis, credit card analysis, and fraud detection), transportation (for fleet management), telecommunications (for call analysis and fraud detection), utilities (for power usage analysis), and healthcare (for outcomes analysis). This paper presents a roadmap of data warehousing technologies, focusing on the special requirements that data warehouses place on database management systems (DBMSs).…

    • 2507 Words
    • 11 Pages
    Best Essays
  • Good Essays

    British Rule

    • 343 Words
    • 2 Pages

    The British rule over India changed the course of history in India. The British came to India at the start of the seventeenth century. This was the time when the British East India Company was established in India to break the Dutch monopoly over spice trade. With time the East India Company increased its powers and started to administer the country. However its policies were disliked by Indians and together they revolted against the company. This led to the downfall of the company and the administration of India went directly under the Queen. In the following lines, you shall find information regarding the period when India was under British rule. Read about the British colonialism in India.…

    • 343 Words
    • 2 Pages
    Good Essays