Excel at Customer Relationship Management
2.2 (5 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
22 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel at Customer Relationship Management to your Wishlist.

Add to Wishlist

Excel at Customer Relationship Management

Achieve success in CRM by understanding the fundamental aspects of CRM and then learn how to apply it effectively.
2.2 (5 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
22 students enrolled
Created by Willie Chan
Last updated 2/2016
Current price: $10 Original price: $25 Discount: 60% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 2 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • define CRM and the different perspectives of CRM
  • differentiate the characteristics of CRM
  • understand the elements of CRM
  • define what influences the success of CRM
  • examine the dynamics of different relationships with customers and suppliers
  • How to transform data into customer knowledge (developing the desired customer profile)
  • Understand the role of segmentation for the benefit of strategic marketing
  • be equipped with a greater understanding of data management and analytics, as well as building customer knowledge, and relationship policies
  • How to evaluate a retention analysis and a cross-sell analysis
  • How to increase the value of the customer database
  • examine the key elements and components of a CRM system, and its relationship with a Campaign Management System as well as Content Management System
View Curriculum
  • No prior knowledge is necessary.
  • Try to make it an effort to continue to the end of the course in order to get the best out of the course.

Excel at CRM is specially designed to provide students with both the theoretical aspects of CRM as well as the practical application of CRM. By going through this course, the student will develop confidence in using CRM tools and techniques to increase customer intimacy and ultimately generate more customer revenue through increased sales.

Excel at CRM uses a good blend of videos, presentations as well as quizzes, and covers a wide breadth and depth with over thirty curriculum items and spanning more than 120 minutes in total.

Who is the target audience?
  • Excel at Customer Relationship Management is meant for students and professionals who want to better understand the concepts and tenets of CRM and learn how to apply its principles at the workplace. If you have interest in performing in CRM and want to learn more about CRM systems, this is the course for you.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
11 Lectures
Introduction to CRM
2 Lectures 27:23
In this first lecture, I will provide you with a broad understanding of what CRM is all about. We will investigate why CRM has evolved together with the advent of IT systems. We will then consider the various elements of CRM as well as the various schools of thought towards CRM.
  • What is CRM?
  • Why CRM?
  • Elements of CRM
  • Relationships with Customers
  • Various Schools of Thought towards CRM
What is CRM and the elements of CRM?

In this second module, you will understand why a good CRM strategy must relate to an organisation's business strategy. You will uncover the three value disciplines that companies use to gain a competitive advantage and how CRM is embedded in these disciplines. You will also learn how to develop the CRM strategy as part of the overall business strategy of an organisation.

  • Business Strategy and CRM Strategy
  • Three Value Disciplines
  • Operational Excellence
  • Product Leadership
  • Customer Intimacy
  • Developing the CRM Strategy
  • CRM as part of the overall Strategy
Business Strategy and its relationship with CRM Strategy

Quiz to Section 1: Introduction to CRM

Quiz #1
8 questions
CRM Marketing Fundamentals
2 Lectures 26:32

In this third session of Excel at CRM, you will start by developing a better understanding of Customer Knowledge, which is the key foundation of CRM. You will assess the quality of data and how it contributes to the success of a good CRM strategy. We will then dive into CRM management and the issues related to it. You will form a better understanding on the Communication Continuum, and we will close this session by learning how to better maximise performance via the various channels of engagement.

  • Customer Knowledge
  • What is Data Quality
  • Quality Customer Database
  • Issues with Poor Data Quality
  • Organisation of Data Management
  • Communication
  • The Communication Continuum
  • How to Maximise Performance via Multichannels
Customer Knowledge and Data Quality

For this session on Customer Privacy, you will realise the importance of personal data as well as the personal data protection act. You will learn how to harness customisation to reach out to a large set of customers. You will develop a better understanding of the various types of pricing policies and their advantages and disadvantages. Lastly, you will dive into relationship policies and examine loyalty programmes.

  • Personal Data
  • Customisation
  • 4 Approaches towards Customisation
  • Individual Pricing Policy via Ecommerce
  • Precision Pricing and Risks
  • Relationship Policy
  • Considerations
  • By Segment
  • Loyalty Programmes
Customer Privacy & Customization

Quiz for section 2: CRM Marketing Fundamentals

Quiz #2
6 questions
CRM Analytical Fundamentals
2 Lectures 20:55

In this session #5 on CRM Analytical Fundamentals, you will examine the data analysis aspects of CRM. You will gain better clarity on what analytical CRM is all about, and why there is a need to perform CRM analyses. The CRM database is used by various stakeholders, hence you will need to know how to ensure and preserve data quality. Last but not least, you will appreciate the various aspects of customer profiling, and here we will deep dive into the various aspects of profiling.

  • What is analytical CRM?
  • CRM selection analyses
  • Preservation of quality
  • Customer profiling including Segment, Customer Values, Product, Satisfaction

Analytical CRM and Selection Analyses

For the session on Data Mining, you will learn about the important of data analysis and what defines a successful data analysis You will consider the problem formulation as the start of the analysis, and leading this to preparation as well as visualisation. You will understand what data mining is, and how this contributes to the overall success of CRM. You will then consider the approaches of segmentation, together with retention as tools to help you make better sense of the customer data sets. Last but not least, you will learn how to define the lifetime value of a customer.

  • Data analysis
  • Successful data analysis
  • Problem formulation
  • Preparations and Process
  • Statistical Techniques
  • Visualisation
  • Data-mining and its contribution to CRM
  • Segmentation
  • Segmentation Criteria
  • Retention
  • Cross Selling
  • Deep Selling
  • Lifetime Value and its calculation
Preview 08:53

Quiz #3 covers the topics centered around CRM Analytical Fundamentals.

Quiz #3
5 questions
CRM Operations
2 Lectures 14:00

For this module on CRM operations, you will fuse what you have learned in the previous modules of marketing fundamentals and analytical fundamentals to the actual operations of CRM. Here, you will examine the call centre and understand the elements of call centre operations. You will consider the technicalities and how they are influenced by the advent of technology. Lastly, you will recall the importance of quality and how this resurfaces in CRM operations.

  • Operational CRM
  • The Call Centre
  • Call Centre Operations
  • Technicalities
  • Advent of Technology
  • Call Centre Elements
  • Quality of Contacts
  • Managing Emails
The Call Centre and the Quality of Contacts

The proliferation of the Internet has affected CRM strategy as well as CRM operations. Hence, in this session, you will focus your attention on Internet CRM marketing, and how you are able to better reach out to your customer base via online traffic building, cybermediaries as well as online marketing tools. Notwithstanding, you will also consider other offline avenues and channels such as direct mail. We will end this session with the Stages of Reading, a very important element of customer engagement.

  • Internet marketing
  • Online traffic building
  • Cybermediaries
  • Online marketing tools
  • Online traffic building
  • Other offline avenues
  • Direct mail
  • Stages of reading
CRM via the Internet

Quiz #4 covers the topics centered around CRM operations.

Quiz #4
6 questions
CRM Systems
2 Lectures 20:12

For this module on CRM Systems, you will have a better perspective on why you may want to leverage CRM systems to better engage your customer base. You will understand both the primary and secondary roles of CRM systems, as well as how such systems interface with the front office, the middle ware as well as the back office.

  • Why CRM systems?
  • Primary roles
  • Secondary roles
  • Front office
  • Middle ware
  • Back office
The various roles of CRM Systems

CRM #10: CMS vs CMS would be a large module as we would be covering extensively on both the campaign management system as well as the content management system. You will not only learn about both systems in detail, but learn how to develop a CRM vision to limit the failure of a CRM system.

  • Campaign Management System
  • Functionalities
  • Opportunity Identification
  • Relationship Planning
  • Contact Opportunities
  • Campaign Management
  • Customer Interaction
  • Measuring and Evaluating
  • Types of Campaign
  • Considerations in Selecting a CMS
  • Content Management System
  • Differences between a CRM/CMS and a CMS
  • Implementation
  • Suppliers
  • Reasons for Failure of CRM Systems
  • The CRM Vision
  • The CRM Project Management
  • Summary
Preview 13:46

Quiz #5 covers the topics centered around CRM systems.

Quiz #5
3 questions
CRM: What lies ahead?
1 Lecture 11:59

The last module of Excel at CRM will allow you to take stock of what you have learned from the past sessions. You will be able to see how CRM will continue to evolve, and what are the factors that will cause this evolution. Finally, you will also be able to grasp some of the predictions on the future of CRM.

  • Objectives
  • Technological Progress
  • Consumer Change
  • Restive Customers
  • Staff Turnover
  • New Predictions
  • Mobility
  • Convergence
  • Social Media Monitoring
  • Privacy and Permissions
  • Workflows
The Future of CRM
About the Instructor
Willie Chan
2.2 Average rating
5 Reviews
22 Students
1 Course
Lecturer in the areas of Management Science

I am currently lecturing at undergraduate level at a university, covering the four modules of Customer Relationship Management, Project Management, Operations Management as well as Risk Management.

I develop the syllabus and course content for the university, aligning closely to Bloom's taxonomy, leverage the best pedagogical practices. I am certain that my sessions will be enriching, interesting and relatable.