abq-sanusi/SwifTel-Communication-Nigeria

# SwifTel Telecom Analytics Dashboard ## Project Overview This project is an end-to-end business intelligence solution developed in Power BI for a telecommunications company, Swiftel. The dashboard transforms raw operational data into actionable insights that support strategic decision-making across subscriber growth, revenue performance, customer complaints, network usage, and churn. The project demonstrates data modeling, DAX calculations, dashboard design, and business storytelling using interactive visualizations. ## Business Problem Telecommunication companies generate large volumes of operational data from customer subscriptions, recharge transactions, call records, internet usage, and support interactions. Without an analytical reporting system, it becomes difficult to identify revenue trends, monitor customer behavior, detect churn, and evaluate service quality. This dashboard was built to provide decision-makers with a centralized view of key business metrics for monitoring performance and identifying opportunities for improvement. ## Objectives The dashboard was designed to: - Monitor subscriber growth and customer churn. - Analyze revenue performance across different periods. - Track recharge and customer activity. - Monitor customer complaints and resolution trends. - Evaluate network and data usage patterns. - Present KPIs through an interactive and easy-to-understand dashboard. ## Tools Used - Microsoft Power BI - Power Query - DAX (Data Analysis Expressions) - Data Modeling - Microsoft Excel ## Tools Used - Microsoft Power BI - Power Query - DAX (Data Analysis Expressions) - Data Modeling - Microsoft Excel ## Key KPIs - Total Revenue - Total Subscribers - Active Subscribers - Churn Rate - Total Recharge Value - Average Revenue Per User (ARPU) - Total Complaints - Complaint Resolution Rate - Call Activity - Data Usage - Network Performance Trends ## Business Insights The dashboard enables stakeholders to: - Identify periods of high and lo …