<?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 Haule Fausta on Medium]]></title>
        <description><![CDATA[Stories by Haule Fausta on Medium]]></description>
        <link>https://medium.com/@haulefaustad?source=rss-2259427b64b6------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/0*iLw2iU_yjaH5qUT8</url>
            <title>Stories by Haule Fausta on Medium</title>
            <link>https://medium.com/@haulefaustad?source=rss-2259427b64b6------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Fri, 20 Nov 2026 19:08:21 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@haulefaustad/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[My Journey Analyzing DataGirlsTanzania’s LinkedIn Performance.]]></title>
            <link>https://medium.com/@haulefaustad/my-journey-analyzing-datagirlstanzanias-linkedin-performance-ad643bd4271a?source=rss-2259427b64b6------2</link>
            <guid isPermaLink="false">https://medium.com/p/ad643bd4271a</guid>
            <category><![CDATA[data]]></category>
            <category><![CDATA[datagirls]]></category>
            <category><![CDATA[excel]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[learning]]></category>
            <dc:creator><![CDATA[Haule Fausta]]></dc:creator>
            <pubDate>Wed, 04 Dec 2024 08:09:46 GMT</pubDate>
            <atom:updated>2024-12-04T08:09:46.982Z</atom:updated>
            <content:encoded><![CDATA[<p>Working with <a href="https://medium.com/u/61a3fa6ce26c">DataGirls Tanzania</a> to analyze their LinkedIn growth was not only a professional milestone but also a personal passion project. This NGO’s mission to empower young women in data and technology resonates deeply with me, and it was exciting to dive into their performance data and uncover actionable insights. Here’s a behind-the-scenes look at how I approached the analysis, the insights I uncovered, and the recommendations I provided to elevate their impact.</p><p><strong>Starting with the Data</strong></p><p>The dataset consisted of two key sheets: <strong>Metrics</strong> and <strong>All Posts</strong>, each brimming with valuable information about LinkedIn activity. My first step was cleaning and preparing the data:</p><ul><li><strong>Metrics Sheet</strong>: I streamlined the 20 columns into 8 key metrics, including <em>Impressions (Total)</em>, <em>Clicks (Total)</em>, and <em>Engagement Rates (Total)</em>.</li><li><strong>All Posts Sheet</strong>: From 19 columns, I retained critical data such as <em>Post Title</em>, <em>Impressions</em>, <em>Click-Through Rate (CTR)</em>, and <em>Engagement Rate</em>.</li></ul><p>By formatting percentages, deducing post topics, and categorizing content types, I transformed raw data into a structured, analyzable format.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*hSR8b9muv6bK3M-rwASBWA.png" /><figcaption>Messy Data</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*7ka5fqLCRaIaJ6I_X6EMdg.png" /><figcaption>Uncleaned Data</figcaption></figure><h3>Key Insights</h3><p>From January to November 2024, the data revealed fascinating trends:</p><ol><li><strong>Content Performance</strong>:</li></ol><ul><li>Text Posts achieved <strong>92% of total engagement</strong>, with an average <strong>15.80% engagement rate</strong> and <strong>10.76% CTR</strong>.</li><li>Videos offered visibility, generating <strong>577 impressions per post</strong>, but their engagement was slightly lower (<strong>11.72%</strong>).</li><li>Articles underperformed, with only <strong>4.94% engagement</strong>, indicating a mismatch with audience preferences</li></ul><p><strong>2. Audience Behavior</strong>:</p><ul><li>Themes like <em>Cohort Success Stories</em> (<strong>37% CTR</strong>) and <em>Empowering Women in Data Analytics</em> (<strong>33% engagement rate</strong>) resonated strongly.</li><li><em>Role Models &amp; Mentorship</em> also performed well, reflecting the audience’s appreciation for relatable and inspiring content.</li></ul><p><strong>3. Monthly Trends</strong>: Engagement spiked in <strong>September</strong>, coinciding with a rise in impressions and activity.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*r6LkssBTnRwR8n3ThCrhEg.png" /><figcaption>Datagirls Tanzania LinkedIn Growth Jan 2024-Nov 2024 Dashboard</figcaption></figure><h3>The Recommendations</h3><p>Based on these insights, I proposed five strategies to maximize LinkedIn performance:</p><ol><li><strong>Double Down on Text Posts</strong>: Regularly share stories of mentorship, cohort success, and Women empowerment in data and tech , leveraging the high engagement rates.</li><li><strong>Refine Video Strategy</strong>: Use short, impactful videos with captions to highlight training programs and community achievements.</li><li><strong>Interactive Engagement</strong>: Launch polls, live Q&amp;As, and other interactive content to build a more engaged community.</li><li><strong>Reimagine Articles</strong>: Focus on guides, case studies, and success stories, accompanied by engaging text posts or videos.</li><li><strong>Stay Consistent</strong>: Maintain a posting schedule of 3–4 posts weekly, mixing formats to keep the content dynamic and engaging.</li></ol><h3>Reflections on Impact</h3><p>Analyzing the LinkedIn performance for DataGirlsTanzania was more than just crunching numbers, it was about aligning data insights with the organization’s mission. This experience has reaffirmed in me the power of data-driven storytelling in building stronger connections, amplifying impact, and inspiring action.</p><p>By focusing on high-performing content types, relatable themes, and consistent audience engagement, DataGirlsTanzania can continue empowering young women in data and technology while expanding their community and influence.</p><p>I’m excited to see how these insights shape their future growth and look forward to supporting their mission in every way I can.</p><p><em>Have you analyzed social media data for mission-driven organizations? I would love to hear your experiences and tips!</em></p><p>#DataGirlsTz #LinkedInAnalytics #EmpoweringWomen #WomenInTech #DataAnalysis</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=ad643bd4271a" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[My Journey to Cleaner, More Reliable Data.]]></title>
            <link>https://medium.com/@haulefaustad/my-journey-to-cleaner-more-reliable-data-f2f51526c42e?source=rss-2259427b64b6------2</link>
            <guid isPermaLink="false">https://medium.com/p/f2f51526c42e</guid>
            <category><![CDATA[data-cleaning]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[excel]]></category>
            <category><![CDATA[data-analysis]]></category>
            <dc:creator><![CDATA[Haule Fausta]]></dc:creator>
            <pubDate>Sun, 10 Nov 2024 14:23:59 GMT</pubDate>
            <atom:updated>2024-11-10T14:25:50.265Z</atom:updated>
            <content:encoded><![CDATA[<p>As an agribusiness analyst, I know that data drives decisions in agriculture from tracking crop yields and supply chains to forecasting market trends. But the raw data I come across is rarely neatly packaged, it’s often riddled with gaps, duplicates, and inconsistencies. This is why data cleaning is so essential, without it, even the best analyses can lead to misguided conclusions. In this article, I’m sharing my key takeaways from learning data cleaning in Excel with IvyProSchool and reflecting on how these skills will elevate my work in agricultural data analysis.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/850/1*VIxaDHdKX714l3aV7KbCjw.png" /><figcaption>A messy data that needs some cleaning</figcaption></figure><p>Why Clean Data Matters:</p><p>Data cleaning isn’t just about tidying up a spreadsheet, it’s about transforming data into a reliable, analytics ready format. For agriculture and agribusiness, where we rely on precise information to predict trends, assess trade systems, and improve supply chain management, clean data is non-negotiable. Consistent, complete, and correctly formatted data enables us to make sound decisions that will impact everything from crop yield projections to pricing strategies.</p><p><strong>Core Data Cleaning Techniques in Excel</strong></p><p>Here are some of the fundamental techniques I learned that make data cleaning in Excel both practical and powerful:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*tIHWI-MCYpvyYYrH32GOCQ.png" /><figcaption>Treatment of Outliers</figcaption></figure><ol><li><strong>Removing Empty Rows: </strong>Empty rows can fragment data tables, creating disjointed sections and affecting the flow of analysis. Removing these rows keeps all information in a single, cohesive table, making calculations and insights clearer and more streamlined. I learned that filtering for blank cells and deleting rows worked efficiently to resolve this.</li><li><strong>Removing Duplicates</strong>: Data sourced from multiple systems can contain duplicate entries which causes skewing analysis. For example, repeated records on crop outputs could distort yield averages. Excel’s Remove Duplicates function was straightforward to use and I also learned to visually catch duplicates with Conditional Formatting before committing to any deletions.</li><li><strong>Ensuring Consistent Data Types</strong> : Inconsistent data types can disrupt analysis and result in error messages. For instance, a sales column intended for numbers might contain text entries, causing issues when calculating averages or sums. I learn Find and Replace (Ctrl+H) and Text to Columns are fantastic for sorting these out. Sorting data is also useful here it pushes text entries to the top, so I can quickly spot inconsistencies and correct them.</li><li>4. <strong>Dealing with Missing Data</strong>: Missing values often stem from incomplete records or data entry errors. Depending on the dataset, I can handle missing values by:</li></ol><ul><li>Deleting rows or columns (if their absence won’t affect the analysis)</li><li>Replacing gaps with averages or specific values (like mean crop yield or median prices)</li><li>Imputing values using statistical methods.</li></ul><p>5. <strong>Outlier Identification and Treatment</strong>: Outliers are critical in agribusiness data they can indicate unique insights, like extreme weather impacts on yield, or simply be errors. I learned that <strong>Quartile Functions</strong> in Excel are invaluable for spotting these anomalies. By calculating quartiles, I can flag data points that fall outside the expected range, allowing for a balanced approach to managing these variations.</p><p>Along the way, I had some standout “aha” moments that made data cleaning in Excel feel a lot more straightforward and fun.</p><ul><li><strong>Flash Fill (Ctrl + E)</strong>: This shortcut instantly became my favorite! Flash Fill saves so much time by auto-filling repetitive patterns, making it a powerful tool for routine data entry.</li><li><strong>CONCATENATE vs. Text to Columns</strong>: Working with text data was eye-opening. Text to Columns<strong> </strong>is my go-to method for splitting data as it’s precise and easy to use. CONCATENATE has its place for combining information, but I found Text to Columns especially useful for separating complex strings quickly.</li><li><strong>Quartile Functions</strong>: Learning to use quartiles to spot outliers felt like a breakthrough. It’s a practical tool that I can now apply to identify outliers in crop yields, pricing data, or production metrics.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/675/1*pG6toBLw4BXgjGSQi6nkmQ.jpeg" /><figcaption>Data insights</figcaption></figure><p><strong>Reflecting on My Learning Journey</strong></p><p>This learning experience has really added some valuable tools to my data cleaning kit. Now, I feel much more confident tackling those tricky, messy datasets that used to feel overwhelming. In agribusiness, getting the data right is where real insights start from understanding trade flows to tracking supply chain details. Moving forward, I will be putting these skills into action, whether it’s working with production metrics, streamlining trade data, or refining supply chain records. Data cleaning now feels like more than just a routine step; it’s a way to make sure every analysis is accurate and reliable, a foundation I can build on in every project.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=f2f51526c42e" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Loving Yourself: A Biblical Perspective]]></title>
            <link>https://medium.com/@haulefaustad/loving-yourself-a-biblical-perspective-160cf5ce8bb5?source=rss-2259427b64b6------2</link>
            <guid isPermaLink="false">https://medium.com/p/160cf5ce8bb5</guid>
            <dc:creator><![CDATA[Haule Fausta]]></dc:creator>
            <pubDate>Fri, 11 Oct 2024 13:23:24 GMT</pubDate>
            <atom:updated>2024-10-11T13:23:24.271Z</atom:updated>
            <content:encoded><![CDATA[<h4>Loving Yourself: A Biblical Perspective.</h4><p>&quot;Love your neighbor as yourself.&quot; This biblical commandment is a cornerstone of Christian ethics. But what does it truly mean to &quot;love yourself&quot;? And how does self-love relate to our love for others?</p><p>It&#39;s important to clarify that loving yourself is not synonymous with selfishness or narcissism. Instead, it&#39;s about recognizing your intrinsic value and worth. It&#39;s about treating yourself with kindness, respect, and compassion.</p><p>There are times when our love for others may understandably overshadow our self-love. For instance, a parent&#39;s love for their child often takes precedence over their own needs. Similarly, a caregiver may prioritize the well-being of their patient above their own. However, it&#39;s crucial to find a balance. Neglecting your own needs can lead to burnout, resentment, and ultimately, an inability to effectively love and support others.</p><p>So, how can we cultivate self-love? Here are a few practical steps:</p><p>1. <strong>Set Boundaries</strong>: Establishing healthy boundaries is essential for self-preservation. It means saying &quot;no&quot; when necessary, prioritizing your well-being, and avoiding people or situations that drain your energy.</p><p>2. <strong>Practice Self-Care</strong>: Take time for activities that nourish your mind, body, and soul. This could include exercise, meditation, hobbies, or simply spending time in nature.</p><p>3. <strong>Be Kind to Yourself</strong>: Treat yourself with the same compassion and understanding you would offer a friend. Forgive yourself for mistakes and celebrate your accomplishments.</p><p>4. <strong>Speak Positively</strong>:Avoid negative self-talk and focus on your strengths and qualities. Replace self-criticism with self-encouragement.</p><p>5. <strong>Respect Your Needs:</strong>Listen to your body and mind. Honor your desires and needs, even if they don’t align with everyone else’s expectations.</p><p>I recently had a conversation with my friend Solana about her experiences with some &quot;Christian friends&quot; who owed her money. She&#39;s been incredibly understanding, assuming they must be going through tough times. But from what I can see, it seems more likely that they&#39;re simply choosing not to pay her back.</p><p>Solana&#39;s empathy and willingness to give others the benefit of the doubt are admirable qualities. However, I couldn&#39;t help but wonder if she was being too lenient with herself and her own needs. Sometimes, we can become so focused on loving and forgiving others that we neglect our own well-being.</p><p>When we truly love ourselves, we are better equipped to love others. We are less likely to seek validation or approval from external sources. We are more compassionate, understanding, and generous. By nurturing our own well-being, we create a solid foundation for building healthy relationships with others.</p><p>Loving yourself is not about selfishness; it’s about self-preservation. It’s about recognizing your worth, setting boundaries, and practicing self-care. By cultivating self-love, we can live more fulfilling lives and contribute more meaningfully to the world around us.</p><p>Remember, loving yourself is not just a commandment; it&#39;s a practical step towards a more balanced and fulfilling life.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=160cf5ce8bb5" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>