<?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 Rafia Amir on Medium]]></title>
        <description><![CDATA[Stories by Rafia Amir on Medium]]></description>
        <link>https://medium.com/@rafiaamir146?source=rss-0c4f1eb4a100------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*_a4lbMtONfNUYEPg9O5aSA.jpeg</url>
            <title>Stories by Rafia Amir on Medium</title>
            <link>https://medium.com/@rafiaamir146?source=rss-0c4f1eb4a100------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Fri, 20 Nov 2026 22:06:31 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@rafiaamir146/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[Understanding and Resolving Customer Churn: Insights from IBM Telco]]></title>
            <link>https://medium.com/@rafiaamir146/understanding-and-resolving-customer-churn-insights-from-ibm-telco-daeb48bda91c?source=rss-0c4f1eb4a100------2</link>
            <guid isPermaLink="false">https://medium.com/p/daeb48bda91c</guid>
            <category><![CDATA[research]]></category>
            <category><![CDATA[telecommunication]]></category>
            <category><![CDATA[insights-and-data]]></category>
            <category><![CDATA[analysis]]></category>
            <category><![CDATA[mysql]]></category>
            <dc:creator><![CDATA[Rafia Amir]]></dc:creator>
            <pubDate>Thu, 26 Sep 2024 08:44:21 GMT</pubDate>
            <atom:updated>2024-09-26T08:44:21.867Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/270/1*yK3fOVQCE1aIELf0BJqE0g.png" /><figcaption>Customer Churn insight</figcaption></figure><p>In the fast-paced world of telecommunications, customer retention is more crucial than ever. With fierce competition and ever-evolving consumer expectations, understanding why customers leave — commonly referred to as churn — is vital for companies like IBM Telco. Churned customers hold a wealth of information that can illuminate patterns in behavior, preferences, and unmet needs. By analyzing these insights, businesses can not only refine their strategies but also tailor their offerings to better meet the demands of current and potential customers. In this article, we’ll explore the significance of examining churned customers and present actionable recommendations for leveraging this data to enhance customer loyalty and drive growth in the telecom industry. Join us as we uncover how looking back can pave the way for a more resilient future.</p><p>The top 5 churned customers according to the highest average monthly charge are males and most of them are over 40. They have a maximum contract for 2 years. Most of them stayed for 1 year only. The primary reason for this customer behavior is the better service provided by competitors. Most of them said the competitors offered better devices and higher download speeds. Other reasons were product dissatisfaction and network reliability issues. Many churned customers’ reasons remained unidentified as well. It is also interesting to look at the pattern of payment methods among churned customers and those who chose to stay. The churn rate seems to be the lowest among the customers with credit cards and much higher in the Mail Check and Bank Withdrawal method. This means most customers prefer paying through credit cards.</p><p>Keeping in view the results we need to implement the strategy of tailoring personalized offers. Considering the primary reasons for churn, it is important to thoroughly analyze the competitors’ services and products and compare them with the company’s. Look for their strong areas and try to implement those to the company’s products. Also thoroughly study own products and analyze the weak points. Actions must be taken to overcome those.</p><p>Following that, age-based Offers need to be made. A larger chunk of customers is about 50 years old on average. This means most of them are fairly old. This requires the company to formulate offers for older people who mostly use traditional means to communicate. This consists of primarily calls and messages. Better offers and network services need to be introduced in this area.</p><p>Moreover, since most churned customers are males it is important to customize offers according to that gender. This may require extra focus on areas of interest of males when marketing and introducing promotional campaigns. Engage these customers with surveys to understand their needs better and personalize offers based on their feedback.</p><p>Additionally, contract type incentives are required. As most of the churned customers have short-term contracts of one or two years, the company can offer a discount for committing to a longer-term contract i.e. 3–5 years or more. It is also recommended to include bundles that cater to the needs and preferences of these high-value groups, potentially including complementary services or discounts on different restaurants, clothing brands, and others.</p><p>As most customers prefer paying through credit cards, it is preferable to facilitate the customers to use that method and make it more convenient and accessible to them. This may reduce the churn rate of the company and help in retaining customers.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=daeb48bda91c" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Witnessing the true power of Power BI]]></title>
            <link>https://medium.com/@rafiaamir146/witnessing-the-true-power-of-power-bi-1bd0956592db?source=rss-0c4f1eb4a100------2</link>
            <guid isPermaLink="false">https://medium.com/p/1bd0956592db</guid>
            <category><![CDATA[data]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[work]]></category>
            <dc:creator><![CDATA[Rafia Amir]]></dc:creator>
            <pubDate>Fri, 06 Sep 2024 16:00:22 GMT</pubDate>
            <atom:updated>2024-09-06T16:00:22.139Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/777/1*rIUABqeynf1Zh2rVumwmZQ.png" /><figcaption>Interactive dashboard from Power BI</figcaption></figure><p>I have been working in the field of data for about 2 years and despite working tirelessly, my work never got as much appreciation as it does now. What changed?</p><p>I was introduced to Power BI from where I learned to make my result and analysis visually appealing.</p><p>It is in human nature to appreciate beauty and get attracted towards visually appealing things. Reports and data are no different. Whether you want to impress your boss or pull a client, visually attractive representation of data makes a huge difference. After getting a hang of Power BI, my game in the field of data lifted up too. This powerful software with a user friendly interface helped me in:</p><p><strong>Data Integration</strong>: Power BI can connect to a wide variety of data sources, including databases, online services, Excel spreadsheets, and cloud-based data. This integration makes it easy to consolidate data from different sources into a single view.</p><p><strong>Interactive Dashboards and Reports</strong>: It allows users to create interactive, visually appealing dashboards and reports. You can click on elements to drill down into details or filter data dynamically, providing a more engaging and insightful analysis experience.</p><p><strong>Real-Time Data Updates</strong>: Power BI supports real-time data updates, which is crucial for monitoring live metrics and making timely decisions based on the most current information.</p><p><strong>Custom Visualizations</strong>: Power BI offers a range of built-in visualizations and also allows for custom visuals, which can be created or imported from a marketplace. This flexibility helps in presenting data in the most effective way for your specific needs.</p><p><strong>Advanced Analytics</strong>: For more complex analysis, Power BI integrates with tools like DAX (Data Analysis Expressions) and M (Power Query Formula Language), which enable advanced data manipulation and custom calculations.</p><p><strong>Collaboration and Sharing</strong>: It facilitates collaboration by allowing users to share dashboards and reports with others, and it integrates well with other Microsoft tools like SharePoint and Teams.</p><p><strong>Scalability</strong>: Power BI can scale from small business needs to enterprise-level requirements, with options for both desktop and cloud-based versions. Power BI Premium offers additional features and capacity for larger organizations.</p><p><strong>Cost-Effective</strong>: Power BI offers a robust set of features at a relatively low cost compared to other business intelligence tools, with a free version and a Pro version that includes more advanced features and sharing capabilities.</p><p><strong>Security and Compliance</strong>: It provides strong security features, including data encryption, role-based access control, and compliance with various industry standards, ensuring that your data remains secure and adheres to regulatory requirements.</p><p>These strengths make Power BI a versatile and valuable tool for data visualization, reporting, and business intelligence.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=1bd0956592db" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>