<?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 Temperance Godwin on Medium]]></title>
        <description><![CDATA[Stories by Temperance Godwin on Medium]]></description>
        <link>https://medium.com/@temperancegodwin?source=rss-5ea7cde6db67------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*a4-bzHIvF1Ca2q_H5JahFw.jpeg</url>
            <title>Stories by Temperance Godwin on Medium</title>
            <link>https://medium.com/@temperancegodwin?source=rss-5ea7cde6db67------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Mon, 16 Nov 2026 03:31:53 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@temperancegodwin/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[Is It Okay to Be a Data Analyst Without a Niche?]]></title>
            <link>https://medium.com/@temperancegodwin/is-it-okay-to-be-a-data-analyst-without-a-niche-ff46b03ca107?source=rss-5ea7cde6db67------2</link>
            <guid isPermaLink="false">https://medium.com/p/ff46b03ca107</guid>
            <category><![CDATA[data-analyst]]></category>
            <category><![CDATA[niche]]></category>
            <category><![CDATA[careers]]></category>
            <dc:creator><![CDATA[Temperance Godwin]]></dc:creator>
            <pubDate>Fri, 31 Oct 2025 18:52:44 GMT</pubDate>
            <atom:updated>2025-10-31T19:06:21.752Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*xftnGGx5NOnVTB4JXa34qw.jpeg" /></figure><p>When you think of a data analyst, what comes to mind? Do you imagine someone who’s deep into numbers, crunching data all day? Or do you picture someone specializing in one specific area, like customer analytics or financial forecasting? The truth is, the data analytics field is vast, and the question often comes up: <em>Is it okay to be a data analyst without a niche?</em></p><p>If you have ever wondered whether you need to specialize, or if you can thrive as a generalist, you are not alone. Many new data analysts, especially those starting out, are unsure whether they should focus on one niche or keep their skill set broad. In this article, the pros and cons of being a generalist versus niching down will be explored, along with guidance on how to decide what is best for your career.</p><h4>THE WORLD OF DATA ANALYTICS: SO MUCH TO EXPLORE</h4><p>The beauty of being a data analyst is that it’s not just one thing. A data analyst could work on anything from interpreting sales data, to analyzing user behavior, to forecasting trends for product development. You could be in marketing one day, healthcare the next, or even helping a tech startup understand how people interact with their products.</p><p>But here is the thing: within this huge range of possibilities, you will often hear that specializing is the best way to really stand out. “Pick a niche,” they say. But does it really matter if you don’t?</p><h4>THE CASE OF BEING A GENERALIST</h4><p>Being a generalist in data analytics means you have the ability to move between different industries, tackle different types of problems, and constantly challenge yourself to learn new things. It is like being a jack-of-all-trades, which, believe it or not, has its perks.</p><ol><li><strong>Endless Opportunities</strong></li></ol><p>When you don’t tie yourself down to one specific niche, you open the door to countless opportunities. As a generalist, you can work on a variety of projects across different industries. Maybe you work in retail one month, diving into sales data and customer behavior, and then switch to a project in healthcare, analyzing patient data. This kind of versatility can make you incredibly valuable to employers, especially those in smaller companies or startups where people wear many hats.</p><p>The variety also gives you the chance to explore different industries and see where you feel most at home. You might discover a passion for fintech or healthcare analytics that you wouldn’t have thought to explore otherwise.</p><p><strong>2. Flexibility to Adapt</strong></p><p>The data world is constantly evolving. New tools, trends, and technologies pop up all the time, and being a generalist makes you adaptable. You are not limited by the tools or methodologies you are used to because you’re comfortable working with a range of techniques. So when the next big thing comes along, whether it’s machine learning or AI-driven analytics, you can dive in with a fresh mindset.</p><p><strong>3. Broad Skill Set</strong></p><p>Being a generalist means you get to develop a wide array of skills. Whether it is SQL, Python, Tableau, or even soft skills like presenting complex data to non-technical audiences, you will be able to do it all. This can make you a highly sought-after team member, especially in environments that need flexibility.</p><h4>THE CHALLENGES OF BEING A GENERALIST</h4><p>As much as being a generalist sounds appealing, it is not without its challenges.</p><p><strong>1. Lack of Deep Expertise</strong></p><p>One of the drawbacks is that, while you are learning a little bit of everything, you might not become an expert in anything. Employers, especially in highly specialized industries, often want someone who can hit the ground running with deep expertise in a particular area. For example, if you are working in healthcare analytics, you will need to understand regulations, specific tools, and industry trends. Being a generalist might make you less attractive to companies who are looking for that level of deep knowledge.</p><p><strong>2. Standing Out Can Be Hard</strong></p><p>In a competitive job market, it is hard to stand out as a generalist. There are so many data analysts out there with similar skill sets. If you have not specialized, it can sometimes feel like you are just one of many. A niche, on the other hand, allows you to carve out your unique space. It can give you that edge when employers are deciding between you and another candidate.</p><p><strong>3. Slower Career Progression</strong></p><p>While being a generalist can give you a broad range of experiences, it might not necessarily fast-track your career. Many senior roles in data analytics require specialized knowledge. For instance, roles like a Data Science Lead, Product Analyst, or Machine Learning Engineer often require in-depth knowledge of specific tools, techniques, or industries. As a generalist, you might find it harder to climb to these specialized positions without narrowing your focus.</p><h4>WHEN SPECIALIZING MAKES SENSE</h4><p>If you have been a generalist for a while and you’re starting to feel the pressure to specialize, there are a few signs that it might be time to niche down.</p><p><strong>1. You Find a Passion</strong></p><p>If you have been working with data for a while and feel drawn to a particular industry or technique, say, predictive modeling, marketing analytics, or customer segmentation it could be a sign that you have found your niche. Passion drives expertise, and when you are genuinely interested in a specific area, you are more likely to dedicate the time and energy needed to become an expert.</p><p><strong>2. The Job Market Demands It</strong></p><p>In some industries, specialization is a must. For example, in sectors like finance, healthcare, or tech, companies often need highly specialized data analysts who understand not just the numbers, but the unique challenges and regulations of the industry. If you find that the opportunities you’re excited about require expertise in a niche area, it might be time to take the plunge and specialize.</p><p><strong>3. You Want to Command a Higher Salary</strong></p><p>Specialists tend to command higher salaries because their expertise is rare and valuable. By focusing on a niche, whether it is data visualization, machine learning, or a specific industry, you increase your value in the job market. Employers are often willing to pay more for someone who can solve specific problems with deep knowledge and experience.</p><h4>HOW TO FIND YOUR NICHE IN DATA ANALYTICS</h4><p>If you are leaning towards specializing, here’s how you can begin narrowing down your focus:</p><p><strong>1. Reflect on What You Enjoy</strong></p><p>Think about the projects and tasks that excite you the most. Do you love working with marketing data to understand customer behavior? Or do you prefer working with predictive models to forecast sales? The work that energizes you is a great indicator of where you might want to specialize.</p><p><strong>2. Evaluate Market Demand</strong></p><p>Look at job listings in the areas you are interested in. Are there roles that require deep expertise in certain tools, techniques, or industries? Understanding what skills are in high demand will help you decide where to focus.</p><p><strong>3. Develop Expertise Gradually</strong></p><p>Once you have chosen your niche, start building expertise in that area. Take relevant courses, participate in niche projects, and dive into industry-specific literature. Becoming an expert takes time, but it will pay off in terms of career growth and opportunities.</p><h4>CONCLUSION</h4><p>It is absolutely okay to be a data analyst without a niche, especially early on in your career or if you enjoy the variety of working across different industries. Being a generalist allows you to gain broad skills, explore different areas, and stay adaptable in an ever-changing field.</p><p>However, if you find yourself gravitating toward one specific area and feel passionate about it, specializing could open new doors for your career. Ultimately, the choice between being a generalist or a specialist depends on your career goals, personal interests, and the direction you want your professional life to take.</p><p>In the world of data analytics, there is no single path to success, there is room for everyone to thrive. The key is to keep learning, keep exploring, and make the choices that align with where you want to go.</p><p><em>Thank you for following through. Make sure to stick around for more articles related to data analysis and everything tech. I appreciate your claps.</em></p><p><em>Connect with me on </em><a href="https://twitter.com/Roshethequeen"><em>Twitter</em></a><em> and </em><a href="https://www.linkedin.com/in/temperance-godwin/"><em>LinkedIn</em></a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=ff46b03ca107" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[PAYMENT BEHAVIOR AND REVENUE OPTIMIZATION: An A/B TEST ANALYSIS OF NYC YELLOW TAXI TRIPS]]></title>
            <link>https://medium.com/@temperancegodwin/nyc-yellow-taxi-analysis-6289c3a57a49?source=rss-5ea7cde6db67------2</link>
            <guid isPermaLink="false">https://medium.com/p/6289c3a57a49</guid>
            <category><![CDATA[a-b-testing]]></category>
            <category><![CDATA[matplotlib]]></category>
            <category><![CDATA[hypothesis-testing]]></category>
            <category><![CDATA[pandas]]></category>
            <dc:creator><![CDATA[Temperance Godwin]]></dc:creator>
            <pubDate>Tue, 06 May 2025 23:40:32 GMT</pubDate>
            <atom:updated>2025-05-20T22:51:26.820Z</atom:updated>
            <content:encoded><![CDATA[<p>Tool used: Python</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*ZllVBBohmpEvQoLE.jpg" /></figure><p>Every day, thousands of yellow taxis cross the city, transporting locals, tourists, and business travelers. While the city pulses with this constant motion, questions emerge like when taxes are highest in demand and how long do trips last.</p><p>To make informed decisions about infrastructure, pricing models, traffic policies, and even driver support systems, we need to dig into the data.</p><p>As part of the strategic planning team for the New York City Transportation Authority, i stepped into the role of a data analyst tasked with uncovering insights from NYC Yellow Taxi trip data. By exploring patterns in trip duration, pickup and drop-off locations, fare structures, and time-based behaviors, this analysis supports data-driven decisions that can shape the future of urban mobility in New York City.</p><h4>PROBLEM STATEMENT</h4><p>Increasing revenue is crucial for both long-term sustainability and driver satisfaction. This project seeks to leverage data-driven strategies to optimize earnings for taxi drivers. Specifically, we investigate whether the method of payment influences the fare amount, focusing on the potential link between payment type and total fare.</p><h4>RESEARCH QUESTIONS</h4><ol><li>Is there a significant relationship between the total fare paid and the type of payment used?</li><li>Can customer behavior be influenced to prefer higher-revenue payment options without reducing customer satisfaction?</li></ol><h4>OBJECTIVE</h4><p>The primary aim of this project is to conduct an A/B test to assess whether there’s a meaningful difference in fare amounts based on the customer’s payment method. By using Python for statistical hypothesis testing and descriptive analytics, we aim to uncover trends that can help drivers optimize their income. Specifically, the focus is on comparing credit card payments to cash payments to determine if one consistently results in higher fares.</p><h4>DATA SOURCE</h4><p>Kaggle: Check data <a href="https://www.kaggle.com/datasets/elemento/nyc-yellow-taxi-trip-data">here</a></p><h4>DATA OVERVIEW</h4><p>This analysis draws on a robust dataset from the New York City Taxi and Limousine Commission, containing detailed records of taxi trips. After applying data cleaning techniques and performing feature engineering, we isolated the essential variables needed for this investigation, including fare amount, payment type, trip duration, and passenger count.</p><h4>METHODOLOGY</h4><p>Descriptive Statistics: Used to summarize and visualize key variables such as fare amount and payment method distribution.</p><p>Hypothesis Testing: A two-sample T-test was conducted to assess if there’s a statistically significant difference in fare amounts between payment types.</p><p>Regression Analysis: Applied linear regression to examine the correlation between trip duration (derived from pickup and drop-off times) and fare amount.</p><p>View code <a href="https://github.com/Temperance-Godwin/NYC-YELLOW-TAXI-ANALYSIS/blob/main/NYC%20Yellow%20Taxi%20Analysis.ipynb">here</a></p><h4>KEY INSIGHTS</h4><ol><li>Trip and Fare Trends by Payment Type Customers who paid using credit cards typically had longer trips and higher fares than those who paid in cash. This may suggest a tendency for riders to opt for card payments when taking longer or more expensive trips.</li></ol><p>Distribution of fare amount</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/822/0*8pLb_PrTUUEf06tH.png" /></figure><p>Distribution of trip distance</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/822/0*RQ_54fdqlLqGPCj0.png" /></figure><p>2. Customer Payment Preferences Card payments made up 67.5% of all transactions, while cash accounted for just 32.5%. This points to a significant leaning toward card usage, possibly due to perceived ease, security, or available rewards.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/481/0*KoqPHiUDsiu0B3RD.png" /></figure><p>3. Passenger Count Trends Single-passenger trips dominated card payment transactions, making up 40.08% of such payments. For cash payments, solo riders accounted for 20.04%. As the number of passengers increased, the proportion of both card and cash transactions dropped, suggesting that larger groups might prefer other transportation options or payment methods. These patterns underscore the importance of considering both the number of passengers and the payment method when analyzing taxi transaction data.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/989/0*BVV7jN1tLdACtfch.png" /></figure><h4>HYPOTHESIS TESTING</h4><p>Null Hypothesis (H₀): There is no difference in average fare between card-paying and cash-paying customers.</p><p>Alternative Hypothesis (H₁): There is a significant difference in average fare between card and cash transactions.</p><p>Q-Q plot of Fare Amount</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/563/0*G6sBgu7dXcJD8oMS.png" /></figure><p><em>Using a T-statistic of 169.21 and a p-value below 0.05, we reject the null hypothesis. This outcome indicates a statistically significant difference in fare amounts between the two payment methods.</em></p><h4>RECOMMENDATIONS</h4><ol><li>Promote the use of credit cards to help drivers earn more per trip by:</li></ol><ul><li>Displaying in-app prompts or messages during the booking process that highlight the benefits of using card payments, such as faster checkouts or contactless convenience.</li><li>Equiping drivers with small signs or digital displays inside the vehicle encouraging card payments.</li><li>Providing training for drivers to politely suggest card payment when appropriate.</li></ul><p>2. Introduce incentives, such as discounts or loyalty programs, to encourage customers to choose card payments by:</p><ul><li>Collaborating with payment providers to offer limited-time promotions, such as small discounts (e.g., $1 off) for customers who pay with a card.</li><li>Launching loyalty rewards programs where customers earn points for each card transaction, redeemable for future discounts or free rides.</li><li>Offering bundled deals — such as a discount on a return trip — exclusively for card users.</li></ul><p>3. Ensure the payment system is smooth, secure, and reliable to increase customer confidence and preference for card transactions by:</p><ul><li>Upgrading in-vehicle payment terminals to ensure quick and reliable card processing, including contactless and mobile payment options (Apple Pay, Google Pay, etc.).</li><li>Improving the in-app experience by allowing customers to securely save their card details for one-click payments.</li><li>Ensuring transparent digital receipts are automatically sent post-ride to build trust and reduce disputes.</li></ul><p>4. Leverage Data for targeted communication by:</p><ul><li>Analyzing customer payment behavior and send personalized messages or push notifications to frequent cash users, highlighting the advantages of card payments.</li></ul><p>5. Monitor and Measure Impact Continuously by:</p><ul><li>Tracking changes in payment method trends over time after implementing incentives or interface changes.</li><li>Collecting feedback from both drivers and riders to refine the strategies.</li><li>Using periodic A/B tests to validate whether new tactics effectively increase card usage without compromising customer experience.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/846/0*-MfjKltlsAQjPViz" /></figure><h3>Thank you for following through.</h3><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=6289c3a57a49" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[HOW TO FIND YOUR PLACE (AND THRIVE) IN THE TECH INDUSTRY]]></title>
            <link>https://medium.com/@temperancegodwin/how-to-find-your-place-and-thrive-in-the-tech-industry-154789c8366f?source=rss-5ea7cde6db67------2</link>
            <guid isPermaLink="false">https://medium.com/p/154789c8366f</guid>
            <dc:creator><![CDATA[Temperance Godwin]]></dc:creator>
            <pubDate>Thu, 20 Mar 2025 00:00:14 GMT</pubDate>
            <atom:updated>2025-09-29T23:40:49.473Z</atom:updated>
            <content:encoded><![CDATA[<p><strong>HOW TO FIND YOUR PLACE (AND THRIVE) IN THE TECH INDUSTRY</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*CGSr1-frHznnLIiTiE3MCQ.jpeg" /></figure><p>If there is one thing I know about breaking into tech, it is that it’s not just about learning to code or understanding data, it is about discovery. It is about trial and error, questioning everything, and sometimes feeling completely lost before you find your way.</p><p>I’ve been there. Staring at a screen full of code that didn’t make sense. Wondering if I was smart enough to be in the industry. Seeing others get opportunities while I was stuck, applying endlessly with no response. But here’s what I realized: <strong>tech isn’t just for “geniuses” or people who’ve been coding since they were kids, it is for problem solvers, for the curious, for the ones willing to keep going.</strong></p><p>Some of the best people in tech today didn’t start with traditional CS degrees. Some started with a love for gaming, a curiosity about how websites work, or a deep desire to automate boring tasks. The paths are endless, and the beauty of tech? <strong>It is an open world. You get to choose your adventure.</strong></p><h4>Tech Is an Open World Game - Choose Your Path</h4><p>The beauty of tech is that it’s like an open-world game, you don’t have to follow one strict path. There are multiple entry points, and you get to decide how you play.</p><p>Some people start in <strong>software engineering</strong>, coding their way through exciting projects. Others find their calling in <strong>data science</strong>, unraveling insights hidden within numbers. Some thrive in <strong>product management</strong>, bridging tech and business, while others excel in <strong>UI/UX design</strong>, making digital experiences seamless and intuitive.</p><p>So, the first step? <strong>Explore the landscape.</strong> Try different things. Attend workshops, watch YouTube tutorials, take free online courses, or take paid courses. You don’t have to commit to one path right away, give yourself room to experiment.</p><h4>The First Boss Battle — Overcoming Imposter Syndrome</h4><p>You will feel like a fraud at some point. It happens to everyone. That first time you stare at a piece of code that makes zero sense, or when you compare yourself to “tech geniuses” on Twitter, doubt will creep in.</p><p>Here’s the truth: <strong>No one starts as an expert.</strong> Everyone you admire in tech was once where you are now. They struggled, they doubted themselves, but they kept going. The key is to <strong>push through the discomfort and keep learning</strong>. Start small, build confidence with mini-projects, and celebrate small wins. Every bug you fix, every concept you grasp, that is progress.</p><h4>Level Up — Learning by Doing</h4><p>Reading books and taking courses is great, but real learning happens when you <strong>build something.</strong></p><ul><li>Want to be a developer? <strong>Build a personal website or a simple app.</strong></li><li>Interested in data? <strong>Analyze a dataset and create visualizations.</strong></li><li>Thinking about product management? <strong>Break down successful tech products and write case studies.</strong></li></ul><p>The more hands-on experience you gain, the more you stand out. Employers and recruiters love to see practical work over just certificates.</p><h4>The Secret Weapon — Innovation</h4><p>Tech is not just about learning existing skills, it is about <strong>solving problems in new ways.</strong> The most successful people in tech don’t just follow the rules; they create their own opportunities.</p><ul><li>Build an AI-powered career advisor for job seekers.</li><li>Design an app that helps students&#39; study more efficiently.</li><li>Create a tool that automates boring tasks for small businesses.</li></ul><p><strong>You don’t need permission to innovate.</strong> Start small, test ideas, and refine them. The projects you work on today could turn into the startup, product, or career breakthrough that changes your life.</p><h4>The Multiplayer Mode — Community &amp; Networking</h4><p>No one succeeds in tech alone. Find a community that supports your growth.</p><ul><li>Join LinkedIn discussions and connect with industry professionals.</li><li>Attend hackathons and local meetups.</li><li>Contribute to open-source projects.</li><li>Seek mentors who’ve walked the path before you.</li></ul><p>Opportunities often come through <strong>relationships, not just applications</strong>. Make yourself visible in the right spaces, and the right opportunities will start finding you.</p><h4>The Final Boss — Building a Legacy</h4><p>Once you’ve found your footing, the real challenge begins: <strong>How will you leave your mark?</strong></p><ul><li>Will you build something revolutionary?</li><li>Will you mentor and uplift others?</li><li>Will you write, speak, or teach to share your knowledge?</li></ul><p>Tech is more than just a career; it’s a platform to <strong>make an impact.</strong> Whether it’s launching your own startup, leading groundbreaking projects, or inspiring the next generation, your journey doesn’t stop at just “getting a job.”</p><h4>Conclusion: Your Adventure Awaits</h4><p>Finding yourself in tech isn’t about following a predefined script — it’s about embracing the adventure, learning from every challenge, and carving your own unique path.</p><p>So, if you’re staring at your screen wondering if you belong here, let me tell you: <strong>You do.</strong> Tech is waiting for you to take your first step, explore, create, and innovate.</p><p><em>Thank you for following through. Make sure to stick around for more articles related to data analysis and everything tech. I appreciate your claps.</em></p><p><em>Connect with me on </em><a href="https://twitter.com/Roshethequeen"><em>Twitter</em></a><em> and </em><a href="https://www.linkedin.com/in/temperance-godwin/"><em>LinkedIn</em></a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=154789c8366f" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[FINDING YOUR ROLE, MASTERING THE TOOLS, AND CARVING OUT YOUR NICHE IN DATA ANALYTICS.]]></title>
            <link>https://medium.com/@temperancegodwin/finding-your-role-mastering-the-tools-and-carving-out-your-niche-in-data-analytics-90a3bc3de401?source=rss-5ea7cde6db67------2</link>
            <guid isPermaLink="false">https://medium.com/p/90a3bc3de401</guid>
            <category><![CDATA[data-analytics]]></category>
            <category><![CDATA[data-roles]]></category>
            <category><![CDATA[technicaltools]]></category>
            <dc:creator><![CDATA[Temperance Godwin]]></dc:creator>
            <pubDate>Sat, 05 Oct 2024 02:16:43 GMT</pubDate>
            <atom:updated>2025-10-31T18:58:23.101Z</atom:updated>
            <content:encoded><![CDATA[<p><em>“Data analytics is not a one-size-fits-all field; from business analysts to data scientists, each role contributes uniquely to how we interpret and leverage data. The key is finding where your skills best fit within this evolving landscape.” — John Miller, 2020</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*1Uha3EKOIynfC7ikJg0Q3g.jpeg" /></figure><p>I’ve always believed that storytelling transcends art, it’s the way we shape our world, the way we influence change, and the way we grow. If there’s one industry that thrives on storytelling, it’s data analytics. At its core, data analytics is about translating numbers into narratives, uncovering the truth behind patterns, and making informed decisions. But here’s the thing: within this vast, complex universe, there are several roles to play.</p><p>Today, let’s journey through the different roles in data analytics, explore the tools that power these positions, and understand the industries that need them. And for those ready to carve their path, we’ll even dive into how you can find your niche.</p><p><strong>THE ANALYST’S PLAYGROUND: EXPLORING THE ROLES.</strong></p><p>The first question anyone entering data analytics asks is often, “What exactly do analysts do?” But in truth, there’s no one-size-fits-all answer. The title “analyst” is broad, spanning across multiple subfields, each with its unique focus. Let’s break down the major roles:</p><ol><li><strong>Data Analyst</strong>: Often the first step into the world of analytics, a data analyst is like the detective of the digital world. They dig into data sets, clean, organize, and visualize data to help businesses make data-driven decisions. Imagine working for an e-commerce brand and discovering through data which products are most in-demand during specific seasons, this is the work of a data analyst.</li><li><strong>Business Analyst:</strong> This role is all about bridging the gap between business needs and technical solutions. Business analysts work closely with stakeholders to understand the bigger picture, define business goals, and translate these into actionable insights from data. They don’t just ask what the data says, they ask why and what next?</li><li><strong>Financial Analyst:</strong> These analysts are the gatekeepers of financial data. They look at trends, market conditions, and financial statements to provide forecasts and advice on investments. Think about predicting stock market trends or assessing risks for a fintech startup; this is the domain of the financial analyst.</li><li><strong>Data Scientist:</strong> While the term “data scientist” gets thrown around a lot, these professionals take analytics a step further, using advanced statistical methods, machine learning, and even AI to forecast future trends or automate decision-making processes.</li><li><strong>Product Analyst:</strong> A more specialized role in product development and marketing, product analysts gather data related to user behavior, features, and market conditions to help shape the future of a product. In fintech, for instance, they might analyze customer onboarding data to streamline app experiences.</li><li><strong>Marketing Analyst:</strong> Marketing analysts are the key players when it comes to understanding customer behavior and campaign effectiveness. They help companies optimize their marketing strategies by analyzing performance data, customer demographics, and market trends. With consumer preferences constantly shifting, marketing analysts are always on their toes.</li><li><strong>Operations Analyst:</strong> are at the heart of optimizing a company’s processes, making sure the organization runs as efficiently as possible. This role involves analyzing internal workflows, identifying inefficiencies, and suggesting improvements. Operations analysts are vital in industries with complex supply chains and logistics, where reducing waste and improving efficiency can lead to massive savings.</li></ol><p><strong>TOOLS OF THE TRADE: ESSENTIAL TECHNOLOGIES.</strong></p><p>Every great storyteller needs tools, and in the world of data analytics, mastering the right technologies is key to success. Here are the essential tools every analyst should have in their arsenal:</p><ol><li><strong>Microsoft Excel:</strong> It might seem old school, but Excel remains a powerful tool for basic data analysis, especially in smaller datasets. From pivot tables to complex formulas, Excel is often the starting point for new analysts.</li><li><strong>SQL (Structured Query Language):</strong> SQL is the language of databases. Whether you’re retrieving customer information for a retail company or querying financial data, SQL allows analysts to pull, join, and filter data from databases efficiently.</li><li><strong>Python and R:</strong> These programming languages are essential for more advanced data manipulation, analysis, and visualization. Python, in particular, has become a favorite among data scientists due to its versatility and extensive libraries like Pandas and Matplotlib.</li><li><strong>Tableau/Power BI:</strong> These are data visualization tools that allow analysts to create dashboards and visual stories from their data. You could spend hours explaining trends, or you could build a compelling visual that tells the story in seconds.</li><li><strong>Google Analytics: </strong>For those in digital marketing, Google Analytics is indispensable. It tracks website traffic, user behavior, and marketing effectiveness, providing real-time data for companies looking to optimize their online presence.</li></ol><p><strong>INDUSTRIES THAT THRIVE ON DATA.</strong></p><p>Where can your skills as a data analyst take you? The answer is everywhere. Data is the lifeblood of modern business, and no sector is left untouched by the need for data-driven insights. Here’s a snapshot of some major industries and how they leverage data:</p><ol><li><strong>Finance:</strong> Financial analysts work in banking, investments, and fintech to assess risk, monitor markets, and predict trends. Hedge funds and trading platforms are increasingly relying on machine learning algorithms to make split-second trading decisions.</li><li><strong>Healthcare:</strong> With the rise of electronic health records (EHRs) and wearable tech, healthcare providers are using data to track patient outcomes, reduce costs, and personalize treatments. This industry needs data analysts to ensure efficient operations and improved patient care.</li><li><strong>E-Commerce:</strong> From tracking customer behavior to optimizing inventory management, data analytics is pivotal in e-commerce. Analysts here provide insights on everything from pricing strategies to marketing campaigns.</li><li><strong>Marketing and Advertising</strong>: Data analytics is crucial in understanding customer preferences, optimizing ad spend, and tracking campaign performance. Brands rely on digital marketing data to fine-tune their strategies and personalize their messaging.</li><li><strong>Product Management (Tech)</strong>: In tech companies, product analysts monitor user engagement, feature adoption, and the overall success of a product, using data to shape product roadmaps and create better user experiences.</li></ol><p><strong>FINDING YOUR NICHE.</strong></p><p>So how do you find your niche in such a vast field? Here are some key steps:</p><ol><li><strong>Leverage Your Strengths:</strong> Start by asking yourself which aspect of data analytics excites you the most. Do you love numbers and forecasting trends? Financial analytics might be your calling. Are you fascinated by user behavior? Maybe product analytics is your sweet spot.</li><li><strong>Industry Knowledge Matters:</strong> Once you know your strengths, think about which industries resonate with you. Do you see yourself in healthcare, helping improve patient outcomes? Or maybe you’re drawn to fintech, where your insights can help shape the future of finance?</li><li><strong>Stay Agile:</strong> The beauty of data analytics is that it’s evolving. Stay curious. Explore machine learning if you’re into predictive modeling. Dive into new tools or learn how to manage larger datasets. The more versatile you are, the more opportunities will open up.</li><li><strong>Network and Learn:</strong> Follow thought leaders, attend webinars, and join communities. This will not only keep you updated but will help you find mentors or collaborators who can guide you towards your niche.</li></ol><p><strong>CONCLUSION.</strong></p><p>At the end of the day, data is more than numbers on a spreadsheet — it’s the raw material for stories. And as a data analyst, you’re the storyteller. Whether you’re helping a fintech startup forecast its next move, optimizing a product’s user experience, or driving a healthcare company to deliver better patient care, the opportunities are endless.</p><p>The key is understanding the role you want to play, mastering the tools needed, and finding the industry that speaks to you. So, if you’re ready to make an impact, pick your path, hone your skills, and most importantly, tell a story worth hearing.</p><p><em>Thank you for following through. Make sure to stick around for more articles related to data analysis and everything tech. I appreciate your claps.</em></p><p><em>Connect with me on </em><a href="https://twitter.com/Roshethequeen"><em>Twitter</em></a><em> and </em><a href="https://www.linkedin.com/in/temperance-godwin/"><em>LinkedIn</em></a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=90a3bc3de401" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[STRIKING THE BALANCE: DEVELOPING TECHNICAL AND SOFT SKILLS IN DATA ANALYSIS]]></title>
            <link>https://medium.com/@temperancegodwin/striking-the-balance-developing-technical-and-soft-skills-in-data-analysis-58982a238b22?source=rss-5ea7cde6db67------2</link>
            <guid isPermaLink="false">https://medium.com/p/58982a238b22</guid>
            <category><![CDATA[soft-skills]]></category>
            <category><![CDATA[technical-skills]]></category>
            <category><![CDATA[technicaltools]]></category>
            <category><![CDATA[data-analysis]]></category>
            <dc:creator><![CDATA[Temperance Godwin]]></dc:creator>
            <pubDate>Sat, 15 Jun 2024 09:28:50 GMT</pubDate>
            <atom:updated>2024-06-15T09:30:38.438Z</atom:updated>
            <content:encoded><![CDATA[<p><strong><em>“Your technical skills help you acquire employment, and your soft skills help you ensure your employability. Hence, integrate technical and soft skills to fast-track your career- Professor M.S Rao”</em></strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*qL-qsTw5_hD67EqW4v1rWg.png" /></figure><p>In life, certain things go together. Having a perfect blend of technical skills and soft skills is one of them. Developing a strong skill set that combines technical and soft abilities may advance a person’s career and business. It is more difficult than it seems to have this set of abilities at your disposal, but magic always happens when the two work together.<br>Data analysts are becoming increasingly important across industries in today’s data-driven society. It’s in great demand to be able to sort through large datasets, identify patterns, and offer useful insights. Though having technical skills is the cornerstone of data analysis, soft skills serve as the link between technical skills and practical application. The significance of both skill sets and how they work together to produce a good data analyst are examined in this article.</p><p><strong>THE IMPORTANCE OF TECHNICAL KNOWLEDGE IN DATA ANALYSIS</strong></p><p>1.<strong> Data Manipulation and Analysis:</strong> It is essential to be proficient with tools like Excel, R, Python, and SQL. Excel is crucial for preliminary data exploration and reporting, Python and R for statistical analysis and data manipulation, and SQL for database querying.</p><p>2. <strong>Data Visualization:</strong> Data analysts can present data in an informative and visually appealing way with the use of tools like Tableau, and Power BI. Complex data may be transformed into useful insights through effective data visualization.</p><p>3. <strong>Data Cleaning and Preparation:</strong> This is the basic step needed to take as a data analyst before any analysis. Using tools like Excel and Power BI Power Query, SQL, and Python can be used for this process</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/680/1*AKiVL04x3TuH39wxNEDkHQ.png" /><figcaption><strong>Example of technical tools used for data analysis</strong></figcaption></figure><p><strong>THE IMPORTANCE OF SOFT SKILLS IN DATA ANALYSIS</strong></p><ol><li><strong>Communication:</strong> Translating complex findings into insights that non-technical stakeholders can understand requires effective communication. Communication covers the capacity for written and oral interaction as well as the production of engaging reports and presentations.</li><li><strong>Collaboration and Teamwork</strong>: When working with colleagues from several departments, including marketing, finance, and IT, data analysts frequently collaborate as members of a broader team. Implementing successful data initiatives requires the ability to collaborate well with others, exchange knowledge, and incorporate input.</li><li><strong>Effective time management:</strong> Effective time management ensures that data projects are completed on time and meet quality standards. It also helps in balancing multiple projects and deadlines.</li><li><strong>Problem-solving and critical thinking: </strong>Effective problem-solving abilities are essential for handling the many difficulties that come up in data processing. The capacity for innovative problem-solving is essential for handling incomplete data, identifying mistakes, and streamlining procedures. Just like problem-solving, data analysts must learn to think critically. This entails having the capacity to approach issues rationally, challenge assumptions, and examine the evidence from various perspectives to make sure that the results are reliable and objective.</li><li><strong>Adaptability:</strong> Because the data world is always changing, data analysts need to be adaptable and receptive to new problems, tools, and approaches.</li><li><strong>Attention to detail: </strong>Reading and analyzing complex code and technological structure with great attention is required for data analysis. Because of this, data analysts need to be highly focused and skilled to finish tasks successfully.</li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/728/1*F1Rrv0-N4WZ7eV2SBVaC9w.png" /><figcaption><strong>Example of soft skills needed in data analysis</strong></figcaption></figure><p><strong>HOW TO BALANCE BOTH SKILLS</strong></p><ol><li><strong>Seeking feedback:</strong> Asking mentors and peers for input on your technical work and soft skills regularly may enhance your approach and identify areas for development by receiving constructive feedback.</li><li><strong>Practical Application:</strong> Utilize technical skills to solve practical issues. Take part in projects that involve statistical analysis, visualization, and data manipulation. At the same time, learn to communicate your findings using reports and presentations to explain your research to non-technical audiences.</li><li><strong>Embrace a growth mindset: </strong>Embrace difficulties and see setbacks as teaching moments by adopting a development attitude. This way of thinking encourages adaptation and ongoing development, important qualities necessary for success in the fast-paced profession of data analytics.</li><li><strong>Continuous learning:</strong> Keep yourself informed on the latest data analytics tools and technology. Technical skills can be improved using online workshops, certificates, and courses. Seek out possibilities to enhance soft skills concurrently through training courses and practical experience.</li><li><strong>Networking and collaboration: </strong>While working together on projects develops cooperation and problem-solving skills, networking with other experts offers insights into industry trends and best practices.</li></ol><p><strong>CONCLUSION</strong></p><p>Balancing technical and soft skills is essential for any data analyst aiming for excellence. While technical skills enable you to manipulate and interpret data effectively, soft skills ensure that your findings are communicated and utilized in the best possible way. By actively working on developing both, you can become a more versatile and impactful data analyst, capable of driving meaningful change within your organization.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=58982a238b22" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[INFLUENCER MARKETING ANALYSIS(An end-to-end project)]]></title>
            <link>https://medium.com/@temperancegodwin/influencer-marketing-analysis-an-end-to-end-project-65b664b36c99?source=rss-5ea7cde6db67------2</link>
            <guid isPermaLink="false">https://medium.com/p/65b664b36c99</guid>
            <category><![CDATA[market-analysis]]></category>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[influencer-marketing]]></category>
            <dc:creator><![CDATA[Temperance Godwin]]></dc:creator>
            <pubDate>Sat, 01 Jun 2024 02:00:57 GMT</pubDate>
            <atom:updated>2024-06-01T05:12:40.127Z</atom:updated>
            <content:encoded><![CDATA[<p><strong>TOOLS USED</strong>: <strong>EXCEL</strong> (For Data Exploration), <strong>SQL</strong> (For data cleaning, analyzing, and testing), AND <strong>POWER BI</strong> (For data visualization through dashboards)</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*a2bAnQpBsTP5nTxeIXhfgg.gif" /></figure><p><strong>INTRODUCTION</strong></p><p>The objective of this analysis centers on discovering the top-performing UK Youtubers to form marketing collaborations throughout 2024.</p><p><strong>PROBLEM STATEMENT.</strong></p><p>Sharon, the Head of Marketing, has found it challenging to identify the top YouTube channels in the UK for marketing campaigns. Her online research is hindered by overly complicated and conflicting insights. Calls with third-party providers have also been unhelpful, as they offer expensive options with underwhelming results. Additionally, the BI reporting team lacks the bandwidth to assist her with this task.</p><p>As the Head of Marketing, she needs a dashboard that analyzes YouTube channel data in the UK. This dashboard should enable her to identify the top-performing channels by evaluating metrics such as subscriber base and average views. With these insights, she can make better decisions about which YouTubers to collaborate with, ensuring each marketing campaign is as effective as possible.</p><p>For this analysis, we’re going to focus on the questions below to get the information we need for our marketing client -</p><p>Here are the key questions we need to answer for our marketing client:</p><ol><li>Who are the top 10 YouTubers with the most subscribers?</li><li>Which 3 channels have uploaded the most videos?</li><li>Which 3 channels have the most views?</li><li>Which 3 channels have the highest average views per video?</li><li>Which 3 channels have the highest views per subscriber ratio?</li><li>Which 3 channels have the highest subscriber engagement rate per video uploaded?</li></ol><p><strong>DATA SOURCE</strong></p><p>The data is sourced from<a href="https://www.kaggle.com/datasets/bhavyadhingra00020/top-100-social-media-influencers-2024-countrywise?resource=download"> Kaggle</a></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Q02YazRJr04lN-1xV4niEQ.png" /></figure><p><strong>SKILLS DEMONSTRATED</strong></p><ol><li>SQL Aggregates</li><li>DAX functions</li><li>Data Visualization</li></ol><p><strong>DATA CLEANING.</strong></p><p>The data-cleaning process was done in SQL. The dataset was imported from Excel. The criteria or the data-cleaning process involves retaining only the relevant columns, ensuring data types are suitable for each column&#39;s contents, and making sure no columns contain null values, ensuring all records are complete.</p><ol><li>Removing unnecessary columns from the table: For this analysis, i need nombre, total subscribers, total views, total videos</li></ol><pre>SELECT NOMBRE,<br>       total_subscribers,<br>       total_views,<br>       total_videos<br>FROM top_uk_youtubers_2024;</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/565/1*68tNnMynQQFVVv_1n9owZQ.png" /></figure><p>2. Extracting the channel names from nombre columns: For this step, I used the CHARINDEX, CAST, and SUBSTRING function</p><p>The CHARINDEX function is used to find the starting position of one string inside another string</p><pre>SELECT CHARINDEX (&#39;@&#39;, NOMBRE) AS position_of_@,<br>       NOMBRE<br>FROM top_uk_youtubers_2024</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/403/1*hjlvYJsxwbnDbfQecW852Q.png" /></figure><p>Next, I used the SUBSTRING function and the CAST function to make sure the column is in string format</p><pre>SELECT CAST(SUBSTRING (NOMBRE,1, CHARINDEX(&#39;@&#39;, NOMBRE)-1) AS varchar(100)) AS channel_name<br>FROM top_uk_youtubers_2024</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/295/1*dttLBdNjpiejdokLnYDiWg.png" /></figure><pre>SELECT CAST(SUBSTRING (NOMBRE,1, CHARINDEX(&#39;@&#39;, NOMBRE)-1) AS varchar(100)) AS channel_name,<br>       total_subscribers,<br>       total_videos,<br>       total_views<br>FROM top_uk_youtubers_2024</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/543/1*1s0uJ14oIciAWSiBKZgGew.png" /></figure><p><strong>DATA QUALITY TEST</strong></p><p>I need high-quality data for this analysis. I rule out missing figures, inaccurate data, and duplicate data.</p><p>Some datasets that need to be conducted include</p><ol><li>Row count check</li><li>Column count check</li><li>Data type check</li><li>Duplicate check</li></ol><p><strong>Row Count Check:</strong> The data needs to be 100 records of YouTube channels</p><pre>SELECT COUNT(*) AS Total_no_of_rows<br>FROM uk_youtubers_2024</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/149/1*O2pi_Lz34GGAK3HWkMw7gQ.png" /></figure><p><strong>Column Count Check:</strong> The data needs 4 fields</p><pre>SELECT <br>      COUNT(*) AS column_count<br>FROM INFORMATION_SCHEMA.COLUMNS<br>WHERE TABLE_NAME =&#39;uk_youtubers_2024&#39;</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/142/1*pPkLKrgfJG8-BSJW_3adfg.png" /></figure><p><strong>Data Type Check: </strong>The channel name column must be in string format, and the other columns must be numerical data type(integer)</p><pre>SELECT COLUMN_NAME,<br>         DATA_TYPE<br>FROM INFORMATION_SCHEMA.COLUMNS<br>WHERE TABLE_NAME =&#39;uk_youtubers_2024&#39;</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/222/1*bOiKj7UIe7qtC4Wj6xFz0A.png" /></figure><p><strong>Duplicate Count Check:</strong> Each record must be unique in the dataset</p><pre>SELECT channel_name,<br>       COUNT(*) AS duplicate_count<br>FROM uk_youtubers_2024<br>GROUP BY channel_name<br>HAVING COUNT(*)&gt;1</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/214/1*8Gsy6yJZIsXdptdqeS9Kuw.png" /><figcaption>No Duplicate Found.</figcaption></figure><p><strong>CREATING DAX MEASURES</strong></p><ol><li><strong>Total Subscribers(M)</strong></li></ol><pre>Total Subscribers (M) = <br>VAR million = 1000000<br>VAR sumOfSubscribers = SUM(view_uk_youtubers_2024[total_subscribers])<br>VAR totalSubscribers = DIVIDE(sumOfSubscribers,million)<br><br>RETURN totalSubscribers</pre><p><strong>2. Total Views(B)</strong></p><pre>Total Views (B) = <br>VAR billion = 1000000000<br>VAR sumOfTotalViews = SUM(view_uk_youtubers_2024[total_views])<br>VAR totalViews = ROUND(sumOfTotalViews / billion, 2)<br><br>RETURN totalViews</pre><p>3.<strong> Total Videos</strong></p><pre>Total Videos = <br>VAR totalVideos = SUM(view_uk_youtubers_2024[total_videos])<br><br>RETURN totalVideos</pre><p>4. <strong>Subscriber Engagement Rate</strong></p><pre>Subscriber Engagement Rate = <br>VAR sumOfTotalSubscribers = SUM(view_uk_youtubers_2024[total_subscribers])<br>VAR sumOfTotalVideos = SUM(view_uk_youtubers_2024[total_videos])<br>VAR subscriberEngRate = DIVIDE(sumOfTotalSubscribers, sumOfTotalVideos, BLANK())<br><br>RETURN subscriberEngRate </pre><p>5. <strong>Views per Subscriber</strong></p><pre>Views Per Subscriber = <br>VAR sumOfTotalViews = SUM(view_uk_youtubers_2024[total_views])<br>VAR sumOfTotalSubscribers = SUM(view_uk_youtubers_2024[total_subscribers])<br>VAR viewsPerSubscriber = DIVIDE(sumOfTotalViews, sumOfTotalSubscribers, BLANK())<br><br>RETURN viewsPerSubscriber </pre><p>6. <strong>Average views per video</strong></p><pre>Average Views per Video (M) = <br>VAR sumOfTotalViews = SUM(view_uk_youtubers_2024[total_views])<br>VAR sumOfTotalVideos = SUM(view_uk_youtubers_2024[total_videos])<br>VAR  avgViewsPerVideo = DIVIDE(sumOfTotalViews,sumOfTotalVideos, BLANK())<br>VAR finalAvgViewsPerVideo = DIVIDE(avgViewsPerVideo, 1000000, BLANK())<br><br>RETURN finalAvgViewsPerVideo </pre><p><strong>DATA VISUALIZATION</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/874/1*UbuIYqBoQZIUd4k_jeAQ_A.png" /></figure><p>To interact with the dashboard, <a href="https://app.powerbi.com/view?r=eyJrIjoiMGZkOWFjNGQtZGM3Zi00ZjFhLThiM2MtZThhN2Q2OTA0YWQ0IiwidCI6Ijg0ZGZiOGY5LWYzMTItNDk1NC05ZTk5LWYzZjcxMTgzZDZmMSJ9">click here</a></p><p><strong>FINDINGS</strong></p><ol><li>Who are the top 10 YouTubers with the most subscribers?</li></ol><pre>SELECT TOP 10 channel_name,<br>       total_subscribers<br>FROM uk_youtubers_2024<br>GROUP BY channel_name, total_subscribers<br>ORDER BY total_subscribers DESC;</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/252/1*bP8kRDSKpqTdbzz3lMc0og.png" /></figure><p>2. Which 3 channels have uploaded the most videos?</p><pre>SELECT TOP 3 channel_name,<br>       total_videos<br>FROM uk_youtubers_2024<br>GROUP BY channel_name, total_videos<br>ORDER BY total_videos DESC</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/235/1*e7xxdxRp7YgAcr7j-hyctw.png" /></figure><p>3. Which 3 channels have the most views?</p><pre>SELECT TOP 3 channel_name,<br>       ROUND(total_views,-8) AS total_views<br>FROM uk_youtubers_2024<br>GROUP BY channel_name, total_views<br>ORDER BY total_views DESC</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/209/1*qcrXAy1KHOq6c3YhjgnZhw.png" /></figure><p>4. Which 3 channels have the highest average views per video?</p><pre><br>SELECT TOP 3 channel_name,<br>       ROUND(CAST(total_views AS FLOAT)/total_videos,-6) AS Avg_views_per_video<br>FROM uk_youtubers_2024<br>GROUP BY channel_name, total_videos,total_views<br>ORDER BY Avg_views_per_video DESC</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/247/1*aVcb3qwQRQTG5FEJDbyD0g.png" /></figure><p>5. Which 3 channels have the highest views per subscriber ratio?</p><pre>SELECT Top 3 channel_name,<br>         (total_views/total_subscribers) As Total_views_per_subscriber <br>FROM uk_youtubers_2024<br>ORDER BY Total_views_per_subscriber DESC;</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/281/1*7uUp9Qcadk2CKDADRvsVMw.png" /></figure><p>6. Which 3 channels have the highest subscriber engagement rate per video uploaded?</p><pre><br>SELECT Top 3 channel_name,<br>         ROUND((total_subscribers/total_videos),-3) As Total_subscribers_per_video<br>FROM uk_youtubers_2024<br>ORDER BY Total_subscribers_per_video DESC;</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/272/1*eYQgkEQOgZntONSkcw51LQ.png" /></figure><p><strong>VALIDATION-CALCULATING THE POTENTIAL ROI</strong></p><p>For this analysis, I included the breakdown of the calculation used for my analysis. I am using the Top 3 channel names with the highest subscribers and I will compare my results in Excel and SQL.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/475/1*97Slsbzkn46rk4fW572v_w.png" /></figure><p>This breakdown includes:</p><ol><li>Calculating average views per video which is computed using the dashboard</li><li>Calculating potential product by multiplying the average views per video by the conversion rate</li><li>Calculating product cost by multiplying the potential product by the product cost,</li><li>Calculating the net profit by subtracting the campaign cost from Potential revenue per video.</li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*-8wQnNV0SJE89OInO-BfoQ.png" /></figure><p>To get the breakdown of the analysis in SQL, the steps involve:</p><ol><li>Define the variables</li></ol><pre><br>DECLARE @conversionrate FLOAT = 0.02;<br>DECLARE @productcost MONEY = 5.0;<br>DECLARE @campaigncost MONEY = 50000.0</pre><p>2. Create a CTE that rounds average views per video</p><pre>WITH ChannelData AS(<br>       SELECT channel_name,<br>       total_videos,<br>       total_views,<br>       ROUND(CAST(total_views AS FLOAT)/total_videos,-4) AS Avg_views_per_video<br> FROM uk_youtubers_2024<br> )</pre><p>3. Select appropriate columns for analysis</p><pre>SELECT *<br>FROM ChannelData<br>WHERE channel_name IN (&#39;NoCopyrightSounds&#39;,&#39;DanTDM&#39;, &#39;Dan Rhodes&#39;)</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/427/1*hev-hs08qH7ipXqUyLHLyg.png" /></figure><p>4. Filter Results by YouTube channels with the highest subscriber basis and order by net profits from highest to lowest</p><pre>SELECT channel_name,<br>       Avg_views_per_video,<br>       (Avg_views_per_video * @conversionrate) AS potential_product_sold_per_video,<br>       (Avg_views_per_video * @conversionrate * @productcost) AS potential_revenue_per_view,<br>   (Avg_views_per_video * @conversionrate * @productcost) -@campaigncost AS net_profit<br>FROM ChannelData<br>WHERE channel_name IN (&#39;NoCopyrightSounds&#39;,&#39;DanTDM&#39;, &#39;Dan Rhodes&#39;)<br>ORDER BY net_profit DESC</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/661/1*GreRwbOBv5W2esuVDGngLg.png" /></figure><p>The next thing I did is to input my data into my Excel sheet to compare the differences</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*fZ6pZdwuziLGYmAsSwvUtg.png" /><figcaption>The worksheet shows no difference between Excel Validation, and SQL Validation</figcaption></figure><p><strong>INSIGHTS</strong></p><ol><li>The Top 3 Channels with the most subscribers are NoCopyRightSounds, Dan Rhodes, and DanTSM.These channels have managed to attract large audiences due to their engaging content and consistent uploads. In addition to having a vast subscriber base, these channels are influential within their respective niches, with each channel providing unique content that appeals to their followers.</li><li>When it comes to the total number of views, DanTDM, Dan Rhodes, and Mister Max lead the way. These channels have amassed substantial view counts, reflecting their wide appeal and the popularity of their videos. Their high viewership is indicative of their ability to create content that resonates with a broad audience, keeping viewers coming back for more.</li><li>Entertainment channels, particularly those focused on entertainment and music, are especially valuable for achieving broader reach. Channels that consistently post engaging content tend to generate the most significant engagement and interaction from their audiences. This consistency in posting and the ability to captivate viewers’ interests make entertainment channels highly effective for reaching a wide and diverse audience.</li><li>GRM Daily, Man City, and Yogscast stand out as the channels with the most uploaded videos. These channels maintain a prolific output, regularly adding new content to their platforms, which helps them stay relevant and continually engage their audience. The frequency and volume of their uploads contribute to their strong presence on YouTube.</li></ol><p><strong>RECOMMENDATIONS</strong></p><ol><li>In terms of collaboration, Dan Rhodes is the best YouTube Channel to work with as the channel helps to maximize visibility fully. While GRM Daily, Man City, and Yogscast regularly upload content, their potential return on investment may not justify the collaboration within the current budget limits.</li><li>Mister Max is a top choice for maximizing reach, but DanTDM and Dan Rhodes offer better long-term benefits due to their large subscriber bases and high average views.</li><li>Overall, NoCopyrightSounds, DanTDM, and Dan Rhodes are the top three channels for collaboration, as they consistently attract the highest engagement.</li></ol><p><strong>POTENTIAL RETURN OF INVESTMENT(ROI)</strong></p><p>Partnering with Dan Rhodes would result in a net profit of $1,065,000 per video for the client. An influencer marketing contract with Mister Max could generate a net profit of $1,276,000. A product placement campaign with DanTDM could bring in about $484,000 per video, while an influencer marketing deal would yield a one-time net profit of $404,000. Additionally, collaborating with NoCopyrightSounds could earn the client $642,000 per video, making it a valuable option.</p><p>Due to this analysis, partnering with Dan Rhodes will help promote the client’s products. Once a milestone is reached, an advanced partnership with DanTDM, Mister Max, and NoCopyrightsounds will be next.</p><p><em>Thank you for following through. Make sure to stick around for more articles related to data analysis and everything tech. I appreciate your claps.</em></p><p><em>Connect with me on </em><a href="https://twitter.com/Roshethequeen"><em>Twitter</em></a><em> and </em><a href="https://www.linkedin.com/in/temperance-godwin/"><em>LinkedIn</em></a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=65b664b36c99" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[TRANSACTIONAL DATA ANALYSIS USING SQL]]></title>
            <link>https://medium.com/@temperancegodwin/transactional-data-analysis-using-sql-db9be4cb344d?source=rss-5ea7cde6db67------2</link>
            <guid isPermaLink="false">https://medium.com/p/db9be4cb344d</guid>
            <category><![CDATA[fintech]]></category>
            <category><![CDATA[transactional-analysis]]></category>
            <category><![CDATA[sql]]></category>
            <category><![CDATA[data-analysis]]></category>
            <dc:creator><![CDATA[Temperance Godwin]]></dc:creator>
            <pubDate>Sat, 18 May 2024 10:29:56 GMT</pubDate>
            <atom:updated>2024-05-18T10:37:23.128Z</atom:updated>
            <content:encoded><![CDATA[<p><em>8-Weeks SQL challenge, Case Study #4 by Danny Ma</em></p><p>This case study centers on analyzing and interpreting the data generated from various transactions within an organization for understanding business operations, customer behavior, financial performance, and operational efficiency</p><p>TOOLS USED FOR ANALYSIS: SQL</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Xe1DnZkK15YZhPtzhX7-UQ.png" /></figure><p>INTRODUCTION</p><p>There is a new innovation in the financial industry called Neo-Banks: new aged digital-only banks without physical branches.</p><p>Danny thought that there should be some sort of intersection between these new-age banks, cryptocurrency, and the data world…so he decided to launch a new initiative — Data Bank!</p><p>Data Bank runs just like any other digital bank — but it isn’t only for banking activities, they also have the world’s most secure distributed data storage platform!</p><p>Customers are allocated cloud data storage limits which are directly linked to how much money they have in their accounts. There are a few interesting caveats that go with this business model, and this is where the Data Bank team need your help!</p><p>The management team at Data Bank wants to increase its total customer base — but also needs some help tracking just how much data storage their customers will need.</p><p>This case study is all about calculating metrics, and growth and helping the business analyze their data in a smart way to better forecast and plan for their future developments!</p><p><strong>ABOUT THE DATASET</strong></p><p>The Data Bank team have prepared a data model for this case study as well as a few example rows from the complete dataset below to get you familiar with their tables.</p><h4>ENTITY RELATIONSHIP DIAGRAM</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/796/1*ibHVebXDsOSL4T9COh20OA.png" /></figure><h4>TABLE 1:REGIONS</h4><p>Just like popular cryptocurrency platforms — Data Bank is also run off a network of nodes where both money and data is stored across the globe. In a traditional banking sense — you can think of these nodes as bank branches or stores that exist around the world.</p><p>This regions table contains the region_id and their respective region_name values</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/205/1*SPdXyBSUu2B49lnXLHNA3Q.png" /></figure><h4>Table 2: Customer Nodes</h4><p>Customers are randomly distributed across the nodes according to their region — this also specifies exactly which node contains both their cash and data.</p><p>This random distribution changes frequently to reduce the risk of hackers getting into Data Bank’s system and stealing customer’s money and data!</p><p>Below is a sample of the top 10 rows of the data_bank.customer_nodes</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/462/1*oSJTY2ovTEZfNu6roNNBug.png" /></figure><h4>TABLE 3: CUSTOMER TRANSACTIONS</h4><p>This table stores all customer deposits, withdrawals, and purchases using their Data Bank debit card.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/400/1*y6_sFDsVcvJSQ2ZBXqT8Sw.png" /></figure><p><strong>PROBLEM STATEMENTS</strong></p><p>The following case study questions include some general data exploration analysis for the nodes and transactions before diving right into the core business questions and finishing with a challenging final request!</p><p>The problem statements are grouped into 4:</p><p>A. Customer Nodes Exploration</p><p>B. Customer Transactions</p><p>C. Data Allocation Challenge</p><h3>A. CUSTOMER NODES EXPLORATION</h3><ol><li>How many unique nodes are there on the Data Bank system?</li></ol><p>ANSWER</p><ul><li>Use COUNT DISTINCT to find the number of unique nodes</li></ul><pre>SELECT COUNT(DISTINCT node_id) AS UniqueNodes<br>FROM customer_nodes</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/132/1*XW9Z16fwOjwUBX4HBhS_xg.png" /></figure><p>There are 5 unique nodes on the Data Bank System</p><p>2. What is the number of nodes per region?</p><p>ANSWER</p><ul><li>USE COUNT to find the number of nodes per region</li><li>USE INNER JOIN to join the customer nodes dataset to the region dataset</li></ul><pre>SELECT COUNT(node_id) AS TotalNodes,<br>       cn.region_id,<br>       region_name<br>FROM regions rn<br>JOIN customer_nodes cn<br>ON cn.region_id =rn.region_id<br>GROUP BY cn.region_id, region_name<br>ORDER BY TotalNodes DESC;</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/249/1*iWw0cDxoX0IQrjRBkdnhpQ.png" /></figure><p>The Australia region contains the highest number of nodes having 770 nodes in total while the Europe region contains the lowest number of nodes having 616 nodes in total</p><p>3. How many customers are allocated to each region?</p><ul><li>USE COUNT DISTINCT to find the number of customers.</li><li>USE INNER JOIN to join the region table to the customer nodes tables to find the customer per region.</li></ul><pre>SELECT COUNT (DISTINCT customer_id) AS TotalCustomers,<br>       cn.region_id,<br>       region_name<br>FROM regions rn<br>JOIN customer_nodes cn<br>ON cn.region_id =rn.region_id<br>GROUP BY cn.region_id, region_name<br>ORDER BY TotalCustomers DESC</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/267/1*LL4HNs7gCp6Sml3WZyDJIA.png" /></figure><p>4. How many days on average are customers reallocated to a different node?</p><p>ANSWER</p><ul><li>Use DATTEDIF to find the total days of reallocation.</li><li>Use AVG to find the average days of reallocation</li></ul><pre>SELECT AVG(DATEDIFF(day,start_date, end_date)) AS AverageNumberOfDaysAllocated<br>FROM customer_nodes</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/213/1*Nnhecv0EIkTsdinVJvpMLw.png" /></figure><p>It takes an average of 49 days to be reallocated to a different node</p><p>5. What is the median, 80th, and 95th percentile for this same reallocation days metric for each region?</p><p>ANSWER</p><ul><li>Use PERCENTILE_CONT and WITHIN GROUP to find the median, 80th, and 95th percentile</li></ul><pre>SELECT <br>    region_name,<br>    median_reallocation_days,<br>    percentile_80_reallocation_days,<br>    percentile_95_reallocation_days<br>FROM (<br>    SELECT <br>        cn.region_id, region_name,<br>        PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY DATEDIFF(day, start_date, end_date)) OVER (PARTITION BY region_name) AS median_reallocation_days,<br>        PERCENTILE_CONT(0.8) WITHIN GROUP (ORDER BY DATEDIFF(day, start_date, end_date)) OVER (PARTITION BY region_name) AS percentile_80_reallocation_days,<br>        PERCENTILE_CONT(0.95) WITHIN GROUP (ORDER BY DATEDIFF(day, start_date, end_date)) OVER (PARTITION BY region_name) AS percentile_95_reallocation_days<br>    FROM customer_nodes cn<br> JOIN regions rn<br> ON rn.region_id =cn.region_id<br>) AS percentiles<br>GROUP BY region_name,median_reallocation_days,percentile_80_reallocation_days,percentile_95_reallocation_days;</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/593/1*gPyabL1RS9TzkxX_LVej1g.png" /></figure><ul><li>Europe and America have the same median reallocation days of 18, Africa has 17.5 days while Asia and Australia have 17 days</li><li>Europe and Australia have 28 days as the 80th percentile, while Africa, Asia, and America have 27 days as the 80th percentile</li><li>All regions have different reallocation days for the 90th percentile with the highest region being Asia with 269 days and Europe with the lowest being 258 days.</li></ul><h4>B. CUSTOMER TRANSACTIONS</h4><ol><li>What is the unique count and total amount for each transaction type?</li></ol><p>ANSWER</p><ul><li>Use COUNT to find the unique count of the transaction types</li><li>Use SUM to find the total amount for each transaction type</li></ul><pre>SELECT DISTINCT txn_type,<br>       COUNT(*) AS UniqueCount,<br>       SUM(txn_amount) AS TotalAmount<br>FROM customer_transactions<br>GROUP BY txn_type<br>ORDER BY TotalAmount DESC;</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/274/1*k6CzV4kvOO--AQaKA0ByoA.png" /></figure><p>Deposit contains the highest number of transaction types with a total number of 2671 while Withdrawal contains the lowest number of transaction types with a total of 1580</p><p>2. What is the average total historical deposit counts and amounts for all customers?</p><p>ANSWER</p><ul><li>Use SUBQUERY to find the average total historical deposit counts and amounts for all customers</li></ul><pre>SELECT txn_type,<br>    AVG(total_deposit_count) AS Avg_total_deposit_count,<br>    AVG(total_deposit_amount) AS Avg_total_deposit_amount<br>FROM (<br>    SELECT <br>        customer_id, txn_type,<br>        COUNT(*) AS Total_Deposit_count,<br>        SUM(txn_amount) AS Total_Deposit_amount<br>    FROM customer_transactions<br> WHERE txn_type =&#39;deposit&#39;<br> GROUP BY customer_id,txn_type<br>) AS customer_deposit_totals<br>    GROUP BY txn_type</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/368/1*ho6ho8eDdvg1JOKKS16KPw.png" /></figure><p>The average total for deposit type is 5, while the average amount for all customers is 2718</p><p>3. For each month — how many Data Bank customers make more than 1 deposit and either 1 purchase or 1 withdrawal in a single month?</p><ul><li>Create a CTE named TotalCustomers to calculate the number of deposits, purchases, and withdrawals for each customer for each month using the DATEPART and DATENAME functions to extract the month number and month name from the txn_date column.</li><li>Use the main query to filter the customer activity CTE to include only customers who made more than 1 deposit and either 1 purchase or 1 withdrawal in a single month.</li></ul><pre>WITH TotalCustomers AS<br>(<br> SELECT customer_id,<br>        DATEPART(MONTH, txn_date) AS Month_id,<br>        DATENAME(MONTH, txn_date) AS MonthName,<br>        COUNT(CASE WHEN txn_type = &#39;deposit&#39; THEN 1 END) AS DepositCount,<br>        COUNT(CASE WHEN txn_type = &#39;purchase&#39; THEN 1 END) AS PurchaseCount,<br>        COUNT(CASE WHEN txn_type = &#39;withdrawal&#39; THEN 1 END) AS WithdrawalCount<br>FROM customer_transactions<br>GROUP BY customer_id, DATEPART(MONTH, txn_date), DATENAME(MONTH, txn_date)<br>)<br><br>SELECT Month_id, <br>       MonthName,<br>       COUNT(DISTINCT customer_id) AS CustomerCount<br>FROM TotalCustomers<br>WHERE DepositCount &gt; 1<br>      AND (PurchaseCount &gt; 0 OR WithdrawalCount &gt; 0)<br>GROUP BY Month_id, MonthName;</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/259/1*q0a7tkMeS5yDK0zIlwSkng.png" /></figure><p>March contains the highest number of customers who had made more than 1 deposit and either 1 withdrawal or 1 deposit with a total of 192, while April had the least number of customers with a total number of 70.</p><p>4. What is the closing balance for each customer at the end of the month?</p><p>5. What is the percentage of customers who increase their closing balance by more than 5%?</p><p>ANSWER</p><ul><li>Use CTE to calculate the total transactions for each customer for each month, the closing balance for each customer for each month by summing up the transactions from the previous months, and the percentage increase in closing balance for each customer from the previous month.</li><li>Use the PctIncrease in the final CTE to calculate the percentage of customers whose closing balance increased by more than 5% compared to the previous month.</li></ul><pre>WITH MonthlyTransactions AS<br>(<br> SELECT customer_id,<br>        EOMONTH(txn_date) AS end_date,<br>        SUM(CASE WHEN txn_type IN (&#39;withdrawal&#39;, &#39;purchase&#39;) THEN -txn_amount<br>     ELSE txn_amount END) AS Transactions<br> FROM customer_transactions<br> GROUP BY customer_id, EOMONTH(txn_date)<br>),<br>ClosingBalances AS <br>(<br> SELECT customer_id,<br>        end_date,<br>        COALESCE(SUM(transactions) OVER(PARTITION BY customer_id ORDER BY end_date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW), 0) AS ClosingBalance<br> FROM MonthlyTransactions<br>),<br>PctIncrease AS <br>(<br>  SELECT customer_id,<br>  end_date,<br>  ClosingBalance,<br>  LAG(ClosingBalance) OVER (PARTITION BY customer_id ORDER BY end_date) AS previous_closing_balance,<br>         100 * (ClosingBalance - LAG(ClosingBalance) OVER (PARTITION BY customer_id ORDER BY end_date)) / NULLIF(LAG(ClosingBalance) OVER (PARTITION BY customer_id ORDER BY end_date), 0) AS PctIncrease<br> FROM ClosingBalances<br>)<br>SELECT CAST(100.0 * COUNT(DISTINCT customer_id) / (SELECT COUNT(DISTINCT customer_id) FROM customer_transactions) AS FLOAT) AS PctCustomers<br>FROM PctIncrease<br>WHERE PctIncrease &gt; 5;</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/122/1*3PMQ6-wIe80KSGQoqdJC5g.png" /></figure><p>75.6% of customers increase their closing balance by 5%</p><h4>C. DATA ALLOCATION CHALLENGE</h4><p>For this multi-part challenge question — you have been requested to generate the following data elements to help the Data Bank team estimate how much data will need to be provisioned for each option:</p><ol><li>Running customer balance column that includes the impact of each transaction</li></ol><pre>  SELECT customer_id,<br>       txn_date,<br>       txn_type,<br>       txn_amount,<br>       SUM(CASE WHEN txn_type = &#39;deposit&#39; THEN txn_amount<br>  WHEN txn_type = &#39;withdrawal&#39; THEN -txn_amount<br>  WHEN txn_type = &#39;purchase&#39; THEN -txn_amount<br>  ELSE 0<br>    END) OVER(PARTITION BY customer_id ORDER BY txn_date) AS running_balance<br>FROM customer_transactions;</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/420/1*i1FJfdooFByFBF2zWiEDEA.png" /></figure><p>2. Customer balance at the end of each month</p><p>ANSWER</p><pre>SELECT customer_id,<br>       DATEPART(MONTH, txn_date) AS month,<br>       DATENAME(MONTH, txn_date) AS month_name,<br>       SUM(CASE WHEN txn_type = &#39;deposit&#39; THEN txn_amount<br>  WHEN txn_type = &#39;withdrawal&#39; THEN -txn_amount<br>  WHEN txn_type = &#39;purchase&#39; THEN -txn_amount<br>    ELSE 0<br>    END) AS closing_balance<br>FROM customer_transactions<br>GROUP BY customer_id, DATEPART(MONTH, txn_date), DATENAME(MONTH, txn_date);</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/330/1*L9hB-H5E-7_lnMhJh-pZVA.png" /></figure><p>3. Minimum, average and maximum values of the running balance for each customer.</p><p>ANSWER</p><ul><li>Use CTE to find the running balance of each customer based on the order of transactions.</li><li>Calculate the minimum, maximum, and average balance for each customer.</li></ul><pre>WITH running_balance AS<br>(<br> SELECT customer_id,<br>        txn_date,<br>        txn_type,<br>        txn_amount,<br>        SUM(CASE WHEN txn_type = &#39;deposit&#39; THEN txn_amount<br>   WHEN txn_type = &#39;withdrawal&#39; THEN -txn_amount<br>   WHEN txn_type = &#39;purchase&#39; THEN -txn_amount<br>   ELSE 0<br>     END) OVER(PARTITION BY customer_id ORDER BY txn_date) AS running_balance<br> FROM customer_transactions<br>)<br><br>SELECT customer_id,<br>       AVG(running_balance) AS avg_running_balance,<br>       MIN(running_balance) AS min_running_balance,<br>       MAX(running_balance) AS max_running_balance<br>FROM running_balance<br>GROUP BY customer_id;</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/478/1*2r7x0Xqve38tktVrCtKv3Q.png" /></figure><p><em>Thank you for following through! Make sure to stick around for more articles related to data analysis and everything tech. I appreciate your claps.</em></p><p><em>Connect with me on </em><a href="https://twitter.com/Roshethequeen"><em>Twitter</em></a><em> and </em><a href="https://www.linkedin.com/in/temperance-godwin/"><em>LinkedIn</em></a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=db9be4cb344d" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[THE ART AND IMPACT OF DATA STORYTELLING: TRANSFORMING NUMBERS INTO NARRATIVES”]]></title>
            <link>https://medium.com/@temperancegodwin/the-art-and-impact-of-data-storytelling-transforming-numbers-into-narratives-f4e51713f4b6?source=rss-5ea7cde6db67------2</link>
            <guid isPermaLink="false">https://medium.com/p/f4e51713f4b6</guid>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[good-storytelling]]></category>
            <category><![CDATA[storyelling]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[data-storytelling]]></category>
            <dc:creator><![CDATA[Temperance Godwin]]></dc:creator>
            <pubDate>Sat, 11 May 2024 09:02:33 GMT</pubDate>
            <atom:updated>2024-05-11T09:50:15.628Z</atom:updated>
            <content:encoded><![CDATA[<h4><strong>THE ART AND IMPACT OF DATA STORYTELLING: TRANSFORMING NUMBERS INTO NARRATIVES</strong></h4><p><strong><em>How well we communicate is determined not by how well we say things but how well we are understood.” — Andrew Grove, American businessman</em></strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/786/1*sRY4Mtq0aUcqzzUeHwIHIg.jpeg" /></figure><p>What’s scarier than rogue or incorrect data? Bad data visualization because it complicates understanding and doesn’t add any value.</p><p>The ability to use data to convey captivating stories has become essential for analysts, decision-makers, and communicators in today’s data-driven society. The core of data storytelling is examined in this article, along with its importance, advantages, influence on analysis, tips, and journey to becoming a skilled data storyteller.</p><p><strong>WHAT IS STORYTELLING?</strong></p><p>Storytelling is fundamentally the skill of using a structured narrative to communicate ideas, feelings, and facts. When it comes to data, storytelling is combining trends, insights, and discoveries into a compelling narrative that appeals to an audience.</p><p>Storytelling elevates data analysis from a technical process to a strategic communication tool. It bridges the gap between ideas and action by bringing context, relevance, and meaning to data. A well-crafted data story may highlight trends, uncover patterns, and provide actionable insights to improve business outcomes.</p><p><strong>IMPORTANCE OF STORYTELLING IN DATA ANALYSIS</strong></p><ol><li><strong>Develops an Emotional Connection:</strong> Storytelling gives the data a human face, which makes it more memorable and accessible. Data storytellers may make data come to life by using real-world examples, stories, and case studies. This will inspire empathy, comprehension, and engagement from their audience.</li><li><strong>Makes Data Accessible and Engaging</strong>: Storytelling’s capacity to make data accessible and engaging for a larger audience is a major factor in its importance in data analysis. Raw data might be intimidating or difficult to grasp, but storytelling puts it in perspective and makes it relevant. Storytellers may engage and maintain the attention of their audience by providing facts in the form of a narrative that has a distinct beginning, middle, and finish.</li><li><strong>Drives Decision-Making: </strong>Making decisions based on data is essential to contemporary corporate strategy. Data by itself is insufficient; it must be transformed into insights that can be used. A good storytellers can emphasize significant trends, patterns, and ramifications by developing a narrative based on data insights. This enables decision-makers to make well-informed choices that propel corporate expansion and prosperity.</li><li><strong>Improves Collaboration and Communication</strong>: In every business, good communication is crucial, particularly when sharing intricate data insights. Through the distillation of complicated information into stories that connect with stakeholders at all levels and departments, storytelling promotes clear and successful communication. It promotes cooperation, openness, and goal alignment, which improves decision-making and results.</li><li><strong>Enhances Data Literacy, Innovation, and Creativity:</strong> Storytelling promotes data literacy by clarifying data concepts and emphasizing the importance of data-driven decisions. It promotes curiosity and critical thinking. It also fosters innovation and creativity in data analysis by making analysts discover new methods to visualize and communicate information.</li></ol><figure><img alt="An example of a bad visualization" src="https://cdn-images-1.medium.com/max/908/1*DNo3w31bamlIG0A7QnxNIg.png" /><figcaption><strong>An example of a bad visualization.</strong></figcaption></figure><p><strong>TIPS FOR TELLING A GOOD DATA STORY.</strong></p><p>Data can inform, lead decision-making, and motivate change. However, presenting data fascinatingly and effectively takes more than just statistics and charts; it necessitates the art of storytelling. Here are some strategies for telling a good data story:</p><p>1. <strong>Understand your audience:</strong> This is essential for good data storytelling. Tailor your tale to their expertise, interests, and goals. Use language and situations that are relatable to them to guarantee engagement and relevancy.</p><p>2.<strong> Simplify Complexity:</strong> While data might be complex, your story should not be. Simplify difficult concepts, and technical information into straightforward and comprehensible language. Concentrate on presenting crucial insights and takeaways without overloading your audience with irrelevant details.</p><p>3. <strong>Concentrate on Insights:</strong> The insights you find will form the core of your data story. Include your data’s most significant discoveries, patterns, and trends in your story. Emphasize the significance of these findings and their influence on strategy or decision-making.</p><p>4. <strong>Make Good Use of Visuals:</strong> Graphics may greatly improve data storytelling. To successfully demonstrate important ideas, use the right visuals such as graphs, charts, and infographics. To complement your story, be sure your images are aesthetically pleasing, clear, and concise.</p><p><strong>5. Structure Your Story:</strong> A compelling story draws readers in and leads them on a voyage of exploration. Present the data and analysis logically, begin with a captivating hook or introduction, and end with practical recommendations or implications.</p><p>6. <strong>Tell a compelling Story: </strong>Crafting an emotionally compelling narrative is the goal of data storytelling, which goes beyond simply providing information. To create a compelling and memorable data story use aspects of storytelling such as characters, conflicts, and resolutions.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/756/1*41mqc1wzVLXaLXHLKvlrew.png" /><figcaption><strong>An example of a good visualization-The effect of storytelling</strong></figcaption></figure><p><strong>HOW TO BECOME A GOOD DATA STORYTELLER</strong></p><p>1. <strong>Improve Your Data Analysis Skills:</strong> To begin, focus on improving your data analysis abilities. Acquire effective skills in data collection, cleaning, analysis, and interpretation. Gain knowledge of data visualization tools and methods to produce visually stunning graphs, dashboards, and charts.</p><p>2. <strong>Identify storytelling Principles:</strong> Research the tactics, structures, and principles of narrative. Discover how to improve your data tales by learning about character development, conflict resolution, narrative arcs, and other storytelling components. To learn more, check for books, classes, and storytelling resources.</p><p>3. <strong>Know Your Audience:</strong> Recognize the goals, interests, and knowledge of your audience. Make your data storytelling strategy more relatable to them. Make use of relatable and relevant language, images, and examples for your target audience.</p><p>4.<strong> Identify Key Insights:</strong> Pay close attention to the major insights and patterns in your data. Reduce complicated information to concise, useful takeaways. Draw attention to the “now what” and “so what” of your data analysis to promote action and decision-making.</p><p>5. <strong>Effectively Use Visualizations:</strong> To improve your data narrative, strategically use data visualizations. Select the appropriate kinds of graphs, charts, and other graphics to enhance your story and make the information easier to understand.</p><p>6.<strong> Practice Storytelling:</strong> To hone your storytelling abilities, practice regularly. To get feedback and ideas, share data stories with peers, coworkers, or in professional contexts. In your storytelling, be mindful of the tempo, tone, and level of engagement.</p><p>7. <strong>Get Input and Improve:</strong> Consult mentors, stakeholders, or professionals in data storytelling for their insights. Iterate on your narratives and incorporate feedback into your storytelling technique. Make constant improvements and adjustments to your data storytelling methods in response to criticism and new knowledge.</p><p>8. <strong>Learn and Remain Curious: </strong>Maintain an open mind and curiosity. Investigate fresh approaches to analysis, narrative, and data sources. To increase your knowledge and proficiency in data storytelling, go to conferences, webinars, and seminars.</p><p>In conclusion, always remember, People remember stories, not data. Data storytelling is an effective method for transforming raw information into engaging narratives that drive comprehension, engagement, and action. Mastering the art of data storytelling allows you to successfully convey insights, influence choices, and leave a lasting impression in the data-driven world. Embrace storytelling as a necessary talent in your data analysis toolbox, and release the narrative potential of numbers.</p><p><em>Thank you for following through. Make sure to stick around for more articles related to data analysis and everything tech. I appreciate your claps.</em></p><p><em>Connect with me on </em><a href="https://twitter.com/Roshethequeen"><em>Twitter</em></a><em> and </em><a href="https://www.linkedin.com/in/temperance-godwin/"><em>LinkedIn</em></a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=f4e51713f4b6" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Process Mapping Strategy: Optimizing Data Analysis Techniques]]></title>
            <link>https://medium.com/@temperancegodwin/process-mapping-strategy-optimizing-data-analysis-techniques-950dba2c6062?source=rss-5ea7cde6db67------2</link>
            <guid isPermaLink="false">https://medium.com/p/950dba2c6062</guid>
            <category><![CDATA[process-mapping]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[data-analyst]]></category>
            <dc:creator><![CDATA[Temperance Godwin]]></dc:creator>
            <pubDate>Sat, 27 Apr 2024 10:58:28 GMT</pubDate>
            <atom:updated>2024-04-27T13:37:17.393Z</atom:updated>
            <content:encoded><![CDATA[<h4>PROCESS MAPPING STRATEGY: OPTIMIZING DATA ANALYSIS TECHNIQUES</h4><p><strong><em>If you cannot describe what you are doing as a process, you don’t know what you are doing- W. Edwards Deming</em></strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/440/1*ryRTtoJ3WHtDx4TXfPtfkg@2x.jpeg" /></figure><p>In the dynamic surroundings of data analysis, where the number and complexity involved in data are increasing exponentially, having robust methodologies is critical. Among these tactics, process mapping stands out as a fundamental tool that improves not just data analysis but also decision-making and operational efficiency. This article covers process mapping tactics, emphasizing their importance in enhancing data analysis techniques and revealing actionable insights.</p><p><strong>WHAT IS PROCESS MAPPING?</strong></p><p>Process mapping is an approach for visualizing map out workflows and processes. It entails designing a process map, often known as a flowchart, process flowchart, or workflow diagram.</p><p>Process mapping helps individuals, organizations, and enterprises enhance their efficiency. Process maps can help teams explore ideas for process improvement, boost communication, and offer process documentation.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/284/1*i7U8DU2M0GJCNCLlqWRMZw@2x.jpeg" /><figcaption>An example of a SQL Data Flow Diagram</figcaption></figure><p><strong>IMPORTANCE OF PROCESS MAPPING IN DATA ANALYSIS</strong></p><ol><li><strong>Contextualizing Data:</strong> Process maps explain where and how individual data points fit into the overall process framework, giving raw data some context. Contextualization improves data interpretation and guarantees that the conclusions drawn are applicable and useful</li><li><strong>Promoting Collaboration:</strong> Process maps give cross-functional teams common knowledge, which encourages cooperation and coordination. They promote team success by making it possible for stakeholders from many departments to comprehend and participate in process optimization initiatives.</li><li><strong>Identifying Inefficiencies:</strong> Process maps show inefficiencies, duplications, and possible bottlenecks by illustrating the movement of operations. These revelations open the door to data-driven optimizations that improve productivity and operational efficiency.</li><li><strong>Enhancing Decision-Making</strong>: Process maps provide an organized framework for evaluating the effects of suggested modifications when using data analysis to guide decision-making. They provide scenario analysis, risk assessment, and the comparison of different approaches, enabling stakeholders to make well-informed, fact-based decisions.</li></ol><p><strong>HOW TO EFFECTIVELY OPTIMIZE DATA ANALYSIS THROUGH PROCESS MAPPING STRATEGIES</strong></p><ol><li><strong>Set Clear Goals:</strong> To begin your process mapping exercise, clearly define your goals. Understand the insights you aim to acquire, how they relate to the objectives of the firm and the particular indicators or KPIs you will be concentrating on.</li><li><strong>Involve your stakeholders: </strong>Include relevant stakeholders such as process owners, subject matter experts, and end users. Their points of view and ideas are very helpful in identifying pain points, capturing subtleties, and setting priorities for areas that need improvement.</li><li><strong>Select the Right Tools:</strong> Make use of specialized process mapping software or solutions that include features like data analysis platform integration, drag-and-drop interfaces, and collaboration options. Draw.io, Microsoft Visio, and Lucidchart are a few well-liked tools.</li><li><strong>Document Process Variation:</strong> Recognize and record any deviations or special cases from the process. Comprehensive process mapping requires an awareness of variability, as not all operations have a linear path.</li><li><strong>Integrate with Data Analysis Tools:</strong> Easily incorporate data analysis methods and tools into your process maps. Utilize business intelligence systems, statistical analysis, process mining, and visualization tools to discover actionable insights and patterns from mapped processes.</li><li><strong>Iterate and Validate:</strong> The process of process mapping is iterative. Make constant improvements to your maps in response to feedback, fresh data, and changing business needs. Verify the accuracy, relevance, and alignment of your maps with operational reality by validating them with relevant stakeholders.</li><li><strong>Enable Continuous Monitoring:</strong> Set up systems for tracking and assessing mapped processes continuously. To monitor performance, identify irregularities, and promote ongoing improvements, use dashboards, alerts, and key performance indicators (KPIs).</li></ol><p>In conclusion, process mapping is an effective tactic for enhancing data analysis methods, generating operational savings, and producing insights that can be put to use. Process mapping enables organizations to fully utilize their data assets by offering context, locating bottlenecks, promoting cooperation, and aiding in decision-making. Using these process mapping techniques helps businesses succeed in the data-driven age by turning data into valuable insight rather than just visualizing procedures.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=950dba2c6062" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[INTELLIGENT SYNERGY: THE DYNAMIC RELATIONSHIP BETWEEN ARTIFICIAL INTELLIGENCE AND HUMAN…]]></title>
            <link>https://medium.com/@temperancegodwin/intelligent-synergy-the-dynamic-relationship-between-artificial-intelligence-and-human-ab1bbb50a9f0?source=rss-5ea7cde6db67------2</link>
            <guid isPermaLink="false">https://medium.com/p/ab1bbb50a9f0</guid>
            <category><![CDATA[technology]]></category>
            <category><![CDATA[science]]></category>
            <category><![CDATA[ai]]></category>
            <category><![CDATA[artificial-intelligence]]></category>
            <category><![CDATA[human-intelligence]]></category>
            <dc:creator><![CDATA[Temperance Godwin]]></dc:creator>
            <pubDate>Sat, 20 Apr 2024 21:40:47 GMT</pubDate>
            <atom:updated>2024-04-20T21:42:05.910Z</atom:updated>
            <content:encoded><![CDATA[<h4><strong>INTELLIGENT SYNERGY: THE DYNAMIC RELATIONSHIP BETWEEN ARTIFICIAL INTELLIGENCE AND HUMAN INTELLIGENCE.</strong></h4><p><strong><em>“Artificial intelligence amplifies human potential, while human intelligence ensures AI serves humanity’s best interests. Together, they shape a future where innovation and empathy coexist harmoniously.”</em></strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*4GtJq1ShcREILOP-YAUV0g.jpeg" /></figure><p>Two major developments stand out as technology evolves: Artificial Intelligence (AI) and Human Intelligence (HI). While Artificial Intelligence is the pinnacle of computer power and machine learning, human intelligence reflects human cognition’s complexity, creativity, and empathy. This article covers the synergies, differences, and consequences of AI and HI, focusing on the junction that affects our present and future.</p><p><strong>THE RISE OF ARTIFICIAL INTELLIGENCE IN TRANSFORMING INDUSTRIES AND SOCIETY.</strong></p><p>Fundamentally, Artificial Intelligence (AI) is the modeling of Human Intelligence processes by machines, typically computer systems. With the use of algorithms and statistical models, these systems are made to analyze data, identify trends, make choices, and learn from experience. AI includes a wide range of capabilities, from simple rule-based systems to sophisticated machine learning algorithms and neural networks.</p><p>AI has become an influencing factor in a wide range of sectors and enterprises. AI applications are changing the way people live, work, and interact with technology. Examples include natural language processing, driverless cars, and predictive analytics in healthcare and finance. Its capacity to deal with massive volumes of data, automate activities, and draw insights has enabled unprecedented levels of innovative thinking and effectiveness.</p><p><strong>CHALLENGES AND CONSIDERATION IN AI DEVELOPMENT.</strong></p><p>Despite its potential, artificial intelligence comes with difficulties. Careful navigation is needed when navigating ethical issues with AI deployment, algorithmic bias, privacy concerns, employment displacement, and social effects. Building trust and reducing possible hazards require AI systems to be transparent, accountable, equitable, and inclusive.</p><p>Furthermore, existential concerns about humanity’s future are raised by the idea that Artificial Intelligence (AI) might surpass human intellect, a phenomenon referred to as superintelligence or Artificial General Intelligence (AGI). Global cooperation and multidisciplinary collaboration are required for continued discussions on AI ethics, governance frameworks, human-AI collaboration, and responsible AI development.</p><p><strong>EXPLORING HUMAN INTELLIGENCE: THE POWER OF HUMAN INTELLIGENCE.</strong></p><p>The depth and breadth of human reasoning which includes thinking, creativity, emotional intelligence, social abilities, and moral reasoning, are all included in human Intelligence. Humans can learn, adapt, invent, sympathize, and work together in ways that are not possible for algorithms through human intelligence. <br> <br>With human intelligence, humans are capable of critical thinking, questioning, exploring novel concepts, and resolving challenging moral and societal issues. Applying human intelligence in technology and society helps foster creativity, empathy, resilience, and moral decision-making.</p><p><strong>COMPLEMENTARY STRENGTHS OF HUMAN INTELLIGENCE (HI) AND ARTIFICIAL INTELLIGENCE (AI).</strong></p><p>Artificial intelligence and human intellect complement each other, and this benefits both fields. Artificial Intelligence (AI) is very proficient in data-driven activities, pattern detection, optimization, and scalability. It enhances human skills and offers useful insights in several domains, including healthcare, finance, education, and logistics. Productivity, creativity, and the types of services provided to people and communities are all improved by this synergy.<br> <br>With the ability of humans to empathize, be creative, and intuitive, and make ethical decisions, human intellect is still unmatched in its ability to solve social problems, navigate difficult ethical issues, and foresee future possibilities. The human element gives more depth, significance, and authenticity in domains including social interaction, art, leadership, and customer service.</p><p><strong>EMBRACING COLLABORATIVE INNOVATION BETWEEN ARTIFICIAL INTELLIGENCE AND HUMAN INTELLIGENCE.</strong></p><p>In the ever-changing world of artificial intelligence and human intelligence, it is critical to promote collaborative creativity. AI design, development, and implementation that prioritizes the needs of humanity guarantee that technology advances human welfare, promotes the common good, and respects ethical values.</p><p>Unlocking revolutionary potential across several areas is possible through embracing collaborative innovation between Artificial Intelligence (AI) and Human Intelligence (HI). This synergy fuels individualized experiences, improves decision-making, sparks innovative problem-solving, propels economic progress, and tackles social issues. Human ingenuity, empathy, and ethical reasoning are combined with artificial intelligence’s computing power and data analytics to create a cooperative future where technology works for the good of humankind.<br> <br> To prepare humans for the AI-driven future, education, and upskilling programs are essential as they promote digital literacy, critical thinking, flexibility, and lifelong learning. Encouraging interdisciplinary discourse among technology professionals, ethicists, educators, legislators, and the public promotes responsible innovation and a comprehensive grasp of the implications of artificial intelligence.</p><p><strong>CONCLUSION</strong></p><p>Artificial Intelligence(AI) and human intelligence influence the development of technology and society. The complementary strength between these two types of intelligence is a transformational force that is changing both the present and the future. New opportunities are created for ethical AI development, decision-making, creativity, customization, and continual improvement by utilizing the complementary qualities of HI and AI. By emphasizing ethical issues, cultivating a human-centered perspective, and using technology, human’s greatest interests begin to advance. A more inventive, inclusive, and better future is created by working together to maximize the benefits of Human Intelligence(HI) and Artificial Intelligence(AI).</p><p><em>Thank you for following through. Make sure to stick around for more articles related to data analysis and everything tech. I appreciate your claps.</em></p><p><em>Connect with me on </em><a href="https://twitter.com/Roshethequeen"><em>Twitter</em></a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=ab1bbb50a9f0" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>