<?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 Emma Donery on Medium]]></title>
        <description><![CDATA[Stories by Emma Donery on Medium]]></description>
        <link>https://medium.com/@Emma_Donery?source=rss-adda59ce4677------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*4T7TIsWvhOXdkyDR6YE1jw.jpeg</url>
            <title>Stories by Emma Donery on Medium</title>
            <link>https://medium.com/@Emma_Donery?source=rss-adda59ce4677------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Mon, 16 Nov 2026 17:59:24 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@Emma_Donery/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[Beyond Coding: How Women Are Redefining What It Means to Work in Tech]]></title>
            <link>https://medium.com/@Emma_Donery/beyond-coding-how-women-are-redefining-what-it-means-to-work-in-tech-8ca00f08b0b0?source=rss-adda59ce4677------2</link>
            <guid isPermaLink="false">https://medium.com/p/8ca00f08b0b0</guid>
            <category><![CDATA[technology]]></category>
            <category><![CDATA[blogging]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[tech]]></category>
            <category><![CDATA[women-in-tech]]></category>
            <dc:creator><![CDATA[Emma Donery]]></dc:creator>
            <pubDate>Mon, 14 Oct 2024 07:28:06 GMT</pubDate>
            <atom:updated>2024-10-14T07:28:06.517Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*bkUADupI-Upux28FgSv9hA.png" /></figure><p>When I first entered the world of data science, I was in awe of the complexities behind the technology. There were layers of code, intricate algorithms, and technical jargon that felt overwhelming at first. I’ve spent a lot of time navigating this space as a data analyst, and while coding is certainly a big part of what I do, I’ve come to realize something very important: <strong>tech is so much more than just writing code</strong>. The more I delve into data and collaborate with others, the clearer it becomes that tech is a vast landscape where skills like leadership, communication, ethics, and user experience matter just as much as technical ability.</p><p>Women like me — working in <strong>data science, analysis, project management, ethics, and research</strong> — are proving every day that you don’t have to be a coder to thrive in tech. In fact, the diversity of roles women are embracing is changing the very definition of a tech career, and that’s something we should all celebrate.</p><h3>Project Management: The Backbone of Every Tech Project</h3><p>As I’ve collaborated on various tech projects, I’ve seen firsthand how vital <strong>project managers</strong> are. These are the people who keep teams aligned, timelines intact, and visions on track. Interestingly, many of the women I’ve worked with excel in these roles. Project management isn’t about coding — it’s about leadership, coordination, and strategic thinking, qualities that are crucial to making any tech initiative a success.</p><p>I think of <strong>Annie Jean-Baptiste</strong>, Google’s Head of Product Inclusion, who doesn’t spend her days writing code but instead focuses on ensuring that the company’s products serve a diverse range of users. Her role emphasizes the importance of inclusion and accessibility in tech, reminding me that success in this industry depends not just on building great software but on building products that work for everyone.</p><h3>Data Science: My Journey Beyond Code</h3><p>In my own experience as a <strong>data analyst</strong>, I’ve learned that working with data is about so much more than just crunching numbers or building models. It’s about <strong>understanding the stories behind the data</strong>, how it can impact decision-making, and how insights can be communicated effectively to drive business outcomes. The work I do often involves translating complex data into meaningful narratives for teams that don’t necessarily have technical backgrounds, which is where my love for communication and collaboration really shines through.</p><p>For me, data science has been about blending technical skills with the ability to connect the dots between the data and the human element. It’s why I love my role so much — it’s proof that <strong>you don’t have to be a hardcore coder to thrive in tech</strong>. It’s about using your unique strengths, whether that’s analyzing data, leading a project, or designing user-friendly systems.</p><h3>The Role of AI Ethics: A New Frontier for Women</h3><p>One area that fascinates me — and where women are making huge strides — is <strong>AI ethics</strong>. As someone who’s passionate about data, I’m particularly drawn to the ethical challenges surrounding AI, especially when it comes to ensuring fairness and mitigating bias in algorithms. The more AI is integrated into our daily lives, the more we need people who can ask critical questions about how it’s being used.</p><p>One person who stands out in this field is <strong>Dr. Timnit Gebru</strong>, whose work in Ethical AI has been groundbreaking. She’s one of the leaders raising awareness about the biases embedded in AI systems, showing us that we need diverse voices shaping these technologies. It reminds me of the role women are playing in areas like <strong>data privacy</strong> and <strong>algorithmic transparency</strong>, using their skills not to build the technology but to ensure it’s fair and equitable.</p><p>Her work inspires me as a data professional to think beyond the technical aspects of my job and to focus on the ethical responsibilities we have when handling data. It’s not just about getting the analysis right; it’s about ensuring that our work reflects a commitment to fairness and accuracy for all.</p><h3>Tech Policy and Research: Women Shaping the Future</h3><p>Through my work in data analysis, I’ve become increasingly aware of how important <strong>tech policy and research</strong> are to shaping the future of the industry. Women like <strong>Rashida Richardson</strong> are doing incredible work at the intersection of law and technology, ensuring that algorithmic decision-making systems don’t perpetuate existing inequalities.</p><p>As a data scientist, it’s inspiring to see how research and policy can have such a profound impact on the direction of the tech industry. Women like Rashida are showing that you don’t need to code to influence the future of tech — you just need to care deeply about its broader social implications.</p><h3>A Broader Definition of Tech Success</h3><p>What excites me most about this evolving landscape is that it’s proving to women like myself that <strong>you don’t have to fit into the traditional mold to succeed in tech</strong>. The industry is more than just coding; it’s about solving real-world problems, designing for users, managing teams, and shaping ethical guidelines. Women are redefining tech by bringing their diverse skills and perspectives to the table, and I see that every day in my work as a data analyst.</p><p>The more I grow in my career, the more I realize that there’s space for women to make a significant impact in roles that go beyond the technical. Whether it’s leading data-driven initiatives, advising on AI ethics, or managing complex projects, women are showing that tech success can take many forms — and that’s what makes this industry so exciting.</p><h3>Conclusion: Tech is for Everyone</h3><p>As I reflect on my own journey and the stories of women around me, one thing is clear: <strong>tech needs more than just coders</strong>. It needs problem-solvers, leaders, designers, and ethical thinkers. Women are stepping into these roles and showing that you can thrive in tech without fitting the stereotype of a coder. Whether you’re into data analysis like me, interested in AI ethics, or drawn to project management, there’s a place for you in this industry.</p><p>At the end of the day, <strong>technology is about solving problems for people</strong>. And as more women enter and redefine non-traditional roles, they are shaping a tech landscape that is more inclusive, more innovative, and more ethical.</p><p>If there’s one thing I’ve learned, it’s this: <strong>you don’t need to write code to change the world through technology</strong>. You just need the passion, the skills, and the determination to make a difference — and women everywhere are proving that every day.</p><p>If you found this article inspiring, please give it a clap 👏 and share it ↪️ with others who might benefit from this conversation.</p><p><strong>Let’s amplify the voices of women in tech together!</strong></p><p>Follow me for more discussions on data science, tech careers, and the journey of women making an impact in this field.</p><p>Thank you for reading, and let’s continue to inspire one another in our quest to build a more inclusive tech community!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=8ca00f08b0b0" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Most Common Excel Errors (and How to Fix Them)]]></title>
            <link>https://medium.com/@Emma_Donery/most-common-excel-errors-and-how-to-fix-them-5cf4e124b35e?source=rss-adda59ce4677------2</link>
            <guid isPermaLink="false">https://medium.com/p/5cf4e124b35e</guid>
            <category><![CDATA[technology]]></category>
            <category><![CDATA[data]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[excel]]></category>
            <category><![CDATA[data-analysis]]></category>
            <dc:creator><![CDATA[Emma Donery]]></dc:creator>
            <pubDate>Tue, 01 Oct 2024 13:15:13 GMT</pubDate>
            <atom:updated>2024-10-01T13:15:13.593Z</atom:updated>
            <content:encoded><![CDATA[<p>Excel is a powerhouse for data analysis and management, but even the most seasoned users can stumble upon pesky errors that disrupt their workflow. Whether you’re crafting complex formulas or simply entering data, understanding these common Excel errors is essential for maintaining efficiency and accuracy. In this article, we’ll explore the 10 most frequent Excel errors — ranging from the frustrating #DIV/0! to the enigmatic #SPILL!—and provide you with straightforward solutions to fix them. So, let’s dive in and turn those error codes into opportunities for learning!</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/900/1*YfWJHwbysGNvuKEmghSf7A.png" /></figure><p>Here’s a list of the 10 most common Excel errors and how to fix them:</p><h3>1. ###### Error</h3><p>Typically indicates that a cell is too narrow to display the formatted contents.</p><h4>Causes of the ###### Error:</h4><ol><li><strong>Cell Width:</strong> The most common reason is that the cell is not wide enough to display the entire value, especially for numbers and dates.</li><li><strong>Negative Dates or Times</strong>: If you’re working with dates or times, a negative value can also trigger this error.</li></ol><h4>How to Fix the ###### Error:</h4><ol><li><strong>Resize the Cell</strong>:</li></ol><ul><li><strong>Manually</strong>: Hover over the right edge of the cell until the cursor changes to a double-headed arrow, then click and drag to widen the cell.</li><li><strong>AutoFit</strong>: Double-click the right edge of the cell header (the column letter) to automatically adjust the width to fit the contents.</li></ul><p><strong>2. Check for Negative Values</strong>:</p><ul><li>If the cell is supposed to display a date or time, ensure that the value is not negative. If it is, correct the formula or input to provide a valid date or time.</li></ul><p><strong>3. Change Number Formatting</strong>:</p><ul><li>If the content is a number and you don’t need the full display, consider changing the number format to reduce decimal places or using a different format that requires less space.</li></ul><p><strong>4. Wrap Text</strong>:</p><ul><li>For long text strings, you can wrap the text within the cell. Right-click on the cell, select “Format Cells,” go to the “Alignment” tab, and check the “Wrap text” option.</li></ul><h3>2. #CALC! Error:</h3><p>It indicates that there is a calculation error in a formula or function, particularly in newer versions of Excel that support dynamic arrays.</p><h3>Causes of the #CALC! Error:</h3><ol><li><strong>Unsupported Array Formulas</strong>: When using functions that return arrays, and Excel cannot evaluate them properly.</li><li><strong>Calculation Issues with Dynamic Arrays</strong>: If you’re using Excel’s dynamic array functions (like FILTER, SORT, UNIQUE, etc.), the #CALC! error may appear if the formula can&#39;t produce a valid result.</li><li><strong>Circular References</strong>: When a formula refers back to its own cell either directly or indirectly, leading to a calculation that cannot be resolved.</li></ol><h3>How to Fix the #CALC! Error:</h3><ol><li><strong>Check Array Formulas</strong>:</li></ol><ul><li>Ensure that you are using array formulas correctly. If you’re using a function that expects an array but the input is not valid, this can cause the #CALC! error. Verify that all referenced ranges and arguments are correct.</li></ul><p><strong>2. Inspect for Circular References</strong>:</p><ul><li>Go to the <strong>Formulas</strong> tab, and click on <strong>Error Checking</strong> to see if there are any circular references in your formulas. Resolve these by adjusting the formulas to eliminate any circular dependency.</li></ul><p><strong>3. Evaluate the Formula</strong>:</p><ul><li>Use the <strong>Evaluate Formula</strong> tool in the <strong>Formulas</strong> tab to step through the calculation process and identify where the error occurs.</li></ul><p><strong>4. Check for Valid Data Types</strong>:</p><ul><li>Ensure that the data types in your formula are appropriate. For instance, if you’re performing calculations on text strings or empty cells where numbers are expected, this could trigger the #CALC! error.</li></ul><p><strong>5. Update Excel</strong>:</p><ul><li>Sometimes, issues arise from bugs in specific versions of Excel. Make sure your software is up-to-date by checking for any available updates.</li></ul><h3>3. #DIV/0!</h3><p>It occurs when a formula attempts to divide a number by zero or by an empty cell. This is a common error, especially when using division formulas or functions that involve division.</p><h3>Causes of the #DIV/0! Error:</h3><ol><li><strong>Division by Zero</strong>: The most straightforward cause is trying to divide by zero (e.g., =A1/B1 where B1 is 0).</li><li><strong>Empty Cells</strong>: If the denominator cell is empty, Excel treats it as zero, resulting in the error.</li></ol><h3>How to Fix the #DIV/0! Error:</h3><ol><li><strong>Check the Denominator</strong>:</li></ol><ul><li>Ensure that the cell you are dividing by is not zero or empty. If it is, you may need to enter a valid number or adjust your data.</li></ul><p><strong>2. Use the </strong><strong>IF Function</strong>:</p><ul><li>You can use an IF statement to check if the denominator is zero or empty before performing the division. Here’s an example:</li></ul><pre>=IF(B1=0, &quot;Cannot divide by zero&quot;, A1/B1)</pre><blockquote>This formula checks if B1 is zero; if it is, it returns a message instead of the error. Otherwise, it performs the division.</blockquote><p><strong>3. Use the </strong><strong>IFERROR Function</strong>:</p><ul><li>The IFERROR function can also handle division errors gracefully. It allows you to return a custom message or value when an error occurs:</li></ul><pre>=IFERROR(A1/B1, &quot;Error: Division by zero&quot;)</pre><blockquote>This formula returns “Error: Division by zero” if A1/B1 results in an error.</blockquote><p><strong>4. Check for Data Entry Errors</strong>:</p><ul><li>Sometimes, data may be incorrectly entered. Double-check your data for any inconsistencies that could lead to division by zero.</li></ul><h3>4. #N/A</h3><p>It indicates that a value is not available or cannot be found in a formula, particularly common in lookup functions like VLOOKUP, HLOOKUP, MATCH, or INDEX.</p><h3>Causes of the #N/A Error:</h3><ol><li><strong>Lookup Value Not Found</strong>: The primary cause is that the value you are trying to find does not exist in the specified range.</li><li><strong>Incorrect Range</strong>: The range referenced in the lookup function might not be correctly set, leading to a failure to find the value.</li><li><strong>Data Type Mismatch</strong>: The lookup value and the values in the lookup range may not be of the same data type (e.g., numbers stored as text).</li></ol><h3>How to Fix the #N/A Error:</h3><ol><li><strong>Check the Lookup Value</strong>:</li></ol><ul><li>Ensure that the value you are looking for exists in the lookup range. Double-check for typos or discrepancies in spelling or formatting.</li></ul><p><strong>2. Verify the Range</strong>:</p><ul><li>Make sure that the range specified in the lookup function includes the necessary data. For example, in =VLOOKUP(A1, B1:C10, 2, FALSE), ensure that the value in A1 is actually in the first column of B1:C10.</li></ul><p><strong>3. Data Type Consistency</strong>:</p><ul><li>Ensure that the data types match. For instance, if you’re looking for a number, make sure the range doesn’t contain text representations of numbers. You can convert numbers stored as text to actual numbers by using the VALUE function:</li></ul><pre>=VALUE(A1)</pre><p><strong>4. Use the </strong><strong>IFNA Function</strong>:</p><ul><li>To handle the #N/A error gracefully, you can use the IFNA function, which allows you to specify a value to return if an #N/A error is encountered:</li></ul><pre>=IFNA(VLOOKUP(A1, B1:C10, 2, FALSE), &quot;Not found&quot;)</pre><blockquote>This will return “Not found” instead of #N/A if the lookup fails.</blockquote><p><strong>5. Check for Hidden Characters</strong>:</p><ul><li>Sometimes, hidden characters (like extra spaces) in the lookup values can cause a mismatch. Use the TRIM function to remove any extra spaces:</li></ul><pre>=TRIM(A1)</pre><h3>5. #NAME?</h3><p>It ndicates that Excel doesn’t recognize something in your formula. This error commonly occurs due to misspellings, unrecognized functions, or issues with named ranges.</p><h3>Causes of the #NAME? Error:</h3><ol><li><strong>Misspelled Function Names</strong>: If you mistype a function name, Excel will not recognize it.</li><li><strong>Undefined Named Ranges</strong>: If you use a named range that hasn’t been defined, Excel will return this error.</li><li><strong>Incorrectly Quoted Text</strong>: If text strings are not enclosed in quotation marks, Excel won’t recognize them.</li><li><strong>Missing Add-ins</strong>: Sometimes, functions from add-ins may not work if the add-in is not enabled or installed.</li><li><strong>Improper Use of Operators</strong>: Using operators incorrectly (e.g., not using commas or semi-colons correctly) can also trigger this error.</li></ol><h3>How to Fix the #NAME? Error:</h3><ol><li><strong>Check for Spelling Mistakes</strong>:</li></ol><ul><li>Review the formula to ensure all function names and named ranges are spelled correctly. For example, ensure you wrote SUM instead of SOM.</li></ul><p><strong>2. Verify Named Ranges</strong>:</p><ul><li>Go to the <strong>Formulas</strong> tab and click on <strong>Name Manager</strong> to see if the named range you’re using is defined correctly. If it isn’t, you can define it or correct the reference in your formula.</li></ul><p><strong>3. Use Quotation Marks</strong>:</p><ul><li>Ensure that any text strings in your formula are enclosed in quotation marks. For example, instead of:</li></ul><pre>=IF(A1=&quot;Yes&quot;, B1, C1)  // Correct</pre><blockquote>Ensure “Yes” is quoted correctly.</blockquote><p><strong>4. Check for Missing Add-ins</strong>:</p><ul><li>If you’re using functions from an add-in, make sure the add-in is activated. Go to <strong>File</strong> &gt; <strong>Options</strong> &gt; <strong>Add-Ins</strong> to manage them.</li></ul><p><strong>5. Review Function Arguments</strong>:</p><ul><li>Check that you are using the correct syntax for functions. For instance, some functions require specific types of arguments or separators (like commas versus semicolons).</li></ul><h3>6. #NULL!</h3><p>The #NULL! error in Excel indicates that a formula is trying to reference a cell or range that is not valid. This typically happens due to incorrect use of operators, particularly when trying to find the intersection of two ranges that do not actually intersect.</p><h3>Causes of the #NULL! Error:</h3><ol><li><strong>Incorrect Use of Space Operator</strong>: The #NULL! error commonly occurs when a space is used between two cell ranges in a formula, indicating an attempt to find the intersection, which fails if there is no intersection.</li><li><strong>Empty Cell References</strong>: If a formula references empty or invalid cell ranges, it may also lead to this error.</li></ol><h3>How to Fix the #NULL! Error:</h3><ol><li><strong>Check the Formula Syntax</strong>:</li></ol><ul><li>Ensure that you are using the correct syntax for your formula. If you want to add or combine values from two ranges, use a comma (,) instead of a space. For example:</li></ul><pre>=SUM(A1:A10 B1:B10)  // Incorrect (causes #NULL!)</pre><blockquote>Change it to:</blockquote><pre>=SUM(A1:A10, B1:B10)  // Correct</pre><p><strong>2. Verify Cell References</strong>:</p><ul><li>Make sure that all cell references in your formula are valid. Check for any accidental deletions or incorrect references that might lead to the error.</li></ul><p><strong>3. Use the Correct Operator</strong>:</p><ul><li>If you intend to find the intersection of two ranges, ensure that they actually intersect. If they don’t, you’ll need to adjust your formula logic or the ranges involved.</li></ul><h3>7. #NUM!</h3><p>The #NUM! error in Excel occurs when a formula has invalid numeric values. This can happen for various reasons, often related to calculations that cannot be performed as expected.</p><h3>Causes of the #NUM! Error:</h3><ol><li><strong>Invalid Numeric Operations</strong>: Trying to perform operations that do not yield valid numeric results, such as calculating the square root of a negative number.</li><li><strong>Overflow or Underflow</strong>: Using values that are too large or too small for Excel to handle, leading to an overflow or underflow error.</li><li><strong>Invalid Arguments in Functions</strong>: Some functions require specific types of arguments, and providing inappropriate values can lead to this error.</li></ol><h3>How to Fix the #NUM! Error:</h3><ol><li><strong>Check for Invalid Operations</strong>:</li></ol><ul><li>Review your formula for any calculations that may not yield valid results. For example, if you have:</li></ul><pre>=SQRT(-1)  // This will return #NUM! because square root of a negative number is invalid</pre><blockquote>To fix it, ensure that you are only passing non-negative values to the square root function.</blockquote><p><strong>2. Review Function Arguments</strong>:</p><ul><li>Verify that all arguments used in your functions are valid. For example, ensure that the inputs to statistical functions like IRR or NPV are properly defined.</li></ul><p><strong>3. Inspect for Large or Small Values</strong>:</p><ul><li>If you’re working with very large or very small numbers, consider whether they are within Excel’s allowable range. The maximum and minimum values in Excel are approximately 1.797693E+308 and -1.797693E+308, respectively.</li></ul><p><strong>4. Use the </strong><strong>IF Function to Handle Errors</strong>:</p><ul><li>To prevent the #NUM! error from displaying, you can use the IF function to check for conditions that may lead to the error:</li></ul><pre>=IF(A1&lt;0, &quot;Invalid input&quot;, SQRT(A1))=IF(A1&lt;0, &quot;Invalid input&quot;, SQRT(A1))</pre><h3>8. #REF!</h3><p>This indicates that a formula is referencing a cell or range that is not valid. This usually occurs when a cell reference is deleted or moved</p><h3>Causes of the #REF! Error:</h3><ol><li><strong>Deleted Cells</strong>: If a formula references a cell that has been deleted, it will result in a #REF! error.</li><li><strong>Moved Cells</strong>: If a formula references cells that have been moved (e.g., when rows or columns are deleted), it can break the reference.</li><li><strong>Incorrect Use of Functions</strong>: Some functions might return a #REF! error if they are given improper arguments or if their ranges are not set correctly.</li></ol><h3>How to Fix the #REF! Error:</h3><ol><li><strong>Identify the Error Location</strong>:</li></ol><ul><li>Click on the cell with the #REF! error to see the formula. This will help you identify which part of the formula is causing the error.</li></ul><p><strong>2. Restore Deleted Cells</strong>:</p><ul><li>If you accidentally deleted a cell that the formula references, you can undo the deletion (Ctrl + Z) if it was recent, or you may need to re-enter the data or formula in the cell.</li></ul><p><strong>3. Update the Formula</strong>:</p><ul><li>If you moved cells or deleted rows/columns, update the formula to refer to the correct cells. For example, if your formula looks like:</li></ul><pre>=A1 + B1</pre><blockquote>And you deleted row 1, you’ll need to adjust it to refer to existing cells:</blockquote><pre>=A2 + B2  // Adjusted if you deleted row 1</pre><p><strong>4. Check Named Ranges</strong>:</p><ul><li>If you are using named ranges, make sure they are still valid. Go to the <strong>Formulas</strong> tab, click on <strong>Name Manager</strong>, and check if the named ranges still point to the correct cells.</li></ul><p><strong>5. Use the </strong><strong>IFERROR Function</strong>:</p><ul><li>To prevent the #REF! error from displaying, you can wrap the formula in the IFERROR function, allowing you to return a more user-friendly message or value:</li></ul><pre>=IFERROR(A1 + B1, &quot;Reference Error&quot;)</pre><h3>9. #VALUE!</h3><p>The #VALUE! error occurs when a formula has the wrong type of argument or operand. This error usually indicates that Excel cannot interpret the values used in the calculation. Here’s how to troubleshoot and fix this error:</p><h3>Causes of the #VALUE! Error:</h3><ol><li><strong>Incorrect Data Types</strong>: Using text in a formula where a number is expected (e.g., trying to perform arithmetic operations on text strings).</li><li><strong>Mismatched Range Sizes</strong>: When using array formulas or functions that require arrays of the same size, mismatched ranges can cause this error.</li><li><strong>Invalid Arguments in Functions</strong>: Some functions require specific types of arguments, and providing incorrect values can lead to a #VALUE! error.</li><li><strong>Excessive Spaces</strong>: Extra spaces or non-printable characters in text values can cause Excel to interpret them as text instead of numbers.</li></ol><h3>How to Fix the #VALUE! Error:</h3><ol><li><strong>Check Data Types</strong>:</li></ol><ul><li>Ensure that all arguments in your formula are of the correct type. For example, if you have:</li></ul><pre>=A1 + B1</pre><blockquote>Make sure that both A1 and B1 contain numeric values. If either contains text, you’ll get a #VALUE! error.</blockquote><p><strong>2. Use the </strong><strong>VALUE Function</strong>:</p><ul><li>If your cell contains numbers stored as text, you can convert them to numeric values using the VALUE function:</li></ul><pre>=A1 + VALUE(B1)</pre><p><strong>3. Review Function Arguments</strong>:</p><ul><li>Verify that all functions are being used correctly with the appropriate arguments. For example, if you use SUM incorrectly:</li></ul><pre>=SUM(A1:A5, B1:B10)  // Correct if ranges are appropriate</pre><blockquote>Ensure that the ranges are valid and intended.</blockquote><p><strong>4. Eliminate Extra Spaces</strong>:</p><ul><li>Use the TRIM function to remove any unnecessary spaces from your text:</li></ul><pre>=TRIM(A1)  // This removes extra spaces</pre><p><strong>5. Check for Non-Printable Characters</strong>:</p><ul><li>If there are hidden characters in your data, you can use the CLEAN function to remove them:</li></ul><pre>=CLEAN(A1)</pre><h3>10. #SPILL!</h3><p>It occurs when a formula is trying to return multiple values (or an array), but Excel can’t display them all in the specified range. This error is typically related to dynamic array functions introduced in Excel 365 and Excel 2021.</p><h3>Causes of the #SPILL! Error:</h3><ol><li><strong>Blocked Cells</strong>: If any cells in the range where the formula is trying to spill its results are not empty (i.e., they contain data, formulas, or formatting), Excel will return a #SPILL! error.</li><li><strong>Merged Cells</strong>: If the spill range includes merged cells, it can also cause this error.</li><li><strong>Array Size Mismatch</strong>: The output from a formula might not fit into the specified range, especially when dealing with array functions.</li></ol><h3>How to Fix the #SPILL! Error:</h3><ol><li><strong>Clear Blocked Cells</strong>:</li></ol><ul><li>Check the cells in the range where the formula is trying to spill its results. If any of these cells contain data, clear them to allow the formula to output its results. For example, if your formula is in A1 and trying to spill into A2:A10, ensure that A2:A10 are all empty.</li></ul><p><strong>2. Unmerge Cells</strong>:</p><ul><li>If the spill range includes any merged cells, unmerge them. You can do this by selecting the merged cells, going to the <strong>Home</strong> tab, and clicking on <strong>Merge &amp; Center</strong> to unmerge.</li></ul><p><strong>3. Check Formula Logic</strong>:</p><ul><li>Ensure that the formula is designed to produce a result that fits the intended spill range. For instance, using a function that produces more rows or columns than expected can trigger this error.</li></ul><h3>Tips to Avoid Excel Errors:</h3><ul><li><strong>Always Check Data Types</strong>: Ensure that you’re working with the correct data types to avoid type mismatches.</li><li><strong>Use Named Ranges</strong>: Named ranges can make formulas easier to read and reduce the likelihood of reference errors.</li><li><strong>Utilize Error Handling Functions</strong>: Use IFERROR or IFNA to manage potential errors gracefully</li></ul><h3>Frequently Asked Questions</h3><p><strong>1. Why do I keep getting </strong><strong>#VALUE! even though my data looks correct?</strong></p><ul><li>The #VALUE! error often happens when there’s hidden text in cells or non-printable characters. Try using the CLEAN and TRIM functions to remove unwanted characters.</li></ul><p><strong>2. Can I prevent </strong><strong>#DIV/0! errors from appearing in my spreadsheet?</strong></p><ul><li>Yes! You can use error handling functions like IFERROR or IF to manage division calculations safely.</li></ul><p><strong>3. What’s the difference between </strong><strong>#N/A and </strong><strong>#VALUE!?</strong></p><ul><li>The #N/A error indicates a missing value in a lookup function like VLOOKUP, whereas #VALUE! happens when Excel encounters incompatible data types.</li></ul><p><strong>4. Can merged cells cause errors?</strong></p><ul><li>Yes, merged cells often cause #SPILL! or #REF! errors in formulas that reference a range of cells. It’s best to avoid using merged cells in data tables.</li></ul><p><strong>5. How do I troubleshoot when I don’t know the error?</strong></p><ul><li>Use the “Error Checking” feature in Excel’s <strong>Formulas</strong> tab. It will help identify and explain the issue in your formula.</li></ul><h3>Further Reading and Resources</h3><ul><li><a href="https://support.microsoft.com/en-us/excel">Microsoft Excel Help Center</a></li><li>Excel Jet: Common Excel Errors</li><li>Chandoo.org: Learn Excel</li></ul><h3>Conclusion:</h3><p>Navigating Excel’s error codes can feel daunting, but understanding the reasons behind them is half the battle. By familiarizing yourself with these 10 common errors and their solutions, you can enhance your proficiency and confidence in using Excel. Remember, every mistake is a stepping stone to mastery — so embrace these challenges as opportunities for growth. With this knowledge in hand, you’ll be better equipped to tackle your data with ease and transform potential pitfalls into valuable learning experiences. Happy Excel-ing!</p><p>We want to hear from you! Have you encountered an Excel error that’s not listed here? Share your experiences and solutions in the comments below, and let’s learn from each other!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=5cf4e124b35e" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Online Platforms for Free Data Volunteer Opportunities]]></title>
            <link>https://medium.com/@Emma_Donery/online-platforms-for-free-data-volunteer-opportunities-7455b7b76107?source=rss-adda59ce4677------2</link>
            <guid isPermaLink="false">https://medium.com/p/7455b7b76107</guid>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[data]]></category>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[technology]]></category>
            <category><![CDATA[data-science]]></category>
            <dc:creator><![CDATA[Emma Donery]]></dc:creator>
            <pubDate>Tue, 01 Oct 2024 11:40:24 GMT</pubDate>
            <atom:updated>2024-10-01T11:40:24.556Z</atom:updated>
            <content:encoded><![CDATA[<h4>Volunteering for Data: A Win-Win for You and the World</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Bf8lb4f7sp9KKSbA2vTWAQ.png" /></figure><p>In today’s data-driven world, possessing strong data skills is a valuable asset. But what if you’re just starting out in the field and need practical experience? Volunteering can be the perfect solution. Not only does it allow you to gain hands-on experience, but it also gives you the opportunity to contribute to meaningful causes and make a positive impact on the world.</p><p><strong>The Benefits of Volunteering for Data</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/800/0*IVePR25htELyWtZs.gif" /></figure><ul><li>It provides you with <strong>real-world experience</strong>. 🌎</li></ul><p>By working on projects for non-profit organizations or research institutions, you’ll get to apply your data skills to solve real problems. This practical experience can be invaluable when you’re looking for a job or seeking promotions.</p><ul><li>Volunteering can <strong>expand your professional network</strong>. 🛜🌐</li></ul><p>When you work with other professionals in the field, you’ll have the opportunity to learn from their experiences and build relationships that can benefit your career. These connections can also lead to future job opportunities or collaborations.</p><ul><li>It can be <strong>incredibly rewarding</strong>. 🏆🏆</li></ul><p>Knowing that you’re using your skills to help others can be a great source of satisfaction. It’s a chance to make a difference in the world and contribute to something larger than yourself.</p><p>Here are some online platforms where you can find volunteer opportunities to gain data skills:</p><blockquote>⬇️⬇️⬇️⬇️⬇️</blockquote><h3>General Volunteer Platforms:</h3><ul><li><a href="https://www.volunteermatch.org/virtual-volunteering"><strong>VolunteerMatch</strong></a></li></ul><p>A popular platform connecting volunteers with organizations.</p><ul><li><a href="https://www.idealist.org/en/volunteer"><strong>Idealist</strong></a></li></ul><p>Offers a wide range of volunteer opportunities, including data-related projects.</p><ul><li><a href="https://www.catchafire.org/volunteer?name_filter=&amp;type_filter=1&amp;type_filter=2&amp;type_filter=5&amp;page=1&amp;init=true"><strong>Catchafire</strong></a></li></ul><p>Connects skilled professionals with nonprofits to tackle challenges.</p><ul><li><a href="https://www.bluebonnetdata.org/"><strong>Blue Bonnet Data</strong></a></li></ul><p>They recruit, train, and organize volunteers with technical skills to form data and tech teams.</p><ul><li>DataKind</li><li>Statistics without Borders</li><li>We Make Change</li></ul><h3>Data-Specific Platforms:</h3><ul><li><strong>DataKind:</strong> A global nonprofit that leverages data science to address social challenges.</li><li><strong>Data for Good:</strong> A platform connecting data scientists with organizations seeking data expertise.</li><li><strong>Data Science for Social Good:</strong> A community focused on using data science to solve social problems.</li></ul><h3>Crowdsourcing Platforms:</h3><ul><li><strong>Zooniverse:</strong> A platform for citizen science projects, often involving data analysis.</li><li><strong>Kaggle:</strong> A platform for data science competitions and datasets, which can offer learning opportunities.</li></ul><p><strong>Making the Most of Your Volunteer Experience</strong></p><p>To get the most out of your volunteer experience, it’s important to be proactive and engaged. Here are some tips:</p><ul><li><strong>Take initiative:</strong> Don’t be afraid to suggest new ideas or take on additional responsibilities.</li><li><strong>Learn from others:</strong> Ask questions and seek feedback from experienced professionals.</li><li><strong>Network with your colleagues:</strong> Build relationships with people you meet through your volunteer work.</li><li><strong>Document your accomplishments:</strong> Keep a record of the projects you work on and the skills you develop.</li></ul><p><strong>Conclusion</strong></p><p>Volunteering for data is a fantastic way to gain experience, make a difference, and build your professional network. Whether you’re a seasoned data scientist or just starting out, there are plenty of opportunities to get involved. So why not take the plunge and start volunteering today?</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=7455b7b76107" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Excel Mastery in 60 Days: Join My Challenge! ✨]]></title>
            <link>https://medium.com/@Emma_Donery/excel-mastery-in-60-days-join-my-challenge-2e58c63d8dac?source=rss-adda59ce4677------2</link>
            <guid isPermaLink="false">https://medium.com/p/2e58c63d8dac</guid>
            <category><![CDATA[analytics]]></category>
            <category><![CDATA[data]]></category>
            <category><![CDATA[excel]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[excel-training]]></category>
            <dc:creator><![CDATA[Emma Donery]]></dc:creator>
            <pubDate>Wed, 18 Sep 2024 13:23:59 GMT</pubDate>
            <atom:updated>2024-09-18T13:23:59.642Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*p2NHAjJbOcTtk8-F4WvekQ.png" /></figure><p>Are you ready to unlock the power of Excel and transform your data skills? Whether you’re a complete beginner or looking to sharpen your skills, I’m thrilled to announce my <strong>60-Day Excel Challenge</strong>! 🎉</p><h3>What is the 60-Day Excel Challenge?</h3><p>Over the next two months, I’ll be diving deep into Excel, tackling a new topic every day, and I want you to join me on this journey! From mastering the basics to exploring advanced functions, this challenge is designed to help you gain confidence and competence in one of the most powerful tools in data management.</p><blockquote>💡 <em>“Excel is the most powerful tool for business analytics today.”</em>💡</blockquote><h3>Weekly Recaps 📝</h3><p>To keep you in the loop, I’ll be sharing a recap blog every week, summarizing what I learned, key takeaways, and tips that you can apply immediately. This way, you can follow along, get inspired, and perhaps even participate in your own Excel journey!</p><h3>What Can You Expect? 🤔</h3><p>Here’s a sneak peek into the first week:</p><ul><li><strong>Day 1:</strong> Introduction to the Excel interface (cells, rows, columns)</li><li><strong>Day 2:</strong> Basic formatting techniques to make your spreadsheets stand out</li><li><strong>Day 3:</strong> Simple formulas like SUM and AVERAGE</li><li><strong>Day 4:</strong> Utilizing functions like MIN and MAX to analyze data</li><li><strong>Day 5:</strong> Understanding cell references (relative and absolute)</li><li><strong>Day 6:</strong> Creating and formatting tables for better data organization</li><li><strong>Day 7:</strong> Tips for efficient data entry, including shortcuts and autofill</li></ul><p>By the end of the week, you’ll have a solid foundation to build upon!</p><h3>Why Join Me? 🚀</h3><ul><li><strong>Learn and Grow:</strong> This challenge is a perfect opportunity to learn something new and enhance your skills.</li><li><strong>Community Support:</strong> Engage with others who are also learning. Share tips, ask questions, and celebrate victories together!</li><li><strong>Stay Motivated:</strong> Weekly recaps will not only help you track your progress but also keep you inspired.</li></ul><p><em>“The only limit to our realization of tomorrow will be our doubts of today.” — Franklin D. Roosevelt</em></p><h3>How to Get Involved</h3><ol><li><strong>Follow Along:</strong> Subscribe to my Medium blog to get weekly updates.</li><li><strong>Join the Conversation:</strong> Leave comments with your experiences, questions, or tips.</li><li><strong>Challenge Yourself:</strong> Consider taking the challenge yourself! Share your progress using #ExcelChallenge.</li></ol><h3>Personal Journey 🌟</h3><p>When I first started using Excel, I felt overwhelmed by all the functions and features. But with practice and persistence, I turned my confusion into confidence. I can’t wait to share what I learn with you!</p><h3>Resources and Tools 📚</h3><p>For those eager to dive deeper, check out these resources:</p><ul><li><strong>Excel Jet</strong>: Great for quick tips and tricks.</li><li><strong>YouTube Channel “ExcelIsFun”</strong>: Offers fantastic tutorials that align with our weekly topics.</li></ul><p><strong>Books</strong>: <em>“Excel 2021 for Dummies”</em> is a user-friendly guide for beginners.</p><h3>Closing Thoughts 💬</h3><p>Let’s make these next 60 days a journey of learning, growth, and discovery. Together, we can conquer Excel and unleash its potential! 💪</p><p><em>“The beautiful thing about learning is that no one can take it away from you.” — B.B. King</em></p><p>Stay tuned for my first recap next week, and let’s get started on this exciting adventure! 🌟</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=2e58c63d8dac" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[The Algorithmic Blues: A Data Analyst Fights for Mental Fitness]]></title>
            <link>https://medium.com/@Emma_Donery/the-algorithmic-blues-a-data-analyst-fights-for-mental-fitness-94001ef5799c?source=rss-adda59ce4677------2</link>
            <guid isPermaLink="false">https://medium.com/p/94001ef5799c</guid>
            <category><![CDATA[women-in-tech]]></category>
            <category><![CDATA[mental-health]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[mental-health-awareness]]></category>
            <category><![CDATA[data-science]]></category>
            <dc:creator><![CDATA[Emma Donery]]></dc:creator>
            <pubDate>Mon, 06 May 2024 13:23:47 GMT</pubDate>
            <atom:updated>2024-05-06T13:23:47.649Z</atom:updated>
            <content:encoded><![CDATA[<h4>From Pivot Tables to Peace of Mind: A Data Analyst’s Fight for Mental Fitness (and How You Can Too!)</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*31fqCyyV7Wbmem71qpxEeg.png" /></figure><p>Let’s face it, the allure of pivot tables can fade faster than server response times on a Monday morning . As a data analyst, I navigate a world of numbers: wrangling unruly spreadsheets, taming complex algorithms, and translating cryptic code into actionable insights. It’s a thrilling dance between logic and creativity, precision and problem-solving.</p><p>But here’s the secret no one tells you — the data I analyze most meticulously these days isn’t on some dusty server, it’s the ever-fluctuating data stream inside my own head.</p><h3><strong>Mental Health in the Age of Big Data</strong></h3><p><strong>May, Mental Health Awareness Month</strong>, serves as a powerful reminder that even the most data-driven amongst us need to hit that internal “<em>refresh</em>” button every now and then.</p><p>A recent study by the National Alliance on Mental Illness (NAMI) found that a staggering <strong>39% of data analysts</strong> report experiencing symptoms of anxiety or depression in the past year. That’s a higher rate than the national average!</p><blockquote>Dr. Amy Moore, a leading psychologist specializing in workplace stress, puts it perfectly: “We often focus on optimizing external systems, forgetting that our internal systems need optimization as well. Mental health is just as crucial for peak performance as technical skills.”</blockquote><p>The truth is, the constant analysis, the pressure to deliver razor-sharp insights under tight deadlines, the endless virtual meetings — it can all take a toll. There have been days when my anxiety has spiked higher than a poorly coded stock prediction model on a bad news day. And let’s not even get me started on the nights where sleep feels like a distant dream, lost in the sea of unfinished reports and looming deadlines.</p><h4>Confession time:</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/245/1*KDHLu_DyWNVGszoB_41mMA.gif" /></figure><p><strong>Vulnerability Alert #1: The Shame Spiral </strong>🫣</p><p>There were times when I felt ashamed of my mental health struggles. I used to be the queen of “<em>powering through</em>.” Red flags like anxiety and exhaustion? I treated them like bugs in my code — something to be squashed and ignored. But here’s the thing: ignoring mental health is like trying to run a complex data analysis on a dying laptop. The results will be messy, and you might lose valuable data (like your sanity!).</p><p>It took a particularly brutal burnout for me to finally acknowledge that my mental health needed just as much attention as my technical skills.</p><p><strong>Vulnerability Alert #2: The Imposter Syndrome </strong>🫣</p><p>Let’s be honest, data analysts are supposed to be the masters of logic and control. So how do you reconcile that with the emotional rollercoaster of, say, generalized anxiety disorder? There were days when I felt like a fraud, a data analyst who couldn’t even analyze her own emotional state. But you know what? This vulnerability is actually a strength. It allows me to connect with others who might be struggling silently, and to advocate for mental health awareness in a way that feels genuine and relatable.</p><p><strong>Vulnerability Alert #3: The All-Nighter Trap </strong>🫣</p><p>There was a time when I subscribed to the “hustle harder” mentality. Remember Monica Geller in “Friends,” fueled by gallons of coffee and sheer willpower? Yeah, that was me. There was a big presentation looming, and my anxiety was through the roof. My usual laser focus was replaced by a constant loop of self-doubt in my head. I ended up pulling an all-nighter fueled by cold brew and desperation, and let’s just say the presentation wasn’t my finest moment.</p><p>That experience was a wake-up call. I realized I needed to prioritize my mental health just as much as I prioritized meeting deadlines.</p><h3><strong>Becoming My Own Data Guru</strong></h3><p>But here’s the good news: my data analyst skills came in handy! I started treating my mental health like the most critical dataset I’ve ever encountered. Here’s how I’m using my analytical skills to combat the “algorithmic blues” (yes, I just coined that term!): 😂</p><h3>1️⃣ <strong>Tracking the Trends</strong></h3><blockquote>“Self-awareness is the first step to change,” says meditation guru Deepak Chopra.</blockquote><p>I couldn’t agree more. I use a mood tracker app like <a href="https://www.calm.com/">Calm</a> to identify patterns in my emotional state. Turns out, those pre-presentation jitters tend to peak on Wednesdays. Now, I schedule some calming meditation time on those mornings using apps like <a href="https://www.headspace.com/">Headspace</a> or <a href="https://insighttimer.com/">Insight Timer</a> to quiet the mental storm.</p><p><strong><em>Sleep?</em></strong> I wear a sleep tracker to understand how my quality of rest impacts my focus and energy levels. Turns out, those late-night coding sessions fueled by cold brew aren’t exactly a recipe for peak performance (shocker, right?).</p><h3>2️⃣ <strong>Analyzing the Network</strong></h3><p><strong><em>Feeling overwhelmed?</em></strong> I take a deep breath and analyze my schedule with the precision of a data visualization expert. Am I drowning in pointless meetings that could be replaced with an asynchronous update? Time to renegotiate with my manager! I also analyze my social interactions. Turns out, catching up with my supportive network of girlfriends after work does wonders for my energy levels and overall well-being.</p><h3>3️⃣ <strong>Becoming a Workplace Wellness Champion</strong></h3><p>But it’s not just about me. Data can be a powerful tool for advocating for mental well-being at work. Inspired by a recent employee survey, I proposed a flexible work schedule program. The pilot program has been a huge success, with employees reporting increased productivity and reduced stress levels. We’re also piloting a mindfulness workshop series — turns out, even the most hard-core data crunchers can benefit from a little zen. ‍</p><h3>💡<strong>The Takeaway</strong></h3><p>Listen up, 🙉 Taking care of your mental health isn’t a weakness, it’s a strategic advantage. You wouldn’t make decisions based on incomplete data, so don’t ignore the data screaming from within.</p><p>🔶 <strong>Schedule regular “me time”</strong> for activities that bring you joy, like meditation, reading, spending time in nature, or simply doing nothing. Treat this “me time” like any other important meeting — block it out and stick to it.</p><p>🔷 <strong>Build a strong support network</strong> of colleagues, friends, or family who understand the demands of your field and can offer encouragement when needed.</p><p>🔶 <strong>Celebrate your wins</strong> — both the big and the small. Accomplishments, no matter how seemingly insignificant, deserve recognition!</p><p>🔷 <strong>Become a Data Detective of Your Social Interactions:</strong> Feeling burnt out? Analyze your calendar and communication logs. Are you taking on too many meetings or interacting with negative people? Adjust your schedule and build a support network of positive, energizing relationships.</p><p><strong><em>Remember</em></strong>, we’re not just data analysts, we’re human beings. Let’s use this May, and every month, to prioritize our mental well-being and become data-driven forces for positive change — in ourselves, our workplaces, and the world around us. Now, go forth, analyze your needs, and design a life that fuels your mental and professional success!</p><p><strong>Need a Helping Hand? Here are some Resources:</strong></p><ul><li>National Alliance on Mental Illness (NAMI)</li><li>National Institute of Mental Health (NIMH)</li></ul><p>“Let’s start a conversation! Share your mental health tips and resources in the comments below. Together, we can rewrite the algorithm of our lives and become data-driven champions of mental well-being.</p><p>Let’s connect: <a href="https://twitter.com/Emma_Donery">Twitter</a> | <a href="https://www.linkedin.com/in/emma-donery/">LinkedIn</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=94001ef5799c" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Data Validation: From Chaos to Clarity]]></title>
            <link>https://medium.com/@Emma_Donery/data-validation-from-chaos-to-clarity-c978bbf0a18b?source=rss-adda59ce4677------2</link>
            <guid isPermaLink="false">https://medium.com/p/c978bbf0a18b</guid>
            <category><![CDATA[validation]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[analytics]]></category>
            <category><![CDATA[data]]></category>
            <category><![CDATA[data-visualization]]></category>
            <dc:creator><![CDATA[Emma Donery]]></dc:creator>
            <pubDate>Mon, 07 Aug 2023 12:25:20 GMT</pubDate>
            <atom:updated>2023-08-10T16:58:47.478Z</atom:updated>
            <content:encoded><![CDATA[<h4>Your Data’s Funniest BFF 🧑‍🤝‍🧑</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/900/0*1PrxJYOLLwdwn8pp.png" /></figure><p>Meet the data validation heroes — armed with wit, algorithms and a love for clean data! They swoop into your data sets like caped crusaders, ready to save the day with precision and accuracy. <em>Duplicates?</em> No match for their superhero powers! <em>Inconsistent data?</em> They’ll align it like a perfect dance routine. <em>Missing values?</em> They’ll conjure them back from the Bermuda Triangle (well, almost!). With these validation heroes at your side, data mishaps don’t stand a chance, and your data-driven decisions become bulletproof — or, should we say, error-proof!</p><p>Jokes aside!.. Let’s dive right in 🤿🤿</p><h3>What is Data Validation❓</h3><p><strong>Data validation </strong>is a pivotal process that entails verifying and validating collected data before it is used. It plays a critical role in guaranteeing accurate results in data handling, whether data gathering, analysis, or presentation structuring. This essential step ensures the reliability and trustworthiness of the data, empowering organizations to make informed decisions and derive meaningful insights from their data assets.</p><blockquote>“Valid data, valid decisions — it all starts with validation.”</blockquote><h4>✨ Key Principles of Data Validation</h4><ul><li><strong>Data Completeness</strong>: Ensuring all required fields contain valid and non-null values, leaving no gaps or missing information.</li><li><strong>Data Accuracy</strong>: Verifying that data values are correct, valid, and conform to predefined rules and formats.</li><li><strong>Data Consistency</strong>: Ensuring data across different datasets or sources is consistent and aligned.</li><li><strong>Data Integrity</strong>: Confirming that data remains unaltered during storage, retrieval, or transmission.</li><li><strong>Data Validity</strong>: Validating data against predefined rules, constraints, or reference data to ensure its correctness and accuracy</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/proxy/0*PdRVa-wxf7e70KKK.png" /></figure><h3>✨ <strong>Data validation rules</strong></h3><p><em>They are predefined checks and constraints applied to data to ensure accuracy, consistency, and conformity to specific criteria</em>. These rules help maintain data integrity and prevent incorrect or inconsistent data entry into a database or system. Organizations can improve data quality and avoid data-related issues by enforcing data validation rules.</p><h4>Common types of data validation rules:</h4><p>⚆ <strong>Format Validation:</strong> Format validation checks whether data follows the expected format or pattern. For example, validating email addresses to ensure they contain an “@” symbol and a domain name.</p><p>⚆ <strong>Range Validation:</strong> Range validation ensures data falls within specified numerical or date ranges. For instance, validating age values to ensure they are within a specific range, like 18 to 100 years.</p><p>⚆ <strong>Presence Check </strong>(Required Fields): Presence checks verify that data is provided for mandatory fields. These rules prevent the submission of records with missing essential information.</p><p>⚆ <strong>Uniqueness Check</strong>: Uniqueness checks validate that data in a particular field is unique and not duplicated elsewhere in the dataset. For example, ensuring that each customer has a unique identification number.</p><p>⚆ <strong>Data Type Validation</strong>: Data type validation ensures that data is of the correct data type. For instance, ensuring that numeric fields contain only numbers and text fields contain only text.</p><p>⚆ <strong>Referential Integrity</strong>: Referential integrity checks maintain relationships between related datasets. For example, when deleting a record with foreign key relationships, the data validation rule prevents deletion if associated records exist.</p><p>⚆ <strong>Business Rule Validation</strong>: Business rule validation enforces specific business rules and logic relevant to the application or business process. This could include custom rules like product SKU formats or exact discount percentages.</p><p>⚆ <strong>Length Validation</strong>: Length validation checks whether data in a field meets the specified length requirements. For example, ensuring that a postal code field contains precisely five characters.</p><p>⚆ <strong>Cross-Field Validation</strong>: Cross-field validation verifies relationships between multiple fields. For instance, ensuring that the end date of an event is after the start date.</p><p>⚆ <strong>Consistency Check</strong>: Consistency checks ensure that data between related fields remains consistent. For example, providing that the shipping and billing addresses match for a customer.</p><p>⚆ <strong>Custom Validation</strong>: Custom validation rules are tailored to specific requirements that may not fit into standard validation categories. Organizations can create custom rules based on their unique data validation needs.</p><h3>✨The Role of Data Validation in Business Processes:</h3><ol><li>Enhanced Decision-Making: Data validation ensures that decisions are based on reliable and accurate information, leading to better outcomes.</li><li>Regulatory Compliance: Validated data helps organizations meet industry standards and data protection regulations.</li><li>Improved Customer Experience: Accurate data enables personalized customer interactions and tailored services.</li><li>Risk Mitigation: Data validation reduces the risk of errors in financial reporting, supply chain management, and other critical operations.</li></ol><h3>✨ Challenges in Data Validation</h3><p>1️⃣ <strong><em>Siloed or Outdated Data:</em></strong></p><p>In the vast and distributed landscape of an organization’s data, some data inevitably becomes siloed or outdated. Validating such data sets poses a significant challenge, as accessing and verifying the integrity of isolated or outdated data requires additional effort and resources.</p><p>2️⃣ <strong><em>Time-Consuming Validation</em></strong>:</p><p>Validating data can be time-consuming, mainly when dealing with large datasets or performing manual validation. The sheer volume of data can overwhelm the validation process, delaying crucial insights and decisions. Creating a representative sample for validation can alleviate some of this burden but may not catch all potential errors.</p><p>3️⃣ <strong><em>Risks of Human Error</em></strong>:</p><p>Much of the validation process is performed manually without artificial intelligence-based validation tools. This increases the risks of human error, leading to inaccuracies, data redundancy, and skewed results. Human validation also tends to be subjective, varying from one individual to another.</p><p>4️⃣ <strong><em>Lack of Data Management Understanding</em></strong>:</p><p>Insufficient expertise in data management processes can result in irrelevant and stale data being stored in datasets. Inadequate knowledge of business rules and requirements can lead to difficulties meeting validation standards, causing frustration and inefficiencies for data professionals.</p><p>5️⃣ <strong><em>Inconsistent Validation Standards</em></strong>:</p><p>Different teams within an organization may have varied validation standards or interpretations of data quality requirements. This inconsistency can lead to discrepancies in data validation results and hinder data sharing and collaboration across departments.</p><p>6️⃣ <strong><em>Handling Complex Data</em></strong>:</p><p>The increasing complexity of data, especially in unstructured formats or from multiple sources, presents a considerable challenge for validation. Traditional validation approaches may not be adequate to handle diverse data types, leading to potential errors and incomplete assessments.</p><p>7️⃣ <strong><em>Data Privacy and Security:</em></strong> Validating data while ensuring data privacy and security can be a delicate balance. Organizations must protect sensitive information while performing thorough validation, creating a challenge in striking the right balance between data access and security.</p><p><em>Thanks for reading! If you like the article, </em><strong><em>clap (up to 50!),</em></strong><em> </em><strong><em>connect with me</em></strong><em> on social media, and </em><strong><em>follow me on Medium</em></strong><em> to stay updated with my new articles.</em></p><p><strong>🐤</strong><a href="https://twitter.com/Emma_Donery"><strong>Twitter </strong></a><strong>| 👔</strong><a href="https://www.linkedin.com/in/emma-donery/"><strong>LinkedIn</strong></a><strong> | 🎉</strong><a href="https://www.instagram.com/emma_donery/"><strong>Instagram</strong></a><strong> | 💻</strong><a href="https://github.com/EmmahCodes254"><strong>Github</strong></a></p><p><strong>👋 Like my work? Thank You. You can leave a comment on the next topic you would like me to write about.</strong></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=c978bbf0a18b" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Write and Get Paid $100–$900 for Your Data Science/AI Articles ]]></title>
            <link>https://medium.com/@Emma_Donery/write-and-get-paid-100-900-for-your-data-science-ai-articles-5d97e1ba0ac4?source=rss-adda59ce4677------2</link>
            <guid isPermaLink="false">https://medium.com/p/5d97e1ba0ac4</guid>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[data]]></category>
            <category><![CDATA[technical-writing]]></category>
            <category><![CDATA[blogging]]></category>
            <category><![CDATA[blog]]></category>
            <dc:creator><![CDATA[Emma Donery]]></dc:creator>
            <pubDate>Mon, 05 Dec 2022 19:34:45 GMT</pubDate>
            <atom:updated>2022-12-05T19:34:45.285Z</atom:updated>
            <content:encoded><![CDATA[<h4><strong><em>Write Like it matters, and it will. -Libba Bray</em></strong></h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*z4bOUPa2Qh5Tx8xt7LDpjw.png" /><figcaption>cover image</figcaption></figure><p>Heads up! I caught a dollar 💰🤑, and you can too. Get paid well to write about your passions while educating others.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/200/0*QjKbaSTMM0-I9ISx.gif" /><figcaption>make money gif by tenor</figcaption></figure><p>Data science is high in demand and explains how digital data is transforming businesses and helping them make sharper and more critical decisions. Here are some sites you can write for as you earn. I have written for some and the pay is really great. Try your luck too and earn some dollars as you write what you love 🍀.</p><h3>♦️ <a href="https://arctype.com/blog/contribute/">Arctype</a></h3><p><a href="https://arctype.com/"><strong>Arctype</strong></a> is the fast and easy-to-use database client for writing queries, building dashboards, and sharing data with your team.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*nM-MzB5wqXtBJ0N8-6HpxQ.png" /><figcaption>Arctype</figcaption></figure><p>There are five <strong>categories</strong> that this blog focuses on:</p><ol><li>SQL</li><li>Databases</li><li>Analysis</li><li>Dashboards</li><li>Advice for developers</li></ol><p>To contribute or write for archtype, check out this link <a href="https://arctype.com/blog/contribute/">here</a> to learn about their writing process</p><h3>♦️ <a href="https://marketing824805.typeform.com/to/b1T4Fw8E?typeform-source=www.google.com">Airbyte</a></h3><p><a href="https://airbyte.com/"><strong>Airbyte</strong></a> is an open-source data integration engine that helps you consolidate your data in your data warehouses, lakes, and databases.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*_TftKscVJMa5pwKF9len5g.png" /><figcaption>Airbyte</figcaption></figure><p>This platform is looking for data engineers, analysts, and backend developers to share their knowledge through blog articles that they publish under their <a href="https://airbyte.com/blog-categories/data-insights">data insights</a> or <a href="https://airbyte.com/tutorials">tutorials</a> sections.</p><p><strong>Payment</strong></p><ul><li>$900 for an article of about 1500 words after the article is published</li></ul><p>The good thing is you can cross-post your article on your medium page or personal blog</p><p>However, they only allow articles written in the English language only.</p><p>Check more about this opportunity <a href="https://airbyte.com/write-for-the-community">here</a></p><h3>♦️ <a href="https://contentlab.io/about/">Contentlab</a></h3><p><a href="https://contentlab.io/about/"><strong>ContentLab</strong></a> is a technical content marketing agency focused on delivering high-quality articles, tutorials, courses, and marketing materials to the tech industry.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*nTXM7PrWFu9K3HYFD_gUbg.png" /><figcaption>ContentLab</figcaption></figure><p>ContentLab works in these spaces:</p><ul><li><strong>Cloud</strong></li><li><strong>DevOps</strong></li><li><strong>Containers</strong></li><li><strong>AI/ML, Security</strong></li><li><strong>Web</strong></li><li><strong>Gaming</strong></li></ul><p>To become a technical writer or subject matter expert for ContentLab, Check this 🔗<a href="https://contentlab.io/writeforus/"><strong>link</strong></a></p><h3>♦️ <a href="https://draft.dev/write">Draft.dev</a></h3><p><a href="https://draft.dev/"><strong>Draft</strong>.<strong>dev</strong></a> helps startups create technical content designed to reach software engineers.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*2wNFY6uDBDftQOVXtntutg.png" /><figcaption>Draft.dev</figcaption></figure><p>Their services include</p><ul><li><strong>Technical blog posts</strong></li><li><strong>Tutorials</strong></li><li><strong>Ebooks</strong></li><li><strong>Content planning</strong></li></ul><p>Draft.dev creates content that will be read by a wide range of readers around the world hence encourages everyone at all experience levels to apply.</p><p>To get started, fill out their form o their site. 🔗<a href="https://draft.dev/write"><strong>Link</strong></a></p><h3>♦️ <a href="https://neptune.ai/">Neptune.ai</a></h3><p><a href="https://neptune.ai/"><strong>Neptune.ai</strong></a> is a lightweight tool for experiment management and collaboration in Data Science projects. It is an organized place for all your experiments, data exploration Notebooks, and more. It supports any kind of project workflow</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*cWoNb-ktoeLvhH0R_PCz-w.png" /><figcaption>Neptune.ai</figcaption></figure><p>Comprise of sharing your knowledge with the ML community?</p><p>They’re searching for:</p><ul><li><strong>ML practitioners</strong></li><li><strong>Data Scientists</strong></li><li><strong>ML Engineer</strong></li></ul><p>To write articles for Neptune.ai, check this 🔗<a href="https://neptune.ai/write-for-us"><strong>link</strong></a> out to learn more.</p><p>Rates vary between $300–600 per article</p><h3>♦️ <a href="https://blog.paperspace.com/write-for-paperspace/">Paper space</a></h3><p><a href="https://www.paperspace.com/"><strong>Paperspace</strong></a> is a high-performance cloud computing and ML development platform for building, training and deploying machine learning models.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*GL5klqpnL4RaPC6C0LbWZQ.png" /><figcaption>Paper space</figcaption></figure><p>Paperspace is concerned with articles around these three areas:</p><ul><li><strong>machine learning</strong></li><li><strong>Data science</strong></li><li><strong>3-D modeling</strong></li></ul><p>Check out this 🔗<a href="https://blog.paperspace.com/write-for-paperspace/"><strong>link</strong></a> on how to get started and some of the topics that you can write about.</p><h3>♦️ <a href="https://nanonets.com/">Nanonets</a></h3><p><a href="https://nanonets.com/"><strong>Nanonets</strong></a> is a Machine Learning platform that allows users to capture data from invoices, receipts, and other documents without any template setup.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*dMnKXoSpju0GPTj2YfxPFw.png" /><figcaption>Nanonets</figcaption></figure><p>Nanonets pays you to write your favorite Machine Learning Topics.</p><p>Suitable for <strong>machine learning</strong> and <strong>computer vision</strong> enthusiasts who love to learn and document what they learn.</p><p>To write for Nanotets, follow this 🔗<a href="https://nanonets.com/blog/write-for-us/"><strong>link</strong></a></p><h3>♦️ <a href="https://www.thebotforge.io/"><strong>Thebotforge</strong></a></h3><p><a href="https://www.thebotforge.io/"><strong>Thebotforge</strong></a> is the leading UK-based Chatbot agency specializing in conversational AI.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*EZsGvFKlTxeyq4rcmj2J3w.png" /><figcaption>Thebotforge</figcaption></figure><p>You can become a guest writer on their technical blog about <strong>conversational AI</strong> and related technologies</p><p>Check more on how to get started writing for their platform here. 🔗<a href="https://www.thebotforge.io/guest-authors/"><strong>Link</strong></a></p><h3>♦️ <a href="https://www.hitsubscribe.com/">Hitsubscribe</a></h3><p><a href="https://www.hitsubscribe.com/"><strong>Hitsubscribe</strong></a><strong> </strong>is a content marketing firm that leverages actual software engineers to write content for your audience of software engineers.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*fFUd3-GzIYaRY5SS2heIOQ.png" /><figcaption>Hitsubscribe</figcaption></figure><p>To write for Hitsubscribe, check more on the 🔗<a href="https://www.hitsubscribe.com/apply-to-be-an-author/"><strong>link</strong></a></p><p><strong>Major Topics include:</strong></p><ul><li>DevOps</li><li>Automated testing</li><li>Machine learning</li><li>Security</li></ul><h3>♦️ <a href="https://stackabuse.com/">Stack Abuse</a></h3><p><a href="https://stackabuse.com/"><strong>Stack Abuse</strong></a><strong> </strong>is a resource for software developers of any level to learn new technologies in web development and machine learning.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*14iAST3vouxCZW2i6sj2_w.png" /><figcaption>Stack Abuse</figcaption></figure><p><strong>Topics</strong></p><ul><li>Node.js</li><li>JavaScript (React, Vue, etc)</li><li>Python</li><li>MEAN Stack</li><li>AI</li><li>Unix Commands/Programming</li></ul><p>To write for Stack Abuse, check out this 🔗<a href="https://stackabuse.com/write-for-us/"><strong>link</strong></a> for writing guidelines and the writing process.</p><h3>♦️ <a href="https://365datascience.com/">365 DataScience</a></h3><p><a href="https://365datascience.com/"><strong>365 DataScience</strong></a><strong> </strong>is an educational career platform that offers various certificates &amp; courses in data science disciplines</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*B-y2oQZSc1bmPWuiL5gKQg.png" /><figcaption>365 DataScience</figcaption></figure><p>If you want to write an article for 365 DataScience, send the following at <a href="/service/mailto:team@365datascience.com">team@365datascience.com</a>:</p><ul><li>A brief overview of your background, qualifications, and experience</li><li>Links to your published articles and/or other relevant editorial work</li></ul><p>Check out more outlines and requirements on what is required of you to get started here 🔗<a href="https://365datascience.com/support/can-i-write-articles-and-contribute-to-your-blog/"><strong>Link</strong></a></p><h3>♦️ <a href="https://www.projectpro.io/">ProjectPro</a></h3><p><a href="https://www.projectpro.io/"><strong>ProjectPro</strong></a><strong> </strong>is an awesome platform that helps one learn much hands-on industrial experience with a step-by-step walkthrough of projects</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*TJ0aLPD5pLFJafl2OEwzQA.png" /><figcaption>ProjectPro</figcaption></figure><h4>Topics You Can Contribute To</h4><ul><li>Big Data</li><li>Data Science</li><li>Machine Learning</li><li>Deep Learning</li><li>Artificial Intelligence</li><li>MLOps</li><li>AWS</li><li>Azure</li><li>GCP</li><li>Cloud Computing</li><li>Python</li><li>R Programming</li></ul><p>Check out this 🔗<a href="https://www.projectpro.io/write-for-projectpro"><strong>link</strong></a> for Content Submission Guidelines and how to apply.</p><h3>Final Thoughts</h3><p>If you ever wait for perfection, you&#39;ll never write a word, so start now. Wish you the best of luck 🍀. Remember, you do not need to be an expert to try out something new. I hope this article helps you. Please leave a comment or feedback.</p><p><strong>Keep Writing ✍️</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/320/0*zK2wjRwhGw25uEf3.gif" /><figcaption>typing gif</figcaption></figure><p><em>Thanks for reading! If you like the article make sure to </em><strong><em>clap (up to 50!)</em></strong><em> and </em><strong><em>connect with me</em></strong><em> on social media and </em><strong><em>follow me on Medium</em></strong><em> to stay updated with my new articles.</em></p><p><strong>🐤</strong><a href="https://twitter.com/Emma_Donery"><strong>Twitter </strong></a><strong>| 👔</strong><a href="https://www.linkedin.com/in/emma-donery/"><strong>LinkedIn</strong></a><strong> | 🎉</strong><a href="https://www.instagram.com/emma_donery/"><strong>Instagram</strong></a><strong> | 💻</strong><a href="https://github.com/EmmahCodes254"><strong>Github</strong></a></p><p><strong>👋 Like my work? Thank You. You can buy me a coffee</strong></p><p>☕<a href="https://www.buymeacoffee.com/emmadonery">Buy me a coffee</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=5d97e1ba0ac4" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Data Lake VS. Data Warehouse: which is right for me? ]]></title>
            <link>https://medium.com/@Emma_Donery/data-lake-vs-data-warehouse-which-is-right-for-me-f53c3f296f51?source=rss-adda59ce4677------2</link>
            <guid isPermaLink="false">https://medium.com/p/f53c3f296f51</guid>
            <category><![CDATA[data]]></category>
            <category><![CDATA[data-warehouse]]></category>
            <category><![CDATA[data-lake]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[data-engineering]]></category>
            <dc:creator><![CDATA[Emma Donery]]></dc:creator>
            <pubDate>Mon, 07 Nov 2022 20:18:44 GMT</pubDate>
            <atom:updated>2022-11-07T20:18:44.549Z</atom:updated>
            <content:encoded><![CDATA[<h4>Understand the differences between the two most popular options for storing big data.</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Y3_A9dfqU0i449mCwIfbhw.png" /><figcaption>Data Lake vs. Data Warehouse</figcaption></figure><p>The debate between “<strong><em>data lakes vs. data warehouses</em></strong>” has probably just begun, yet each model is distinct due to major distinctions in structure, procedure, users, and general adaptability. Building the appropriate data lake or data warehouse will be essential for business growth, depending on your needs. In this article, we are going to understand the two and unpack the differences between them.</p><p><strong>INTRODUCTION</strong></p><figure><img alt="gif by tenor" src="https://cdn-images-1.medium.com/max/400/0*d3FYMNbC7FlaAoGs.gif" /></figure><p>The two most popular options for storing massive data are data lakes and data warehouses. These two forms are frequently mixed together, but they differ greatly from one another. In actuality, their primary function of data storage is the only significant resemblance between them.</p><blockquote>A <strong>data lake</strong> is a sizable collection of unprocessed data, the use of which is currently unknown. On the other hand, a <strong>data warehouse</strong> stores data that has previously been processed for a particular purpose and is formatted, and filtered.</blockquote><h3>What is a Data Lake?</h3><p>A <strong>data lake</strong> is a sizable collection of unprocessed data, the use of which is currently unknown.</p><p><strong>DATA LAKE BENEFITS</strong></p><ul><li><strong>Agility</strong> — Without prior planning, you can quickly configure searches, data models, or apps. The data lake method is well suited to enable SQL queries as well as real-time analytics, big data analytics, and machine learning.</li><li><strong>Real-time</strong> — Data can be imported in its native format instantly from a variety of sources. This enables you to execute machine learning and real-time analytics while also setting off events in other apps.</li><li><strong>Scale</strong> — Data lakes can handle large volumes of structured and unstructured data, including call logs and ERP transactions, despite their lack of organization.</li><li><strong>Speed </strong>— By delaying time-consuming operations like data transformation and schema development until you’ve determined the business question(s) that need to be answered, keeping data in its raw form also makes it ready for use much faster.</li><li><strong>Improved insights</strong> — By conducting new analyses on a wider variety of data, you can discover unanticipated and previously unattainable insights.</li><li><strong>Cost reductions — </strong>Data lakes need less time to manage, which results in cheaper operational costs. Additionally, because the majority of the tools you use to manage them are open source and run on affordable hardware, storage costs are lower than those of traditional data warehouses.</li></ul><h3>What is a Data Warehouse?</h3><p>A <strong>data warehouse</strong> stores data that has previously been processed for a particular purpose and is formatted, and filtered.</p><p><strong>DATA WAREHOUSE BENEFITS</strong></p><ul><li>Informed decision making</li><li>Consolidated data from many sources</li><li>Historical data analysis</li><li>Data quality, consistency, and accuracy</li><li>Separation of analytics processing from transactional databases, which improves the performance of both systems</li></ul><h3>Data Lake vs Data Warehouse</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/220/0*GwJMHRPnTs7P49M_.gif" /><figcaption>gif by tenor</figcaption></figure><h4>1️. <strong>Data storage</strong></h4><ul><li>A data lake contains all an organization’s data in a raw, unstructured form, and can store the data indefinitely — for immediate or future use</li><li>A data warehouse contains structured data that has been cleaned and processed, ready for strategic analysis based on predefined business needs.</li></ul><h4>2️. <strong>Users</strong></h4><ul><li>Data from a data lake — with its large volume of unstructured data — is typically used by data scientists and engineers who prefer to study data in its raw form to gain new, unique business insights.</li><li>Data from a data warehouse is typically accessed by managers and business-end users looking to gain insights from business KPIs, as the data has already been structured to provide answers to pre-determined questions for analysis.</li></ul><h4>3️. <strong>Analysis</strong></h4><ul><li>Predictive analytics, machine learning, data visualization, BI, big data analytics.</li><li>Data visualization, BI, data analytics.</li></ul><h4>4️. <strong>Schema</strong></h4><ul><li>Schema is defined after the data is stored in a data lake vs data warehouse, making the process of capturing and storing the data faster.</li><li>In a data warehouse, the schema is defined before the data is stored. This lengthens the time it takes to process the data, but once complete, the data is ready for consistent, confident use across the organization.</li></ul><h4>5️. <strong>Processing</strong></h4><ul><li>ELT (Extract, Load, Transform). In this process, the data is extracted from its source for storage in the data lake, and structured only when needed</li><li>ETL (Extract, Transform, Load). In this process, data is extracted from its source(s), scrubbed, then structured so it’s ready for business-end analysis.</li></ul><h4>6️. <strong>Cost</strong></h4><ul><li>Storage costs are fairly inexpensive in a data lake vs data warehouse. Data lakes are also less time-consuming to manage, which reduces operational costs.</li><li>Data warehouses cost more than data lakes, and also require more time to manage, resulting in additional operational costs.</li></ul><h4>7️. <strong>Size</strong></h4><ul><li>Data lakes are much bigger in size because they retain all data that might be relevant to a company. Data lakes are often petabytes in size — that’s 1,000 terabytes!</li><li>Data warehouses are much more selective about what data is stored.</li></ul><blockquote><strong>NB</strong>: Remember that you occasionally require a combination of the two storage options. Particularly when creating data pipelines.</blockquote><h3>Final Thoughts</h3><p><strong><em>I hope you enjoyed reading this article.</em></strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/200/0*DONSkI0Gqk9vmVg0.gif" /></figure><h4><strong>Clap it! Follow Me! Share it</strong></h4><p><strong>Let’s Connect: </strong><a href="https://twitter.com/Emma_Donery"><strong>Twitter</strong></a><strong> | </strong><a href="https://www.linkedin.com/in/emma-donery/"><strong>Linkedin</strong></a><strong> | </strong><a href="https://www.instagram.com/emma_donery/"><strong>Instagram</strong></a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=f53c3f296f51" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Must Watch TED Talks for Data Science]]></title>
            <link>https://medium.com/@Emma_Donery/must-watch-ted-talks-for-data-science-2c65540dd382?source=rss-adda59ce4677------2</link>
            <guid isPermaLink="false">https://medium.com/p/2c65540dd382</guid>
            <category><![CDATA[tedtalks]]></category>
            <category><![CDATA[dáta]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[data-visualization]]></category>
            <dc:creator><![CDATA[Emma Donery]]></dc:creator>
            <pubDate>Wed, 26 Oct 2022 19:07:31 GMT</pubDate>
            <atom:updated>2022-10-26T19:07:31.458Z</atom:updated>
            <content:encoded><![CDATA[<ol><li><a href="https://youtu.be/Sm5xF-UYgdg"><strong>How not to be ignorant about the world</strong></a> by <strong><em>Hans and Ola Rosling</em></strong> — author of <em>“Factfulness”</em></li></ol><p><strong>Hans Rosling</strong>, with his famous charts of the global population, health, and income data (and an extra-extra-long pointer), demonstrates that you have a high statistical chance of being quite wrong about what you think you know.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/853/1*sjqkA7y0oAwbU5kyDYR1QA.png" /></figure><p>2. <a href="https://youtu.be/5Zg-C8AAIGg"><strong>The beauty of data visualization</strong></a> by <strong><em>David McCandless</em></strong></p><p><strong>David McCandless</strong> turns complex data sets, like worldwide military spending, media buzz, and Facebook status updates, into beautiful, simple diagrams that tease out unseen patterns and connections. Good design, he suggests, is the best way to navigate the information glut — and it may just change the way we see the world.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/842/1*D3lFaD2g7cDRJjl5mIYaRw.png" /></figure><p>3. <a href="https://youtu.be/Zwwanld4T1w"><strong>Three ways to spot a bad statistic</strong></a> by <strong><em>Mona Chalabi</em></strong>, a <em>data journalist</em></p><p>Data journalist <strong>Mona Chalabi</strong> shares handy tips to help question, interpret and truly understand what the numbers are saying.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/811/1*3J36JzUfkoEvpyELj63MTw.png" /></figure><p>4. <a href="https://youtu.be/8pHzROP1D-w"><strong>Big data is better data</strong></a> by <strong><em>Kenneth Cukier</em></strong></p><p><strong>Kenneth Neil Cukier</strong> is an American journalist and author of books on technology and society</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/851/1*8owov2_kKgMfKA_MT1lgUA.png" /></figure><p>5. <a href="https://youtu.be/pk35J2u8KqY"><strong>The human Insight missing from Big Data</strong></a> by <strong><em>Tricia Wang</em></strong>, a global <em>tech ethnographer</em></p><p><strong>Tricia Wang</strong> demystifies big data and identifies its pitfalls, suggesting that we focus instead on “thick data” — precious, unquantifiable insights from actual people — to make the right business decisions and thrive in the unknown.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/859/1*bNw6Vcb9UD7mmERtfs2c9g.png" /></figure><p>6. <a href="https://youtu.be/Sa27SUR0Mlo"><strong>Your company’s data could end world hunger</strong></a> by <strong><em>Mallory Freeman</em></strong>, <em>Lead Data Scientist</em></p><p>Although your business may have made financial contributions to address humanitarian problems, your data may be even more valuable. <strong>Mallory Freeman</strong> demonstrates how private sector businesses may contribute untapped data and decision scientists to assist solve significant issues, such as the refugee crisis and global famine. What potential contributions might your business make?</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/856/1*-tYfuNLSCe6z5HZNgvzlvw.png" /></figure><p>7. <a href="https://youtu.be/NgbqXsA62Qs"><strong>Who controls the world</strong></a> by <strong><em>James B. Glattfelder</em></strong>, <em>Swiss Scientist</em></p><p><strong>James Glattfelder</strong> focuses on the concept of complexity, or how a connected system — like a flock of birds — is more than the sum of its parts. And it turns out that complexity theory can tell us a lot about how the economy functions. Glattfelder presents a ground-breaking investigation of how power is distributed throughout the world economy and how the vulnerability that results from the concentration of power in the hands of a startlingly small number of people.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/845/1*9lNIBGzi98ihydCSqUJE9w.png" /></figure><p><strong>Comment on your favorite TED Talks in the Data space.</strong></p><p><strong>Clap it! Share it! Follow Me!</strong></p><p><a href="https://twitter.com/Emma_Donery">Twitter</a> | <a href="https://www.linkedin.com/in/emma-donery/">Linkedin</a> | <a href="https://www.instagram.com/emma_donery/">Instagram</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=2c65540dd382" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[End To End Machine Learning Project Implementation: Preparation and Basic Analysis]]></title>
            <link>https://medium.com/@Emma_Donery/end-to-end-machine-learning-project-implementation-preparation-and-basic-analysis-b98dcbe432f?source=rss-adda59ce4677------2</link>
            <guid isPermaLink="false">https://medium.com/p/b98dcbe432f</guid>
            <category><![CDATA[machine-learning]]></category>
            <category><![CDATA[machine-learning-python]]></category>
            <category><![CDATA[exploratory-data-analysis]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[data-preparation]]></category>
            <dc:creator><![CDATA[Emma Donery]]></dc:creator>
            <pubDate>Tue, 25 Oct 2022 16:24:56 GMT</pubDate>
            <atom:updated>2022-10-25T16:24:56.063Z</atom:updated>
            <content:encoded><![CDATA[<h4>Learn how to build, test and deploy Machine Learning projects</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/880/1*LGPUzPcUQ_NfayNuu3sx4A.png" /></figure><p>This is a very simple project we are going to implement to understand and build end-to-end ML Projects with confidence.</p><p>We are going to predict Boston housing prices based on various features using the Boston housing dataset</p><p>This is the first article on the series “ End To End Machine Learning Project Implementation”.</p><h4>Prerequisites</h4><ul><li>Basics of python programming</li><li>Basics of Machine Learning — You can refer to my article on <a href="https://dev.to/emma_donery/machine-learning-with-python-introduction-4e67">Machine learning with python introduction</a></li><li>Anaconda Distribution installed — Check <a href="https://jakuuire.medium.com/">the docs</a> on how to install and get started with anaconda</li></ul><p>First, we are going to import all the libraries we are going to use.</p><p>Launch your jupyter notebook and import all the required libraries as seen below.</p><p><strong>Importing important libraries</strong></p><pre>import pandas as pd<br>import numpy as np<br>import matplotlib.pyplot as plt<br>%matplotlib inline</pre><p>Our dataset is available in a library so we are just going to import it. However, you can still download the dataset on <a href="https://www.kaggle.com/datasets/vikrishnan/boston-house-prices">Kaggle</a>.</p><pre>from sklearn import datasets<br>boston_df = datasets.load_boston()</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*v1aQjkIfZo4fX6x9oCLnuQ.png" /></figure><h3><strong>Understanding the dataset</strong></h3><p><strong>Check the description</strong></p><ul><li><em>DESCR</em>: describes the dataset</li></ul><pre>print(boston.DESCR)</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*3UZ91sgZvOqzJ_AEWjswww.png" /></figure><p>We have the target in our case “prices” which is what we want to predict based on certain features. We can go forward and explore or understand the target and features in our dataset. Simply print them out.</p><ul><li><em>target</em>: prices of the house</li><li><em>feature_names</em>: names of the features</li></ul><pre>print(boston.target)</pre><pre>print(boston.feature_names)</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*aRe3OBKKpBGA9_KDMNVGIA.png" /></figure><h3>Preparing Dataset And Basic Analysis</h3><p>Create the entire data frame altogether with respect to all the independent features</p><pre>dataset = pd.DataFrame(boston.data)</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*QtaX3EqVZAmAE8SoMcQ_9Q.png" /></figure><p><strong>NB</strong>: the displayed data does not show column names, we are going to put up all the column names</p><p><strong>There are two ways to do this:</strong></p><ul><li>When creating the pd.dataframewe can include the column.feature_names</li></ul><pre>dataset = pd.DataFrame(boston.data,columns=boston.feature_names)</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*yxB6pLqjA2Gbq08b94eA0Q.png" /></figure><p>Now you can see the column names, however, it shows all the independent features but does not show the output or dependent feature, which in our case is <em>price</em></p><ul><li>So to output the dependent feature in this dataset or target which is obviously found in boston.target , we create a new field price and assign it to bosto.target</li></ul><pre>dataset[&#39;price&#39;] = boston.target<br>dataset.head()</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*82GOeekJSIS97sN5Qilvpw.png" /></figure><h3>Basic Analysis</h3><h4>Checking the data types of all columns</h4><pre>dataset.info()</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*wRB8pAP1mCtAvZbycaTTBA.png" /></figure><h4>Summarizing the stats of the data</h4><pre>dataset.describe()</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*5rLbrI0wr2G-JQjx5Ftu1A.png" /></figure><h4>Checking missing values</h4><pre>dataset.isnull()</pre><p>If there is any value that is true, that implies that it is missing otherwise false means there is no missing values</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*a4lGwCCT2C2yA36DVPK0iw.png" /></figure><p>However, as you can see, the dataset is big to be displayed on the screen hence there still might be columns with TRUE values. To find out, we will use the sum() function to find out.</p><pre>dataset.isnull().sum()</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*UfmI2FuQSG1P5Jc1Af-jRA.png" /></figure><p>In this scenario, all of our columns are zero, meaning that our dataset has no missing values.</p><h3>Exploratory Data Analysis</h3><p><strong>Exploratory Data Analysis</strong> refers to the critical process of performing initial investigations on data so as to discover patterns, spot anomalies, test hypotheses, and check assumptions with the help of summary statistics and graphical representations.</p><h4>Correlation</h4><p>The goal is to find out how the independent features and the output features are correlated.</p><pre>dataset.corr()</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Rb4fN4tTQHxctLG_frdJbw.png" /></figure><p><strong>Tip</strong>✨: The by default correlation, in this case, is the pearson correlation Basically, it checks the relationship between two feature x and y in a way that it tries to say whether it is highly positively correlated, negatively correlated, or not correlated at all. Usually, the output ranges from -1 to 1</p><ul><li>If the value is near -1 , the more negatively correlated the features are</li><li>If the value is near +1, the more positively correlated the features are</li><li>And if it is near to 0 , they are hardly correlated.</li></ul><p>We are going to check two <strong>types of correlation</strong> here</p><ul><li>Correlation between independent features</li><li>Correlation between independent and dependent features</li></ul><p>If there is a high correlation between independent features, we can remove one of the features, this is known as <strong>multi-collinearity</strong></p><blockquote>⚠️<strong>Warning: </strong>The Boston housing prices dataset has an ethical problem. The scikit-learn maintainers therefore strongly discourage the use of this dataset unless the purpose of the code is to study and educate about ethical issues in data science and machine learning. <a href="https://scikit-learn.org/stable/modules/generated/sklearn.datasets.load_boston.html">Read more</a></blockquote><h3>Conclusion</h3><p>In the next article, we will do more advanced analysis and use some visualizations to understand the relationship of the target variable with other features, build our model, train our model and predict our new data</p><p>See you in the next article</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/400/0*s72nUsoiCQoryyx9.gif" /></figure><p><strong>Clap It!</strong>👏 <strong>Share It!</strong>🚀 <strong>Follow Me!</strong>💖</p><p>Happy to connect: <a href="https://twitter.com/Emma_Donery">Twitter </a>| <a href="https://www.linkedin.com/in/emma-donery/">Linkedin</a> | <a href="https://www.instagram.com/emma_donery/">Instagram</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=b98dcbe432f" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>