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

    College to Career: A recent survey commissioned by Bentley University in 2014 found that “compared with business decision-makers and corporate recruiters, high school and college students were far less likely to define preparedness in terms of personal traits or work ethic” (Chase, 2015). This means skills and experience rank high for college students when they evaluate preparedness. Unfortunately, the same survey found “thirty-seven percent of recent college graduates give themselves a grade of “C” or lower on their individual level of preparedness” (Chase, 2015).…

    • 899 Words
    • 4 Pages
    Improved Essays
  • Decent Essays

    Macy’s Inc. relies extensively on technology and on its information systems to process transactions, compile results and operate its business. As an advantage, Macy’s Systems and Technology, Inc. engages in creating, collecting, and directing pieces of data to form management tools. The company implements integrated retail, e-commerce, and data warehouse systems. As a disadvantage, the information systems can be subject to interruption from power outages, damage from viruses, cyber-attack or other security breaches. In these cases, companies like Macy’s may experience the loss of critical data and delays in its processes.…

    • 111 Words
    • 1 Pages
    Decent Essays
  • Improved Essays

    Unit 7 D2

    • 693 Words
    • 3 Pages

    2. Data warehouses- collects data from multiple databases and data silos; then organizes them for complex analysis, to gain more knowledge, and to use in their decision process. 3. Data marts-a small-smaller versions of data…

    • 693 Words
    • 3 Pages
    Improved Essays
  • Decent Essays

    Sysco emphasize on productivity and efficiency in the warehouse because it can induce many beneficial effect to the faculty. For example, if the productivity in the warehouse increases, it can increase the frequency of shipment and also the revenue in the same time. Whereas, if the efficiency increases, customers can get the product as quick as possible, leading to enhance the satisfaction of the purchase from Sysco. As more customers satisfy the service of Sysco, they are more likely to continue the purchasing in Sysco, and finally Sysco can acquire the benefit. Meanwhile, when the productivity and efficiency in the warehouse increase, Sysco is more available to provide the product with lower price.…

    • 205 Words
    • 1 Pages
    Decent Essays
  • Improved Essays

    1. What opportunities are being missed when each little area (scheduling, supply management, marketing, and others) has its own “stove piped” data? (Provide some examples.) As opportunities are being missed, with any organization having the right fit is important to succeed and getting organized. With the schedule, it does not provide a way to connect to the other resources such as client’s appointment.…

    • 745 Words
    • 3 Pages
    Improved Essays
  • Great Essays

    Case Study Kelly Salon

    • 1222 Words
    • 5 Pages

    13 Database high For any business to operate effectively, it needs to have an IT system that interacts with the user, other applications to capture and analyze data. Thus, Kelly must ensure she has a system that supports database. 14 Data Warehouse high The system should support storage of data as well as reporting and analyzing the same data to derive meaning from it to make business decisions regarding the future of the…

    • 1222 Words
    • 5 Pages
    Great Essays
  • Superior Essays

    Zillow Case Study Essay

    • 1460 Words
    • 6 Pages

    Introduction In this case study, the business of Zillow.com in providing real estate information to all users to its website is explored, and the use of business intelligence by Zillow.com in its offering to customer, and the way it uses a data mart to market its new product, are discussed. In addition, this case study includes a discussion of various characteristics of information quality as seen from Zillow’s perspective, and how Zillow is using a data-driven website. Analysis Background of Zillow.com Zillow.com is an online web-based real estate site helping homeonwers, buyers to find and share information about real estate and mortgages. It allows users to access information anonoyoumously and free of charge, using the kinds of tools…

    • 1460 Words
    • 6 Pages
    Superior Essays
  • Decent Essays

    Sysco Case Study Summary

    • 240 Words
    • 1 Pages

    Sysco's main issue is that, they are using different hardware and software platforms. Senior managers are having a hard time pulling a specific information because they are configured differently even if the companies are using the same software. The data of the customers are stored differently from different organizations. They had implemented ERP to resolve this issue. Other information was not consistent that is why Sysco implemented a data warehouse as well.…

    • 240 Words
    • 1 Pages
    Decent Essays
  • Improved Essays

    Hussmann Swot Analysis

    • 1089 Words
    • 4 Pages

    In addition to affording far more granular control over the warehouse as well as greater visibility of staff performance within it, other departments will be impacted as well • Customer service – greater visibility of order status • Production – greater adherence to the production schedule will be required • Engineering – Bill of material accuracy will be needed in order for accurate inventory…

    • 1089 Words
    • 4 Pages
    Improved Essays
  • Improved Essays

    Target Canada Essay

    • 1597 Words
    • 7 Pages

    Undaunted by the already-difficult task of getting a nation-wide distribution network up and running, the retail giant decided to also implement a new inventory tracking system not even fully rolled out in their American locations at the time (CITATION). The system, called SAP, was supposed to make the entire network more seamless and efficient, with the ultimate goal of implementing it throughout Target’s North American operations. Unfortunately, Target failed in acquiring personnel with any real knowledge of how to implement the system. According to Canadian Businessweek, other retailers, such as Canada-based Loblaws, had previously attempted to implement the system, which proved to be cumbersome and onerous to switch to. While Target attempted to combat this by hiring an outside consulting firm to assist in the process, they failed to train employees to a functional extent (CITATION).…

    • 1597 Words
    • 7 Pages
    Improved Essays
  • Improved Essays

    AMD Case Study

    • 978 Words
    • 4 Pages

    AMD has incorporated strategies that integrates IT solutions across all the teams with the help of IT to support efficient and responsive supply chain management. A standard ERP (Enterprise Resource Planning) system, SAP has been adopted. AMD uses hybrid Push-Pull: Batch dynamic production controls. Current supply chain challenges that AMD is facing: • Economic uncertainty due to global presence • Pressures from competition • Sensitive towards cost • Different technical challenges • Strong emerging markets • Environment is now too sensitive…

    • 978 Words
    • 4 Pages
    Improved Essays
  • Superior Essays

    Amazon Research Paper

    • 1604 Words
    • 7 Pages

    This assignment has presented three main points why big data is so crucial. Firstly, Amazon is widely praised for having pioneered web-based customer relations, setting an industry benchmark in market-leading technological infrastructure. Secondly Amaxon offer anonline personal service References Kotler, P., Armstrong, G., Wong, V., and Saunders, J., 2008. Principles of Marketing.…

    • 1604 Words
    • 7 Pages
    Superior Essays
  • Improved Essays

    In today 's world supply chain is at the centre of the business, for many decades’ companies have outsourced and organised many jobs to suppliers and intermediaries creating expansion and, recreated designs and through innovative processes, such sourcing has resulted in global supply chain management. It is a connected series of activities which is concerned with planning, organising, coordinating and controlling of materials, parts, and finished goods from supplier to customer. It is concerned with two distinct flows/ function i.e. material flow and information flow through the organization (Stevens 1989). At every point of chain information and material is passed in order to improving the efficiency at every level.…

    • 839 Words
    • 4 Pages
    Improved Essays
  • Improved Essays

    HBR CASE STUDY Excel-Pls supply chain management at Haus Mart 1. How is value added in supply chain management through better planning versus better execution? Ans. Supply chain management as we have learnt in this course is managing the movement of goods and services. It involves the storage and flow raw materials, inventory of work in process as well as finished goods from their point of origin to their point of consumption or use.…

    • 1315 Words
    • 6 Pages
    Improved Essays
  • Improved Essays

    With hours wasted looking on the status of inventory for customers, Walmart has implemented an app for their managers called MyProductivity. (rtinsights.com) This has allowed Walmart employees to be able to identify if product is available in their store without having to waste time going to the storage area to look for the product. Managers are able to identify buying trends of the customers by looking into the data provided allowing them to re order high turnover…

    • 1142 Words
    • 5 Pages
    Improved Essays