<?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 Maryciana Maxmillian on Medium]]></title>
        <description><![CDATA[Stories by Maryciana Maxmillian on Medium]]></description>
        <link>https://medium.com/@marycianamaxmillian?source=rss-083007d9cc30------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/0*kXbuopAkikts9rit</url>
            <title>Stories by Maryciana Maxmillian on Medium</title>
            <link>https://medium.com/@marycianamaxmillian?source=rss-083007d9cc30------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Fri, 20 Nov 2026 19:06:02 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@marycianamaxmillian/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[Unlocking LinkedIn Insights: A Data-Driven Approach to Understanding Engagement for DataGirls…]]></title>
            <link>https://medium.com/@marycianamaxmillian/unlocking-linkedin-insights-a-data-driven-approach-to-understanding-engagement-for-datagirls-2b67f476bfe8?source=rss-083007d9cc30------2</link>
            <guid isPermaLink="false">https://medium.com/p/2b67f476bfe8</guid>
            <category><![CDATA[data-analytics]]></category>
            <dc:creator><![CDATA[Maryciana Maxmillian]]></dc:creator>
            <pubDate>Wed, 04 Dec 2024 09:41:02 GMT</pubDate>
            <atom:updated>2024-12-04T09:50:20.491Z</atom:updated>
            <content:encoded><![CDATA[<h3><strong>Unlocking LinkedIn Insights: A Data-Driven Approach to Understanding Engagement for DataGirls Tanzania</strong></h3><p>When it comes to optimizing LinkedIn strategies, the key is not just about posting more, but posting smarter.<br>DataGirls Tanzania, an incredible non-profit that empowers women in tech, tasked me with analyzing their LinkedIn performance over the course of January 2024 to November 2024.</p><p>The goal? To uncover insights that would help them boost their engagement and reach on the platform. What followed was a deep dive into their data, uncovering patterns and trends that could shape their content strategy going forward.</p><p>1.	Cleaning the Data: The Foundation of Insight<br>Before I could draw any conclusions, I had to prepare the data. I’m sure any data analyst will tell you that cleaning the data is often the hardest (and most important) part of the job. Here’s how I approached it:</p><p>-	Exploring the Data: I began by taking a look at the dataset—familiarizing myself with the structure, identifying missing or irrelevant columns, and understanding what each piece of data represented.<br><br>-	Removing Irrelevant Columns: Some of the columns weren’t adding value to the analysis, so I deleted them to make the data set cleaner and more manageable. This included things like LinkedIn’s internal post IDs that didn’t provide actionable insights.</p><p>-	Eliminating Empty Rows: There were rows in the dataset that didn’t contain any meaningful data. I removed these, as keeping them would only distort the analysis.<br><br>-	Standardizing Dates: Dates in the dataset were in different formats, so I standardized them. This allowed me to group posts by month—a crucial step for spotting trends over time.</p><p>-	Filling Missing Content Types: Some posts had missing content types, so I labeled those as “Others” to ensure all posts were accounted for in the analysis.<br><br>By the time I finished, the data was cleaned, structured, and ready for deeper insights.</p><p>2.<strong>	Analyzing and Visualizing the Data:</strong><br>Once the data was ready, I moved on to the fun part—analyzing the trends and creating visualizations. Here are some key insights that stood out:</p><p>•	Engagement Rate Over Time:<br>I created a chart showing how the engagement rate changed throughout the year. What stood out to me was the steady increase in engagement, with a huge spike in August 2024. This was a standout month in terms of reactions and comments, so I knew I had to dig deeper into what made that month special.</p><p>•	Content Type Distribution<br>A quick donut chart helped me see that 88% of DataGirls’ posts were articles, 9% were videos, and the remaining 3% were categorized as “Others.” Interestingly, videos—despite being a small portion of the content—consistently drove higher engagement. This pointed to an opportunity for DataGirls to ramp up video content.</p><p>•	Clicks and Impressions<br>Another crucial metric I examined was clicks on posts. August 2024 was the peak month, with over 2,500 clicks. This surge aligned with increased engagement, suggesting a connection between content quality and click-through rate.<br><br>I used Excel’s charting tools to make these trends visually clear, which helped identify both opportunities and areas for improvement.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Rqr0dZrKxzWMye53dvKAcw.jpeg" /><figcaption>DataGirls Tanzania performance Dashboard</figcaption></figure><p>3. Key Insights and Takeaways:<br>After analyzing the data, several key insights emerged that could influence DataGirls Tanzania’s LinkedIn strategy:</p><p>•	Video Content is Key: Although videos made up only 9% of content, they drove significantly more engagement than articles. This shows that video is a format with a much higher return on investment. DataGirls should consider producing more video content in 2025.</p><p>•	September Was a Breakthrough Month: Engagement exploded in September, with the highest number of reactions and comments. I would recommend investigating what posts worked particularly well that month and see if those strategies can be replicated.</p><p>•	Consistency is Crucial: DataGirls showed a steady increase in engagement when posting consistently, especially in the first half of 2024. There was a drop in posting frequency in months like August and November, which likely contributed to a decrease in engagement. Posting consistently will be key moving forward.</p><p>•	Timing Matters: The data suggested that engagement was higher during Wednesdays and Thursdays, particularly in the mornings. If DataGirls can align posting times to peak engagement hours, they could see further growth in interactions.</p><p>4.	Actionable Recommendations for DataGirls Tanzania<br>Based on the findings, here are some actionable recommendations:</p><p>•	Focus on Video Content<br>Video content generated more engagement than articles. DataGirls should invest more in video production, focusing on tutorials, stories, and behind-the-scenes content to connect with their audience more effectively.</p><p>•	Replicate the September Success<br>September 2024 was a standout month for engagement. I suggest revisiting the posts from that month and identifying patterns that could be leveraged again—whether it’s the timing, content type, or a specific campaign.</p><p>•	Stick to a Consistent Posting Schedule<br>Consistent posting is key to engagement. DataGirls should aim to post 2–3 times a week, especially in the first half of the month when engagement is often highest.</p><p>•	Optimize Post Timing<br>By focusing on posting on Wednesdays and Thursdays during peak hours (typically late morning), DataGirls can optimize visibility and interaction with their posts.<br><br>Conclusion: What’s Next for DataGirls Tanzania?<br>The insights uncovered through this analysis provide DataGirls Tanzania with a roadmap for enhancing their LinkedIn presence. By focusing on video content, consistency, timing, and leveraging successful months, DataGirls can continue to grow its impact and reach.<br>With these actionable steps in mind, DataGirls is poised to take its social media game to the next level, creating more engaging content and connecting with an even broader audience.<br>What strategies have you used to boost LinkedIn engagement? Share your thoughts below or drop me a message—I’d love to hear your experiences!</p><p><a href="https://medium.com/u/61a3fa6ce26c">DataGirls Tanzania</a><br>#DataAnalytics #LinkedInGrowth #ContentStrategy #WomenInTech #DataGirlsTanzania #Excel #DataInsights</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=2b67f476bfe8" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Unlocking the Power of Excel]]></title>
            <link>https://medium.com/@marycianamaxmillian/unlocking-the-power-of-excel-42ec9aaae0d7?source=rss-083007d9cc30------2</link>
            <guid isPermaLink="false">https://medium.com/p/42ec9aaae0d7</guid>
            <dc:creator><![CDATA[Maryciana Maxmillian]]></dc:creator>
            <pubDate>Mon, 11 Nov 2024 13:14:15 GMT</pubDate>
            <atom:updated>2024-11-14T08:11:24.167Z</atom:updated>
            <content:encoded><![CDATA[<p>My Data Cleaning Journey!</p><p>Data cleaning in Excel? YES, PLEASE! I always knew data cleaning was crucial, but this YouTube playlist really opened my eyes to just how powerful Excel is when it comes to tidying up messy datasets.</p><p>➡️Clean data is the backbone of any solid analysis—without it, you’re just guessing in the dark. I’m beyond excited to share my takeaways from the playlist and how working with my accountability partner has leveled up my skills. Let’s dive in!</p><p>➡️Learning Summary<br>Data Cleaning Using Excel Wow, Excel has so many tricks up its sleeve! The first part of the playlist introduced basic yet essential cleaning techniques—removing extra columns, spotting weird formatting issues, and generally making your dataset look nice and tidy.</p><p>➡️I knew Excel could filter data, but this playlist showed me how to REALLY use those features efficiently. Now, I can clean up even the messiest data with confidence!</p><ul><li>Identifying and Treating Missing Values Missing values used to make me cringe—what do you even DO with those gaps? Well, now I know! Thanks to this playlist, I learned how to use ISBLANK() to easily find missing values and fill them in. But that’s not all! I can now use averages, custom values, or even remove those pesky incomplete rows with ease. Excel’s IF() function has become my new best friend for dealing with missing data!</li><li>Outliers Treatment and Identification Ah, outliers—those sneaky values that can throw your whole analysis off! This section was a game-changer. I loved learning how to spot outliers visually with scatter plots and box plots (honestly, Excel’s visuals are so much more helpful than I realized!). Plus, calculating standard deviations and z-scores to catch outliers made me feel like a data detective. I’m now ready to handle outliers confidently, both visually and statistically. Bring on the messy data!</li><li>Data Types and Consistency This one hit home more than I expected. Mixing up data types—like having numbers mixed with text—can cause a LOT of headaches. But no more! I learned how to use the Text to Columns feature and functions like VALUE() to make sure everything is in the right format. Having consistent data types feels like magic—no more errors popping up in my formulas because of random text or formatting issues. I’ve got Excel under control!</li><li>How to Split Data Have you ever seen a dataset with a single column crammed full of information? Well, now I know how to break it down, no problem! The Text to Columns feature is a lifesaver, letting me split data into neat, manageable chunks using delimiters like commas or spaces. This was especially useful for contact information—I cleaned up a long list of addresses and emails in seconds! I feel like a data superhero with this new skill!</li></ul><p>Personal Insights</p><p>Collaborating with my accountability partner added so much value to this whole process. We both had some “aha” moments, especially when it came to handling outliers. Visualization through box plots really made spotting those outliers so much easier, and discussing our strategies helped us both get faster at identifying problem areas in our datasets.</p><p>One of the biggest revelations came while working on data types. It sounds straightforward, but keeping everything consistent across large datasets is NOT as easy as it seems. Thankfully, having a partner to troubleshoot with made this challenge fun instead of frustrating. Excel is so much easier to navigate now that I understand how to ensure data consistency.</p><p>Reflection<br>I can’t even begin to express how much this assignment has boosted my Excel skills. From handling missing data to catching outliers, I feel so much more confident in my ability to clean data efficiently and accurately. Every trick and technique from the playlist has given me more control over my datasets, and I’m honestly excited to keep using these skills in the future. Whether it’s for academic projects or (fingers crossed) my future job in data science, I know these techniques will be invaluable. Data cleaning? I’m ready for you!</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/680/1*K_LcGWADvYv53bE5-mqZHQ.png" /><figcaption>Data cleaning using Excel</figcaption></figure><p>#DataCleaning #Excel #DataScience and #DataGirlsTz #LearningJourney <a href="https://medium.com/u/61a3fa6ce26c">DataGirls Tanzania</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=42ec9aaae0d7" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>