Kar Dealership Data WarehouseThe purpose of the Kar data warehouse is to make data available to business users for decision-making purposes and to enable the dealership to use predictive and statistical analytics to help the company sells more Kar products. The reason for creating a data warehouse is to do business intelligence (Hammergren & Simon, 2009). The Kar dealership has understood that to be successful it must use its data as a tool to be competitive. They need to find out who their customers are and what their preferences are. A data warehouse will give the Kar dealership the analytical tools it needs to use its data to help it understand its customers and how to market products to them. Goals The goal of implementing a data warehouse is to sell more cars, services, and vehicles. products. The data warehouse will help Kar get an idea of ​​the level of customer satisfaction with Kar dealers and Kar service departments. Additionally, the data warehouse will also provide demographic analysis on vehicle model preferences for the dealer network's customer base. Data Warehouse Implementation Phases The Kar dealership's data warehouse will be based on a three-tier architecture to ensure physical separation between the organization's production systems and the new decision support system (DSS). Additionally, the three-tier architecture includes a reconciled data layer containing cleaned, corrected, and enhanced data that will be loaded into the data warehouse (Goldfarelli & Rizzi, 2009). The Kar data warehouse will be developed using the rapid warehouse methodology developed by SAS, which breaks down the project into less risky subprojects (Goldfarelli & Rizzi, 2009, p 28). This meth......middle of paper....... (2014, January 1). MySQL in data warehousing and business intelligence. Retrieved April 16, 2104, from http://www.mysql.com/why-mysql/data-warehouse.htmlPicarille, L. (2004). Vertical focus: How automotive dealers drive relationships. Retrieved from http://www.destinationcrm.com/Articles/Columns-Departments/Insight/Vertical-Focus-How-Auto-Dealers-Drive-Relationships-44408.aspxRao, S. (1996, April 6). Diaper beer syndrome. Forbes. Retrieved April 17, 2014, from http://www.forbes.com/forbes/1998/0406/6107128a.htmlVowler, J. (2002, March). Data warehouse design from top to bottom. Retrieved from http://www.computerweekly.com/feature/Data-warehouse-design-from-top-to-bottomWalls, D., & Scott, M.D. (1999, December 20). 7 steps to archiving data. 7 steps to archiving data. Retrieved April 16, 2014, from http://sqlmag.com/database-administration/7-steps-data-warehousing