Essay On Data Warehousing

Submitted By dace
Words: 2252
Pages: 10
Open Document
Data warehousing can greatly benefit and help any organization. In the book “Databases Illuminated”, data warehousing is described as a storage place of a company’s historical data that is often collected from various departments or sections of a company that belong to the company as a whole (Ricardo, 2012). With the scope and range of data that is stored this can at times include massive amounts of data. Such a “warehouse” of data can be invaluable to a company. I am sure that once anyone understands exactly what a data warehouse can do, they will also decide that one is definitely needed.
Data warehouses are widely used in most of the largest and complex businesses or companies around the world. They are really not efficient or of much use to moderately large or small organizations. Data warehouses are invaluable to a company because good decision-making is the cornerstone of any business. The best decisions are made when all the relevant data available and taken into consideration. The best possible source for this type of data is a data warehouse. It is relatively simple, data is extracted periodically from the applications that support business processes and copied onto special dedicated computers. From there it can be manipulated and supplemented with data from other sources. The result is a warehouse of information that can be used as the main source of information for reports, analysis, and strategizing.
These data warehouses can help a company to grow and capitalize on certain business trends. The intelligence gained from a data warehouse can quickly answer questions like, what still works? What continues to sell? How can cash be conserved? What costs can be cut without causing long term harm? So, data warehouses can provide us with the ability to answer these critical questions by turning the massive amounts of data into a form that is current and easy to understand. As a result we can analyze current and long term trends, by instantly alerting opportunities and problems, and by getting continuous feedback on the effectiveness of our decisions.
DSSResources.com is a knowledge repository about computerized systems that support decision making and its editor Dan Power says there are three major advantages from developing a data warehouse. These advantages include integrating data from multiple sources, performing new types of analyses, and reducing cost to access historical data (Power, 2008). These advantages leverage cost and can help a company to save money.
More specifically other advantages include Enhanced Intelligence primarily through improved information access. Decisions no longer have to be made based on limited data and just on what executives feel is right. Decisions that affect the company can be made based on credible facts that are backed up with evidence and actual data. The intelligence gained can be applied directly to business processes including marketing, inventory management, financial management, and sales.
Another benefit is increased query performance. Data warehouses are designed and constructed with a focus on speed of data retrieval and analysis. They are designed for storing large volumes of data and being able to rapidly query that same data. A data warehouse is built for analysis and the retrieval of data rather than just efficiently maintaining records. Similarly, timely access to data is an advantage that enables users and decision makers to have access to data from many different sources. This allows users to spend a minimal amount of time in the data retrieval process. Scheduled data integration actions are processed in the data warehouse environment. These actions consolidate data from multiple sources and transform that data into a useful form. Consumers can then easily access data from one interface and can also query data directly with less support. These consumers of the data can then spend more time performing data analysis and less time
Show More

Related Documents: Essay On Data Warehousing

research paper

Research Paper 1 How safe are the government facilities? Rebecca Leon Empire State University Business Continuity Planning and Disaster Recovery Diane Delucia April 01, 2015 Research Paper 2 On March 9th 2015 an email was sent out to every Army…

Words 1122 - Pages 5

IT Research Paper

Research Paper MELKIA WATERS Mwaters17@capellauniversity.edu IT3006 PROF. JULIA KRUMMEN Nov. 10, 2013 Identifying Improved Methodology to Procure HIT Software Benefits Users Introduction Researchers conducted a study conducted at The University of Utah Healthcare system (comprising of 3 major hospitals) on the usability of their health information technology (HIT) software. Evaluators found 60 usability problems and 233 heuristic violations (Guo et al., 2011). Heuristic is defined by Oxford Dictionaries…

Words 1892 - Pages 8

Research Paper

25099373 CNF15_3 Research Methods Research Proposal Word Count: 1210 A look into the Memory Retention: Can stimulants increase a person’s memory? A quantitative research proposal. For this research proposal, memory will be looked into to see whether a person’s memory can be increased via the intake of stimulants. This quantitative research will then look into whether there are any future benefits in consuming stimulants if memory is found to be increased. There is already research similar in nature…

Words 1359 - Pages 6

Research Paper

Research papers are a common type of paper for students to write, especially when they are attending college. These papers require students to perform research, such as utilizing primary and secondary sources to draw new conclusions. For students who have not written this type of paper before, it may seem daunting. There are many free sample research papers online for those who want to see how to structure their paper and other details.Diane Hacker, an author who writes manuals for students writing…

Words 307 - Pages 2

Research Paper

Research Paper EDUC 600 Pamela Noble Dr. Albright Liberty University Abstract Billions of dollars are spent every year on psychologist, psychiatrist, and counselors only to discover that one of the key elements missing in their child is resiliency. Resiliency for the purpose of this study is defined as the appropriate personality such as strength and positive adaptation that help a person or family cope with stress or life difficulties, increasing the likelihood of…

Words 514 - Pages 3

Research Paper

Research Paper How does an imposed requirement of regularly identifying exposure to operational risk benefit an insurance company? Executive Summary The topic of this research paper is how an imposed requirement of regularly identifying exposure to operational risk benefits an insurance company. Risks occur naturally in all business, but if risk is not controlled, there are plenty of consequences that can arise. Insurance companies deal with risk everyday, ranging from fraud, car theft, health…

Words 2609 - Pages 11

Research Paper

Comparison of the Sciences SSC101 Research Assignment Module 7 Saint Leo University December 08, 2012 The three social sciences below are defined as according to the Merriam-Webster on line dictionary. www.merriam-webster.com Anthropology 1: the science of human beings; especially : the study of human beings and their ancestors through time and space and in relation to physical character, environmental and social relations, and culture 2: theology dealing with the origin,…

Words 2578 - Pages 11

Research Paper

amount Americans drink today by three and you'll have an idea what much of the nineteenth century was like.” So how does someone become an alcoholic? This has to do with a combination of genetic, physiological, psychological and social factors. Research have discovered that children of alcoholics are four times more likely to become alcoholics themselves. Children of alcoholic parents are raised in the environment where drinking is okay and they tend to pick up the drinking habit from their parents…

Words 1766 - Pages 8

Research paper

groups, sexual preferences, sex, size, etc. So to fathom being in a society where it is essentially a "free for all" towards being prejudice, or genuinely prejudice towards these types of groups is very hard to imagine. Prior to doing any definite research, I thought I had a pretty clear idea on how exactly equal opportunity could both benefit, and hurt today’s workplace. As I was reading “Advantages & Disadvantages of Equal Opportunity Employment” (Casey Reader) a short online article by Casey Reader…

Words 1332 - Pages 6

Research Paper

you commit yourself to. This way of thinking really reflects on the type of writing process I endure. While writing I really focus on how I want to identify myself, what questions I wish to discover, and how this idea might change me. To begin my paper I use an outline. On this outline at the top of the page I write my main topic that I wish to write about. After I have created the topic, I then write a list of ideas that relate to what I want to talk about. Out of the ten ideas I create I choose…

Words 2972 - Pages 12