WGU D601 VKN1 Task 3
Data Storytelling for Varied Audiences
Interactive Dashboard and Data Storytelling Reflection Paper
Program: Master of Science in Data Analytics
Assessment: VKN1 Task 3
Subject: Telecommunications Customer Churn Analysis
A. Interactive Data Dashboard
A1. Dashboard Alignment
The telecommunications customer churn dashboard focuses on identifying customer
characteristics, geographic patterns, and service-related factors associated with customer
attrition. Its primary purpose is to convert customer-level data into business insights that support
retention planning.
Two principal stakeholder groups guide the dashboard's design: the Senior Vice President for
Customer Experience and the Executive Vice President of Sales. Both executives need to
understand how customer demographics, geography, service pricing, and contractual
relationships relate to customer retention.
The dashboard addresses these information needs through two complementary views: KPIs &
Customer Distribution (U.S.) and Churn Demographics.
The geographic dashboard presents the overall churn rate, average monthly charges, customer
distribution by state, and geographic churn comparisons. These elements provide an executive-
level overview of the scale and geographic distribution of the problem.
The demographic dashboard examines monthly charges by area type and churn status, retention
by gender, customer tenure, and contract type. These visualizations allow stakeholders to
investigate relationships that are not immediately apparent from summary statistics.
The reported overall churn rate of 26.5% establishes the business context. The dashboard then
narrows the analysis to customer segments where retention interventions may have the greatest
impact.
, This layered structure accommodates different decision-making needs. Customer experience
leadership can examine which groups may benefit from improved service engagement, while
sales leadership can evaluate the potential implications of pricing and contract structure.
The dashboard therefore serves as more than a descriptive reporting tool. It provides a
framework for identifying retention priorities, investigating possible contributors to churn, and
developing measurable business responses.
A2. Decision-Making Support
The dashboard supports decision-making by transforming customer churn measurements into
comparisons that business leaders can interpret and act upon.
One particularly useful visualization compares average monthly charges for retained and churned
customers across rural, suburban, and urban markets.
The displayed results are:
Area Type Retained Customers Churned Customers Difference
Rural $163.21 $198.97 $35.76
Suburban $162.38 $201.13 $38.75
Urban $163.45 $197.85 $34.40
Across all three area types, customers who churned had higher average monthly charges than
customers who remained with the company.
The difference ranges from $34.40 to $38.75 per month, suggesting a consistent association
between higher monthly charges and customer attrition.
This evidence gives sales and customer experience leaders a reason to investigate affordability,
perceived service value, and the effectiveness of existing retention offers.
However, the visualizations establish an association rather than proving that higher pricing
directly caused customers to leave. Other factors, including service quality, contract type, tenure,
and competing offers, may influence the relationship.
A second important visualization examines customer churn by tenure.
The chart shows a substantial concentration of churned customers during the first year of the
customer relationship. Churned customers in this group also had higher average monthly charges
than retained customers.
The reported first-year averages are approximately $194.09 for churned customers and $150.19
for retained customers, a difference of $43.90.
Data Storytelling for Varied Audiences
Interactive Dashboard and Data Storytelling Reflection Paper
Program: Master of Science in Data Analytics
Assessment: VKN1 Task 3
Subject: Telecommunications Customer Churn Analysis
A. Interactive Data Dashboard
A1. Dashboard Alignment
The telecommunications customer churn dashboard focuses on identifying customer
characteristics, geographic patterns, and service-related factors associated with customer
attrition. Its primary purpose is to convert customer-level data into business insights that support
retention planning.
Two principal stakeholder groups guide the dashboard's design: the Senior Vice President for
Customer Experience and the Executive Vice President of Sales. Both executives need to
understand how customer demographics, geography, service pricing, and contractual
relationships relate to customer retention.
The dashboard addresses these information needs through two complementary views: KPIs &
Customer Distribution (U.S.) and Churn Demographics.
The geographic dashboard presents the overall churn rate, average monthly charges, customer
distribution by state, and geographic churn comparisons. These elements provide an executive-
level overview of the scale and geographic distribution of the problem.
The demographic dashboard examines monthly charges by area type and churn status, retention
by gender, customer tenure, and contract type. These visualizations allow stakeholders to
investigate relationships that are not immediately apparent from summary statistics.
The reported overall churn rate of 26.5% establishes the business context. The dashboard then
narrows the analysis to customer segments where retention interventions may have the greatest
impact.
, This layered structure accommodates different decision-making needs. Customer experience
leadership can examine which groups may benefit from improved service engagement, while
sales leadership can evaluate the potential implications of pricing and contract structure.
The dashboard therefore serves as more than a descriptive reporting tool. It provides a
framework for identifying retention priorities, investigating possible contributors to churn, and
developing measurable business responses.
A2. Decision-Making Support
The dashboard supports decision-making by transforming customer churn measurements into
comparisons that business leaders can interpret and act upon.
One particularly useful visualization compares average monthly charges for retained and churned
customers across rural, suburban, and urban markets.
The displayed results are:
Area Type Retained Customers Churned Customers Difference
Rural $163.21 $198.97 $35.76
Suburban $162.38 $201.13 $38.75
Urban $163.45 $197.85 $34.40
Across all three area types, customers who churned had higher average monthly charges than
customers who remained with the company.
The difference ranges from $34.40 to $38.75 per month, suggesting a consistent association
between higher monthly charges and customer attrition.
This evidence gives sales and customer experience leaders a reason to investigate affordability,
perceived service value, and the effectiveness of existing retention offers.
However, the visualizations establish an association rather than proving that higher pricing
directly caused customers to leave. Other factors, including service quality, contract type, tenure,
and competing offers, may influence the relationship.
A second important visualization examines customer churn by tenure.
The chart shows a substantial concentration of churned customers during the first year of the
customer relationship. Churned customers in this group also had higher average monthly charges
than retained customers.
The reported first-year averages are approximately $194.09 for churned customers and $150.19
for retained customers, a difference of $43.90.
