Tabellab

Customer analytics courses: segments, satisfaction and loyalty

Knowing who your customers are and how they feel is the base of every retention and growth plan.

Customer Analytics & Satisfaction courses (14)

$9.90Intermediate

Customer Churn & Survival Analysis: Hazard Rates, Kaplan-Meier & Retention Curves

Tenure and censoring from raw dates, hazard rates, survival curves and the median lifetime, Kaplan-Meier with a step chart, Basic vs Plus with a log-rank test, LTV from the curve, churn drivers and the ROI of a save offer, then data checks, actuarial life tables, pooled cohort triangles, late entry, competing risks, annual renewals, exponential and Weibull fits, channel-adjusted rate ratios, churn forecasts, score calibration and a final dashboard: 20 graded labs on one fictional subscription box.

20 lessons · 20 labs

$9.90Intermediate

Customer Experience Metrics: NPS, CSAT, CES & Retention Impact

Measure customer experience like a CX analyst: NPS from raw answers, segments and margins of error, CSAT top-2-box, effort scores, coded comments and Pareto, driver analysis and the link to churn, then journey touchpoints, detractor callbacks, complaint rates and backlog ageing, keyword tagging, onboarding retention, wait-time bands, save-desk economics, Bayesian star ratings, NPS targets, customer lifetime value and a CX business case – 20 labs, every cell checked instantly.

20 lessons · 20 labs

$9.90Intermediate

Customer Analytics: Lifetime Value, Cohorts & Churn

Calculate AOV, purchase frequency and CLV with margin, retention and discounting, build cohort tables from raw orders, chart retention curves, measure churn and survival, set CAC ceilings by segment and predict repeat purchases, then go further: monthly subscription CLV, retention by tenure and spend growth, hidden segments, contribution after returns and service, promo cohorts, sensitivity grids, lever comparisons, channel CAC, referral value, customer equity, model plausibility checks and a final dashboard: 20 hands-on labs, every cell checked as you go.

20 lessons · 20 labs

$9.90Intermediate

Customer Segmentation: RFM Scoring, Personas & k-Means by Hand

RFM from a raw order log, quintile scores with PERCENTILE and PERCENTRANK, named segments, segment value charts, z-scores, a k-means iteration by hand, the elbow method and campaign economics, then deeper: weighted scores, fixed business-rule bins, net revenue after returns, outlier capping and log transforms, an R × F heatmap, segment migration, k-means convergence, silhouette scores, category-mix personas, holdout lift, email-vs-print channel choice and a quarterly segment dashboard: 20 graded labs on one fictional homeware shop.

20 lessons · 20 labs

$9.90Intermediate

Customer Success by the Numbers: Health Scores, Time-to-Value, Renewal Forecasts, Expansion & Account Coverage

Manage a book of accounts with numbers: health scores and their trends, onboarding time-to-value, renewal forecasts and forecast accuracy, notice deadlines, price increases at renewal, expansion, seat true-ups, success-plan progress, workload and cost to serve, retention scenarios and a quarterly CS dashboard – 20 hands-on labs, every cell checked instantly.

20 lessons · 20 labs

$9.90Beginner

Excel for Customer Success Managers: Health Scores, Renewals, Churn & NRR

20 hands-on labs for CSMs at a small B2B software company: account list and ARR, health scores and their trend, renewal calendar and price uplifts, seat true-ups, multi-year deals, logo and revenue churn, churn reasons, NRR, adoption and feature breadth, support tickets and SLA backlog, NPS, expansion pipeline, at-risk accounts, a QBR one-pager, a CS dashboard and a renewal readiness board.

20 lessons · 20 labs

$9.90Intermediate

Loyalty Program Economics: Points, Breakage & Member Value

Price a points catalogue, value the points liability and breakage, cost the program per member, measure member uplift without selection bias, design tiers, chart a redemption curve, calculate ROI and test a new earn rate, then go further: blended cost per point, pricing rewards to a target cost rate, liability sensitivity, quarterly reconciliation, stranded points, expiry policy, tier migration and tier cost, double-points weeks, partner billing, a coffee stamp card and a store dashboard: 20 hands-on labs, every cell checked as you go.

20 lessons · 20 labs

$9.90Beginner

Customer Onboarding Email Sequences: Time to First Value, Step Completion, Activation, Drop-Off Diagnosis, Cohort Retention & Tickets Avoided

Turn a welcome email into a measurable onboarding programme. You will calculate days to first value for a software and service company, build the step funnel and email completion rates, define activation milestones, time every nudge, diagnose where accounts drop off and read weekly cohort retention, then count support tickets avoided, compare signup sources, clean a raw export, test nudge emails against a control group and check whether the lift is real. You will also write priority trigger rules, watch unsubscribes and complaints, link activation to retention, value and pay back the programme, price tickets by topic, build a what-if grid and finish with a scorecard and a forecast, in 20 hands-on labs, fictional data, every cell checked as you go.

20 lessons · 20 labs

$9.90Beginner

Customer Personas & Journey Mapping: Survey Segments, Persona Size & Value, Journey Drop-Off, Touchpoints & Channel Preference

Turn survey answers and shop data into personas that guide real decisions. You count respondents per need, assign personas with rules, project them onto the customer base and compare their value with an index. Then you map the journey: step conversion, drop-off and the biggest leak, a touchpoint inventory with an importance and satisfaction gap, and the channel each persona prefers. The second half deepens the evidence: you clean a survey of duplicates and speeders, build a needs heat map, calculate margins of error and the sample size you need, weight a lopsided sample, value personas over their lifetime, compare journey conversion by persona, cost customer acquisition, measure time to purchase, split a budget, track trends and persona migration, run a what-if grid and finish with a priority scorecard. Segments always use needs and behaviour, never protected characteristics. 20 hands-on labs, fictional Brambleway Outdoor data, every cell checked as you go.

20 lessons · 20 labs

$9.90Intermediate

Social Customer Care: First-Response & Resolution Times, Volume & Staffing, Deflection, Sentiment, Escalation & Cost per Contact

Run social customer care by the numbers. You will turn timestamps into first-response and resolution times, test them against service levels per channel, read the volume by hour and convert it into agents, occupancy and idle time, measure how much help content deflects and what that saves, track sentiment before and after a reply and relate it to reply speed, count escalations and what they cost, work out the cost per contact and per resolution, check first-contact resolution and reopens, judge agents fairly with weighted quality scores, forecast weekly volume, test whether a new reply style really works, compare scenarios in a what-if grid and finish with a monthly care scorecard, in 20 hands-on labs with fictional data and every cell checked as you go.

20 lessons · 20 labs

$9.90Intermediate

Polling & Survey Sampling: Margin of Error, Weighting & Poll Averages

Margins of error with NORM.S.INV, sample sizes, the finite population correction, stratified allocation, post-stratification weights, Kish's design effect, weighted poll averages and the margin of a lead, then changes between polls, undecided voters, likely-voter models, response rates, Wilson intervals, systematic and PPS samples, quota tracking, mean scores with t, house effects, panel turnover and a poll release dashboard: 20 graded labs on one fictional city referendum.

20 lessons · 20 labs

$9.90Intermediate

Survey & Customer Feedback Analysis in Excel

Response rates, Likert scales, NPS, cross-tabs, weighting, margins of error, significance tests, data cleaning, multi-select, grids, effort scores, reliability, tracking and Pareto: 20 hands-on labs on one customer survey, every cell checked instantly.

20 lessons · 20 labs

$9.90Intermediate

Prioritisation Surveys: Ranking Questions, Best–Worst Scaling, TURF Reach & Kano Categories

Find out what customers want most: ranking scores, top-3 and head-to-head results, best–worst counts, ratio scores and standard errors, design checks, TURF reach including greedy, weighted and sensitivity runs, Kano categories and quadrants, and a final prioritisation dashboard – 20 hands-on labs, with every cell checked as you go.

20 lessons · 20 labs

$9.90Intermediate

Survey Weighting: Post-Stratification, Raking (IPF) & Design Effects

Compare sample and population margins, build base weights from selection probabilities, adjust for nonresponse, post-stratify, rake (IPF) to two and three margins and check convergence, collapse sparse cells, trim weights in rounds, diagnose the weight spread, compute weighted estimates, cross-tabs, medians and jackknife standard errors, measure Kish's design effect and margins of error, compare schemes against a benchmark and finish with a weighting dashboard: 20 graded labs on one fictional transit survey. Synthetic data for practice.

20 lessons · 20 labs

Knowing who your customers are and how they feel is the base of every retention and growth plan. These courses teach segmentation with RFM scoring, customer experience measures such as NPS and CSAT, health scores and renewals for customer success teams, loyalty programme economics, personas and journey maps, and the survey methods that make feedback reliable. You work with spreadsheets that mirror real customer data, so the techniques are ready for your own.

This topic hub gathers 14 Customer Analytics & Satisfaction courses from Data & Analytics, Marketing, Business: 3 beginner, 11 intermediate. Most courses have about 20 hands-on labs, a final exam and a certificate, and the first lesson of every course is free. Searches this hub is built for: rfm analysis excel; nps calculation; csat score formula; customer health score excel.

Frequently asked questions

Which Customer Analytics & Satisfaction course should I start with?

Start with “Customer Analytics”. It is the most central course in this topic at intermediate level. Then move on to the more specialised courses in the list above.

How much do the Customer Analytics & Satisfaction courses cost?

Every course costs a one-time $9.90, with no subscription, and the first lesson of each course is free so you can try it before buying. Each course ends with a final exam and a certificate.

How are the Customer Analytics & Satisfaction courses taught?

Each course is a series of hands-on labs in a built-in spreadsheet that checks your formulas as you type, with short explanations alongside. You need only a web browser; nothing to install. Examples use fictional data and are for learning, not professional advice.

Open your first lab in under a minute

Pick a course, pay once and start right away. Your progress is saved in your account.

Browse the courses