The Disadvantages And Disadvantages Of Data Warehousing

Improved Essays
As with many things, the data mart’s biggest asset is also its biggest flaw. And the biggest problem with data marts is that they are compartmentalized. Only one group of people can access that information. If that group wants additional data, it must be gathered from a different data mart or data warehouse and brought to their data mart (Westerman 13). When this happens there can be numerous warehouses to maintain, which is not desired. Wal-Mart advises to wait until the data warehouse is established to build the data marts. By doing so the data flow is less complex. The data flows from the functional systems into the warehouse and then on to the data marts. This flow strategy can make it easy and relatively quick to build data marts …show more content…
One of the advantages of warehousing is the ability of have clean data. The processes that occur in warehouse capture the incoming data and clean, purge, and merge the information in preparation to enter into storage. The fact that indexes are created in the warehouse is another advantage. A major advantage is the ability to run queries to obtain the desired information. Each query can be individualized to the task at hand. Data warehousing offers security for a business, housing all vital information in one protected area. This type of storage is more secure than paper records stored in files with the possibility of theft, misplacement or lost in a disaster. Paper records are all but impossible to recreate. This would be no problem if the information is stored electronically with backups …show more content…
It is imperative that a business continually evaluate their practices to make sure that they are serving their customer to the best of their ability. It is advantageous to a business to have information at their fingertips and have the ability to access it immediately. A lengthy time delay to search for requested information for a customer could cost them a sale. Data warehousing and mining are a valuable portion of the operation and supply chain management of a company. The data retrieved from warehousing and mining can be used to support inventory, production and sales. Inventory and sales can be can tracked, so that raw supplies can be brought in based on the need. Production schedules can be composed based on the raw materials arriving and the need of products that are in high demand. It appears that mining and warehousing are a large component of the supply chain management.
The most important aspect of data mining and data warehousing is the ability to communicate, directly and indirectly with the customer. A company can directly solicit the customer feedback on a product that they have already delivered. The customer feedback can be retained and reviewed for product change or product research. Indirectly, the business can make purchasing suggestions to a customer via email, advertising, or direct mailing based on information previously retained in the system. Following this

Related Documents

  • Improved Essays

    It is a collection of integrated applications that a company uses to connect activities across all of its departments so that every employee is working with the same information. (Shacklett, 2015) By implementing an ERP system, companies can streamline their operations and standardize business processes, which saves them time, effort, and most importantly, money. Companies often choose what ERP tools they need based upon which business processes they want to be improved. It also depends on what type of business they are running, such as if they sell products or services. If they sell products, they might want to choose ERP tools that will help them address problems regarding manufacturing, distribution, or supply chain management.…

    • 799 Words
    • 4 Pages
    Improved Essays
  • Improved Essays

    By this it can use the attributes and entities within the database which makes it easier to access. As this creates a link between each table such as if a customer was to buy a product, a record is then made this will store their information such as their first name, surname and adds a unique Customer ID in the customer table. The product table will store information such as the title, price and Unique product ID. Now…

    • 710 Words
    • 3 Pages
    Improved Essays
  • Superior Essays

    The system is designed in such a way that it automatically generates a piece of note that shows the quantities along with delivery descriptions. The manager must then click confirm when he has finished selecting the inventory that they wanted to use. Safety stock is, however, very crucial to customers (Pyzdek & Keller,…

    • 1116 Words
    • 4 Pages
    Superior Essays
  • Improved Essays

    CRM therefore manages the customer relationships by creating a clear understanding of the market (Know), by developing services and products based on the added value for target groups (Target), then enabling the actual sale and delivery of services and products via a portfolio of channels (Sell) and finally developing long-term profitable relationships with after sales services (Service). The relationship is developed with strategically significant customers, and hence necessary for the organization to determine the nature of this significance. Traditionally, this has been done by determining the value of the customer to the organization, but other criteria that can be used include whether a customer serves as a benchmark for other customers or whether the customer inspires change in the supplier. However, under certain circumstances CRM may result in the termination of relationships. It has not worked out that well in practice as many large companies sometimes spend huge amounts of money on CRM systems only to find disappointing results.…

    • 731 Words
    • 3 Pages
    Improved Essays
  • Decent Essays

    Why is Market Research important? A few of the many reasons why market research is important for businesses: It helps in Better Communication with Your Customers Consumers always have a higher hand when it comes to doing business. In order to have them connected closely to your business, you must communicate clearly. Try to meet or exceed their expectations consistently to stay in their good books. Show them you care for them by communicating your concern and accepting their…

    • 749 Words
    • 3 Pages
    Decent Essays
  • Improved Essays

    In business, this process is very important to provide initial data that can be used to generate useful information on the next stage in order to make business decisions. This needs the ability of knowing which elements of information to monitor and how to apply the right filters to each. 2) Orient Orient is the process of gathering the knowledge from the observed data to generate useful information. This phase determines what the data means to users and what the users can do about it. As the repository of previous knowledge and experiences in user’s mind, orient is the most important part of the OODA Loop since it shapes the way we observe, decide, and…

    • 1201 Words
    • 5 Pages
    Improved Essays
  • Decent Essays

    Supply Chain Memo

    • 814 Words
    • 4 Pages

    Return: this function processes the return of customers, repair or maintenance of the product or service also handles excess inventory, managing activities include authorization of comebacks, provision of services or products, credit or replacement. Having supply chain management, it is important for the operation of any company that intents to bring to market some innovative product or service, in this way responsibilities are distributed and ensures that the final product may be placed on the market, depending on the demand of the same. Supply Chain Management, also helps to determine the costs of each of the parts of the production process of a product or service and this helps companies determine how much to spend and the investment that has to be done for the production of a product or service and identify any expenses which might be not needed for production. There are different ways to establish a supply chain network, based on the needs or constraints that the company may have. 5 Steps are listed to considerer for this purpose.…

    • 814 Words
    • 4 Pages
    Decent Essays
  • Improved Essays

    There is so much that can be gained by gathering customer intelligence, which will provide a wealth of information that reveals what drives the customer and what their interests are. For the company that can connect their product to their customer’s interests, developing a trusting relationship that will lead to a long-term business life cycle will prove much…

    • 1012 Words
    • 4 Pages
    Improved Essays
  • Improved Essays

    Pak Nsave Case Study

    • 1047 Words
    • 5 Pages

    Management can find valuable data in their firm 's own internal records to help with their marketing decision. Typical sources of internal are sales records, financial statements and marketing cost analysis. Marketers analyse sales performance records to gain an overall view of company efficiency to find clues to potential problems. (Louis E, Boone, David L. Kurtz, (2015). Marketers can analyse sales performance records to gain an overview of company efficiency and to find clues to potential problems.…

    • 1047 Words
    • 5 Pages
    Improved Essays
  • Great Essays

    Big Data Research Paper

    • 1598 Words
    • 7 Pages

    Big Data provides you with the information of past activities and then helps you to make a decision based on that data. As well as helping the user this allows the companies to collect data and then improve their services this is because Big Data gives them real-time research by just analysing what the user does online. It allows companies to see how their own business is doing and what trends are occurring which then can lead them in the right direction to get a possible edge over other companies who don’t have this form of data collection. Analysing trends show a business what the customers want and then gives them an action plan in which they can what the next step is to retain/attract customers and create profits. (Ciklum,…

    • 1598 Words
    • 7 Pages
    Great Essays