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
Telecom Customer Churn Analysis
Python • Pandas • Matplotlib • Jupyter Notebook
Overview
Cleaned and analyzed customer-level telecom data to identify patterns associated with customer churn across contracts, tenure, pricing, service adoption, and reported churn reasons.
What I Built
Using Python and Pandas, I investigated missing values and data quality issues, prepared the dataset for analysis, performed exploratory analysis, and created visualizations to communicate the most important patterns.
Rather than simply removing unusual or incomplete records, data-quality decisions were validated against related fields and documented to preserve the integrity of the analysis.
Key Findings
Overall churn was approximately 27% • Month-to-month customers had substantially higher churn than customers with longer contracts • Churned customers had higher average monthly charges • Internet customers without Online Security showed higher churn • Competitor-related factors represented a major group of reported churn reasons
Tools: Python • Pandas • Matplotlib • Jupyter Notebook
Want to see the analysis?
View the complete notebook and technical walkthrough on GitHub → https://github.com/jamietran8818/business-data-analytics-portfolio/blob/main/python-customer-churn-analysis/README.md
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
Real estate dashboards are usually built for data entry. Aurex Living was built for decision-making.
$873,42.39 total revenue. 1,269 completed deals this month. $276K sold, $346K rented. Property cards, agent tracking, map view, average sale value trending +10% - every number a real estate operator actually needs, on one clean white canvas.
📊 Turn Your Excel Data Into a Clear Business Dashboard
Still managing your business reports in Excel and spending hours trying to understand your numbers?
I help small businesses turn their existing Excel/CSV data into simple, interactive Power BI dashboards.
With a dashboard, you can quickly track:
• 📈 Sales performance
• 🏆 Top-selling products
• 👥 Customer trends
• 🏪 Store/branch performance
• 📦 Product performance
• 🎯 KPIs and monthly targets
I recently built a retail analytics dashboard using Power BI, with data cleaning and transformation using Excel/Power Query.
I'm currently looking to work with small businesses, retailers, and growing teams that want their data to be easier to understand and use.
💬 If you already maintain your business data in Excel, feel free to message me. I'd be happy to show you what a dashboard could look like for your business.
I designed an automated Navision → n8n → Odoo → Peppol workflow. Navision generates a daily Excel export, which n8n automatically retrieves, parses, validates, and maps before using the Odoo API to create customer invoices with their corresponding invoice lines.
The workflow also includes error handling, logging, validation, secure API authentication, scheduling, and failure notifications. Once invoices are created in Odoo, its standard Peppol functionality handles electronic delivery to B2B customers.
The solution reduced manual invoice processing, created a more transparent and traceable workflow, and provided a scalable foundation for the company's transition from Navision to Odoo. It also prepared the invoicing process for Peppol e-invoicing while keeping Navision as the primary accounting system during the transition.
I'd want a reconciliation check between each daily Excel export and the invoices Odoo actually created. If one row fails after the others succeed, does the next run resume just that row?