The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
Telecommunications Customer Churn Analysis & BI Dashboard
Contributed to the development of an interactive Business Intelligence solution for analyzing customer churn in the telecommunications industry.
The project covered 8,000 customer records and focused on understanding customer attrition, satisfaction, and key business performance indicators.
My Contributions:
Created DAX measures for business KPIs.
Designed the dashboard Landing Page.
Designed Page 1 and Page 3.
Selected and configured visualizations to communicate analytical findings effectively.
Key Analysis Areas:
Customer Churn Rate
Customer Satisfaction (CSAT)
Customer Segmentation
Churn Trends and Patterns
Business KPI Monitoring
Key Findings:
Total churned customers: 2,145.
Overall churn rate: 26.81%.
Customer satisfaction score: 50.43%.
Tools & Technologies:
Power BI, DAX, Data Visualization, Business Intelligence.
Note: Data modeling and a date-related adjustment were handled by another team member.
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Related posts
End-to-end retail analytics pipeline that turns raw, messy CSV exports into business decisions, built in Python and SQL and runnable with one command.
What it does:
Cleans and validates 6 relational tables, fixes 585 data-quality issues and logs every action
Loads a SQLite warehouse with keys, constraints and window-function SQL
Customer analytics: RFM segmentation, cohort retention, CAC / LTV by channel, product Pareto, market-basket analysis
Churn prediction model validated on future data (ROC-AUC 0.71, no data leakage)
6-month revenue forecast, best of 3 models by backtest (4.2% MAPE)
Auto-generated Excel report (live formulas, native charts) and an interactive Streamlit dashboard
18 automated tests
Built a complete SQL Server (T-SQL) data warehouse for a fictional multi-channel, multi-currency retailer (synthetic dataset created for demonstration purposes). Delivered: staging layer loaded from 17 CSV files (~397K rows); one transactional, re-runnable ETL stored procedure that cleans duplicates, mixed date formats and inconsistent labels; a star schema with keys and constraints; reporting views with business rules defined once (net revenue in USD, contribution margin); automated data-quality tests; and 17 analytical queries (cohort retention, RFM segmentation, Pareto/ABC, constant-currency growth, carrier failure alert, inventory health, CAC vs platform claims, budget vs actual). Key insight: marketplace shows 51% gross margin but only 24.5% contribution margin after commission, shipping and refunds.
Developed a comprehensive, 10-page interactive Power BI Executive Dashboard for "Altitude Outfitters" (a multi-channel, multi-currency outdoor retail company operating across 8 countries). The goal was to transform 17 raw, messy tables (~146K order lines) into an automated decision-making tool for leadership.
Key Features & Technical Highlights:
• Data Cleaning & ETL (Power Query): Cleaned dirty data, handled missing values, removed duplicates, and standardized multi-format dates and currencies using custom M-code.
• Data Modeling: Designed a robust Star/Snowflake Schema resolving complex relationships and multi-granularity facts (daily marketing spend, weekly sessions, monthly targets, and order-level sales).
• Advanced DAX: Created 50+ measures including dynamic Currency Conversion (Local to USD + Constant Currency FX Impact), Time Intelligence (YTD, YoY), Contribution Margin Waterfall, and Customer Acquisition Cost (CAC).
• Deep-Dive Analytics: Built Customer Cohort Retention Heatmaps, RFM Segmentation, Pareto (80/20) Analysis, Marketing Funnel, and an Inventory Health Quadrant (Days of Cover vs. Sales Velocity).
• Premium UI/UX Design: Applied a custom JSON dark theme, Field Parameters (dynamic metric switching), 'What-If' scenario sliders for target forecasting, Custom Tooltips, and a seamless Master-Detail drill-through experience using Bookmarks.
(Note: Fictional dataset created for portfolio demonstration purposes).
