课程
Case Study: Analyzing Customer Churn in Excel
基础技能水平
更新时间 2026年4月ExcelReporting1 小时4 视频21 练习1,750 经验值27,474成就声明
深受数千家公司学习者的喜爱
培训2人或更多？
试用DataCamp for Business课程描述
Apply your Excel Skills with a Case Study
For subscription-based businesses, reducing customer churn is a top priority. In this Excel case study, you'll investigate a dataset from an example telecom company, Databel, and analyze their churn rates.Understand why customers churn
Analyzing churn doesn’t just mean knowing the churn rate: it’s also about figuring out why customers are churning at the rate they are and how to reduce churn. You'll answer these questions by creating calculated columns and fields, building PivotTables, and creating an eye-catching dashboard.先决条件
Introduction to Excel1
Exploratory analysis
In this first chapter, you’ll start by exploring your new dataset in Excel and gain an initial understanding of why customers are churning.
2
Investigating churn patterns
You’ll continue leveraging the Excel knowledge you gained from the prerequisite courses to investigate further why customers are leaving Databel.
3
Creating a cohesive story
In the last chapter, you’ll create a dashboard-style sheet and arrange your visuals to present your results to stakeholders in a cohesive story.
Case Study: Analyzing Customer Churn in Excel
课程完成 通过 DataCamp for Mobile 提升您的数据技能
随时随地通过我们的移动课程和每日 5 分钟编程挑战提升技能。