alex166-cmd/malawi_telecom_analytics

A data analytics and visualization project in DataBricks that provides insights into Malawi's telecommunications sector through interactive dashboards and data-driven reporting. The project analyzes key telecom performance indicators such as subscriber growth, revenue trends, customer segmentation. ## Dashboard Creation Steps 1. **Data Source Identification** - Used the `dbacademy.default.malawi_telecom_data` table containing monthly telecom KPIs for Malawi operators. - Verified data freshness and completeness by checking the latest available month and ensuring all operators are represented. 2. **Data Exploration** - Explored columns: `Month`, `Operator`, `Subscribers`, `ARPU MWK`, `Churn Rate Pct`, `Revenue MWK Millions`, `NPS Score`, `FCR Pct`. - Performed summary statistics (mean, median, min, max) for each KPI to understand data distribution. - Identified trends and outliers in subscriber counts, revenue, and customer satisfaction metrics using initial visualizations and descriptive statistics. - Examined correlations between KPIs, such as ARPU vs. Churn Rate and NPS vs. FCR. 3. **Data Cleaning & Preparation** - Checked for missing values and handled them appropriately (e.g., imputed with median for continuous variables, flagged missing categorical data). - Converted data types (e.g., ensured `Month` is datetime, numeric columns are correct types). - Aggregated data by operator and month for time series analysis, ensuring consistent granularity. - Created calculated fields such as monthly growth rates and rolling averages for smoother trend analysis. 4. **Visualization Development** - Created line charts for subscriber growth and revenue trends over time, segmented by operator. - Built bar charts for ARPU and churn rate comparisons across operators and months. - Added KPI widgets for NPS and FCR to highlight customer experience, using color coding for performance thresholds. - Incorporated scatter plots to visualize relationships between ARPU, churn, and satisfaction metrics. - Enabled drill-down capabilities for detailed operator-level analysis. 5. **Dashboard Assembly** - Combined visualizations into a single dashboard for holistic analysis, arranging charts for logical flow (e.g., growth, revenue, churn, satisfaction). - Added filters for `Operator …