
Ultimate access to all questions.
In your role, you need to implement diagnostic analytics to understand the reasons behind customer churn in a telecom company. The dataset includes 'CustomerID', 'Age', 'Gender', 'ServiceType', 'MonthlyCharges', and 'Churn'. Describe how you would use SQL queries and data visualization tools in Microsoft Fabric to identify key factors contributing to churn. Include the types of analyses you would perform and the visualizations that would best represent these findings.
A
Use SQL to group data by ServiceType and Gender, then use pie charts for visualizations.
B
Aggregate data by MonthlyCharges and Age, then use bar charts and line charts for visualizations.
C
Filter data by Churn and analyze correlations with other variables using heat maps.
D
Sort data by CustomerID and use scatter plots for visualizations.