Nobody downloaded yet

Description of a data data warehouse - Assignment Example

Comments (0) Cite this document
Summary
This is due to the fact that a data warehouse will provide data from different sources, therefore managers and executives will no longer need to make business decisions based on limited…
Download full paperFile format: .doc, available for editing
GRAB THE BEST PAPER93.4% of users find it useful
Description of a data data warehouse
Read TextPreview

Extract of sample "Description of a data data warehouse"

Download file to see previous pages Data from different sources are converted into a common format in the data warehouse, therefore, each department will produce results that are in line with all the others.
Furthermore, a data warehouse will be of great importance during data recovery. If a disaster occurs in the transactional database, it will be easy to restore all data, all if not all, that which is of importance, to the transactional database from the warehouse.
This table is used to store information about different tables from the dimensions table, which include: CustomerKey, SupplierKey, DateKey, ProductKey, OrderID, Required_DateKey, UnitsOnOrder, ProductPrice, Shipped_DateKey, Quantity, TotalPrice, ShipperCompany, ShipperPhone, InsertAuditKey and UpdateAuditKey.
The table contains key values of different dimensions tables. ProductKey, SupplierKey, DateKey, UnitPrice, UnitsInStock, UnitsOnOrder, ReorderLevel, UnitsSold, InsertAuditKey, UpdateAuditKey. The Product, Supplier, and Date keys are surrogate keys in the FactInvetory table. The InsertAuditKey and the UpdateAuditKey are foreign keys from the FactOrder table.
The table contains information about keys, the SK_EmployeeKey, SK_TerritoryKey, and the SK_DateKey. All these are surrogate keys referencing EmployeeKey TerritoryKey and DateKey from different dimensions table.
The table has CustomerKey as the surrogate key for the table, CustomerID as the business key. Other customer information stored in this table include: FirstName, LastName, TitleOfCourtesy, CompanyName, Address, City, Region, PostalCode, PostalCountry, Phone, Fax, Description, IsCurrent, EffectiveStartDate, AffectiveEndDate, InsertAuditKey, UpdateAuditKey.
The other employee information stored in the dimension employee table include: LastName, FirstName, Title, TitleOfCourtesy, BirthDate, HireDate, Address, City, Region PostalCode, Country, HomePhone, Extenision, Notes.
Other information stored in this table include: Day, ...Download file to see next pagesRead More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Description of a data data warehouse Assignment”, n.d.)
Description of a data data warehouse Assignment. Retrieved from https://studentshare.org/information-technology/1668230-description-of-a-data-data-warehouse
(Description of a Data Data Warehouse Assignment)
Description of a Data Data Warehouse Assignment. https://studentshare.org/information-technology/1668230-description-of-a-data-data-warehouse.
“Description of a Data Data Warehouse Assignment”, n.d. https://studentshare.org/information-technology/1668230-description-of-a-data-data-warehouse.
  • Cited: 0 times
Comments (0)
Click to create a comment or rate a document

CHECK THESE SAMPLES OF Description of a data data warehouse

Data warehouse

...? How information systems have revolutionized the way businesses have been operating lately stands at the focus of this paper. The author of the paper has actually summarized the benefits of information systems in the field of business automation and reengineering, customer relationship management, building IT enabled city infrastructures and use of data mining in business analytics. The content of the paper comes from four books reviewed by the author and primarily serves the purpose of delivering fundamental knowledge of the topics which are gaining immense importance today (Gray 2001). The target audience of this paper are mostly scholars and researchers who could get basic information and clear definitions of topics...
2 Pages(500 words)Essay

Recommendations for Data Warehouse Concept

...and regulations that controls access to the information. Description of Data Warehouse There are various activities that take place in every organization in order for the processing of services to be completed. Therefore, there is the need for data collection, data analysis, and process and data storage in regards to the organization. Not all the available data are public, therefore, there are some of the data that are private and need to be kept safely from un-authorize users. In order for any organization to be in the position of keeping their information safely, there is a need for the introduction of...
8 Pages(2000 words)Speech or Presentation

Data Warehouse

... Data Warehouse In computing the term data warehouse (DW) refers to a centrally managed and integrated database containing both raw and formatted data received from various operational sources (in an organization), generally stored in an archival manner for easy access and used for reporting and analysis purposes as shown in fig. 1. Data warehousing is a process of centralized data management and retrieval (Greenfield, par.1). Data warehouses can have both current as well as historical data. The data received from various operational resources in...
5 Pages(1250 words)Essay

Data Warehouse Business Pla

...? Data Business Plan Bridgette Scott American Public System Data Warehouse Business Plan Data Warehouse Business Plan is essential in creating a clear understanding of the operations of a business, helping management establish potential risks and pitfalls of the business. This business plan will highlight the overview and structure of the business forming the basis of issue identification and strategic assessment. The business plan points out the infrastructure and information systems of the company and role in management and operation of data warehouses. The company’s data management and knowledge by its...
5 Pages(1250 words)Assignment

Data Warehouse assignment

...the sales figure. Though this is a logically true relationship, the fact that this is one of the findings from the data in the warehouse makes it an analysis of the data from the data mart. The data was analyzed with respect to the time dimension - week. Sales were analyzed against the customers weekly. It was identified that the sales amount graph for the six weeks of 2005 for ALL the customers generated the following trend: The above graph displays that there was a drop in sales amount in the third week of 2005. Since this is a graph of cumulative sales, we can assume it to be a fair representation (normalized) of the entire dataset. After the third...
11 Pages(2750 words)Essay

Data warehouse presentation evaluation

...Generally a data warehouse is a trace of an enterprise's past transactional and operational information that is stored in a specially designed database with appropriate facilities for data analysis and reporting. There is one common idea in the basis of data warehousing design: first data should be integrated from distributed and differently structured databases and then it should be picked out for purposes of reporting, decision support, analysis or control. There are four design approaches to this process that differ by scale of data, action sequences and complexity. Top-Down Approach assumes that data is transferred...
2 Pages(500 words)Essay

Data Warehouse Project Management

...Data Warehouse Project Management Contents of the Report Introduction DePaul An Introduction The Data Warehouse Project Project Charter Requirements Document Statement of Work Risk Analysis Conclusion Introduction Databases and Database theory have been around for a long time now. The earlier databases centered around a single database serving both purposes: transaction processing and decision support. However with the advancement of technology such as 4GL and PC and with the empowerment of the end user to perform his/her own tasks, a more sophisticated version of the databases started to occur. These sophisticated data storage technologies are known as data warehouses. A data warehouse is a copy of the transactional data... that is...
20 Pages(5000 words)Essay

Data description

...Data Task The research process encompasses collecting data from various sources, and describing this data is important to ensure that the data from different sources is summarized and presented in away that its users can understand. Often, descriptive, numerical and graphical methods are used when describing data and this makes it easy for the user of this data to know if the results are in accordance to the hypothesis of the research (Clark-Carter, 2009). Various methods can be used to describe data because of the differences in data or variables being evaluated. There are two...
1 Pages(250 words)Essay

Data description

... Data on Diabetes Diabetes is basically a group of diseases which is marked by significant increase in the level of blood glucose that results either from deficiency in production of insulin or insulin action or even both. The most commonly found types of Diabetes are type 1, type 2 and gestational diabetes. It has caused serious complications and death at premature level but when people with this disease take preventive measures they can reduce their complication’s risk by a considerable amount. According to Centers for Disease Control and Prevention (2011), about 25.8 million Americans are diagnosed with Diabetes which is approximately 8.3% of the total U.S. population and more than seven million are unaware of the fact... Data on Diabetes ...
2 Pages(500 words)Essay

Data warehouse

...Data Warehouse College: Data Warehouse In the era of development of business technology data warehouse - data mining are crucial tools in the business environment. Data warehouse is a system used for reporting and data analysis of information within organizations. This is a critical tool that many managers use for synthesis of decisions that affect the organizational path. In the contemporary competitive business environment, this has become one of the most popular technologies as decisions become an important determiner of the organizational development. Some of the...
4 Pages(1000 words)Essay
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.

Let us find you another Assignment on topic Description of a data data warehouse for FREE!

Contact Us