<?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 Ufuoma Agwaye on Medium]]></title>
        <description><![CDATA[Stories by Ufuoma Agwaye on Medium]]></description>
        <link>https://medium.com/@ufuomaagwaye?source=rss-30892f981c36------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*YjC8skWibqVQ5QJvrHbAtA.jpeg</url>
            <title>Stories by Ufuoma Agwaye on Medium</title>
            <link>https://medium.com/@ufuomaagwaye?source=rss-30892f981c36------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Fri, 20 Nov 2026 09:00:43 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@ufuomaagwaye/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[Why AI Won’t Replace Data Analysts: The Irreplaceable Value of Human Business Thinking]]></title>
            <link>https://medium.com/@ufuomaagwaye/why-ai-wont-replace-data-analysts-the-irreplaceable-value-of-human-business-thinking-f8d72aeb7ee4?source=rss-30892f981c36------2</link>
            <guid isPermaLink="false">https://medium.com/p/f8d72aeb7ee4</guid>
            <category><![CDATA[problem-solving-skills]]></category>
            <category><![CDATA[business-intelligence]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[artificial-intelligence]]></category>
            <category><![CDATA[analytical-thinking]]></category>
            <dc:creator><![CDATA[Ufuoma Agwaye]]></dc:creator>
            <pubDate>Tue, 13 Jan 2026 02:53:43 GMT</pubDate>
            <atom:updated>2026-01-13T02:53:43.401Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Obtp_OD3QJTx6RbGF8sAbw.png" /></figure><p>Picture this: An AI system processes 10 million customer records in 30 seconds, identifies 47 statistical patterns, and generates a beautiful dashboard showing that customer churn increased by 23% in the Northeast region. Impressive, right?</p><p>But AI may not understand the why: That the company just closed its only distribution center in that region last quarter.</p><p>This scenario perfectly illustrates the promise and the limitation of AI in data analytics. Yes, AI is transforming how we work with data. It is making us faster, more efficient, and capable of processing volumes that would have been unthinkable a decade ago. But speed and automation isn’t all that there is.</p><h4>The Speed Revolution: What AI Does Brilliantly</h4><p>AI has fundamentally changed data analytics, and that’s a good thing. Modern AI tools can automate repetitive tasks like data cleaning, visualization, and pattern recognition with remarkable efficiency. What used to take analysts days compiling reports, running standard queries, generating visualizations now takes minutes.</p><p>AI excels at processing massive datasets, identifying correlations, and surfacing anomalies that might take human analysts weeks to discover. These capabilities free analysts from mundane tasks, allowing them to focus on higher-value work. Automation is real, powerful, and necessary in today’s data-driven business environment.</p><p>But here’s the critical distinction: AI makes analysis faster. It doesn’t make it rich and smart.</p><h4>The Three Irreplaceable Elements of Human Analytical Thinking</h4><h4>1. Domain Expertise and Business Context</h4><p>AI systems are only as knowledgeable as the data they’re trained on. They lack the lived experience and contextual understanding that human analysts bring to their work. When an AI model flags an unusual spike in sales, it sees a statistical anomaly. A human analyst with domain expertise might recognize it as the predictable result of a competitor’s product recall or a seasonal buying pattern specific to that industry.</p><p>This means: AI can tell you what happened in your data. Only a human who understands your business can tell you why it matters and what it means for your strategy. Domain experts can validate whether data is complete, accurate, and truly representative of real-world conditions. They know when a correlation is meaningful and when it’s merely coincidental. They understand the nuances that raw data cannot capture.</p><p>This contextual intelligence is what transforms numbers into insights. Without it, you have information without understanding which poses a dangerous foundation for business decisions.</p><h4>2. Problem Framing: Asking the Right Questions</h4><p>Perhaps the most critical skill that separates human analysts from AI is the ability to frame the right problems and ask the right questions. AI can answer questions with remarkable speed and accuracy, but it cannot determine which questions are worth asking in the first place.</p><p>Problem framing is the art of taking vague business challenges and translating them into clear, actionable analytical questions. It requires empathy to understand stakeholder needs, strategic thinking to align analysis with business goals, and creativity to approach problems from unconventional angles.</p><p>When a CEO says “we need to improve customer satisfaction,” an AI system doesn’t know where to start. A skilled analyst knows to dig deeper: What aspect of satisfaction? Which customer segments? What’s driving dissatisfaction? What does “improvement” actually mean in measurable terms? The ability to transform ambiguous business goals into specific, answerable questions is fundamentally human.</p><p>If you’re looking to develop this critical skill, I’ve created a comprehensive course on<a href="https://selar.com/u1np81ic87"> how to think like an analyst</a>, which focuses specifically on problem framing and translating messy business challenges into clear analytical questions.</p><p>The analysts who focus on developing this skill, moving from simply answering questions to strategically framing them, are the ones whose careers remain insulated from AI disruption. The ability to frame questions and how you think about problems is what creates lasting value.</p><h4>3. Strategic Decision-Making and Ethical Reasoning</h4><p>Data analysis doesn’t end with insights, it culminates in decisions. And decisions involve tradeoffs, ethics, stakeholder considerations, and consequences that extend far beyond what any dataset can capture.</p><p>AI lacks the moral reasoning and ethical framework required for true critical thinking. When analyzing customer data, AI doesn’t consider privacy implications or fairness concerns unless explicitly programmed to do so. It doesn’t weigh the human impact of a cost-cutting recommendation or consider whether a statistically optimal solution is organizationally feasible.</p><p>Human analysts bring judgment to the table. They understand that a recommendation that looks perfect on paper might be politically impossible to implement, culturally inappropriate, or ethically questionable. They can navigate the gray areas where data provides guidance but not answers, where multiple stakeholders have competing interests, and where the “right” decision depends on values that cannot be quantified.</p><p>This is why over-reliance on AI for analysis is actually risky. It can lead to superficial understanding and undermine the development of critical human analytical skills that businesses need for sound decision-making.</p><h4>The Future is Human-AI Collaboration</h4><p>The future of data analytics isn’t humans versus AI. Rather, it’s humans plus AI. The most effective approach treats AI as a powerful collaborator that handles what it does best: large-scale data processing, pattern recognition, and automation of routine tasks.</p><p>This partnership frees human analysts to focus on what they do best: creative thought, critical thinking, emotional intelligence, and strategic problem-solving. AI surfaces patterns and highlights trends. Humans determine what those insights mean, whether they’re actionable, and how they fit into the broader business context.</p><p>One way to think of this is: AI is the calculator, not the mathematician. It accelerates computation but doesn’t understand what to compute or why it matters.</p><h4>What This Means for Data Analysts</h4><p>If you’re a data analyst worried about AI replacing you, shift your focus. Don’t compete with AI on speed or computational power. Instead, double down on developing the skills that AI cannot replicate:</p><p><strong>Deepen your domain expertise.</strong> Become the person who understands not just the data, but the business reality behind it. Know your industry, your customers, your market dynamics.</p><p><strong>Master the art of problem framing.</strong> Practice translating messy business challenges into clear analytical questions. Develop your ability to understand what stakeholders really need, even when they can’t articulate it clearly.</p><p><strong>Cultivate strategic thinking.</strong> Learn to connect analytical insights to business strategy. Understand organizational dynamics, change management, and how to make recommendations that are not just analytically sound but practically implementable.</p><p><strong>Embrace AI as your accelerator.</strong> Use AI tools to handle the heavy lifting of data processing. Your value lies in interpreting what those patterns mean and deciding what to do about them.</p><p>The analysts who will thrive in the AI era are those who understand that their role isn’t to compete with machines at what machines do best, but to provide what only humans can: context, judgment, strategic thinking, and the wisdom to ask questions that matter.</p><p>Right now, the question isn’t whether AI will replace human analytical thinking. The question is: Will you develop the analytical thinking skills that AI cannot replace?</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=f8d72aeb7ee4" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Data Isn’t Just Numbers: A Guide for Small Business Owners]]></title>
            <link>https://medium.com/@ufuomaagwaye/data-isnt-just-numbers-a-guide-for-small-business-owners-6f00a69f3df0?source=rss-30892f981c36------2</link>
            <guid isPermaLink="false">https://medium.com/p/6f00a69f3df0</guid>
            <category><![CDATA[small-business-owner]]></category>
            <category><![CDATA[data]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[social-media-strategy]]></category>
            <dc:creator><![CDATA[Ufuoma Agwaye]]></dc:creator>
            <pubDate>Fri, 24 Oct 2025 07:40:14 GMT</pubDate>
            <atom:updated>2025-10-24T07:40:14.595Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*5cFWDTEJbODT4MEkslZcGg.png" /></figure><p>Last week, I was talking to an online vendor about analysing her business data. Her immediate response? “I’m not good with numbers. All those rows and columns make my head turn.” If you’ve ever felt the same way, I get it. But <strong>data is more than spreadsheets and complicated formulas. Data is any information that tells you what’s working in your business and what isn’t.</strong></p><p>Let me show you what I mean.</p><h3><strong>Data Is Already Working for You</strong></h3><p>Think about the last time you posted a series of content on Instagram. After sometime, you noticed that some posts got more likes, comments, or saves than others.</p><p>That’s data. Instagram’s platform analytics is showing you what content your audience connects with most. The post that got 50 saves versus the one that got is your audience voting with their engagement.</p><p><strong>What this means for you:</strong> create more of that type of content because it resonates.</p><h3><strong>Data Lives in Your Links Too</strong></h3><p>Here’s another example. Let’s say you put a link in your Instagram bio that goes to your website or online store. If you’re using UTM parameters (tracking codes you can add to any link), you can see exactly which platform is sending you the most visitors.</p><p>Maybe you’re posting on Instagram, Facebook, and Twitter. UTM links reveal that 70% of your website traffic comes from Instagram, 20% from Facebook, and 10% from Twitter.</p><p><strong>What does this mean for you as a business owner?</strong> Double down on Instagram. That’s where your people are. You’re making smart decisions based on what your audience is already telling you.</p><h3><strong>When Your Customers Speak in Data</strong></h3><p>Consider email marketing. You send out a newsletter with three different calls-to-action: “Shop New Arrivals,” “Read Our Blog,” and “Book a Consultation.”</p><p>Your email platform shows you that 60 people clicked “Shop New Arrivals,” 15 clicked “Read Our Blog,” and 45 clicked “Book a Consultation.”</p><p>Your audience is telling you they’re more interested in shopping and booking than reading blog posts right now. This helps you adjust your strategy accordingly.</p><p>Data is the digital footprint your customers leave behind when they interact with your business online. Every like, click, share, time spent on a page, or abandoned cart is your customer communicating with you. The difference between guessing and knowing what works is data.</p><p><strong>So, If You Have Your Business on social media or a website…</strong></p><p>Then you already have access to data. You just need to know where to look and what questions to ask like:</p><ul><li>Which posts get the most engagement, and why?</li><li>What time of day do your followers interact most?</li><li>Which traffic sources send the most visitors to your website?</li><li>What products do people view but not purchase?</li><li>Which email subject lines get opened more?</li></ul><p>These are business questions that your existing platforms can answer right now.</p><p>So, data doesn’t have to be intimidating. You could start out by clicking one platform where you’re active and just look at just one metric this week. What’s your most popular post this month? What’s your most visited webpage? What email had the highest open rate?</p><p>This is the beginning of data-driven decision-making for you as a small business owner.</p><p>I’ve created a free mini-guide called “Data for Small Business Owners: How to Read and Use Your Online Analytics for Business Growth.” It breaks down exactly which metrics to track, where to find them, and how to turn insights into action.</p><p><a href="https://selar.com/3863612b62"><strong>Download the free guide here</strong></a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=6f00a69f3df0" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Nice Gets You Eaten: Lessons from The Count of Monte Cristo]]></title>
            <link>https://medium.com/@ufuomaagwaye/nice-gets-you-eaten-lessons-from-the-count-of-monte-cristo-9f4b8aceb98a?source=rss-30892f981c36------2</link>
            <guid isPermaLink="false">https://medium.com/p/9f4b8aceb98a</guid>
            <category><![CDATA[film-analysis]]></category>
            <category><![CDATA[the-count-of-monte-cristo]]></category>
            <category><![CDATA[wisdom]]></category>
            <category><![CDATA[personal-development]]></category>
            <category><![CDATA[society]]></category>
            <dc:creator><![CDATA[Ufuoma Agwaye]]></dc:creator>
            <pubDate>Wed, 15 Oct 2025 02:28:24 GMT</pubDate>
            <atom:updated>2025-10-15T02:28:24.410Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*rw5gHBMJGfDi1l17tGOXlw.png" /></figure><blockquote>“Behold, I send you out as sheep in the midst of wolves; therefore, be wise as serpents and harmless as doves.” — Matthew 10:16</blockquote><p>When I watched <em>The Count of Monte Cristo</em> (2002), I saw more than an adventure story. I saw a man’s education in a hard truth: being nice isn’t enough. True kindness demands intelligence, discernment, and the courage to understand how wolves think. While the revenge plot captivates, Edmond Dantès’ downfall carries a warning that feels urgent in 2025’s predatory world.</p><p><strong>The Cost of Naivety: Edmond’s Downfall</strong></p><p>Edmond didn’t fail because he was good. He failed because he was naive. Unprepared for the world’s harsh realities, he was betrayed at his engagement party by those who studied him like predators study weakness. Fernand coveted his life; Danglars resented his promotion. They exploited his innocence, his inability to read their motives, and his belief that good faith would be reciprocated. His literal illiteracy wasn’t a romantic flaw; it was a weapon for his enemies, like when Villefort burned a letter Edmond couldn’t read to challenge him.</p><p>Thirteen years in the Château d’If wasn’t punishment for a crime. It was the price of his ignorance.</p><p><strong>The 1%’s Secret: Strategic Wisdom</strong></p><p>This same naivety separates the 1% from everyone else. The wealthy and successful don’t only work hard but they also master the game’s unwritten rules. They read people, markets, and systems, studying weaknesses to stay ahead. They know naivety is a luxury the poor can’t afford. While we’re taught to trust in fairness and turn the other cheek, they navigate a world where rules shift based on power. Niceness, like Edmond’s, is vulnerability dressed as virtue, making us legible to predators.</p><p><strong>Kindness vs. Niceness: A Biblical Lesson</strong></p><p>The biblical fruits of the spirit emphasize kindness, not niceness. And I think that’s intentional because sending you out to play nice among wolves will only get you eaten. Matthew 10:16 doesn’t urge us to become wolves but to understand their tactics: how they hunt, what drives them. You need that knowledge not to become a wolf, but to survive as doves. Kindness, unlike naive niceness, requires wisdom to know when and how to act. Edmond learned this in prison, where Abbé Faria gave him more than a map and money. He taught him reading, strategy, history, and martial skills. These were tools to read people and systems, transforming him from sheep to strategist without losing his humanity.</p><p><strong>Becoming a Serpent, Remaining a Dove</strong></p><p>The movie brilliantly shows Edmond’s victory not through violence but through cunning. He outsmarts his enemies by understanding their greed, fear, and vanity, orchestrating their downfall with surgical precision. Yet, he doesn’t become Fernand or Danglars. He emerges as someone who navigates danger with awareness, capable of destruction but choosing mercy which I consider a victory of wisdom with conscience. This balance is what the 1% master: toggling between serpent and dove, never stuck wondering why they’re pecked.</p><p><strong>Lessons for 2025: Educate or Be Eaten</strong></p><p>The treasure didn’t free Edmond, his education did. By understanding motivations and anticipating moves, he turned knowledge into power, choosing redemption over tyranny. In 2025, as the gap between the aware and unaware widens, we must follow suit. We need street smarts: watching what people do, not what they say. We must learn systems, how money flows, how power operates, who shapes rhetoric and why. For example, reading a contract’s fine print or taking a free online course on personal finance or negotiation can shield us from exploitation. Ignorance of motives makes us targets. We can’t afford to be illiterate in our own lives.</p><p>The tragedy isn’t being too good; it’s being too naive. Kindness from ignorance is vulnerability in disguise. Dantès paid thirteen years for his innocent ignorance. We don’t have to. His story, lived by countless others, teaches us to stop being nice and start being wise.</p><p><strong>Be a dove. But first, learn to be a serpent.</strong></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=9f4b8aceb98a" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[From Guesswork to Precision: Using Data to Create Content That Sells]]></title>
            <link>https://medium.com/@ufuomaagwaye/from-guesswork-to-precision-using-data-to-create-content-that-sells-29f54fddfebd?source=rss-30892f981c36------2</link>
            <guid isPermaLink="false">https://medium.com/p/29f54fddfebd</guid>
            <category><![CDATA[data-driven-marketing]]></category>
            <category><![CDATA[digital-marketing]]></category>
            <category><![CDATA[content-creation]]></category>
            <dc:creator><![CDATA[Ufuoma Agwaye]]></dc:creator>
            <pubDate>Mon, 17 Mar 2025 10:06:58 GMT</pubDate>
            <atom:updated>2025-03-17T10:06:58.887Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*wauuG9RcKXgBTDkk13elVw.png" /><figcaption>Using Data to Create Content That Sells</figcaption></figure><p>There’s nothing more rewarding than using data to turn guesswork into strategy. Recently, I had the chance to do just that for <strong>Fido Finance (name withheld for privacy)</strong>, a personal finance business I helped to create an eBook and course that truly resonated with their audience. Here’s how I helped them go from uncertainty to precision, using data to create content that truly resonates.</p><p><strong>The Challenge: Avoiding the Guesswork Trap</strong></p><p>Fido Finance had a solid email list and a growing social media presence, but they were stuck. They wanted to create a high-value eBook or course that truly resonated with their audience. But instead of guessing which personal finance topics would perform best, they wanted to be sure. Without data, they risked wasting time, money, and credibility on content no one needed. That wasn’t an option.</p><p>Their challenge was clear: <em>How do we create content and products that solves real problems for our audience?</em></p><p><strong>The Solution: Data-Driven Customer Research</strong></p><p>To get real answers, I designed and launched a targeted survey that reached Fido Finance’s audience via email and social media. This was important to uncover key insights such as:</p><ul><li>The biggest personal finance challenges they faced</li><li>Why solving these issues mattered to them</li><li>How difficult it was to find effective solutions</li><li>Whether they wanted to be contacted when a solution was available (to build a warm email list).</li></ul><p>With responses from 134 engaged individuals, I analysed the data, categorizing pain points and ranking them based on frequency and difficulty. The insights revealed clear patterns:</p><ul><li><strong>Top Challenges</strong>: Saving for Specific Goals, Budgeting with Irregular Income, and Investing for Beginners.</li><li><strong>Difficulty Levels</strong>: Over 60% of respondents found it “Very Difficult” to solve their challenges.</li><li><strong>Emotional Drivers</strong>: Reducing stress, achieving financial goals, and gaining financial security.</li><li><strong>Warm Leads</strong>: 107 respondents opted to share their emails, creating a ready-made list of potential customers.</li></ul><p><strong>The Strategy: Turning Insights into Action</strong></p><p>With these insights, I helped Fido Finance create a data-driven content and marketing strategy. Here’s what we did:</p><ol><li><strong>Content Creation</strong>: We focused on the top challenges, creating actionable guides like “How to Save for a Down Payment in 12 Months” and “Budgeting for Freelancers: A Step-by-Step Guide.” Each piece included templates and frameworks to make it easy for users to apply what they learned.</li><li><strong>Emotional Messaging</strong>: We used language that resonated with the audience’s emotional drivers. For example, instead of saying, “Learn How to Budget,” we said, “Take Control of Your Finances and Reduce Stress.”</li><li><strong>Pre-Launch Marketing</strong>: We used the email list from the survey to build anticipation for the ebook/course. A series of emails educated the audience about the problem and positioned the product as the solution.</li><li><strong>Post-Launch Feedback</strong>: After launching, we conducted a follow-up survey to measure its impact and gather feedback for future improvements.</li></ol><p><strong>The Result: Content That Resonated</strong></p><p>By using data, Fido Finance avoided the common pitfall of creating content that no one wanted. Instead, they focused on topics their audience was actively searching for solutions to. The warm leads from the survey gave them a head start, allowing them to pre-sell the eBook to 107 customers before launch and generate buzz around the product.</p><p>This project was a perfect example of how data analytics and digital marketing can work hand-in-hand to drive results. It’s not enough to create content, you need to create the <strong>right content</strong>. And the only way to do that is by understanding your audience’s needs, challenges, and emotional drivers. Data takes the guesswork out of marketing and ensures that every decision is informed and intentional.</p><p><em>Note: The client’s name has been changed to protect their privacy.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=29f54fddfebd" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Beyond Admin Tasks: What Being a Virtual Assistant Really Means]]></title>
            <link>https://medium.com/@ufuomaagwaye/beyond-admin-tasks-what-being-a-virtual-assistant-really-means-578a5ac88000?source=rss-30892f981c36------2</link>
            <guid isPermaLink="false">https://medium.com/p/578a5ac88000</guid>
            <category><![CDATA[problem-solving]]></category>
            <category><![CDATA[adaptability]]></category>
            <category><![CDATA[virtual-assistant]]></category>
            <category><![CDATA[growth]]></category>
            <category><![CDATA[virtual-assistant-service]]></category>
            <dc:creator><![CDATA[Ufuoma Agwaye]]></dc:creator>
            <pubDate>Mon, 27 Jan 2025 08:36:00 GMT</pubDate>
            <atom:updated>2025-01-28T05:17:55.445Z</atom:updated>
            <content:encoded><![CDATA[<h3><strong>Beyond Admin Tasks: Virtual Assisting Really Means</strong></h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*HAt9IbWODrRzOjo3WZB5rw.png" /><figcaption>Versatile VA</figcaption></figure><p>When I first started working remotely as a virtual assistant (VA), I believed my role was strictly limited to administrative tasks like email management, scheduling, and data entry. While these tasks are part of the job, my experience has shown that being a VA extends far beyond the basics.</p><p>At first, I thought I had to niche down solely as an admin VA. It seemed like the logical thing to do. But as I took on more projects, I quickly realized that niching down too early could limit my potential. Focusing on a niche can be beneficial, but it may also limit your ability to explore new opportunities, develop diverse skills, and expand your expertise.</p><p>Over time, I learned from my clients’ needs that my role wasn’t just about checking off tasks on a to-do list. It was about solving problems and delivering real value. A recent project I handled is a perfect example of this. We had an email campaign to send out, and over 9,000 customers were set to receive our January newsletter. However, our CRM could only handle sending out 3,000 emails at a time. Upgrading to a higher plan wasn’t an option due to budget constraints, so I had to find a way to work around it.</p><p>Here’s how I tackled it:</p><ol><li>I downloaded the customer data as a CSV file and loaded it into Google sheets.</li><li>Then I used FILTER function to split and organize the data into separate sheets:</li></ol><p>Batch 1 (Rows 2 to 3001):</p><p>=FILTER(A2:C9848, ROW(A2:A9848) &gt;= 2, ROW(A2:A9848) &lt;= 3001)</p><p>(Because the sheet has headers and data really starts from row 2)</p><p>Batch 2 (Rows 3002 to 6001):</p><p>=FILTER(A2:C9848, ROW(A2:A9848) &gt;= 3002, ROW(A2:A9848) &lt;= 6001)</p><p>Batch 3 (Rows 6002 to 9001):</p><p>=FILTER(A2:C9848, ROW(A2:A9848) &gt;= 6002, ROW(A2:A9848) &lt;= 9001)</p><p>Batch 4 (Rows 9002 to 9848):</p><p>=FILTER(A2:C9848, ROW(A2:A9848) &gt;= 9002, ROW(A2:A9848) &lt;= 9848)</p><p>3. Finally, I uploaded the batches back into the CRM and scheduled each segment accordingly.</p><p>The campaign was completed on time without exceeding budget limits. And in the next marketing meeting, I was able to recommend a long-term solution to scale up email capacity efficiently. In that moment, the focus wasn’t on waiting for the ideal solution but on getting the job done with the resources available.</p><p>Experiences like this have shown me that remote work is dynamic, requiring adaptability. Beyond admin tasks, I’ve had to work with CRMs, email marketing platforms, and data analytics tools. One of my most fulfilling projects involved cleaning up a client’s customer data in Google Sheets and visualizing insights in Tableau. By analysing KPIs such as highest purchasing customers, most popular products, and regional sales trends, I was able to provide valuable insights that informed their business decisions.</p><p>If you’re just starting out as a virtual assistant, don’t limit yourself to a specific niche or set of tasks or tools. Instead, focus on developing a broad range of skills and being open to new challenges. Reach out to friends with small businesses and offer to help with their projects. This will not only help you gain experience but also build your portfolio. It’s not just about the title; it’s about the value you bring to your clients. Businesses don’t hire just for admin work; they hire for problem-solving. The more you can think critically, adapt to different tools, and provide solutions, the more indispensable you become.</p><p>The next step is to position yourself by packaging your skills and experiences in a way that highlights your problem-solving abilities. With the internet at your fingertips, the possibilities for growth and exploration are limitless. This means that you can achieve anything (as long as it’s legal, of course!). So, don’t box yourself in.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=578a5ac88000" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Is Data Analytics Right for You? Here’s How to Find Out Without Spending a Dime]]></title>
            <link>https://medium.com/@ufuomaagwaye/is-data-analytics-right-for-you-heres-how-to-find-out-without-spending-a-dime-a7a9c4c666c4?source=rss-30892f981c36------2</link>
            <guid isPermaLink="false">https://medium.com/p/a7a9c4c666c4</guid>
            <category><![CDATA[self-assessment]]></category>
            <category><![CDATA[data]]></category>
            <category><![CDATA[learning]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[decision-making]]></category>
            <dc:creator><![CDATA[Ufuoma Agwaye]]></dc:creator>
            <pubDate>Wed, 14 Aug 2024 19:37:08 GMT</pubDate>
            <atom:updated>2024-08-14T19:37:08.679Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*2t62_YKAl9gygV1ydStviQ.png" /></figure><p>Starting anything new like a career can be both exciting, and daunting. If you’ve been eyeing data analytics, you’re probably eager to know if it’s the right fit for you. While bootcamps and courses are fantastic ways to build skills, some often come with a price tag. Before you commit your time and money to learning, let me share a cost-effective way to test the waters.</p><p>When I first considered data analytics, I was drawn in by the promise of working with data, uncovering trends, and making decisions that could influence a company’s direction. It all sounded fascinating. But before jumping into a bootcamp, I wanted to be sure this path was truly for me. I didn’t want to spend money and even my time or resources, only to realize later that I didn’t actually enjoy the day-to-day work of a data analyst.</p><p>This is where “Day in the Life” videos became a game changer for me. I stumbled upon a few of these on YouTube and even TikTok, where data analysts shared what their daily routines look like, everything from the tools they use to the types of problems they solve. It was an eye opener.</p><p>These videos gave me a real-world glimpse into the life of a data analyst, beyond what any course description could offer. I watched how they spent their days, how they approached challenges, and the kind of tasks that filled their hours. It wasn’t just theory or hypothetical projects, it was reality.</p><p>After watching a few of these videos, I asked myself, “Does this fit into the kind of work I enjoy? Could I see myself thriving in this environment?” This simple exercise helped me see whether I was drawn to the tasks and responsibilities of a data analyst or if I was simply enamored with the idea of it.</p><p><strong>Before You Commit: Try This First</strong></p><p>If you’re like me and want to save yourself from potentially wasting money, I highly recommend doing the same. Search for “Day in the Life of a Data Analyst” maybe on YouTube. Watch a few different people, because each analyst may have a slightly different experience depending on their industry or role. As you watch, picture yourself in their shoes. Does the work excite you? Or does it seem like a chore? If you find yourself genuinely interested, that’s a great sign. But that’s not all.</p><p>Once you’ve got a better sense of what the role entails, you might want to dig a bit deeper. YouTube is a treasure trove of free content, including playlists and tutorials on data analytics. These can help you further assess your interest or even start building some basic skills, all without spending a penny. It’s a low-risk way to gauge your passion before diving into more formal education.</p><p>So, if I were to start all over, this is what I’d do differently: I’d gauge my interest first with a mini self-assessment before making any full commitments. Take a peek into the daily life of a data analyst, watch or read content about this, see if it resonates with you, and then decide. Need a pointer to some good content? Please let me know, I’m happy to share!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=a7a9c4c666c4" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[MPR Won’t Cut It: Let’s Focus on Getting Farmers Back to Work]]></title>
            <link>https://medium.com/@ufuomaagwaye/mpr-wont-cut-it-let-s-focus-on-getting-farmers-back-to-work-dfbcdbffdc67?source=rss-30892f981c36------2</link>
            <guid isPermaLink="false">https://medium.com/p/dfbcdbffdc67</guid>
            <category><![CDATA[central-bank-of-nigeria]]></category>
            <category><![CDATA[sustainable-food-systems]]></category>
            <category><![CDATA[inflation]]></category>
            <category><![CDATA[nigerian-economy]]></category>
            <category><![CDATA[monetary-policy]]></category>
            <dc:creator><![CDATA[Ufuoma Agwaye]]></dc:creator>
            <pubDate>Tue, 21 May 2024 20:10:20 GMT</pubDate>
            <atom:updated>2024-05-21T20:10:20.470Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*8Nsc_-bFFDAFkrso0gO3eQ.jpeg" /></figure><p>Dear CBN Governor,</p><p>I’m writing today as a concerned citizen and economic observer. Nigerians are aware of the recent decision to raise the interest rate to 26.25%. While I understand the intention behind this move (to curb inflation), I have to express my reservations about its effectiveness and the potential impact on Nigerians and the economy.</p><p>I wrote about the similar policy decision <a href="https://medium.com/@ufuomaagwaye/cbns-bold-move-raises-mpr-to-22-75-implications-for-your-finance-fbdd261398a4">here</a> in February when the Monetary Policy Rate (MPR) was raised to 22.75%. At the time, I highlighted the key terms of the policy release and expressed concerns about its potential effects on the economy. Unfortunately, it seems like we’re repeating the same cycle without fully addressing the underlying issues.</p><p>The February rate hike was intended to combat inflation, but what was the actual impact? Inflation still remains high, and food inflation, in particular, still rises. This is a critical point, as monetary policy alone cannot effectively address food inflation. The root causes of food inflation lie in the production and supply chain, and we need to tackle these issues head-on.</p><p>Our farmers need to feel secure enough to return to their farms, but the insecurity of farmer’s lives and other issues along the food chain and supply side hinder this. We can’t curb inflation without addressing the food aspect of it. There should be support and incentives to get farmers to their farms, and we need to invest in sustainable agricultural infrastructure and technology to boost productivity.</p><p>Now, with this latest rate hike, I fear we’re only treating the symptoms rather than the underlying disease. It’s like putting a band aid on a bullet wound. The implications of this decision could be far-reaching and potentially harmful to Nigerians and the economy.</p><p>Firstly, the increased interest rate will make borrowing more expensive for individuals and businesses. This could lead to reduced consumer spending, lower economic growth, and even higher unemployment. The average Nigerian is already struggling to make ends meet, and this move will only exacerbate their financial burdens.</p><p>Secondly, the high interest rate will make it challenging for businesses to access credit, which is essential for growth and expansion. This could lead to reduced investment, lower productivity, and decreased economic competitiveness.</p><p>Thirdly, foreign investors will be deterred by the high inflation rate, which is still above the interest rate. This means they’ll be unlikely to invest in our economy, as the returns on their investment will be eroded by inflation.</p><p>I urge you to reconsider this policy decision and explore alternative solutions that address the root causes of inflation, particularly food inflation. It is commendable that there are efforts to deal with the high inflation figure through interest rate hike, but I fear it’s a short-sighted solution that will only lead to more economic hardship for Nigerians. I believe that there are more comprehensive and sustainable solutions to these economic challenges.</p><p>Sincerely,</p><p>Ufuoma (who badly wants Nigeria to succeed).</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=dfbcdbffdc67" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[CBN’s Bold Move Raises MPR to 22.75%: Implications for your finance]]></title>
            <link>https://medium.com/@ufuomaagwaye/cbns-bold-move-raises-mpr-to-22-75-implications-for-your-finance-fbdd261398a4?source=rss-30892f981c36------2</link>
            <guid isPermaLink="false">https://medium.com/p/fbdd261398a4</guid>
            <category><![CDATA[monetary-policy]]></category>
            <category><![CDATA[nigerian-economy]]></category>
            <category><![CDATA[money]]></category>
            <category><![CDATA[central-bank]]></category>
            <dc:creator><![CDATA[Ufuoma Agwaye]]></dc:creator>
            <pubDate>Wed, 28 Feb 2024 14:49:14 GMT</pubDate>
            <atom:updated>2024-02-28T14:57:25.936Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*JGY1PubAQUh3FP77dm7_Yw.jpeg" /><figcaption>Central Bank of Nigeria</figcaption></figure><p>The recent decision by the Central Bank of Nigeria’s Monetary Policy Committee (MPC) to raise the Monetary Policy Rate (MPR) by 400 basis points, from 18.75% to 22.75%, has significant implications for you and the Nigerian economy. In this post, we will discuss the implications of this policy shift, exploring key terms like MPR, CRR, and Liquidity Ratio, to understand how these policy changes affect the Nigerian economy, businesses and individuals.</p><p>To grasp the implications of the MPR hike, key terms like MPR, CRR (Cash Reserve Ratio), Liquidity Ratio, and the Asymmetric Corridor should be understood.</p><p><strong>MPR-Monetary Policy Rate</strong></p><p>The MPR is a control mechanism tool, but it is also a double-edged sword. The MPR, or Monetary Policy Rate, acts as a lever for controlling money supply, lending rates, and inflation. It essentially represents the interest rate at which the Central Bank lends to commercial banks. The recent 400 basis points increase signifies a 4% increase, from 18.75% to 22.75%, reflecting the Central Bank’s attempt to curb Nigeria’s current inflation rate which roughly stands at 29.90% as of February 2024 according to the <a href="https://nigerianstat.gov.ng/elibrary/read/1241453">National Bureau of Statistics (NBS)</a>, and of course attract investors by offering higher returns on government securities.</p><p>While the higher MPR may curb inflation and entice investors seeking higher returns, it also has its challenges. Elevated interest rates can lead to slower economic growth, reduced consumer spending, and higher interest rates on loans. It is worthy to note that if the Monitory Policy Committee seeks to target food inflation through increasing MPR, it may be counterproductive because the Federal Government needs to deal with supply side challenges like security of farmers. The reason for this is that the real issue causing the high prices of food is not just about the cost of borrowing money; it’s also about problems on the farms. Farmers are facing challenges like insecurity, which means they can’t go to their farms to produce enough food. So, even if the MPC raises the MPR, it won’t magically solve the root problem of food inflation. We can’t fix a leaky roof by painting the walls.</p><p><strong>CRR-Cash Reserve Ratio</strong></p><p>Cash Reserve Ratio is like a savings account that banks (for instance, Stanbic IBTC, UBA, Keystone bank etc.) must have with the central bank. When a bank receives money from its customers, it doesn’t keep all of it for lending. Instead, a portion of that money must be set aside, or reserved, with the central bank. This reserved amount is determined by the Cash Reserve Ratio. For example, if the CRR is 20% and a bank receives ₦100,00.00 from customers, then it has to keep ₦20,000.00 (₦100,000 *20%) aside and can only use ₦80,000.00 for lending or other activities.</p><p>The purpose of CRR is to ensure that banks have a certain amount of money securely held with the central bank, which adds a layer of safety to the banking system. Depending on prevailing economic situations, the central bank can adjust the CRR to control the amount of money banks have available for lending.</p><p>Now that the CBN has adjusted the Cash Reserve Ratio (CRR) from 32.5% to 45%, this means that banks must now retain 45% of customers’ cash deposits (our cash deposits) with the Central Bank. This move aims to limit banks’ ability to lend excessively, thereby controlling borrowing and encouraging a reduction in cash circulation. However, it also poses the risk of constraining businesses and individuals with higher interest rates (the lower the availability of funds for banks to lend our small businesses, the higher the interest rates we attract if we indeed take those bank loans).</p><p><strong>Liquidity Ratio</strong></p><p>Liquidity Ratio reflects a bank’s health status and ensures that banks maintain enough assets to cover liabilities and meet its obligations. A healthy ratio protects depositors (you and I) and prevents banks from facing liquidity crises (the unavailability of funds). Imagine going to the bank to take some money and the bank isn’t liquid enough/has run out of cash to give you from the money you deposited with them for safekeeping. This is why a healthy Liquidity Ratio is crucial for ensuring banks can honor customer withdrawals. The recent policy emphasizes the importance of maintaining a minimum Liquidity Ratio of 30%, safeguarding depositors’ interests and overall financial stability.</p><p><strong>Asymmetric Corridor</strong></p><p>For us to understand the asymmetric corridor, think of it as a range or gap that sets the rules for how the central bank deals with commercial banks. It involves two key interest rates:</p><ol><li><strong>Lending Rate:</strong> This is the interest rate at which the central bank lends money to commercial banks.</li><li><strong>Borrowing Rate: </strong>This is the interest rate at which commercial banks can deposit their excess money with the central bank.</li></ol><p>When commercial banks need to borrow money from the Central Bank, they walk on the side with the higher interest rate (lending rate). On the flip side, if they want to deposit extra money with the Central Bank, they walk on the side with the lower interest rate (borrowing rate).</p><p>Now, the asymmetric corridor is like a band around the main interest rate (Monetary Policy Rate or MPR). It sets a higher limit for the lending rate and a lower limit for the borrowing rate. The “+100 basis points” means 1% above the MPR, and “-700 basis points” means 7% below the MPR.</p><p>So, if the MPR is, let’s say, 30%, and the asymmetric corridor is +100/-700 basis points, this means:</p><ul><li><strong>Lending Rate (to commercial banks):</strong> 30% + 1% = 31% -higher interest rate</li><li><strong>Borrowing Rate (from commercial banks): </strong>30% — 7% = 23% — lower interest rate</li></ul><p>This arrangement encourages commercial banks not to keep too much money with the central bank because they can get a better deal by lending the money elsewhere (at a higher rate) or investing it in different sectors. This corridor, set at +100/-700 basis points around the MPR is a way for the central bank to influence how banks use their money and encourage them to participate more actively in the economy (for instance, lending to the real sector) rather than just holding onto cash. This aims to control cash circulation and inflation.</p><p><strong>Impact on Businesses and Individuals</strong>: <strong>You and I</strong></p><p>Banks are likely to pass on the increased MPR to consumers, which inadvertently means higher interest rates on loans. The MPR hike’s ripples into various sectors that will feel the impact in higher interest rates because banks are likely to pass on the increased MPR to consumers (businesses and individuals).</p><p>For businesses seeking loans from these banks, the interest rates on loans are projected to rise, potentially impacting investment decisions and pricing strategies. Therefore, these businesses might opt to reduce borrowing, affecting their cash flow and spending capacity.</p><p>On an individual level, higher interest rates on loans could result in increased costs for consumers (when we as consumers buy from these businesses, the costs may be higher because Chike, Abdul &amp; Femi LTD may have also pushed the higher interest rates to us in form of increased prices). This means that our purchasing power and spending patterns may be affected as well. In the long run, it reduces our propensity to spend.</p><p><strong>Financial Strategy for You and Me: Okay where is our gold in all of these?</strong></p><p>Phew! Seems like we’ve been on and on with all the boring stuff and seemingly bad news, eh? We want to see the light at the end of the tunnel, where the good stuff is at for us with the CBN’s recent policy move. We’ll get there in a bit.</p><p>As the Central Bank of Nigeria takes bold steps to navigate economic challenges, it is necessary that we understand the implications of policy decisions because it comes in handy for making informed financial decisions. Although fraught with uncertainties, the incentivization of higher returns on fixed deposits or treasury bills could encourage investment and savings.</p><p><strong>The light at the end of the tunnel</strong>– We can reassess our financial strategies and take prudent steps by taking advantage of the CBN’s monetary policy to explore investment options with higher returns. Two main investment vehicles to consider here are: fixed deposits and treasury bills.</p><p><strong>Higher Returns on Fixed Deposits and Treasury Bills</strong></p><p>The mention of “incentivization of higher returns on fixed deposits or treasury bills” suggests that the CBN is encouraging individuals to invest their money in these financial instruments. Now, let’s understand what fixed deposits and treasury bills are:</p><p><strong>Fixed Deposits</strong></p><p>When you put money in a fixed deposit, you are essentially lending it to a bank for a specific period at a predetermined interest rate. This interest rate is often higher than regular savings accounts. The money is “fixed” or locked in for a set time, and you receive both the principal (initial amount) and interest at the end of the period.</p><p>How It Works: Imagine you deposit ₦100,000 in a fixed deposit for one year at an interest rate of 5%. At the end of the year, you’ll receive ₦105,000 (the initial ₦100,000 plus ₦5,000 in interest).</p><p><strong>Treasury Bills (T-Bills):</strong></p><p>These are short-term government securities with maturities ranging from a few weeks to a year. When you buy a T-Bill, you are lending money to the government. The government, in return, pays you interest when the bill matures.</p><p>How It Works: Suppose you buy a ₦100,000 T-Bill with a 90-day maturity and a 5% interest rate. After 90 days, the government pays you ₦101,250 (₦100,000 principal plus ₦1,250 in interest).</p><p><strong>You can invest in T-Bills by:</strong></p><ul><li>Opening a Treasury Bill account with your bank or through the Central Bank (please contact your bank for advice on procedure).</li><li>Choose the desired tenor (maturity period) and bid the amount you want to invest.</li><li>Await the results of the auction to know if your bid was successful (again, your banker can put you through this process, as well as with fixed deposits).</li></ul><p>Both T-Bills and Fixed Deposits are secure financial instruments of investments as long as the interest rate is high.</p><p>I hope you have found this write-up insightful. Please let me know your thoughts by commenting below. Please like and share if you found this helpful.</p><p>(Disclaimer: This article is for informational purposes only and does not constitute financial advice.)</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=fbdd261398a4" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[City Point Sales Insight]]></title>
            <link>https://medium.com/@ufuomaagwaye/city-point-sales-insight-6f43743575e5?source=rss-30892f981c36------2</link>
            <guid isPermaLink="false">https://medium.com/p/6f43743575e5</guid>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[data-visualization]]></category>
            <dc:creator><![CDATA[Ufuoma Agwaye]]></dc:creator>
            <pubDate>Fri, 03 Feb 2023 18:24:46 GMT</pubDate>
            <atom:updated>2023-02-03T18:24:46.711Z</atom:updated>
            <content:encoded><![CDATA[<p>I recently worked on a sales analysis project where the manager at City Point (name changed to protect privacy) was concerned about the sales performance across the company’s supply network and wanted a visual picture across specified KPIs. You may interact with the excel dashboard here: <a href="https://1drv.ms/x/s!Au0x6WZ_jfeNhEahlS4406qwTIWX?e=k8Tbgh">City Point Sales Analysis Dashboard.xlsx</a>.</p><p><strong>The Data Set:</strong></p><p>The data set contained 8920 rows and 14 columns on an Excel spreadsheet.</p><p><strong>Data Cleaning:</strong></p><p>Depending on the country where sales came from, the currencies for the unit price column are both in Nigerian Naira (NGN) and South African Rand (ZAR). The manager insisted that the sales be presented in US Dollars (USD). So, after data was cleaned; adjusting column titles to be consistent, removing blanks and duplicates, a new column for Unit Price in USD was created and a NESTED IF expression — <strong>=IF([@Currency] =”NGN”, H2/402, IF([@Currency] =”ZAR”, H2/14.72, ))</strong>,<strong> </strong>was written in the first cell of the new column to adjust the currencies to USD using the exchange rate specified by the manager. The number format for the new column ‘UNIT_ PRICE USD’ was also adjusted to USD currency format.</p><p>After a general scan on the data set, it was also discovered that some values needed to be calculated in separate columns such as Sales (which is also the revenue) and Order Category in order to better analyze the KPIs of interest to the company manager. To derive the sales figures, a MULTIPLICATION expression- <strong>=[@Quantity] *[@[Unit_Price USD]]</strong>, was written in the first cell of the Sales column.</p><p>To derive the Order Category, a NESTED IF expression — <strong>=IF([@Quantity]&lt;=100, “Low End”, IF([@Quantity]&gt;101, “Mid End”, IF([@Quantity]&gt;301, “High End”, 0)))</strong>, was written in the first cell of the Order Category column.</p><p><strong>Data Analysis</strong></p><p>Given that City Point uses Excel for data storage and management, I was asked to work with Excel for this task. While there are other tools for analysis such as power BI and Tableau, Excel is still a powerful and commonly used tool of analysis. Therefore, this data set was cleaned and analyzed using MS Excel.</p><p>Some KPIs of interest to City Point include:</p><p>- Least loyal and VIP customers</p><p>- Percentage of Sales per Outlet</p><p>- Producers with least sales figures</p><p>- Percentage of Sales volume by Sales Channel and Country</p><p>- Order quantity by category group</p><p>Furthermore, after analysis of this data set and based on the expectations of City Point, I included other measures for the sales analysis including:</p><p>- The average fulfillment time for the least 10 and top 10 VIP customers.</p><p>- Worst performing delivery agents.</p><p>These measures will help the manger to see the difference between the fulfillment times among these two groups (loyal and least loyal customers) and to see if fulfillment time has any effect on customer loyalty and even revenue from sales. And since delivery agents are key players in the order to delivery cycle, the company can see if the activities of the agents play a role in keeping customers happy. So, city point can further streamline processes and drive policies that reduce the order time to delivery time and increase customer satisfaction and in the long-run, sales revenue.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/906/1*TJbQjGQyhGiE7ypZJEH82Q.png" /></figure><p>From this dashboard, we see that for the top 5 customers, the largest sale had the least average fulfilment time, and the lowest sale had the most average fulfilment time. Also, for the least 5 customers, the largest sale had the least average fulfilment time. Fulfilment times were plotted against the 10 worst delivery agents since the delivery agents are directly involved in the order cycle. It is also possible that producers contributed to the delay in customer fulfilment time so the manager for city point can see from the dashboard the producers that contributed the least sales figures.</p><p>While City Point’s customer base is larger in South Africa than in Nigeria, the bulk of sales came from Nigeria.</p><p>The dashboard has been designed to provide even specific insights with the slicers by country, currency and state. This also makes the dashboard interactive.</p><p><strong>Recommendations</strong></p><p>With this dashboard, and depending on what business goals it wants to achieve, City Point can decide to investigate low sales in SA through measures such as customer satisfaction through fulfilment times. The company can also investigate which delivery agents are performing below par and find out what is happening across its sales regions.</p><p>City Point can also find out what sales channels are efficient across its sales region and decide for instance to further investigate why Mobile Sites in South Africa accounted for more sales than Nigeria did. Then it gleans further insights on whether for instance, the mobile site for South African customers is more user friendly than Nigeria’s and probably schedule meetings with its business analysts and or mobile developers.</p><p>And through the order by category, it can see what products are always in demand and liaise with producers to ensure availability as this also has an impact on customer fulfilment time. Out of stock products and cancelled orders can also impact sales revenue.</p><p>I will appreciate your thoughts, suggestions on this. Please like this post too if you enjoyed reading.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=6f43743575e5" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Udemy Course Performance Analysis]]></title>
            <link>https://medium.com/@ufuomaagwaye/udemy-course-performance-analysis-10043b2a005?source=rss-30892f981c36------2</link>
            <guid isPermaLink="false">https://medium.com/p/10043b2a005</guid>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[writer]]></category>
            <category><![CDATA[data-analytics-tools]]></category>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[data]]></category>
            <dc:creator><![CDATA[Ufuoma Agwaye]]></dc:creator>
            <pubDate>Thu, 26 Jan 2023 22:44:28 GMT</pubDate>
            <atom:updated>2023-01-26T22:44:28.591Z</atom:updated>
            <content:encoded><![CDATA[<p>I worked on this project where I was requested to track the performance of courses to determine where opportunities to increase revenue may lie for an EdTech, Udemy. You can take a look at the visuals here: <a href="https://public.tableau.com/app/profile/ufuoma.agwaye/viz/UdemyCoursePerformanceAnalysis/UdemyCoursePerformanceDashboard">Udemy Course Performance Analysis | Tableau Public</a>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/999/1*YLZbFyfo1dKm1Oq5Va0aBg.png" /><figcaption>Udemy Course Performance Analysis</figcaption></figure><p>This was achieved by tracking the performances of courses across the four subjects: Business Finance, Graphic Design, Musical Instruments and Web Development. Course performance across the subjects were monitored across values such as:</p><p>- The number of subscribers for each subject which will also capture popularity of each subject.</p><p>- The number of course reviews and rating which will show areas of student interest.</p><p>However, a quick scan on the data showed that Web Development courses were indeed popular. But it begged the question if this necessarily translated to more revenue for Udemy. As we would see later on in this analysis that while Web Development seemed to be popular and the most subscribed subject, the large numbers of subscribers to Web Dev came from free courses and not paid courses. If learners love free courses on Web Dev, the most subscribed course, how is Udemy’s revenue affected by this? Therefore, more insights needed to be gathered to solve this problem and so the data set on Udemy courses was cleaned, sorted and analyzed to gather more insights using Excel and Tableau.</p><p><strong>The Data Set:</strong></p><p>There were four data sets provided for this analysis.</p><p>- Udemy Data Sheet for Web Development Courses</p><p>- Udemy Data Sheet for Business Courses</p><p>- Udemy Data Sheet for Design Courses</p><p>- Udemy Data Sheet for Music Courses</p><p><strong>Data Cleaning</strong></p><p>Each of the data set was cleaned using excel. 345 duplicates were removed. Blank cells were removed. Data was also checked for consistency. For instance, after examining the data, it was observed that the Web Development subject title is not the same as other subject titles. So, the Find and Replace function was used to make the Web Development subject consistent with other subjects.</p><p><strong>Data Analysis</strong></p><p>Tableau was used to analyze the clean data set imported from excel. The aim of this analyses was to present the data on course revenue to understand where opportunities to increase revenue may lie by tracking the performance of courses. To achieve this, data was analyzed to gather insights across questions/measures such as:</p><p>- Total number of subscribers for each subject</p><p>- Average number of subscribers for each subject</p><p>- Average cost per subject at each level</p><p>- Average content duration for each subject</p><p>- Average rating per subject for each level</p><p>Also, a calculated field ‘Free or Paid’ was derived using tableau to see what courses were free or paid at all levels. The calculated field took the logical expression in Tableau- If [Price] = 0 THEN ‘FREE’ ELSEIF [Price] &gt; 0 THEN ‘PAID’ END.</p><p>The course titles by subjects were also sorted by number of subscribers in descending order. Then, number of subscribers was converted to a dimension and used as a filter to show only the top 20 subscribed courses.</p><p>From this dashboard, we see that while web dev seemingly performed well, the Tab ‘Top 20 Subscribed Courses: Free or Paid’ shows that the large numbers came from free courses and not paid ones. Thus, total number of subscribers doesn’t necessarily = more revenue. More learners interested in Web Development need to subscribe for the paid courses.</p><p>At Beginner, Intermediate and Expert level, Graphic Design and Business courses had more ratings than the most subscribed courses in Web Development. These courses also performed in terms of number of subscribers at all levels for free and paid courses. Thus, there is opportunity to make these courses top performing course as well that will drive revenue upward.</p><p><strong>Recommendations</strong></p><p>Encourage users to leave ratings and reviews to aid Udemy understand how course delivery can be improved. This will also help learners with motivation to take up paid courses. Perhaps before a certificate is issued, users should be asked to leave reviews, ratings or feedback. User ratings help other users determine if there is value for money spent for paid courses.</p><p>I will appreciate your comments, suggestions and thoughts on this post in the comments. Please like this post too if you enjoyed reading.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=10043b2a005" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>