<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Sarwat Zahra Hashmi on Medium]]></title>
        <description><![CDATA[Stories by Sarwat Zahra Hashmi on Medium]]></description>
        <link>https://medium.com/@zahrasarwat97?source=rss-8a3301e25dd3------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*2fxu-3d9WG5Ku6c5d5FbXw.jpeg</url>
            <title>Stories by Sarwat Zahra Hashmi on Medium</title>
            <link>https://medium.com/@zahrasarwat97?source=rss-8a3301e25dd3------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Fri, 20 Nov 2026 21:04:02 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@zahrasarwat97/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[SQL Portfolio Project –Analyzing Customer Churn in the Telecom Industry]]></title>
            <link>https://medium.com/@zahrasarwat97/sql-portfolio-project-analyzing-customer-churn-in-the-telecom-industry-b18b7618a9b9?source=rss-8a3301e25dd3------2</link>
            <guid isPermaLink="false">https://medium.com/p/b18b7618a9b9</guid>
            <dc:creator><![CDATA[Sarwat Zahra Hashmi]]></dc:creator>
            <pubDate>Thu, 26 Sep 2024 08:08:53 GMT</pubDate>
            <atom:updated>2024-09-26T08:08:53.566Z</atom:updated>
            <content:encoded><![CDATA[<p>Customer churn is a critical business metric, especially in sectors like telecommunications, where maintaining a strong subscriber base is key to success. High churn rates — where customers leave a service — can signal significant issues, from poor customer experience to competition-driven factors. This blog explores a SQL-based analysis of customer churn using a dataset from IBM’s fictional telecom company, detailing insights and techniques to address customer retention challenges.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*WCa8QYfY1CbttZI7BcMKpg.jpeg" /></figure><h3><strong>Overview of the SQL Portfolio Project</strong></h3><p>This project revolves around analyzing a fictional telco dataset containing information about 7,043 customers. The dataset, sourced from GitHub, represents a telecom company in California offering both home phone and internet services. The aim is to perform an in-depth analysis of customer churn using SQL queries to answer key business questions and offer solutions for improving customer retention.</p><h3><strong>The Importance of Churn Analysis</strong></h3><p>Customer churn has major implications for a telecom business, both in terms of lost revenue and the high costs associated with acquiring new customers. Churn analysis helps identify patterns, behaviors, and factors contributing to customer exits. Insights from such analysis can help telecom companies tailor their marketing strategies, optimize customer experiences, and ultimately reduce churn. Common churn causes, such as billing issues, network problems, or poor customer service, can be addressed to improve customer satisfaction and loyalty.</p><h3>Dataset and Entity-Relationship Diagram (ERD)</h3><p>The analysis began with data cleaning using Excel to ensure the dataset was ready for SQL queries. The ERD created in MIRO illustrates the key relationships between different entities in the dataset, including customers, services, contracts, and payment methods. This diagram is essential for understanding how different aspects of the business impact customer churn.</p><h3>Key Business Questions Addressed with SQL Queries</h3><p>The project addressed several hypothetical business questions using SQL queries. Below are a few highlights:</p><ol><li><strong>Tailoring Personalized Offers for High-Churn Customers</strong></li></ol><ul><li><strong>Query</strong>: Identify the top 5 groups with the highest average monthly charges among churned customers and analyze how age, gender, and contract type influence churn.</li><li><strong>Insight</strong>: This query helps the company create personalized offers that can attract these high-churn customer segments. By tailoring offers based on demographics, the telecom company can design promotions that specifically address the pain points of these groups, potentially reducing churn rates.</li></ul><h4>2. Analyzing Customer Feedback</h4><ul><li><strong>Query</strong>: What are the feedback or complaints from churned customers?</li><li><strong>Insight</strong>: This query dives into customer complaints to understand common reasons behind churn. Identifying recurring issues, such as poor network coverage or billing disputes, can help the company take corrective measures.</li></ul><h4>3. Impact of Payment Methods on Churn</h4><ul><li><strong>Query</strong>: How does the payment method influence churn behavior?</li><li><strong>Insight</strong>: This analysis focuses on the correlation between payment methods and churn rates. By identifying which payment methods are associated with higher churn, the company can incentivize more stable payment options or simplify payment processes to retain customers.</li></ul><h3>Tools and Resources</h3><p>For the technical aspect of the project, the dataset was cleaned using Excel before being imported into <strong>MySQL Workbench</strong> for querying. Excel’s <strong>INDEX</strong> and <strong>MATCH</strong> functions were instrumental in joining tables and removing unnecessary columns. For those interested in exploring the dataset and SQL queries, resources such as the cleaned dataset, ERD, and SQL queries are available on Google Drive and GitHub.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*LyNigHLs781v2kvCxC11Yw.jpeg" /></figure><h3>Conclusion</h3><p>Analyzing customer churn is crucial for telecom companies to stay competitive in today’s fast-paced market. Through SQL queries, this project revealed actionable insights that can help telco companies enhance customer satisfaction, reduce churn rates, and increase profitability. By focusing on high-churn groups, improving service areas that receive negative feedback, and optimizing payment methods, telecom companies can improve their retention strategies.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=b18b7618a9b9" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>