Telecom Customer Churn Analysis

Tools Used: MYSQL, Figma, Power BI

Key questions or metrics I addressed during the analysis:

•Churn Status on various parameters. •Overview of Total Telecom Company. •Steps of analyzing data using MYSQL: •Loading the given csv files/tables in MYSQL. •Making extra column for Age Range to filter different age groups via SQL commands. •Finding numerical results for "Churn Status" on various parameters with respect to the data using SQL queries. •Now, after doing the required changes downloading files from MYSQL.

After loading the relevant tables in Power BI, we apply the following operations:

Application of DAX measures:

During the process of making dashboard, I applied several DAX measures like AVERAGE, SUM to come up with numerical insights which are insightful to the end user.

Theme and Color Palette:

•I went with the light theme for the dashboard and visualization is static and single-paged. •Colors chosen: White, black and green shades.

Visualization:

Here, I used Figma to create layout for static visualization page and Power BI for report formation.