Pular para o conteúdo principal
Página inicialReportingCase Study: Analyzing Customer Churn in Excel

# Case Study: Analyzing Customer Churn in Excel

You will investigate a dataset from a fictitious company called Databel in Excel, and need to figure out why customers are churning.

Comece O Curso Gratuitamente
1 Hora4 Videos21 Exercicios
5.165 AprendizesDeclaração de Realização

## Crie sua conta gratuita

ou

Ao continuar, você aceita nossos Termos de Uso, nossa Política de Privacidade e que seus dados são armazenados nos EUA.
Treinar 2 ou mais pessoas?Experimente o DataCamp For Business

## Descrição do Curso

Are you ready to apply your Excel skills to a fictitious dataset?

## 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.
Para Empresas

### .css-1goj2uy{margin-right:8px;}Group.css-gnv7tt{font-size:20px;font-weight:700;white-space:nowrap;}.css-12nwtlk{box-sizing:border-box;margin:0;min-width:0;color:#05192D;font-size:16px;line-height:1.5;font-size:20px;font-weight:700;white-space:nowrap;}Treinar 2 ou mais pessoas?

Obtenha acesso à biblioteca completa do DataCamp, com relatórios, atribuições, projetos e muito mais centralizados
Experimente O DataCamp for BusinessPara uma solução sob medida , agende uma demonstração.

Ir para a trilha
1. 1

### Exploratory analysis

Grátis

In this first chapter, you’ll start by exploring your new dataset in Excel and gain an initial understanding of why customers are churning.

Reproduzir Capítulo Agora
Analyzing customer churn in Excel
50 xp
Analysis process
100 xp
Data preparation
100 xp
Understanding churn and it's applications
50 xp
Calculating churn
100 xp
Investigating churn reasons
100 xp
Digging deeper into churn categories
100 xp
2. 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. 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.

Para Empresas

### GroupTreinar 2 ou mais pessoas?

Obtenha acesso à biblioteca completa do DataCamp, com relatórios, atribuições, projetos e muito mais centralizados

### Nas seguintes faixas

#### Fundamentos do Excel

Ir para a trilha

Pre Requisitos

Introduction to Excel
Jess Ahmet

Content Developer at DataCamp

Veja Mais