Implementing a Data Warehouse in a Kar Dealer Network
1268 Words6 Pages
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. A data warehouse will provide the Kar dealership with the analytical tools they need to use their data to help them learn about their customers and how to market products to them.
The objective of implementing a data warehouse is to sell more cars, services, and car products. The data warehouse will help Kar gain an insight into the level of customer satisfaction with the Kar dealers and the Kar service departments. Furthermore, the data warehouse will also provide the demographic analysis on vehicle model preferences for the dealer network customer base.
Data Warehouse Implementation Steps
The Kar Dealership data warehouse will be based on three-layer architecture to ensure a physical separation between the organization's production systems and the new Decision Support System (DSS). Furthermore, the three-layer architecture includes a data reconciled layer containing cleansed, 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 breaks up the project into fewer risky sub projects (Goldfarelli & Rizzi, 2009, p 28). This meth...
... middle of paper ...
.... (2014, January 1). MySQL in Data Warehousing & Business Intelligence. Retrieved April 16, 2104, from http://www.mysql.com/why-mysql/data-warehouse.html
Picarille, L. (2004). Vertical focus: How auto dealers drive relationships. Retrieved from http://www.destinationcrm.com/Articles/Columns-Departments/Insight/Vertical-Focus-How-Auto-Dealers-Drive-Relationships-44408.aspx
Rao, S. (1996, April 6). Diaper-beer syndrome. Forbes. Retrieved April 17, 2014, from http://www.forbes.com/forbes/1998/0406/6107128a.html
Vowler, J. (2002, March). Data warehouse design from top to bottom. Retrieved from http://www.computerweekly.com/feature/Data-warehouse-design-from-top-to-bottom
Walls, D., & Scott, M. D. (1999, December 20). 7 Steps to Data Warehousing. 7 Steps to Data Warehousing. Retrieved April 16, 2014, from http://sqlmag.com/database-administration/7-steps-data-warehousing