Data warehouse designer Essay

Data warehouse designer Essay

Implementing a Data Warehouse in a Kar Dealer Network

– Data warehouse architecture Goldfarelli & Rizzi (2009) describe two classifications of a data warehouse architecture. The first classification describes the physical separation of the data warehouse’s architectural layers. The second classification is based on the methods devised by Inmon and Kimball. Inmon advocates the use of hub-and-spoke architecture, while Kimball prefers an architecture based on the data mart bus (Ariyachandra & Watson, 2006). The advantage of the hub-and-spoke approach is data integration versus the ease of development and a lower cost of the federated approach (Hwang & Cappel, 2002)…. ;

Implementing a Data Warehouse in a Kar Dealer Network

– Kar Dealership Data Warehouse The purpose of the Kar data warehouse is to make data available to the business users for decision making purposes and to enable the dealership use predictive analytics and statistics to help the company sell more Kar products. The reason for creating a data warehouse is to do business intelligence (Hammergren & Simon, 2009). The Kar dealership has realized that in order to be successful they must use their data as a tool to be competitive. They must find out who their customers are and what their preferences are…. ;

Database Used for Reporting and Data Analysis

– … • Maintain data history, even if the source transaction systems do not. • Integrate data from multiple source systems, enabling a central view across the enterprise. This benefit is always valuable, but particularly so when the organization has grown by merger. • Improve data quality, by providing consistent codes and descriptions, flagging or even fixing bad data. • Present the organization’s information consistently. • Provide a single common data model for all data of interest regardless of the data’s source…. ;

Data Warehousing

– Introduction Data Warehouses (DW) integrate data from multiple heterogeneous information sources and transform them into a multidimensional representation for decision support applications. Apart from a complex architecture, involving data sources, the data staging area, operational data stores, the global data warehouse, the client data marts, etc., a data warehouse is also characterized by a complex lifecycle. In a permanent design phase, the designer has to produce and maintain a conceptual model and a usually voluminous logical schema, accompanied by a detailed physical design for efficiency reasons…. ;

Data

– 1. Data is something known or assumed. It is anything that fits into a DSS and is valuable. Three examples are grades for a class, a picture of wallpaper, or word of mouth about a new product or company. 2. Words, pictures, and numbers. 3. Information is acquired data that is derived from data and anything that is summarized in numerical or graphical. Information is used for ;informing; some one about something. An example of information is a net income on a balance sheet, the average of grades for a class and a graph of how many people use a certain product…. ;