Question

In: Accounting

150 WORDS REQUIREMENT!!! Discussion how data warehouses are created and used. Please state your reasons in...

150 WORDS REQUIREMENT!!!

Discussion how data warehouses are created and used. Please state your reasons in detail.

Solutions

Expert Solution

Data Warehouses:-

A data warehouse is a database designed to enable business intelligence activities: it exists to help users understand and enhance their organization's performance. It is designed for query and analysis rather than for transaction processing, and usually contains historical data derived from transaction data, but can include data from other sources. Data warehouses separate analysis workload from transaction workload and enable an organization to consolidate data from several sources. This helps in:

  • Maintaining historical records

  • Analyzing the data to gain a better understanding of the business and to improve the business

The information gathered in a warehouse can be used in any of the following domains −

  • Tuning Production Strategies − The product strategies can be well tuned by repositioning the products and managing the product portfolios by comparing the sales quarterly or yearly.

  • Customer Analysis − Customer analysis is done by analyzing the customer's buying preferences, buying time, budget cycles, etc.

  • Operations Analysis − Data warehousing also helps in customer relationship management, and making environmental corrections. The information also allows us to analyze business operations.

The following are the functions of data warehouse tools and utilities −

  • Data Extraction − Involves gathering data from multiple heterogeneous sources.

  • Data Cleaning − Involves finding and correcting the errors in data.

  • Data Transformation − Involves converting the data from legacy format to warehouse format.

  • Data Loading − Involves sorting, summarizing, consolidating, checking integrity, and building indices and partitions.

  • Refreshing − Involves updating from data sources to warehouse.


Related Solutions

300 WORDS REQUIREMENT!!! Discuss the business activities that comprise the conversion process. Please state your reasons...
300 WORDS REQUIREMENT!!! Discuss the business activities that comprise the conversion process. Please state your reasons in detail.
short essay (150-200)words to state your purpose of becoming an engineer? please write it clear so...
short essay (150-200)words to state your purpose of becoming an engineer? please write it clear so I can read it.
Please make it original in your words. Each part require 150 words only please. 450 in...
Please make it original in your words. Each part require 150 words only please. 450 in total. ·         As a professional accountant, how would the process for completing the practice set assignment (a manual accounting process) be used in an accounting department. Explain how communication, teamwork, time management and interpersonal skills play a role in completing this process within an accounting department? ·         When (why) would you use this system rather than an automated accounting system? ·         What are the...
Explain the methods used to issue new securities (in your own words at least 150 words)
Explain the methods used to issue new securities (in your own words at least 150 words)
Please reply to DIscussion 1 and Discussion 2 in your own words: Discussion 1: Virgin Atlantic...
Please reply to DIscussion 1 and Discussion 2 in your own words: Discussion 1: Virgin Atlantic Airways positions itself as a very high-quality airline. Their mission to deliver high quality and exception service is, in my opinion, not reflected on its website. The website depicts Virgin Atlantic as a fun, cool airline to fly with. Much of this vibe is from a direct influence from Virgin Records. David Aaker, author of Strategic Market Management goes on to describe Virgin as...
in your word, to discussion Steinhoff International financial fraud by using the fraud triangle (150 words)
in your word, to discussion Steinhoff International financial fraud by using the fraud triangle (150 words)
in your word, to discussion Steinhoff International financial fraud by using the fraud triangle (150 words)
in your word, to discussion Steinhoff International financial fraud by using the fraud triangle (150 words)
Your work should be in the range of 150-250 words. For all discussion questions, you must...
Your work should be in the range of 150-250 words. For all discussion questions, you must cite to your text or some other reliable source when answering the question. What concepts are you applying? Where are you getting the information? Scenario (based on a real Illinois case): A patient presented to a local emergency room and was examined by a plastic surgeon. A review of an X-ray taken of the patient's knee revealed a possible malignant neoplasm. Consequently, the plastic...
in your own words please , Discuss requirement structuring of Analysis phase of SDLC (activities and...
in your own words please , Discuss requirement structuring of Analysis phase of SDLC (activities and deliverables).
Please reply to each of the discussion posts in your own words: Discussion 1 Yes I...
Please reply to each of the discussion posts in your own words: Discussion 1 Yes I do believe this because I have been a part of scenarios related to this in my workplace. We all have one goal as a team and that is to accomplish our tasks and do it efficiently and quickly. Our boss always says “how can we do more with less.” The biggest part of achieving this is by having trust and cooperation within the whole...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT