Customer Insights and Churn Analysis Dashboard

Overview

This project utilizes Power BI to create an interactive dashboard for analyzing customer demographics and churn factors. The data-driven insights from this dashboard help businesses enhance customer retention strategies.

Objectives

• Analyze customer demographics, service usage, and contract preferences.
• Identify key factors contributing to customer churn.
• Provide actionable insights through visualized KPIs and trends.

Key Features

1. KPIs Tracked:

   • Total Customers
   • Churn Rate
   • Average Tenure
   • Revenue from Monthly Charges
   • Count of Customers by Gender and Senior Citizenship

2. Insights Delivered:

   • Customer distribution by contract type and payment method.
   • Service adoption trends (e.g., Internet service, streaming services).
   • Churn analysis by demographics and service usage.

3. Dashboard Elements:

   • Filters Panel: Allow filtering by contract type, tenure, gender, and senior citizenship.
   • Visualizations: Include bar charts, pie charts, and KPI cards for clear insights.
   • Interactive Features: Enable dynamic exploration of customer data.

Dataset

The project uses a customer churn dataset containing the following fields:

• Customer Demographics: Gender, Senior Citizen status, Dependents.
• Service Details: Internet, Phone, Streaming services.
• Contract Details: Contract type, Payment method, Monthly charges.
• Churn Information: Whether the customer has churned or not.

Steps to Build the Dashboard

1. Understand the Data:

   • Explore the dataset to identify relationships and patterns.

2. Data Cleaning and Transformation:

   • Use Power Query in Power BI to clean and prepare the data.
   • Standardize field names and formats for consistency.

3. Data Modeling:

   • Create relationships between key fields to enable effective filtering and aggregation.

4. DAX Calculations:

   • Define measures for churn rate, revenue, and other KPIs.

5. Create Visualizations:

   • Use pie charts, bar charts, and slicers to display data trends.
   • Design a user-friendly layout to highlight critical insights.

6. Publish and Share:

   • Publish the report to Power BI Service and configure sharing settings.

Key Insights

• Identify customer demographics with the highest churn rates.
• Determine service features driving customer retention.
• Understand revenue contributions by contract and service type.

Tools and Technologies

• Power BI Desktop: For data transformation, modeling, and visualization.
• DAX: For creating KPIs and calculated columns.
• Power Query: For cleaning and shaping data.

How to Use

1. Clone this repository.
2. Open the .pbix file in Power BI Desktop.
3. Explore the dashboard to analyze customer trends and churn factors.
4. Modify or extend the visualizations based on specific business needs.

License

This project is licensed under the MIT License.