Preview

What Is a Data Warehouse ?

Powerful Essays
Open Document
Open Document
2434 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
What Is a Data Warehouse ?
Question 1
What is a data warehouse? What problems does it solve for a business?
A data warehouse is a place where data is stored for archival purpose, analysis purpose.
Usually a data warehouse is either a single computer or many computers servers tied together to create one giant computer systems.
Data warehouse solve a lot of problems to companies as it helps to structure files and avoid unnecessary duplication of data.
Data warehouse also allows to easily updating data and encourages management to regard data as a resource that must be properly managed just as any other resources.

Question1B
What do you see as the benefits of using a web-like browser to access information from a data warehouse?
The benefits of using a web browser to access information from a data warehouse is that it allows users to have access to different search engines and opens up different links with the relevance key search.
Some results will be more complete than others as they have different ways of indexing websites.
Using a web browser to access information from a data warehouse is also useful as the links give you access to images and videos which interact users but can also slow down the logon level of speed operations meaning that the data warehouse is accessed at a fast speed.

Question2

The SAP system is a collection of software that performs standard business functions for corporations. Here are some applications developed by SAP for consumers use, they are regrouped into categories of utilities[1].

Financials applications

The SAP Financials applications contain all of the functionality needed for enterprise-wide financial management. These include:

• Financial Accounting (FI), Provides a complete financial accounting solution, including income statements, balance sheets, journals, ledgers, and all areas of financial accounting. • Enterprise Controlling (EC): Assists in controller tasks. • Capital Investment Management (IM): Assists finance organizations in

You May Also Find These Documents Helpful

  • Powerful Essays

    MIS 563 COURSE PROJECT

    • 2795 Words
    • 12 Pages

    This finding has ABC University seeking a streamlined way to manage their data and for users to access the data that is clean. With this, the University has proposed the creation and implementation of a data warehouse to house all the data from each one of these operational databases into one central location where all students, staff and faculty can access the data using a self service tool such as a report or a data connection to Microsoft Excel to pull data into pivot tables.…

    • 2795 Words
    • 12 Pages
    Powerful Essays
  • Good Essays

    Chapter 5 Quiz

    • 334 Words
    • 5 Pages

    A data mart usually can be constructed more rapidly and at lower cost than a data warehouse because:…

    • 334 Words
    • 5 Pages
    Good Essays
  • Powerful Essays

    Mis535 Midterm

    • 1761 Words
    • 8 Pages

    | data warehouses tend to serve an entire enterprise and a data mart a single department.…

    • 1761 Words
    • 8 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

    Answer: A data warehouse contain pool of data both current and of the past/historical which in turn are used to support decision making by the managers., Without it, GeoStor would lack the variety of data it needs to be able to perform different tasks for different functions.…

    • 617 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    | * The data warehouse of St George bank supports the integrated data among different departments * Data from different departments can be accessed freely * Integrated data from the data warehouse is more beneficial and creates more opportunities and BI for all departments (1+1=3) * “Most departments extract what they need from the warehouse using customer relationship management and BI applications without intervention.” * “They have access to all the data, can create their own filters, their own campaigns.”…

    • 341 Words
    • 1 Page
    Good Essays
  • Good Essays

    1. Describe "active" data warehousing as it is applied at Continental Airlines. Does Continental apply active or real-time warehousing differently than this concept is normally described?…

    • 1485 Words
    • 6 Pages
    Good Essays
  • Powerful Essays

    Pfm Devices

    • 1302 Words
    • 6 Pages

    * The need for a data warehouse could reduce costs by increasing access and visibility to real-time data…

    • 1302 Words
    • 6 Pages
    Powerful Essays
  • Good Essays

    If I were to design Ben & Jerry's data warehouse I would use several dimensions of information. The first dimension would consist of the company's products; ice cream, frozen yogurt or merchandise. The marketing department has to know which products are selling, if Ben & Jerry's didn't know that their T-shirts are selling out as soon as they hit the stores, then they wouldn't be able to take advantage of the opportunity to sell the shirts. The second dimension would consist of the different areas of sales; US, Canada, Mexico, or Europe. I am not sure if they sell their ice cream in Mexico, but with data collection they can find out if their ice cream would be a better seller in the hot climate, rather than pushing for greater distribution in Canada. The third dimension would consist of the "specifics"; where the sale was made, when the sale was made, and who purchased the product. This information can help in the design of the product to focus on the buyer; it can tailor flavors to seasons, and packaging to buyer who looks for the better-looking product. If Ben & Jerry's could know when a season was coming to an end in a specific area, then they could forecast the need or the decline in need and speed up, or slow down distribution to those areas. The focus of the information is that it needs to be useful, and almost any information is useful.…

    • 605 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Bis Midterm Sheet

    • 1467 Words
    • 6 Pages

    A data warehouse is to extract and clean data from operational systems and other sources to store and catalog that data for processing by BI tools. Data warehouses can include external data purchased from outside sources. Meta data is kept in the data warehouse. Physically, a data warehouse consists of a few fast computers with very large storage devices.…

    • 1467 Words
    • 6 Pages
    Good 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

    Sysco

    • 906 Words
    • 4 Pages

    1. Utilization: Massive amount of data in the data warehouse are stored, but cannot be analyzed.…

    • 906 Words
    • 4 Pages
    Powerful Essays
  • Good Essays

    Database tools and technologies affected the business processes and decision making by a great extent. The most important benefit of the database is to change unstructured information into structured information, and allow users to analysis the data stored into different tables with the help of queries. Before database, all the information used to stored into paper and other unstructured computer programs, due to which getting required information process was very slow. Due to database, all the data is stored into the server and not only access of these became faster but also multiple users can access database at the same time. It removes redundancy from the tables, and ensure that the data all over the database is consistent, and also ensure the integrity of the data.…

    • 899 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Fac Case Study

    • 650 Words
    • 3 Pages

    FAC’s data warehouse platform was the NCR 5150M. It run the Teradata Relational Data Base System with 5 SMP nodes. This platform provided 1.5TB of data storage to FAC. Data from many sources like VSAM, IMS which stored in this storage could be accessed by dependent data mart created in an Oracle relational DBMS and Cognos cubes. The analysts in the company can analyze the profitability with tools called PAR which can be run by ad-hoc SQL queries and predefined reports. These kinds of analyzed data could be the information to decision makers by using VIEW in DBMS or many other…

    • 650 Words
    • 3 Pages
    Satisfactory Essays
  • Best Essays

    Historically, a manual file system was composed of a system of file folders and filing cabinets.…

    • 2439 Words
    • 17 Pages
    Best Essays