Question 11

Customer churn, also known as customer turnover, occurs when customers cease using

the services provided by a company. The data set "Churn_ECA.xlsx" contains

information about the telephone company's customers, including demographics,

account details, subscribed services, and a binary indicator denoted as "Churn", which

indicates whether a customer has left the service within the last month. The

accompanying "Glossary" sheet provides descriptions of the variables used in the

dataset.

Question la

Identify one (1) business question that can be addressed by analysing the data.

Elaborate on the pertinent data fields and how they can provide insights to address the

question. Construct an influence chart relevant to the issue. (Max word count: 150

words)/nQuestion 1b

Prepare a tabular summary of the dataset, indicating the data type, key attributes,

summary measures, and any relevant data issues, if present. (Max word count: 150

words)

Question 1c

Use visualization techniques to design a comprehensive dashboard comprising a

minimum of three (3) professional graphical charts that convey valuable insights from

the dataset. Attach a screenshot of each chart and the complete dashboard. Describe the

process of chart and dashboard creation and how the dashboard effectively generates

and communicates insights extracted from the data. (Maximum 250 words)