<?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 Grace Musungu on Medium]]></title>
        <description><![CDATA[Stories by Grace Musungu on Medium]]></description>
        <link>https://medium.com/@gracemutheumusungu?source=rss-dc9123776566------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*jq5WX_0PP8oqxlsq_TbjJA.jpeg</url>
            <title>Stories by Grace Musungu on Medium</title>
            <link>https://medium.com/@gracemutheumusungu?source=rss-dc9123776566------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Sat, 21 Nov 2026 10:18:40 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@gracemutheumusungu/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[Compliance-First: Building a Secure Robo-Advisor for the UAE Market]]></title>
            <link>https://medium.com/@gracemutheumusungu/compliance-first-building-a-secure-robo-advisor-for-the-uae-market-b19ed0b81477?source=rss-dc9123776566------2</link>
            <guid isPermaLink="false">https://medium.com/p/b19ed0b81477</guid>
            <category><![CDATA[fintech]]></category>
            <category><![CDATA[ai]]></category>
            <category><![CDATA[machine-learning]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[finance]]></category>
            <dc:creator><![CDATA[Grace Musungu]]></dc:creator>
            <pubDate>Sun, 26 Apr 2026 21:10:31 GMT</pubDate>
            <atom:updated>2026-04-26T21:13:29.015Z</atom:updated>
            <content:encoded><![CDATA[<h4>Using EODHD API</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/940/1*KakMDNNa3Khz_neCfYizFg.png" /></figure><p>“You can’t give investment advice in the UAE if you can’t guarantee you’re not helping a money launderer. My new UAE Robo-Advisor doesn’t just analyze stocks; it analyzes people. I’ve merged my background in Fraud Risk with Gemini 2.5 to build the future of regulated fintech.”</p><h3>The Problem: Why This Project Exists</h3><p>Imagine you want to invest $50,000 in the UAE stock market. A normal app just takes your money. But what if that money belongs to someone on a global ‘No-Fly’ list or a corrupt politician? If the app accepts it, the whole company can be shut down.</p><p>The UAE fintech landscape is governed by strict CBUAE and SCA regulations. My system is the ‘Brain’ that checks the market and the person at the same time. For a financial institution, a “fast” AI that provides a market trend to a sanctioned individual isn’t an innovation; it’s a liability. The industry needs tools that think like Fraud Risk Managers: skeptical, data-driven, and compliance-first.</p><h3>How the System Flows</h3><p>Think of this system like a High-Security Private Bank, but inside an app:</p><ul><li><strong>The Investor’s Door:</strong> The user requests to invest a specific amount in Dubai or Abu Dhabi stocks.</li><li><strong>The Identity Scanner (The Gatekeeper):</strong> Before a single Dirham is moved, the AI checks the user’s name against global sanctions and UAE-specific PEP (Politically Exposed Persons) lists.</li><li><strong>The Market Brain:</strong> Once cleared, the AI looks at real-time data from the Dubai Financial Market (DFM) or ADX to analyze performance.</li><li><strong>The Regulatory Guardrail:</strong> It cross-references the investment plan with CBUAE guidelines to ensure the risk level is legal for that specific user.</li></ul><h3>The Technical “Engine Room.”</h3><p>I designed this project with a “security-first” mindset, ensuring sensitive keys are hidden, and the system stays modular and protected. I chose Gemini 2.5 to power the agent because it is significantly smarter at connecting live data with complex compliance rules, allowing it to perform the deep, accurate analysis that standard chatbots just cannot manage.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*vmQ-avrRT6327wvDFhgTCw.png" /></figure><h4>Phase 1: The Compliance Gate</h4><p>I built a ‘Security Gate’ using <strong>RAG (Retrieval-Augmented Generation)</strong> to block sanctioned individuals before they can access live market data. Before the engine ever touches a stock ticker, it performs a <strong>mandatory screening.</strong></p><p>The system cross-references the user’s identity against a vectorized knowledge base of internal and global sanctions lists (watchlist.txt). If the system finds a match, it doesn’t just “warn” the user; it shuts down the request.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*YIm0g-7_g-B6I6sEFWzLfg.png" /></figure><p><em>Here, I simulate a request from a sanctioned individual (Lex Luthor). Notice how the system identifies the risk and triggers an immediate compliance refusal, citing </em><strong><em>CBUAE AML</em></strong><em> protocols before any market data is exposed.</em></p><h4>Phase 2: Live Market Intelligence &amp; Financial Reasoning</h4><p>Once a user is cleared, the system transitions from “Security Guard” to “Investment Analyst.” To power this, I integrated the <a href="https://eodhd.com/?via=grace&amp;utm_source=medium&amp;utm_medium=post&amp;utm_campaign=compliance-first-building-a-secure-robo-advisor-for-the-uae-market-b19ed0b81477&amp;utm_content=grace"><strong>EODHD Financial API</strong></a><strong>.</strong> In a regulated environment, you cannot rely on delayed or inconsistent data; <a href="https://eodhd.com/?via=grace&amp;utm_source=medium&amp;utm_medium=post&amp;utm_campaign=compliance-first-building-a-secure-robo-advisor-for-the-uae-market-b19ed0b81477&amp;utm_content=grace"><strong>EODHD</strong></a> was the clear choice because it provides institutional-grade, real-time feeds with the kind of clean, structured JSON output that an LLM can parse flawlessly.</p><p>This ensures that when the AI performs Weekly Trend Analysis, comparing current prices to a 5-day delta for UAE heavyweights like <strong>Emaar</strong> or <strong>FAB,</strong> the data is reliable, accurate, and ready for compliant decision-making. Instead of dumping raw numbers, the AI performs this analysis to provide “Bullish,” “Bearish,” or “Neutral” insights.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*VxZqSe-Zvu-CjG8JRaglXA.png" /></figure><p><strong>The ‘Verified User’ Report</strong><em>: A successful query from a verified user. The system provides an AED-denominated analysis with clean, ‘no-fluff’ formatting, specific market context, and a professional disclaimer.</em></p><h3>Why This Matters for the Future of Fintech</h3><p>This project demonstrates more than just technical proficiency with APIs and LLMs. It showcases:</p><ul><li><strong>Regulatory Intelligence:</strong> An understanding of CBUAE and AML mandates.</li><li><strong>Fraud Risk Expertise:</strong> The ability to build “Security-by-Design” into automated workflows.</li><li><strong>Data Transformation:</strong> Turning raw JSON API responses into professional, actionable financial summaries.</li></ul><p>In the sprint to define the next generation of MENA fintech, I am building tools that aren’t just smart, they’re safe. I’ve successfully integrated <strong>Gemini 2.5</strong> with a live <a href="https://eodhd.com/?via=grace&amp;utm_source=medium&amp;utm_medium=post&amp;utm_campaign=compliance-first-building-a-secure-robo-advisor-for-the-uae-market-b19ed0b81477&amp;utm_content=grace"><strong>EODHD </strong></a>financial data stream, wrapped in a <strong>CBUAE</strong>-aligned compliance layer. This hits both my Robo-Advisory and FinCrime goals by proving that AI can be an active participant in Sanctions/PEP screening.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=b19ed0b81477" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Can AI protect a nation’s financial borders?]]></title>
            <link>https://ai.plainenglish.io/can-ai-protect-a-nations-financial-borders-f0ee65e11c56?source=rss-dc9123776566------2</link>
            <guid isPermaLink="false">https://medium.com/p/f0ee65e11c56</guid>
            <category><![CDATA[fraud-prevention]]></category>
            <category><![CDATA[aml-compliance]]></category>
            <category><![CDATA[fintech]]></category>
            <category><![CDATA[data-science]]></category>
            <dc:creator><![CDATA[Grace Musungu]]></dc:creator>
            <pubDate>Mon, 30 Mar 2026 06:01:00 GMT</pubDate>
            <atom:updated>2026-03-30T06:01:00.574Z</atom:updated>
            <content:encoded><![CDATA[<h3><strong>Can AI protect a nation’s financial borders? 🇦🇪 I built a ‘Digital Lawyer’ to solve the $100M compliance headache.</strong></h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/940/1*o7XtJIbW2m5BZ6i5YyGWYg.png" /></figure><p>You know how, when you go to the bank to move a large amount of money, they sometimes ask you a lot of questions about where it came from? They do that because the government has very strict laws to make sure that money isn’t coming from ‘bad guys’ or illegal business.</p><p>Every time a bank sees a transaction that looks ‘weird’, like someone who only makes $2,000 a month suddenly receiving $100,000 from overseas, the bank is legally required to write a very detailed report to the government (the Central Bank) explaining why they think it’s suspicious.</p><p><strong>The Problem:</strong> Writing these reports is a nightmare. Senior Compliance Officers spend hours manually reviewing transaction alerts, cross-referencing raw data with the complex UAE Federal Decree-Law №10 of 2025, and drafting reports. This manual process is slow, costly, and prone to human error, which can lead to severe regulatory fines. There are so many reports to write that humans can’t keep up.</p><p>As the UAE cements its position as a global financial hub, regulatory scrutiny on Anti-Money Laundering (AML) and Counter-Terrorist Financing (CTF) has reached unheard-of levels. Financial institutions in Dubai and Abu Dhabi face immense pressure to submit accurate, detailed Suspicious Activity Reports (SARs) to the Financial Intelligence Unit (FIU) under tight deadlines.</p><p><strong>The Solution:</strong> I developed an Automated Regulatory Reporting Engine. This tool makes use of Generative AI and Retrieval-Augmented Generation (RAG) to instantly analyze unstructured financial data (like bank statements) against a vectorized knowledge base of UAE laws, automatically drafting a complete, professional SAR in under 60 seconds.</p><p><strong>The Business Problem: The “Compliance Constraints”</strong></p><p>In a top-tier UAE bank, a complex alert might take a human analyst 2 to 4 hours to investigate and document. A single typo in a legal citation or a missed “red flag” defined in the CBUAE Rulebook can compromise the integrity of the filing.</p><p>The problem isn’t just speed; it’s <strong>regulatory fidelity</strong>. The model needs to know the difference between a suspicious transaction in Kenya versus one in the Dubai International Financial Centre (DIFC).</p><p><strong>The Solution: A Law-Aware AI Architect</strong></p><p>To address this, I moved beyond a simple standard chatbot. I built a system that combines the reasoning capability of a Large Language Model (LLM) with the authoritative accuracy of a legal database.</p><h3>The Core Technology (The ‘How’)</h3><ul><li><strong>The Tech:</strong> Dify.ai Workflow + Gemini 1.5 Flash (Chosen for high-speed reasoning and low latency) + RAG (Vectorized UAE Federal Laws).</li><li><strong>The Achievement:</strong> Built a system capable of parsing unstructured bank statements (TXT/PDF) to identify criminal typologies like <strong>Smurfing</strong> and <strong>Structuring</strong>.</li><li><strong>The Regulatory Edge:</strong> The system is “Law-Aware,” automatically citing <strong>Articles 2 &amp; 30 of UAE Law №10 of 2025 concerning Anti-Money Laundering and Combating the Financing of Terrorism</strong> and aligning with 2026 CBUAE reporting standards.</li><li><strong>Impact:</strong> Reduces the “Time-to-Report” for suspicious activity from hours to seconds, ensuring zero “citation errors” in legal filings.</li></ul><h3>The “Wiring” of the AI</h3><p>The system functions using a process called Retrieval-Augmented Generation (RAG). When financial data is provided, the AI doesn’t just “guess” the answer. It is explicitly instructed to search the provided UAE Law database first, find the relevant articles, and use <em>that specific legal context</em> to analyze the data and structure the report.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*7drncgPHdID8SaN_umioiA.png" /><figcaption><strong>User Journey: From Raw Data to Regulatory Intelligence</strong></figcaption></figure><p><strong>User Journey: From Raw Data to Regulatory Intelligence</strong></p><p>I designed the interface to mimic the workflow of a Compliance Officer. The power lies in the system’s ability to handle unstructured data.</p><h3>Step 1: Data Ingestion (The Input)</h3><p>Instead of a human having to manually type out a narrative, the user uploads a document, in this test case, a .txt bank statement for a “student” customer exhibiting typical laundering typologies.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*_L0pomSCoZD-KwCGFsC-Rw.png" /></figure><h3>Step 2: Intelligent Analysis &amp; Legal Mapping (The Process)</h3><p>The Gemini 1.5 Flash model parses the statement, identifies the clustering of deposits just below reporting thresholds (AED 45k, 48k, 42k), and flags the immediate outflow to a crypto-exchange. It then maps these behaviors to specific, defined violations in the vectorized UAE Law.</p><h3>Step 3: The Automated SAR (The Output)</h3><p>The final output is a structured, professional SAR, ready for a final human review before FIU submission.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/762/1*6afEFZFZFDqgSVujsKtoOA.png" /></figure><p><strong>Impact and Business ROI (The ‘Why It Matters’)</strong></p><p>This project demonstrates how FinTech can turn a cost center (Compliance) into an operational efficiency driver.</p><ul><li><strong>90% Reduction in Drafting Time:</strong> Moves SAR creation from 2 hours to under 1 minute.</li><li><strong>100% Legal Citation Accuracy:</strong> Eliminates human error in referencing UAE regulatory articles.</li><li><strong>Consistent Reporting Standard:</strong> Ensures every SAR follows a senior-level, standardized narrative structure (Intro-Body-Conclusion).</li><li><strong>Scalable Analysis:</strong> Enables compliance teams to handle a higher volume of transaction alerts without increasing headcount, a critical requirement for rapidly growing Dubai FinTechs.</li></ul><p>This prototype isn’t just a technical exercise; it is a scalable solution to a concrete business challenge facing every financial entity in the UAE.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=f0ee65e11c56" width="1" height="1" alt=""><hr><p><a href="https://ai.plainenglish.io/can-ai-protect-a-nations-financial-borders-f0ee65e11c56">Can AI protect a nation’s financial borders?</a> was originally published in <a href="https://ai.plainenglish.io/">Artificial Intelligence in Plain English</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How I’m Using Google AppSheet and Data Analytics to Break the Illusion of Productivity in My Job…]]></title>
            <link>https://ai.plainenglish.io/how-im-using-google-appsheet-and-data-analytics-to-break-the-illusion-of-productivity-in-my-job-ea6d714d16eb?source=rss-dc9123776566------2</link>
            <guid isPermaLink="false">https://medium.com/p/ea6d714d16eb</guid>
            <category><![CDATA[google-appsheet]]></category>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[data]]></category>
            <category><![CDATA[automation]]></category>
            <category><![CDATA[mobile-app-development]]></category>
            <dc:creator><![CDATA[Grace Musungu]]></dc:creator>
            <pubDate>Sat, 11 Jan 2025 15:24:40 GMT</pubDate>
            <atom:updated>2025-01-13T06:41:06.897Z</atom:updated>
            <content:encoded><![CDATA[<h3>How I’m Using Google AppSheet and Data Analytics to Break the Illusion of Productivity in My Job Search</h3><h4>Ajira: A Mobile Data Analytics App for Job Search Insights</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Hzdmg0FiluPsoIxsw7QFQQ.png" /><figcaption>Image generated by the writer on Canva</figcaption></figure><p><strong>Ajira App</strong> is a <strong>data-driven mobile solution</strong> that I designed to help job seekers break free from the cycle of <strong>pseudo-productivity</strong> and take <strong>accountability</strong> for their job search journey. Built using <strong>AppSheet</strong>, the app provides users with <strong>actionable insights</strong> to optimize their job search process, track progress, and stay focused on meaningful tasks.</p><h4>Problem Statement</h4><p>What if you could visualize your own effort during the job search, allowing you to see the actual impact of your actions and, in turn, become more honest about your progress and the work required to land your next role?</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/799/1*ZyRk-65geQm4IBg9skKjyw.png" /></figure><h4>How does Pseudo Productivity Look like During a Job Search?</h4><p>Pseudo-productivity in the job search feels like you’re doing everything you <em>should</em> be doing but not getting anywhere. It’s like being on a treadmill — you’re moving, but you’re not going forward.</p><p>Imagine spending hours thinking about perfecting your resume, tweaking every word, but never hitting “send” on an application. Or you’re networking, sending connection requests to everyone, but not having any real conversations that lead to opportunities. It’s a cycle of feeling busy but not accomplishing anything tangible.</p><p>You might spend your day watching job-search videos or reading endless blog posts about how to ace interviews, yet still haven’t applied to any jobs. You’re gathering all this knowledge and getting ready, but not actually applying.</p><p>And before you know it, you’ve spent a whole day, months even<em>“working on your job search,”</em> but your application count is still at zero. Or you apply for just a couple of jobs and feel like you’ve done enough. Sounds Familiar?</p><p>That is the personal problem I was trying to solve with my app.</p><h4><strong>About Ajira</strong></h4><p>Ajira was born from my own experience navigating the challenges of job searching. I realized that the <strong>stress and emotional toll</strong> of the process often led me to <strong>unproductive behaviors</strong> — endlessly scrolling through job boards, fixating on rejections, or feeling stuck after being ghosted by recruiters. I’ve been there, and I know how easy it is to <strong>worry more about not having a job</strong> than taking <strong>accountable steps</strong> to improve your chances.</p><p>I built Ajira to help users(me) shift from <strong>passive frustration to active accountability</strong>. The app focuses on <strong>tangible actions</strong> — tracking job applications, identifying patterns in my job search behavior, and receiving reminders to stay consistent. By leveraging <strong>data analytics and automation</strong>, Ajira empowers users (me) to take charge of their(my) journey, make <strong>data-informed decisions</strong>, and build momentum in their(my) job search.</p><p>For me, Ajira isn’t just a productivity tool — it’s a <strong>job search accountability partner</strong>. It’s about turning <strong>frustration into progress</strong> and <strong>data into action</strong>, helping me regain control of my journey and focus on what truly matters.</p><p>The name is from the Swahili word “Ajira” which means employment.</p><h4>Building a Simple ETL pipeline</h4><p>To develop the Ajira app, I used <strong>Google AppSheet</strong>, a <strong>no-code extension of Google Sheets</strong>. I had originally built a job search tracker in Google Sheets, but I wanted more automation and visualization.</p><p>I needed a <strong>simple ETL pipeline</strong> where any data entered in the tracker would automatically update in the Ajira app and be instantly visualized. Using <strong>Google Sheets as the data source</strong> and <strong>AppSheet for transformation</strong>, I built a system that made my job search data <strong>interactive and actionable</strong> without manual updates.</p><p>In short, <strong>Google Sheets + AppSheet = a seamless ETL solution</strong> to stay on top of my job search journey.</p><p>I’ve organized the job search data into key columns:</p><ul><li><strong>Date Applied</strong></li><li><strong>Company</strong></li><li><strong>Role</strong></li><li><strong>Status</strong></li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/960/1*JX_wb4K_6dowlroVhnx2mA.png" /></figure><p>The <strong>Status column</strong> tracks my progress through different stages of the job application process. I’ve customized the status options to make it <strong>fun and relatable</strong>, reflecting my own experience.</p><p>Here’s a sneak peek at some of those status options:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/978/1*swGDg40NFj2P_iZltXnqfw.png" /></figure><p>Each time I update this tracker, the data flows automatically into the <strong>Ajira app</strong>, giving me a <strong>real-time overview</strong> of my job search progress.</p><h4>The KPIs I am Tracking</h4><p>My main pain point was pseudo-productivity, so I initially focused on tracking two key metrics: <strong>my daily application</strong> count and <strong>my application status.</strong> Secondary metrics, like the specific roles I applied for, are nice to have but not essential for this project.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/799/1*ZyRk-65geQm4IBg9skKjyw.png" /></figure><p>To track the KPI, the declined group should never outnumber the applied group. If that happens, it means I’m getting rejected faster than I’m applying, which could indicate slack on my part. So, every day when I sit at my desk, my goal is to ensure the difference between applied and declined is significant.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/366/1*-vpTl15YAfj3MUPXDiZ5zg.png" /></figure><p>I also added a separate page to showcase my dashboard summary for quick insights.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/799/1*2lIiYDyZTySQ_PJjeY_X5Q.png" /></figure><p>I’m already seeing a major difference in how I applied for jobs last year compared to this year. If I’m not putting in enough effort, the data shows it. This has made me more accountable. I can clearly see my actions and make adjustments, driving me to embrace the “if it is to be, then it is up to me” mindset.</p><h4>Final Remarks on the Project</h4><p>Yes, the job market may not be the best right now. But in this same market, some candidates are torn between two job offers, others are submitting their 30-day notice to move to their next role. What am I driving at?</p><p>You can either choose to sit back and accept that it’s difficult with no way out, or you can acknowledge the challenge, look inward, and take the necessary steps to overcome it. All the best in your job search :)</p><h4>Thoughts on Google Appsheet is it worth it?</h4><p>Yes, it’s worth it, but keep in mind that it’s more of a functional app than an aesthetically pleasing one. It’s a no-code app, so there are limited features. Mobile app development isn’t my specialty, so I didn’t mind that. My focus was on the visualizations, and it did exactly what I needed.</p><p>The chart options are also limited, and the visuals aren’t Power BI standard. But they get the job done. It’s functional and proves that you don’t need fancy graphs to communicate effectively.</p><p>The UI is basic, but it works for me. I wasn’t aiming for aesthetics — I prioritized functionality instead.</p><p>Remember, this is just a tool, the real work is done by an individual.</p><h4>What next? An update on Ajira?</h4><p>I plan to use this app for one more week to test the functionality further. I already have an exciting update lined up after that — I want to track my upskilling progress. Often, you get so caught up in applications that upskilling takes a backseat. Adulting, right? Haha, there’s always something else. I’ll share more about it later.</p><p>If you made it this far, thank you! Feel free to connect with me on <a href="https://www.linkedin.com/in/grace-musungu-1894b2171/">LinkedIn</a>, I share more about my projects and my Data Analytics journey there. oh, And I reply to messages :)</p><p>Have a great year!</p><h3>Thank you for being a part of the community</h3><p><em>Before you go:</em></p><ul><li>Be sure to <strong>clap</strong> and <strong>follow</strong> the writer ️👏<strong>️️</strong></li><li>Follow us: <a href="https://x.com/inPlainEngHQ"><strong>X</strong></a> | <a href="https://www.linkedin.com/company/inplainenglish/"><strong>LinkedIn</strong></a> | <a href="https://www.youtube.com/channel/UCtipWUghju290NWcn8jhyAw"><strong>YouTube</strong></a> | <a href="https://newsletter.plainenglish.io/"><strong>Newsletter</strong></a> | <a href="https://open.spotify.com/show/7qxylRWKhvZwMz2WuEoua0"><strong>Podcast</strong></a></li><li><a href="https://cofeed.app/"><strong>Check out CoFeed, the smart way to stay up-to-date with the latest in tech</strong></a> <strong>🧪</strong></li><li><a href="https://differ.blog/"><strong>Start your own free AI-powered blog on Differ</strong></a> 🚀</li><li><a href="https://discord.gg/in-plain-english-709094664682340443"><strong>Join our content creators community on Discord</strong></a> 🧑🏻‍💻</li><li>For more content, visit <a href="https://plainenglish.io/"><strong>plainenglish.io</strong></a> + <a href="https://stackademic.com/"><strong>stackademic.com</strong></a></li></ul><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=ea6d714d16eb" width="1" height="1" alt=""><hr><p><a href="https://ai.plainenglish.io/how-im-using-google-appsheet-and-data-analytics-to-break-the-illusion-of-productivity-in-my-job-ea6d714d16eb">How I’m Using Google AppSheet and Data Analytics to Break the Illusion of Productivity in My Job…</a> was originally published in <a href="https://ai.plainenglish.io/">Artificial Intelligence in Plain English</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[In my Villain Era- Kindly]]></title>
            <link>https://medium.com/@gracemutheumusungu/in-my-villain-era-kindly-3bf3c8210c3c?source=rss-dc9123776566------2</link>
            <guid isPermaLink="false">https://medium.com/p/3bf3c8210c3c</guid>
            <category><![CDATA[new-year]]></category>
            <category><![CDATA[productivity]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[creative-writing]]></category>
            <dc:creator><![CDATA[Grace Musungu]]></dc:creator>
            <pubDate>Fri, 03 Jan 2025 07:06:27 GMT</pubDate>
            <atom:updated>2025-01-03T07:06:27.526Z</atom:updated>
            <content:encoded><![CDATA[<p>I woke up thinking about my crush.</p><p>I know, right? Not exactly villain material. Blasting <em>That Part</em> by Lauren Spencer Smith at 4 a.m.? I should’ve been cranking some heavy metal or something fierce. But on my villain orientation day, I was singing along to:<br><em>The only way this is gonna hurt,<br>Is if we got old, and you were the one to go first,<br>So I’m wishing on elevens that we both meet up in Heaven…</em>🎶</p><p>We listen we don’t judge. No? haha</p><p>When my alarm rang at 4:29, I reached over to silence it, but I saw the label I’d set:<br><em>“Darling, don’t quit your daydream.”</em> 💖</p><p>Ah yes, my heart, my <em>overly sentimental self</em> at 4:29 in the morning, when the world is still pretending it’s not a bit of a mess.</p><p>I also have no idea why I felt the need to wake myself up at 2 a.m. last year just to double-check that the door was locked. Anxiety, much? I swear, 2024 was a lot. But aren’t we glad we made it through?</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*YW1pAbdCHHB5cnTimVapcw.jpeg" /></figure><p>But back to the alarms. I’m notorious for labeling them, and let me tell you, last year’s list was <em>something. </em>My favorites from last year were <em>“WAKE UP OR ELSE..”, “You’re Not Batman. You Need Sleep”</em> and <em>“Rise and Grind, or Just Rise. Whatever.”</em> I have a strange relationship with alarms. Sometimes I threaten myself, sometimes I encourage myself. But I chuckle every time I read my labels.</p><p>I digress. Ah yes, my villain origin story — I’ve had a rough holiday season. It’s that time of year when everyone seems to be winning at life, and you’re just… there. Watching. Wondering. Overthinking. I was beating myself up over everything I didn’t achieve last year — the job offers that didn’t pan out, the resolutions I forgot by February.</p><p>On the first day of this year, while riding the bus I had a thought that radicalized me. <strong><em>If it is to be, then it is up to ME!</em></strong></p><p>I said it out loud, probably loud enough for the person next to me to think I was insane, but it stuck. — <strong>If it is to be, then it is up to ME!</strong></p><p>If I am to be happy this year, think positively, and get myself out of this state, then it is up to me. And the inverse is also true, If it is to be a bad year then it is up to me. If I am to be with my crush haha I’m kidding. But wouldn’t it be great if it was up to me?</p><p>I’ve spent so much time questioning why things turned out the way they did. Took responsibility for some things. Some questions remain unanswered. And now? I’ve made up my mind. This year, I’m showing up. I’m just going for things.</p><p>Small steps, but big changes. For starters, I deleted all those time-sucking social media apps that were feeding my procrastination habit. I woke up early today. <em>Look at me, a whole new person!</em> Maybe by the end of this year, I won’t even recognize the me I am today. I want to progress, and I’m taking charge.</p><p>It won’t all be perfect. Heck, it might even get messy. But I won’t be here next year at this time, complaining about the same things. That’s a promise.</p><p>So my villain era is about locking in. Prioritizing, working towards the life I want. Taking action. Moving like someone who believes in themselves. Embarrassed to be seen trying? In this economy? Please stand up.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*mA-e2_qo2sr7TMWZTQeVaQ.jpeg" /></figure><p>And if you’re wondering what my crush is doing in this blog post — well, it’s because there are things about him I admire. Other than the fact that I think it was borderline rude of Shakespeare to leave this world without writing poems about him, he’s honestly a brilliant guy.</p><p>Cute eyes. Smart. Driven. Just goes for things. No second-guessing, no hesitation — he just takes action. And you know what? I could borrow a leaf from that book. Sometimes I’m too busy overthinking every step when what I really need to do is to make the jump. Just like him.</p><p>Maybe it’s not about the crush, but about seeing someone go for their dreams without the fear of failure holding them back. And maybe, just maybe, that’s the kind of energy I want to bring into this year.</p><p>That’s why thoughts of him keep sneaking in. Not necessarily because I want him, but because I want to be someone who just wakes up and goes for things too!</p><p>But if there is to be a wedding, consider this your official invitation haha :)</p><p>So, to anyone reading this and feeling like you’re not quite there yet — whether you’re dealing with unrequited crushes, failed resolutions, or random 2 a.m. existential crises, or you are feeling a little lost or a lot — <br><strong>Darling, don’t quit your daydream.</strong></p><p>Because sometimes, it’s the little things — like a well-labeled alarm — that keep us hopeful. And I hope you get the courage to enter your villain era despite the year you just had.</p><p>And maybe, just maybe, this year will surprise us both. But if it is to be, then it is up to you!</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*3aFWbX8UVsHDtFPTovlOJg.jpeg" /></figure><p>Happy New Year :)</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=3bf3c8210c3c" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[What is IFRS and Why is it Important — Finance Data Analysis]]></title>
            <link>https://medium.com/@gracemutheumusungu/what-is-ifrs-and-why-is-it-important-finance-data-analysis-97827d5b53cf?source=rss-dc9123776566------2</link>
            <guid isPermaLink="false">https://medium.com/p/97827d5b53cf</guid>
            <category><![CDATA[finance]]></category>
            <category><![CDATA[accounting]]></category>
            <dc:creator><![CDATA[Grace Musungu]]></dc:creator>
            <pubDate>Thu, 15 Aug 2024 08:17:28 GMT</pubDate>
            <atom:updated>2024-08-15T08:17:28.591Z</atom:updated>
            <content:encoded><![CDATA[<h3>What is IFRS and Why is it Important — Finance Data Analysis</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*0dVFdGxPGUyIqxYsernNyw.png" /></figure><p>Long time no blog post! Not anymore :) A while back I went on an IFRS rabbit hole on YouTube. I couldn’t help but notice how the subject of IFRS is not intuitive for beginners. But are you shocked? Accountants have this habit of assuming everything is intuitive to everyone. That is genius behavior if you ask me haha.</p><p>So I decided to write about it but also make it easy to remember and apply in your daily tasks as a Financial Data Analyst.</p><p><strong>IFRS</strong> stands for <strong>International Financial Reporting Standard.</strong> It’s a set of accounting rules and standards that determine how accounting events should be reported in your business’s financial statements.</p><p>Imagine you have a lemonade stand, and you’re really good at selling lemonade. Now, let’s say you want to open more lemonade stands in different neighborhoods. But to do that, you need to ask your friends or the bank for money.</p><p>Before they give you the money, they want to know how well your lemonade stand is doing. They ask you for a report that shows how much money you made, how much you spent on lemons and sugar, and how much money you have left.</p><p>Now, if everyone had their way of writing these reports, it would be really confusing! Some people might count things one way, and others might count them differently. This is where IFRS comes in.</p><p>It’s like a rulebook that tells everyone how to write these reports in the same way, no matter where they are in the world. So, whether your lemonade stand is in your neighborhood or on the other side of the world, everyone can understand your report and see how your business is doing.</p><p>Why is this important? Well, if everyone uses the same rules, it’s easier for your friends and the bank to trust your reports. They can compare your lemonade stand with others and decide if they want to give you money to grow your business. It’s all about being clear so everyone understands the same thing!</p><h4>What is the importance of IFRS?</h4><ol><li><strong>Global Consistency and Comparability:</strong> Imagine if you and your friend in another neighborhood both have lemonade stands, but you each keep track of your money differently. It would be hard for someone to compare how well your stands are doing. IFRS is like a rulebook that says, “Here’s how everyone should count and report their money.” This way, anyone can easily compare your stand to your friend’s stand, even if they’re in different neighborhoods or countries.</li><li><strong>Transparency:</strong> If you follow the rules in the IFRS rulebook, everyone can see how much money your lemonade stand is making, how much you’re spending, and how much profit you have left. It’s like making sure your lemonade recipe is easy to follow so people know exactly what they’re drinking. This honesty helps people trust your business.</li><li><strong>Facilitating International Investment:</strong> Let’s say you want to open a lemonade stand in a new country, and you need money to do it. If you use the same accounting rules (IFRS) that everyone else does, people in that new country will understand your financial reports. They’ll feel more comfortable giving you money because they can see how well you’re running your original lemonade stand.</li><li><strong>Regulatory Compliance:</strong> Some neighborhoods or countries might require that businesses to follow specific rules for reporting their money. By using IFRS, you’re making sure you’re following the rules everywhere you want to sell lemonade. This keeps you out of trouble and ensures you can keep growing your lemonade empire.</li><li><strong>Improved Efficiency:</strong> When you follow IFRS, you’re using the same set of rules each time you count your money. This makes it easier and faster to keep track of everything because you’re not trying to juggle different ways of counting. It’s like using the same lemonade recipe every time — it just makes things smoother and more reliable.</li><li><strong>Enhanced Credibility:</strong> If your lemonade stand uses IFRS, people will see that you’re serious about your business. They’ll trust that your financial reports are accurate, which makes them more likely to lend you money, buy your lemonade, or even partner with you to open more stands. It’s like having a great reputation — everyone wants to work with you because they know you’re trustworthy.</li></ol><p>In summary, IFRS is important because it provides a globally accepted framework that enhances the clarity, consistency, and reliability of financial reporting, ultimately supporting better decision-making and fostering trust in the global financial markets.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=97827d5b53cf" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Business Analytics: Market Basket Analysis -Full Project. Part 1]]></title>
            <link>https://medium.com/@gracemutheumusungu/business-analytics-market-basket-analysis-full-project-part-1-e4b837c33135?source=rss-dc9123776566------2</link>
            <guid isPermaLink="false">https://medium.com/p/e4b837c33135</guid>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[business]]></category>
            <category><![CDATA[business-analysis]]></category>
            <dc:creator><![CDATA[Grace Musungu]]></dc:creator>
            <pubDate>Mon, 08 Apr 2024 17:35:53 GMT</pubDate>
            <atom:updated>2024-04-08T17:35:53.412Z</atom:updated>
            <content:encoded><![CDATA[<h4>Objective and Requirement Gathering</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*oj3TAtTDrVr0mLtjb65CAg.png" /></figure><p><strong>An important disclaimer.</strong></p><ol><li>Every company/organization has a different framework that they use when it comes to documentation. Please note that. There is no right or wrong way, <em>(or maybe there is. Actually, there is. But find peace in knowing this is not the wrong way. haha)</em></li><li>While I was part of this project, the data used here is <strong>not</strong> the same. This series aims to provide insight on how to conduct day-to-day Business Analytics tasks. The names have also been altered. <em>(for real though you wouldn’t think I would use the company’s data here no?)</em></li></ol><h4>Case Study</h4><p>Keto<em>(Fictional name) </em>is a restaurant that provides healthy food options. They have a website and an app where their clients order food for delivery, though you can still walk in or even dine in.</p><p>They wanted a market basket feature added on both their website and mobile app.</p><blockquote>(sometimes the brief is just a short paragraph so it is up to you as a Business Analyst to dig deeper and ask the right questions to the stakeholders)</blockquote><p>A <strong>market basket</strong> is what people buy together, like peanut butter and jelly or milk and cereal. It helps stores understand what customers like to buy and how they can make shopping easier for everyone! oh and make more revenue. <em>(mostly this)</em></p><h4>Project Objectives</h4><p><strong>Before the interview</strong></p><p>I had established the goal of the interview which was to gain a clear understanding of their expectations and requirements for implementing the market basket feature on their website and app.</p><p>I had prepared questions before the interview, and I sent in the questions for their perusal beforehand. This was to give them time to reflect on their needs and for the smooth running of the interview. I also followed up to ensure they went through the questions.</p><p><strong>During the interview</strong></p><p>After a long interview with the stakeholders, the objectives were narrowed down. At this stage, also listen to what they are not saying. Why? Sometimes people don’t know what they want. Ask questions, then ask more questions. Do not leave any stone unturned. Repeat their answers to them as well :)</p><p>Safe to say the goal of the interview was met. this is the goal I was going for:</p><blockquote><em>“To make sure we’re all on the same page about what we want to achieve with the market basket feature on the website, including how it should improve user experience, increase sales, and match the overall Keto’s business goals.”</em></blockquote><h4>Requirement Gathering</h4><p>These were some of the questions that were asked during the interview. Divided into their respective categories. You don’t have to put them in categories, I just like it that way for easier navigation.</p><p><em>Note that most questions you will prepare before an interview will end up acting like a guide.</em></p><p><strong>Objective Clarification</strong></p><ul><li>What do we want to achieve by adding the market basket feature to the website?</li><li>How can the market basket feature make ordering easier and boost sales?</li></ul><p><strong>Scope Definition</strong></p><ul><li>What specific features should be included in the market basket tool?</li><li>Are there any limits on what we can do, like time or money?</li></ul><p><strong>User Experience Enhancement</strong></p><ul><li>How do we want the market basket tool to make ordering better for customers?</li><li>Are there any ideas about how it should look or work?</li></ul><p><strong>Sales Impact Assessment</strong></p><ul><li>How do we think the market basket tool will help sell more products</li><li>What should we look at to see if it’s working?</li></ul><p><strong>Alignment with Business Goals</strong></p><ul><li>How does adding the market basket feature help our business goals</li><li>What things can we measure to make sure it’s helping? (success metrics)</li></ul><p><strong>User Feedback and Testing</strong></p><ul><li>Do we have any thoughts from customers about what they want in the market basket tool?</li><li>How can we check if the market basket tool is what customers need?<em> (I put this here, but mainly it is for my team)</em></li></ul><p><strong>Implementation Timeline and Resources</strong></p><ul><li>When do we want to have the market basket feature ready?</li><li>Do we have enough people and tools to make it happen? <em>(This is also a question for my team)</em></li></ul><p><strong>Risk and Mitigation Strategies (these are questions for my team as well)</strong></p><ul><li>What could go wrong with adding the market basket feature, and how can we stop it?</li><li>What can we do if something unexpected happens during the process?</li></ul><p>These questions are simplified ensuring that stakeholders with non-technical backgrounds can easily understand and contribute to the requirement-gathering process.</p><p>As we progress through the project, you will see how the communication shifts when communicating with the tech team. That is the whole essence of a Business Analyst, being the bridge between the tech team and the stakeholders and meeting their needs accordingly.</p><p><strong>After the Interview</strong></p><p>Business Analytics has a lot of documentation. So after the meeting, I put our meeting points together and shared them with the stakeholders for approval. A few changes were made. I then shared it with my team.</p><h4>In a nutshell</h4><ol><li>The requirement-gathering technique I used here was interviewing</li><li>I have shared my process before, during, and after the interview</li><li>I have shared the objective and the goal of the interview.</li></ol><h3>What Next?</h3><p>I will tackle the Business Requirements Document in my next blog. How I went about it and the format I used.</p><p>If you have any questions you can leave them in the comment section and I will get back to you :)</p><p>You can connect with me on <a href="https://www.linkedin.com/in/grace-musungu-1894b2171/">LinkedIn</a> and <a href="https://twitter.com/Musungutt">Twitter.</a> You can also reach me via my email gracemussungu@gmail.com.</p><p>See you in my next one!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=e4b837c33135" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Performance Marketing Analysis Using Google Data Studio (Looker Studio)]]></title>
            <link>https://ai.plainenglish.io/performance-marketing-analysis-using-google-data-studio-looker-studio-0a75c60e0a72?source=rss-dc9123776566------2</link>
            <guid isPermaLink="false">https://medium.com/p/0a75c60e0a72</guid>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[marketing-strategies]]></category>
            <category><![CDATA[performance-marketing]]></category>
            <category><![CDATA[marketing]]></category>
            <dc:creator><![CDATA[Grace Musungu]]></dc:creator>
            <pubDate>Mon, 19 Feb 2024 10:56:55 GMT</pubDate>
            <atom:updated>2024-02-20T17:22:51.884Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="Google Data Studio Dashboard for a job board" src="https://cdn-images-1.medium.com/max/1024/1*3-Ug7m62SpAuIcltIOi98Q.png" /></figure><p>Long time no blog!</p><p>If you understand the gist of performance marketing and you just want to interact with the above dashboard, skip to the end of the article and you will find a link to the interactive dashboard.</p><p>However, if you want to know how you go about Performance Marketing, I suggest you read the whole article. By the end of the article, you will:</p><ol><li>Have an understanding of what performance marketing is</li><li>Know how to interpret data insights and suggest areas for improvement</li><li>Learn how to leverage data for decision-making</li></ol><h4>What is Performance Marketing?</h4><p>Imagine you have a lemonade stand.</p><p>Performance marketing is like figuring out the best ways to sell your lemonade. You might make colorful signs <em>(social media ads, email marketing, etc)</em> to catch people’s attention or offer a special deal like buy one, get one free. Then, you keep track <em>(web/social media analytics)</em> of how many cups of lemonade you sell and which strategies<em> (Campaign management)</em> work the best.</p><p>If you sell a lot of lemonade, that’s a good performance! If not, you try different things to see what works better next time. It’s like a game of figuring out how to sell the most lemonade and make the most money!</p><p><strong>Note that </strong>Performance marketing campaigns are <strong>highly data-driven</strong> and rely on analytics and tracking tools to measure and optimize results continually.</p><h3>How Performance Marketing Works</h3><p>I’ll illustrate the concept using the lemonade stand analogy and then connect it to the project I completed using job board data. Additionally, I’ll share the insights I derived from the analysis. Let’s revisit the dashboard to delve deeper into the data.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*3-Ug7m62SpAuIcltIOi98Q.png" /></figure><h4>1. Goal setting</h4><p>In <strong>our</strong> <strong>lemonade stand</strong>, the goal of the business could be to increase revenue. So the marketing goal could be something like selling 100 cups of lemonade cups a day. <strong>Note that </strong>every marketing activity should be aligned with the overall business goal.</p><p><strong>My project: </strong>the goal was to increase the conversion rate by 15% by the end of the campaign. <em>(the goal should always be specific so that at the end you can measure the campaign&#39;s success)</em></p><h4>2. Target audience</h4><p>In <strong>our</strong> <strong>lemonade stand,</strong> You identify your target audience based on factors like location <em>(near a park or busy street)</em>, weather <em>(hot and sunny day),</em> and potential customers <em>(families with kids, joggers, etc.).</em></p><p><strong>My project:</strong> The job board I utilized is renowned in the Middle East and North Africa region. I specifically focused my targeting efforts on job seekers located in the Middle East.</p><h4>3. Campaign creation</h4><p>In <strong>our</strong> <strong>lemonade stand,</strong> You create eye-catching signs and posters to attract customers passing by. You also offer a special promotion, like buy one, get one free, to entice people to stop at your stand.</p><p><strong>My Project: </strong>I assumed that the campaign had already been created. In the real world, this would entail social media advertising and offers on the subscription price to entice people to register on the job board. Or even discounts for referring other users.</p><h4>4. Tracking and analytics</h4><p>Do you remember the goal we set for <strong>our</strong> <strong>lemonade stand</strong> of selling 100 cups of lemonade per day? Throughout the day, you keep track of how many cups of lemonade you sell and where your customers are coming from. For example, you might notice that more people buy lemonade when you offer a discount deal.</p><p><strong>My project: </strong>Throughout the campaign, I kept track of how many job seekers were interacting with our campaign. As shown in the dashboard, you can see the most frequently searched job titles and the leading job industries.</p><p>Additionally, when interacting with the dashboard, you can check how different people found out about the campaign. Whether it was through paid ads, organic traffic, or referrals. <em>A link to the dashboard will be provided at the end of the article.</em></p><h4>5. Optimization</h4><p>In<strong> our lemonade stand,</strong> based on your observations, you can decide to focus more on promoting the discount deal by mentioning it to every customer. You can also move your stand to a busier location in the park where more people are walking by.</p><p><strong>My project: </strong>based on the data, I could refine my messaging and retarget the countries that are bringing more traffic, focusing on the leading job titles that the job seekers are showing more interest in.</p><p>The caveat is that there is still potential for improvement in countries with lower traffic volumes. To address this, I plan to experiment with different messaging strategies and closely monitor the buyer’s journey on the website.</p><p>By tracking their interactions, I can pinpoint where potential customers are dropping off and implement enhancements to improve their experience.</p><h4>6. Conversion tracking</h4><p>In <strong>our lemonade stand,</strong> you can keep track of which promotions are driving the most sales. For example, you might find that customers who hear about the discount deal are more likely to buy multiple cups of lemonade.</p><p><strong>My project: </strong>From the dashboard, it’s evident that organic traffic has been the primary driver of customers to the job board. However, there’s a slight imbalance between negative and positive conversions, indicating an opportunity for improvement.</p><p>This shows the importance of tracking ongoing campaigns. To enhance performance, we could intensify our focus on SEO to increase visibility. Additionally, refining our target audience for paid ads and implementing referral discounts could help bolster other traffic sources.</p><p>When interacting with the dashboard, you can filter according to the insights you wish to see and see which countries in the Middle East region had the most conversions and the least.</p><h4>7. Performance evaluation</h4><p>For <strong>our lemonade,</strong> at the end of the day, you count up how many cups of lemonade you sold and compare it to your goal of 100 cups. If you exceeded your goal, you analyze what worked well <em>(e.g., discount deal, prime location)</em> and plan to use similar strategies in the future.</p><p>If you fall short of your goal, you identify areas for improvement <em>(e.g., better signage, different promotions)</em> to try next time.</p><p><strong>My project: </strong>From the dashboard, it’s evident that there are areas for improvement, such as refining our client targeting, soliciting, and implementing feedback.</p><p>Additionally, identify peak application times throughout the day, week, or month, and capitalize on high-traffic periods on our website. We can also analyze user activity and strategically deliver targeted ads.</p><p>Your input on the dashboard is valuable; feel free to <strong>share your thoughts on areas where we can enhance our strategies. </strong>There are no wrong answers, and I look forward to gaining insights from your feedback.</p><p><strong>Summary</strong></p><p>In summary, performance marketing is a game of figuring out how to sell the most lemonade <em>(or any service/product)</em> and make the most revenue!</p><p>It involves setting goals, targeting the right audience, creating compelling offers, tracking sales and customer behavior, optimizing promotions based on data, and evaluating performance to improve future marketing efforts.</p><h4>Link to the dashboard</h4><p>Click this link to interact with the dashboard — <a href="https://lookerstudio.google.com/reporting/a94dd51b-498b-40d1-afd7-75960e01c4d5">https://lookerstudio.google.com/reporting/a94dd51b-498b-40d1-afd7-75960e01c4d5</a></p><p>whew! That was a long one. Thank you for reading. You can connect with me on <a href="https://www.linkedin.com/in/grace-musungu-1894b2171/">LinkedIn</a> to check on more updates on projects. Additionally, you can connect with me on <a href="https://twitter.com/Musungutt">Twitter</a> for tech banter haha.</p><p>Have an amazing week!</p><h3>In Plain English 🚀</h3><p><em>Thank you for being a part of the </em><a href="https://plainenglish.io/"><strong><em>In Plain English</em></strong></a><em> community! Before you go:</em></p><ul><li>Be sure to <strong>clap</strong> and <strong>follow</strong> the writer ️👏<strong>️️</strong></li><li>Follow us: <a href="https://twitter.com/inPlainEngHQ"><strong>X</strong></a><strong> | </strong><a href="https://www.linkedin.com/company/inplainenglish/"><strong>LinkedIn</strong></a><strong> | </strong><a href="https://www.youtube.com/channel/UCtipWUghju290NWcn8jhyAw"><strong>YouTube</strong></a><strong> | </strong><a href="https://discord.gg/in-plain-english-709094664682340443"><strong>Discord</strong></a><strong> | </strong><a href="https://newsletter.plainenglish.io/"><strong>Newsletter</strong></a></li><li>Visit our other platforms: <a href="https://stackademic.com/"><strong>Stackademic</strong></a><strong> | </strong><a href="https://cofeed.app/"><strong>CoFeed</strong></a><strong> | </strong><a href="https://venturemagazine.net/"><strong>Venture</strong></a></li><li>More content at <a href="https://plainenglish.io/"><strong>PlainEnglish.io</strong></a></li></ul><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=0a75c60e0a72" width="1" height="1" alt=""><hr><p><a href="https://ai.plainenglish.io/performance-marketing-analysis-using-google-data-studio-looker-studio-0a75c60e0a72">Performance Marketing Analysis Using Google Data Studio (Looker Studio)</a> was originally published in <a href="https://ai.plainenglish.io/">Artificial Intelligence in Plain English</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How to Create a Data-Driven Marketing Campaign]]></title>
            <link>https://ai.plainenglish.io/how-to-create-a-data-driven-marketing-campaign-2449585b9ac9?source=rss-dc9123776566------2</link>
            <guid isPermaLink="false">https://medium.com/p/2449585b9ac9</guid>
            <category><![CDATA[marketing]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[campaign]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[marketing-strategies]]></category>
            <dc:creator><![CDATA[Grace Musungu]]></dc:creator>
            <pubDate>Wed, 10 Jan 2024 11:03:16 GMT</pubDate>
            <atom:updated>2024-01-12T04:18:44.396Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/500/1*Gq8Dw_Dxtnh1kOv20gFDMA.png" /></figure><p>Data-driven marketing is a term that has been thrown around for a long time. It is everywhere, in our board rooms and job descriptions. Using data to have a competitive advantage is not a new concept, but talk is cheap, most organizations do not leverage the power of their data.</p><h4>Elephant in the room</h4><p>As someone with a digital marketing background, having worked on multiple campaigns, I can confidently say that <strong>most</strong> ‘data-driven’ marketing campaigns are reactive and not strategic. Data is applied after the campaigns have been executed, instead of being incorporated at the very beginning.</p><p>Result? Organizations end up with great expensive campaigns that never get to the intended audience. How can this be avoided? Data. If we utilized the data that is available, and combined it with the business goals we would have great data-driven marketing campaigns.</p><p>Someone said and I quote “Don’t be afraid to question the status quo and try something new especially if the data supports you”</p><h4><strong>The project scope</strong></h4><p>Data first thinking starts with setting the campaign goals and understanding the ‘why’ so that as an analyst you know which data to analyze.</p><p>My fictional company is called Company A. <em>(I know I could have been more creative with the name.) </em>The company is in retail. <strong>The business goal</strong> of the company is to increase sales hence boosting the revenue. The marketing team is tasked with coming up with ways to achieve this.</p><h4>Process</h4><p>So as an analyst, if the goal is revenue, that is what I’d be looking for in the data. The business goal for that time can help you figure out the columns that are necessary for a specific campaign. In this dataset, I focused on the customer’s annual income and their existing spending score.</p><p><strong>Why does that metric matter? </strong>To increase revenue, the customers must buy from us. Therefore, I need to understand the spending habits of the customers we have so that I can come up with an effective campaign. The trick is to let the data lead the way. Don’t impose on the data.</p><h4>Findings</h4><p>After performing a customer segmentation using Python, here is what I came up with.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/502/1*Wn1bT4w2EG1u0SyMJ0DtjQ.png" /><figcaption>KMeans Algorithm for clustering</figcaption></figure><p>I clustered the customers according to their annual income and spending scores. From the graph, you can notice;</p><ol><li>customers with a low annual income(blue) spent less in our businesses.</li><li>But also some customers with a low income had a high spending score. (pink)</li><li>High-income earners were also divided into the same, the ones who spent a low amount (Green) and the ones who spent a lot (Yellow)</li></ol><p>To increase revenue, you have to create a platform where the ones spending low can comfortably spend, and the high spenders can spend even more.</p><h4><strong>The Marketing Campaign</strong></h4><p>I would propose offering deals. Slashing prices on select times <em>(again you can use data to determine this)</em> That way it evens out the spending ground for all teams. I know you are wondering, that’s it? Yes, marketing campaigns do not have to be complicated, they just need to serve the purpose.</p><p>But the work that will go behind the scenes will be a lot. Because copywriters, social media managers, etc have to tap into their creative juices to create the content. The offer deals message must reach the intended audience. It’s a team effort.</p><p>At this stage, you should also discuss the metrics you will also use to measure the success of your campaign</p><h4>That is not all Manage your expectations!</h4><p>The offers have to make sense to the business finances. Budgeting is key. Do you ever have a mindblowing campaign and then your finance team says no?</p><p>Lucky you if you have me on your team I can do a quick sensitivity analysis since I am a sucker for finance. Lucky you I don’t gatekeep information so this is what a sensitivity analysis would look like in simple terms.</p><p>You don’t need to know how to do it, you can suggest it in the meeting. You will appear very smart haha. In fact I will give you two good points you can raise during your marketing meeting. It will show that you are thorough.</p><ol><li><strong>Sensitivity analysis</strong> is basically figuring out how sensitive your profit is to changes in the price of your product. It is exploring how your profit reacts when you adjust one factor while keeping everything else the same. Like in our case, the prices since we are going to give offers.</li><li><strong>Scenario analysis. </strong>Unlike sensitivity analysis, which adjusts one factor, this looks at how different factors could interact and affect the overall success of your marketing campaign. You are trying to be ready for various possibilities and outcomes. It is just a way of thinking about the future.</li></ol><p>and your last talking point and a very important part of a campaign that goes the offer deals way.</p><h4>Not everyone is going to jump on your offers and it is okay</h4><p>Let’s be real not every customer is going to purchase an item because of the offer. And not every item should be on offer. So you have to be very realistic with your KPIs. Since I am in the mood for oversharing, I will give you my go-to method to know how to measure campaigns effectively.</p><p>There is something in the finance world called <strong>the Pareto Analysis. </strong>Also known as<strong> the law of the few </strong>or the<strong> 80/20 rule. </strong>It helps marketers pinpoint the most effective items and put those on sale.</p><p>The principle implies that 80% of sales will generally result from 20% of customers. By concentrating on the few elements that bring more revenue, marketers can optimize their approach, ensuring a strategic and targeted campaign that resonates effectively through compelling offers.</p><p>So you can carry out the analysis, or just suggest it to your team. Either way, you will help the team.</p><h4>Your campaign is live! What next?</h4><p>Go through the goals you set, and the metrics, conduct testing, and REPORT on ROI. Repeat and improve on your next campaign</p><p>Customer segmentation is a great tool to cluster your customers to get a better view of how you can best serve and reach them. You can use it as a stand-alone or a starting point to do your data research. Just don’t go into a rabbit hole.</p><h4>Conclusion</h4><p>Marketing campaigns don’t have to be complicated, they just have to serve the purpose. You can either work hard or use data and work smart. Why? because numbers don’t lie. So the next time you are called in to defend your ideas, remember talk is cheap, show them the data. Without data, everything is an opinion. And who wants to run their business on an opinion?</p><p>I worked on this project — using customer segmentation to come up with a data-driven marketing campaign. I used KMeans as the Machine Learning algorithm, let me know in the comments if you are interested in the code.</p><p>You can connect with me on <a href="https://www.linkedin.com/in/grace-musungu-1894b2171/">LinkedIn</a> for data content, <a href="https://twitter.com/Musungutt">Twitter</a> for the banter and you can also check out my <a href="https://www.youtube.com/channel/UC0oYus7MV2QclGZInG1YO7g">YouTube channel</a> for data content.</p><p>Have a great week ahead!</p><h3>In Plain English 🚀</h3><p><em>Thank you for being a part of the </em><a href="https://plainenglish.io/"><strong><em>In Plain English</em></strong></a><em> community! Before you go:</em></p><ul><li>Be sure to <strong>clap</strong> and <strong>follow</strong> the writer ️👏<strong>️️</strong></li><li>Follow us: <a href="https://twitter.com/inPlainEngHQ"><strong>X</strong></a><strong> | </strong><a href="https://www.linkedin.com/company/inplainenglish/"><strong>LinkedIn</strong></a><strong> | </strong><a href="https://www.youtube.com/channel/UCtipWUghju290NWcn8jhyAw"><strong>YouTube</strong></a><strong> | </strong><a href="https://discord.gg/in-plain-english-709094664682340443"><strong>Discord</strong></a><strong> | </strong><a href="https://newsletter.plainenglish.io/"><strong>Newsletter</strong></a></li><li>Visit our other platforms: <a href="https://stackademic.com/"><strong>Stackademic</strong></a><strong> | </strong><a href="https://cofeed.app/"><strong>CoFeed</strong></a><strong> | </strong><a href="https://venturemagazine.net/"><strong>Venture</strong></a></li><li>More content at <a href="https://plainenglish.io/"><strong>PlainEnglish.io</strong></a></li></ul><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=2449585b9ac9" width="1" height="1" alt=""><hr><p><a href="https://ai.plainenglish.io/how-to-create-a-data-driven-marketing-campaign-2449585b9ac9">How to Create a Data-Driven Marketing Campaign</a> was originally published in <a href="https://ai.plainenglish.io/">Artificial Intelligence in Plain English</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Difference between an Accountant and a Financial Analyst]]></title>
            <link>https://wire.insiderfinance.io/difference-between-an-accountant-and-a-financial-analyst-b404ad90087a?source=rss-dc9123776566------2</link>
            <guid isPermaLink="false">https://medium.com/p/b404ad90087a</guid>
            <category><![CDATA[finance-and-banking]]></category>
            <category><![CDATA[finance]]></category>
            <category><![CDATA[accounting]]></category>
            <dc:creator><![CDATA[Grace Musungu]]></dc:creator>
            <pubDate>Mon, 13 Nov 2023 15:21:31 GMT</pubDate>
            <atom:updated>2023-12-10T18:36:03.448Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*9IlyPJzZrdrFsEGbzL2mBQ.png" /><figcaption>Image generated using Canva</figcaption></figure><p>If I had a dollar every time I told someone I do Financial analysis and they went <em>“Oh so like an accountant?” </em>honestly I wouldn’t make much haha. Maybe close to 100$ in 9 months. So I decided I would pen down this article since no one is paying me to explain. Next time someone asks, I will just send the link. And we can all enjoy lunch!</p><p>Nothing explains the world of finance better than a simple lemonade stand. I have overused this analogy but as the saying goes <em>“If it works don’t touch it.”</em> Today is no different.</p><p>Imagine you have a lemonade stand and want to ensure you’re doing well with your money.</p><p>An accountant is like a superhero who keeps track of all the money you get from selling lemonade and all the money you spend on lemons, sugar, and cups. They prepare the reports after the close of an accounting period eg, on a monthly, quarterly, or annual basis.</p><p>Now, a financial analyst is like a detective who helps you figure out how to make even more money with your lemonade stand. They look at the big picture and think about things like whether you should sell your lemonade at a higher price, or if you should try selling it in different places. They use their special analytical skills to give you ideas on how to grow your lemonade business and make it even more successful.</p><p>So, while the accountant helps you keep track of your money, the financial analyst helps you come up with smart plans to make even more money and make your lemonade stand the best in town!</p><p>In simpler terms, accountants keep track of <strong>past and present</strong> money stuff, they focus on recording and organizing all the financial transactions that have happened, making sure everything adds up correctly.</p><p>Financial analysts, on the other hand, use that information to plan for the <strong>future</strong> and make the business even better. They are like the strategists. They use the information provided by accountants to analyze trends, make forecasts, and come up with ideas on how to improve the financial health of a business.</p><p>They <strong>may</strong> also help in making decisions about investments, pricing strategies, and overall financial planning.</p><blockquote>Accountants tell us <strong>where we are coming from</strong> and Finance analysts tell us <strong>where we are going.</strong> Both are important.</blockquote><p>So, it’s helpful for financial analysts to understand the language of accounting and the details accountants deal with to make well-informed decisions and recommendations. But together they make a dream team!</p><p>The world of finance and analytics is so broad and I will discuss that in future articles and videos including what it takes to be a Finance Analyst and the tools you need.</p><p>I started a <a href="https://www.youtube.com/@InShort--">YouTube channel</a> focused on making data simple for everyone. I leverage the power of storytelling to break down complex data concepts into simple concepts that are easy to understand and apply.</p><p>I will be uploading Finance analysis content on the channel you can subscribe and turn notifications on to be notified when there is a new video. You can also connect with me on <a href="https://twitter.com/Musungutt">X (Twitter)</a> and <a href="https://www.linkedin.com/in/grace-musungu-1894b2171/">LinkedIn</a> for other updates.</p><p>Have an amazing week!</p><h4>A Message from InsiderFinance</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/301/0*10x5_2smmKq8oIlf.png" /></figure><p>Thanks for being a part of our community! Before you go:</p><ul><li>👏 Clap for the story and follow the author 👉</li><li>📰 View more content in the <a href="https://wire.insiderfinance.io/">InsiderFinance Wire</a></li><li>📚 Take our <a href="https://learn.insiderfinance.io/p/mastering-the-flow">FREE Masterclass</a></li><li><strong>📈 Discover </strong><a href="https://insiderfinance.io/?utm_source=wire&amp;utm_medium=message"><strong>Powerful Trading Tools</strong></a></li></ul><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=b404ad90087a" width="1" height="1" alt=""><hr><p><a href="https://wire.insiderfinance.io/difference-between-an-accountant-and-a-financial-analyst-b404ad90087a">Difference between an Accountant and a Financial Analyst</a> was originally published in <a href="https://wire.insiderfinance.io/">InsiderFinance Wire</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Why I started a Data Youtube channel]]></title>
            <link>https://medium.com/@gracemutheumusungu/why-i-started-a-data-youtube-channel-0dff9853b91c?source=rss-dc9123776566------2</link>
            <guid isPermaLink="false">https://medium.com/p/0dff9853b91c</guid>
            <category><![CDATA[data]]></category>
            <category><![CDATA[funny]]></category>
            <category><![CDATA[youtuber]]></category>
            <category><![CDATA[youtube]]></category>
            <category><![CDATA[data-science]]></category>
            <dc:creator><![CDATA[Grace Musungu]]></dc:creator>
            <pubDate>Tue, 07 Nov 2023 23:08:46 GMT</pubDate>
            <atom:updated>2023-11-07T23:08:46.393Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/500/1*9ad3Ggt3VsNH24raJqKCJw.png" /></figure><p>When I was new to Data Analysis, I struggled to follow through with most concepts. Most of the “beginner-friendly” tutorials were not beginner-friendly. So many people quit because the journey was <em>“hard.”</em> I decided to make the journey easier for someone else by making Data simple for everyone.</p><p>So I started a data channel called <a href="https://www.youtube.com/watch?v=k5QEa1rJ1Us"><strong>In Short.</strong></a><strong> </strong>When I was starting I’d watch some tutorials and mumble “So <strong>in short</strong> <em>huyu anatry kusema</em>?” — what is the instructor saying?</p><p>Being a beginner in any tech field will forever be funny to me. Constantly wondering why Patel’s code is working on YouTube but not working on your computer haha. You rush to StackOverflow only to find that your problem was asked 2 years ago and no one cared to respond.</p><p>A week later you realize the error was because you wrote <em>“import pd as pandas” — </em>I hope the person who did this doesn’t read this blog.</p><p>ChatGpt wasn’t there when I started in case you are wondering. And when it was made available, there was so much hype around it and it was hard to find it available for use. This was a dark time because one-half of the population was trying to find solutions to their code, and the other half was asking it to <em>“write a poem about the blue sky.”</em></p><p>One night, during my game developer era, after successfully developing my number-guessing game, I got on a call with a friend to show off. It was a requirement for everyone who visited me during that period to play that game. I will not talk about the first time I made an area calculator haha. I was a whole dev ready to apply for GDE. I digress.</p><p>Most times, I would consume complex concepts and then later at night rewrite them in my one-note app in the simplest way. That way, it was easy to understand. I love storytelling so I would use that. During group calls, I would then explain the same concepts to my team members. Here is a snippet of how I tried to explain Data Structures in November last year.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*GOigxQ9Vc_8zPQRh3QCjqQ.png" /></figure><p>In case it is not clear here is the definition I wrote. <em>“Think of it as your closet. You arrange your clothes according to functionality and you can pick </em><strong><em>(access)</em></strong><em> clothes and pair </em><strong><em>(modify) </em></strong><em>them according to where you are going. Data structures allow us to organize, store, and manage data for efficient access and modification.</em></p><p>The goal is not to cram the dictionary definition, the goal is to understand. And that is what I aim to do. Leveraging the power of storytelling to explain Data concepts. As much as my journey was not easy, I wouldn’t take anything away from it. But I can make it a bit simple for someone else.</p><p>Of course, you will not learn Python in 15 minutes from the channel <em>(laughs in beginner scams and other short stories). </em>We are focused on mastering the skill as opposed to a time frame — <em>Quote inspired by Chepsi</em></p><p>Now that I have grown from wondering why the code is not working, to wondering why it worked the first time, I would like to be part of your data journey. And you part of mine.</p><p>You might not remember everything from my videos, but you will remember how I made you feel. And each time you click on any of my videos, I hope you always feel like you have what it takes to pursue a data career. My goal is not to use big words, my goal is to be understood.</p><p>Whether you are looking to transition to a data career, you already transitioned, or you are looking to land a new role, there will be something for you. I wanted to add there will be banter, but what if I start therapy and they fix me, and my humor disappears? haha</p><p>I’m here for it all. Your highs and lows. I will also share my journey. The good and the lessons I learned along the way. This is the story before the glory.</p><p>That song <a href="https://www.youtube.com/watch?v=cTxkYFv036A">Kesho- by Bridget Blue</a> hits differently when you only have 8 subscribers, so <a href="https://www.youtube.com/watch?v=k5QEa1rJ1Us"><strong>In Short</strong></a><em> (gerrit?</em>) <a href="https://www.youtube.com/watch?v=k5QEa1rJ1Us">subscribe to my channel </a>haha. You can also connect with me on <a href="https://www.linkedin.com/in/grace-musungu-1894b2171/">LinkedIn</a> for the Data analysis challenges that I do, and on <a href="https://twitter.com/Musungutt">Twitter </a>for the banter.</p><p>Have an amazing week. Rooting for you!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=0dff9853b91c" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>