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.
Objectives
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
Data warehouse developer is responsible for maintaining the practices of modeling, dimensional data, relational structures, and other reporting techniques. Candidates possessing an inner desire for long term employment opportunities in a team oriented fast paced wonderful environment. They need to be qualified with Information Systems, Computer Science and other related fields. It would be preferable to possess minimum of 7 years’ experience with warehouse design and analysis experience with complete knowledge about data modeling and warehouse methodologies. Job requirements for Albertsons Data warehouse developer jobs-
ETL is a three-step process which stands for Extract-Transform-Load. This process comprises of: extracting the desired data from a source, transforming the extracted data into a specific format, and loading the transformed data into a destination such as a data warehouse (Haag & Cummings, 2013). After the ETL process is performed, data-mining tools can be used to turn this data into useful information. For the first three questions, the database would need to capture each checkout price, how many items are purchased, the individual price of each item, and if the item is discounted or full MSRP. This specific data will likely originate from a customer oriented database that will then flow into the data warehouse for full ETL. For YTD profits, the database would need to capture all purchases, sales, profits, and expenses from the current year. Sport T’s company data will originate from an in-company database which focuses on business expenses and profits. In solving customer satisfaction, the KPIs to consider would be survey questions and answers from responding customers as well as customer opinion on what can be improved. For customer surveys, we will ask
Smith, W., & Jewett, D. (2009). Tableau software and teradata database the visual approach to the active data warehouse. In Retrieved from http://www.tableausoftware.com/learn/whitepapers
CarMax faces challenges from several fronts that could threaten to disrupt their growth plans and their position as a disruptor in the used car market. The biggest challenge they face is being able to continuously secure a study supply of high quality used cars, due to the extremely competitive nature of the used car market. CarMax offers cutting edge technology to help the company identify buying trends, pricing trends, and consumer preferences down to the zip code that gave them a large competitive advantage, as “data mining” has matured and competitors have developed their own software tools, eroding the competitive advantage to CarMax.
Bibliography: BusinessDictionary.com, (2015). What is management accounting? Definition and meaning. [Online] Available at: http://www.businessdictionary.com/definition/management-accounting.html [Accessed 23 Jan. 2015].
Burke, Darla. "Alcoholism." : Causes, Risk Factors & Symptoms. George Krucik, MD, n.d. Web. 9 Apr. 2014.
...g system that supports the scalability of their data. The following is their input on their new proposal to create a new operational insight tool in order to provide a solution to their challenge:
Data can give you quite a bit of information about your customers. By examining it, you will be able to begin to see patterns and learn the habits of your customers. This could mean that you are able to provide the correct number of products at the perfect time instead of having a shortfall or being left with additional stock long after interest has fallen in the product.
Today, Information systems have come a long way in creating new services and provided solutions and a better chance for certain issues facing automobile industry. Automobile Industries have taken advantage of this to bring into more desirable and excellent operations, improve value to their products and to their customers, as well as enable new business standard, style and image. In this research paper, we will explore the use of Information Systems in vehicles, the arrangement of Information Systems to sustain business operations of manufacturers, and the effect of doing so on automobile industries.
A data warehouse comprised of disparate data sources enables the “single version of truth” through shared data repositories and standards and also provides access to the data that will expand frequency and depth of data analysis. Due to these reasons, data warehouse is the foundation for business intelligence.
Tucci, Linda. (May. 2008). Five tips on selecting a data center location. Retrieved on March 10, 2011 from http://searchcio.techtarget.com/news/1312614/Five-tips-on-selecting-a-data-center-location
Retail industry is centered on commoditized goods and is hence extremely dependent on price/cost advantages. Investments in IT technologies that enable efficient inventory management. Retail industry is one of the largest users of big data. Big data is being used to analyze process improvements, study logistics, optimize inventory, improve merchandising, and most importantly, study in-store and online consumer behavior to forecast future needs.
The dynamics of our society bring many challenges and opportunities to the business world. Within the last decade, hundreds of jobs have emerged particularly in the technology sector to help keep up with the ever-changing world and to compete on a larger and better scale than the competition. Two key job markets and the basis of this research paper are business intelligence or BI and data mining or DM. These two fields play a very important role in small to large companies and are becoming higher desired sectors within the back offices of the workplace. This paper will explore what the meaning of BI and DM really is, how they are used and what we can expect as workers and learners of the technology and business fields for the future.
For the past couple of decades the majority of businesses have wanted to construct a data-driven organization or company. Furthermore, companies around the world are considering harnessing data as a basis of competitive advantage over other companies. As a result, business intelligence and data science use are popular in many organizations today. The increase in adoption of these data systems is in response to the heavy rise in communications abilities the world over. Which, in turn ,has increased the need for data products. Indeed, the Data Scientist profession is emerging to be one of the better-paying professions due to the urgent need of their labor. This paper is going to discuss what business intelligence is all about and explain data science that is usually confused to be similar to business intelligence. I will tackle a brief overview of data scientists and their role in organizations.
These databases allowed companies to better understand what customers were buying regularly, what they spent and what they did. (Ruchi, 2014) The earliest definition of this was "Database Marketing is an interactive approach to marketing, which uses the individually addressable marketing media and channels (such as mail, telephone and the sales force): to extend help to a company 's target audience; to stimulate their demand; and to stay close to them by recording and keeping an electronic database memory of the customer, prospect and all commercial contacts, to help improve all future contacts and to ensure more realistic of all marketing."