CRM Using Data Warehousing At Case Study

Length: 9 pages Sources: 5 Subject: Business Type: Case Study Paper: #75165048 Related Topics: Case Formulation, Use Of Force, Trust, Analytical
Excerpt from Case Study :

It is important to realize that the level of technology investment at present is sufficient for the current project; this proposal does not necessarily advocate any additional spending on pure technology.

What this analysis pinpoints as a major area of concern is the slow and very gradual transformation of FAC when it needs to move much faster towards its customer goals. The lack of speed and urgency in the shift can be partially attributed to the lack of cohesion and consistency of overall IT strategies to support the next generation of CRM business strategies. At present the IT systems and platforms are sufficient yet they will need to change over time to stay current. Figure 1 illustrates how the ETL structure exists today at FAC, highlighting the role of the data warehouse. FAC will need to streamline this architecture if they are going to continually improve.

Figure 1: Topology of an Enterprise Data Warehouse and its relationship to Business Intelligence Based on analysis of the following sources: (Raisinghani, 2000)

(Shahzad, Mustafa, 2010)

Implications and Recommendations for First American Corporate Strategy

In order for FAC to continually grow and attract new customers while holding onto their existing ones, the existing CRM system needs to be augmented to better align with the strategic priorities and needs of the comp[any. While the many accomplishments and advances are impressive, there is significant room for improvement in the following areas. What is missing from the entire strategy today is the dimension of trust, both within the comp[any for the system, and most importantly, outside the company as FAC aspires to be the trusted advisor for their clients.

The long-term success of the entire initiative however rests on how well FAC can gain and keep the trust of its employees. With 100% turnover in certain areas and a common 25 -- 30% turnover rate in others, FAC has a very significant cost drain going on in the area of change management alone. Based on these factors the first and most significant recommendation is to appoint a senior level executive, potentially a C-level manager who can arbitrate the inherent conflicts that occur when implementing CRM systems and also navigate beyond the often complex problems of process re-engineering and process elimination if necessary (Power, 2009). A leader of this initiative at the C-level will also ensure it stays on track from a prioritization standpoint, not deviating into other areas of the organization as well. One of the most powerful aspects of having a C-level executive be the champion of these programs is the ability to create a greater level of urgency for fully accomplishing all Phase 5 deliverables including having complete production testing and validation of the warehouse done as well. Ultimately the C-level sponsor will be the internal trusted advisor for employees on this project and has the potential to completely re-order the adoption rate or acceptance rate while also significantly increasing the level of faith employees have in it as...


Today there is a wealth of data within the company, with multiple audiences being served by them as diverse as direct and indirect users. What needs to happen is that the lifecycles of each customer segment need to be more accurately and effectively understood, and analytics need to be used to better understand preferences, unmet needs, perceptions of FAC and the ongoing evaluation of substitutes. What is challenging for FAC right now is the breath of data available, yet only partially used frameworks for putting it into context. For a CRM system to deliver the total value it is capable of, it must have a full 360-degree view of the customer (Chan, 2005). This equally applies to data used internally in addition to the market-based and services-based information shared with customers (Fay, Zahay, 2005). By concentrating more on this aspect of the TCS, the opportunity exists to deliver a consistently higher level of performance to customers as well.

The final recommendation is to more closely align the many CRM systems and strategies to corporate objectives. Today the level of accomplishment is exceptional, yet there are many manually-based process workflows in place which introduce the potential of errors. Instead of concentrating on the tactical however, TAC needs to better align their CRM systems to the intended customer experience consequences they are attempting to create and deliver. Only then will TAC be able to attain the full value of these powerful systems and analytics that have the potential to redefine their business.


Bernoff, J., & Li, C. (2008). Harnessing the power of the oh-so-social web. MIT Sloan Management Review, 49(3), 36-42.

Chan, J.O. (2005). Toward a unified view of customer relationship management. Journal of American Academy of Business, Cambridge, 6(1), 32-38.

Cunningham, C., Il-Yeol Song, & Chen, P.P. (2006). Data warehouse design to support customer relationship management analyses. Journal of Database Management, 17(2), 62-84.

Dver, A. (2003). The future of CRM technology. Information Management, 13(7), 22-22.

Fay, C.P., & Zahay, D. (2003). Understanding why marketing does not use the corporate data warehouse for CRM applications. Journal of Database Marketing & Customer Strategy Management, 10(4), 315-326.

Fay, C.P., & Zahay, D. (2005). Why doesn't marketing use the corporate data warehouse? The role of trust and quality in adoption of data-warehousing technology for CRM applications. The Journal of Business & Industrial Marketing, 20(4), 237-244.

Hay, D. (2003). Analyze that?; ensuring data quality for successful CRM. Information Management, 13(11), 22-22.

McKim, B., & Hughes, A.M. (2001). How to measure customer relationship management success. Journal of Database Marketing & Customer Strategy Management, 8(3), 224-231.

Raisinghani, M.S. (2000). Adapting data modeling techniques for data warehouse design. The Journal of Computer Information Systems, 40(3), 73-77.

Tim O'Reilly. (2006, July). Web 2.0: Stuck on a Name or Hooked on Value? Dr. Dobb's Journal,…

Sources Used in Documents:


Bernoff, J., & Li, C. (2008). Harnessing the power of the oh-so-social web. MIT Sloan Management Review, 49(3), 36-42.

Chan, J.O. (2005). Toward a unified view of customer relationship management. Journal of American Academy of Business, Cambridge, 6(1), 32-38.

Cunningham, C., Il-Yeol Song, & Chen, P.P. (2006). Data warehouse design to support customer relationship management analyses. Journal of Database Management, 17(2), 62-84.

Dver, A. (2003). The future of CRM technology. Information Management, 13(7), 22-22.

Cite this Document:

"CRM Using Data Warehousing At" (2012, April 25) Retrieved September 21, 2021, from

"CRM Using Data Warehousing At" 25 April 2012. Web.21 September. 2021. <>

"CRM Using Data Warehousing At", 25 April 2012, Accessed.21 September. 2021,

Purpose of

The documents we provide are to be used as a sample, template, outline, guideline in helping you write your own paper, not to be used for academic credit. All users must abide by our "Student Honor Code" or you will be restricted access to our website.

Related Documents
Data Warehousing and Data Mining
Words: 2013 Length: 6 Pages Topic: Education - Computers Paper #: 80140915

Data Warehousing and Data Mining Executive Overview Analytics, Business Intelligence (BI) and the exponential increase of insight and decision making accuracy and quality in many enterprises today can be directly attributed to the successful implementation of Enterprise Data Warehouse (EDW) and data mining systems. The examples of how Continental Airlines (Watson, Wixom, Hoffer, 2006) and Toyota (Dyer, Nobeoka, 2000) continue to use advanced EDW and data mining systems and processes to streamline

Data Warehousing for an Airline
Words: 3749 Length: 10 Pages Topic: Business Paper #: 64471486

The data load for CRM systems is less significant than those of Accounting and Financial systems and applications. Those specific fields captured by customers are often compressed into measures of activity as well, and as a result the data load is less significant than in the areas of Accounting and Financial Systems and Reservation and Booking Systems. Even when customized reports are created based on CRM data; the data

Data Warehouse a Strategic Weapon of an Organization
Words: 10375 Length: 38 Pages Topic: Business Paper #: 99774450

Data Warehousing: A Strategic Weapon of an Organization. Within Chapter One, an introduction to the study will be provided. Initially, the overall aims of the research proposal will be discussed. This will be followed by a presentation of the overall objectives of the study will be delineated. After this, the significance of the research will be discussed, including a justification and rationale for the investigation. The aims of the study are to

Warehousing Book for an Airlines
Words: 2646 Length: 7 Pages Topic: Business Paper #: 79048130

The results of this effort needs to be shared electronically online to ensure everyone is kept informed about its progress. Memo: With the data warehouse project entering the requirements definition phase, it's important to start setting the foundation for users across the network of retail stores to begin having ownership of the new system. Getting them interested in the new data warehouse, and to take ownership of it will require getting

Data Mining Evaluating Data Mining
Words: 3527 Length: 10 Pages Topic: Education - Computers Paper #: 55885792

The use of databases as the system of record is a common step across all data mining definitions and is critically important in creating a standardized set of query commands and data models for use. To the extent a system of record in a data mining application is stable and scalable is the extent to which a data mining application will be able to deliver the critical relationship data,

Data Warehouse Has Been of
Words: 2010 Length: 6 Pages Topic: Education - Computers Paper #: 16569300

However, many, if not most data warehouses have yet to deal effectively with this very real problem. Additionally, in the near future new parallel database servers are likely to improve the power of data warehousing exponentially. Not only will these servers allow the user to access immense pools of data, but they will also allow them to do so in a fraction of the time (ICFAI, 2004). Finally, it is also very