Kar Dealer Data WarehouseThe purpose of the Kar Data Warehouse is to make data available to business users for decision-making purposes and to enable the dealer to 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 realized that to be successful, it needed to use its data as a tool to compete. They need to find out who their customers are and what their preferences are. A data warehouse will provide the Kar dealership with the analytical tools it needs to use its data to help it better understand its customers and market products to them. Objectives The objective of implementing a data warehouse is to sell more cars, services and cars. products. The data warehouse will help Kar gain insight into the level of customer satisfaction with Kar dealers and Kar after-sales services. Additionally, the data warehouse will also provide demographic analysis of vehicle model preferences for the dealer network's customer base. Data Warehouse Implementation Steps The Kar Dealership Data Warehouse will be based on a three-layer architecture to provide physical separation between the organization's production systems and the new production support system. decision (DSS). Additionally, the three-layer architecture includes a reconciled data layer containing cleaned, adjusted, and enhanced data that will be loaded into the data warehouse (Goldfarelli & Rizzi, 2009). Kar's data warehouse will be developed using the rapid warehouse methodology developed by SAS. , which divides the project into less risky sub-projects (Goldfarelli & Rizzi, 2009, p 28). This meth...... middle of paper ....... (January 1, 2014). MySQL in Data Warehousing and Business Intelligence. Retrieved April 16, 2014 from http://www.mysql.com/why-mysql/data-warehouse.htmlPicarille, L. (2004). Vertical Focus: How Car Dealers Maintain Relationships. Retrieved from http://www.destinationcrm.com/Articles/Columns-Departments/Insight/Vertical-Focus-How-Auto-Dealers-Drive-Relationships-44408.aspxRao, S. (April 6, 1996). Diaper-beer syndrome. Forbes. Retrieved April 17, 2014 from http://www.forbes.com/forbes/1998/0406/6107128a.html Vowler, J. (March 2002). Designing a data warehouse from top to bottom. Retrieved from http://www.computerweekly.com/feature/Data-warehouse-design-from-top-to-bottomWalls, D. and Scott, MD (December 20, 1999). 7 steps to data warehousing. 7 steps to data warehousing. Retrieved April 16, 2014 from http://sqlmag.com/database-administration/7-steps-data-warehousing