ExcelR Jumbo PassExcelR Jumbo Pass Video   You May Have Heard About Offers, But Have You Heard Of ExcelR's JUMBO PASS? Well, Here's Your Chance To Avail The JUMBO PASS!! Watch The video


Course Description

About The Course

Customer analytics is the process of identifying the behavior of customers based on their transactions and interaction through various channels. Customer analytics involves developing customer segments based on their behavior similarity, building RFM (Recency, Frequency, Monetary) models, identifying the life time value of the customer. Insights which come out of the customer segments and models built will help in building the right services to various customer segments and personalized services to high profile customers. Customer analytics also include identifying the potential customers who might churn out which can help in taking proactive actions to retain the customer.

Some of the areas where customer analytics are extensively used are

Retail industry to understand customer purchasing behavior and how to use the purchasing pattern for cross and up sell

  • Financial industry to understand customer life time value, churn analysis etc. and provide personalized services
  • Telecom industry to understand the customer usage behavior and provide bundled packages and other incentives to increase the revenues and reduce customer churn

Additionally customer experience analytics includes identifying the behavior of the overall customer behavior and take insights in building the best products which caters to the needs of different customer segments.

Are you interested in providing solutions to increase the customer experience by understand the behavior of the customer based on the customer transaction data, are you passionate in building products by understanding customer preferences, is your overall objective is to increase the revenue and retain the valuable customers then customer analytics is the right area which you need to focus on.

We provide customer analytics training covering customer segmentation, web analytics, and customer churn management etc. using real time examples with the support of widely used industry tool R.

Things You Will Learn

  • MeXL (Marketing Engineering for Excel)
  • Voice of the Customer / Customer Co-Creation
  • Data for Segmentation
  • Managing “Voice of the Customer”Data
  • The Cluster Analysis + Discriminant Analysis Approach
  • Advanced Issues in Segmentation
  • Rationale for Segment Targeting
  • The GE/McKinsey Portfolio Matrix
  • Segmentation using MeXL
  • Analytics for Perceptual Mapping and Product Positioning
  • Product Positioning
  • Relevance of Mapping for Product Positioning
  • Preference Mapping
  • Incorporating Preferences in Perceptual Mapping
  • Advanced Issues in Preference Mapping
  • Perceptual Mapping using MeXL
  • Analytics for Product/Service Design
  • The Relevance of Trade-off Approaches
  • Conjoint Analysis
  • Approaches to Conjoint Analysis
  • Conjoint Analysis using MeXL
  • Complete Conjoint Analysis
  • Interpreting Conjoint Results
  • Optimizing Design using Conjoint Results
  • Analytics for Tracking Customer Growth
  • Application of Bass Model using MeXL
  • Framework to choose among different digital media options
  • Emerging display advertising ecosystem (e.g. ad exchanges bidding) and Retargeting and real time —-bidding) and Retargeting
  • Decision Analytics for real time and targeted display advertising
  • Using Experiments to Optimize Value of Digital Media
  • An introduction to experiments. Why do we need them?
  • Using Logistic Regressions
  • Experiment Design for E-retailing
  • Challenges in selling focal products and their accessories
  • Using multivariate regressions to measure effectiveness of product videos for e-retail
  • Analytics of Multivariate Experiments
  • Testing digital media e.g. websites
  • Experiments with large number of factors
  • Analytics of User Generated Content
  • Text and sentiment analytics
  • Designing effective rating mechanisms
  • Mining positive and negative opinions and assigning their impact for improving business outcomes
  • New Digital Business Models
  • Open innovation, emerging principles and key learnings in crowdfunding
  • Fundamentals of search engine marketing, web analytics,and digital advertising
  • Application of multivariate regression on sponsored search advertising case
  • Digital marketing attribution
  • Fundamentals of social media (Paid, earned and owned media)
  • How are businesses adopting social media: Discussion of Ford Fiesta case
  • Social listening and text analytics
  • Painting the mobile landscape
  • Discussion of mobile analytics
  • Application of multivariate regression on mobile services adoption case

Contact Our Team of Experts

Why ExcelR?


  • The all new and exclusive JUMBO PASS is the latest initiative taken by ExcelR to offer you access to attend unlimited batches over the course of 365 days. The JUMBO PASS is course specific. You will be able to attend unlimited number of classes for the course of your choice.
  • Data Analytics, Business Analytics & Data Science are the same with just 3 different names. The name of the role of people working in this profession is called as Data Scientist
  • Data analytics is a profession which caught the attention of the world only since 2 years. Because of this very reason most companies are struggling to close the demand-supply gap. Hence, people who are trained and have decent exposure to the data analytics techniques are recruited immediately.
  • There are a lot of job opportunities in various job portals for freshers. The key thing employer would be keen to know is whether you have the conceptual knowledge or not. The projects provided by ExcelR in various concepts will only reinforce your learning to make you market ready for the jobs.
  • We understand that the human brain can grasp only so much. Hence, we record all the sessions and provide access to the e-learning to the trainees for the rest of their life.
  • Yes and No. Yes in the sense programming skills would be required & No in the sense one need not have extremely strong programming skills. However, we at ExcelR ensure that you get sufficient exposure to the statistical programming tool called ‘R’. We start right from the basics assuming you do not have any exposure towards programming.
  • R has approximately 50% market share & it is open source (free of cost). Hence, R is very lucrative in the analytics space. Almost all the jobs are asking for experience & exposure in R. Demand for other statistical tools is decreasing steadily & hence it is recommended to be futuristic and invest time in learning R.
  • Salaries range varies based on experience, industry, domain, geography & various other parameters. However, as a general thumb rule, we can apply the following formula:
  •  Salary = No. of years of experience * 3 Lakhs per annum (India – INR)
  •  Salary = No. of years of experience * $1200 to $1500 per annum (Overseas – USD)
  • Instructor-led online training is an interactive mode of training where participants and trainer will log in at the same time and live sessions will be done virtually. These sessions will provide scope for active interaction between you and the trainer.
  • ExcelR offers a blended model of learning. In this model participants, can attend classroom, instructor-led live online and e-learning (recorded sessions) with a single enrolment. A combination of these 3 will produce a synergistic impact on the learning. One can attend multiple Instructor-led live online sessions for one year from different trainers at no additional cost with the all new and exclusive JUMBO PASS.
  • The training is a live instructor-led interactive session done at a specific time where participants and trainer will log in at the same time. The same session will be also recorded and access will be provided to revise, recap or watch a missed session.
  • You can reach out to us by visiting our website and interact with our live chat support team. Our customer service representatives will assist you with all your queries. You can also send us an email at [email protected] with your query and our Subject Matter Experts / Sales Team will clarify your queries or call us on 1800-212-2120 (Toll-Free number – India), 608-218-3798 (USA), 800 800 9706 (India), 203-514-6638 (United Kingdom), 128-520-3240 (Australia).
  • Not a problem even if you miss a live Business Analytics session for some reason. Every session will be recorded and access will be given to all the videos on ExcelR’s state-of-the-art Learning Management System (LMS). You can watch the recorded Business Analytics sessions at your own pace and convenience.
  • Yes, after successfully completing the course you will be awarded a course completion certificate from ExcelR.
  • The different payment methods accepted by us are
    • Cash
    • Net Banking
    • Cheque
    • Debit Card
    • Credit Card
    • PayPal
    • Visa
    • Mastercard
    • American Express
    • Discover

Global Presence

ExcelR is a training and consulting firm with its global headquarters in Houston, Texas, USA. Alongside to catering to the tailored needs of students, professionals, corporates and educational institutions across multiple locations, ExcelR opened its offices in multiple strategic locations such as Australia, Malaysia for the ASEAN market, Canada, UK, Romania taking into account the Eastern Europe and South Africa. In addition to these offices, ExcelR believes in building and nurturing future entrepreneurs through its Franchise verticals and hence has awarded in excess of 30 franchises across the globe. This ensures that our quality education and related services reach out to all corners of the world. Furthermore, this resonates with our global strategy of catering to the needs of bridging the gap between the industry and academia globally.

ExcelR's Global Presence


Call Us whatsapp