<?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 Claire Scanlon on Medium]]></title>
        <description><![CDATA[Stories by Claire Scanlon on Medium]]></description>
        <link>https://medium.com/@clairehelenscanlon?source=rss-140494af2f7c------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*u8MIb4nzc0tgUqt2cMwMVw@2x.jpeg</url>
            <title>Stories by Claire Scanlon on Medium</title>
            <link>https://medium.com/@clairehelenscanlon?source=rss-140494af2f7c------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Fri, 20 Nov 2026 00:19:01 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@clairehelenscanlon/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[The Blueprint for Connected Data]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/@clairehelenscanlon/the-blueprint-for-connected-data-611e25ee3022?source=rss-140494af2f7c------2"><img src="https://cdn-images-1.medium.com/max/1954/1*SIySJMT0m_BDresBA-vNOg.jpeg" width="1954"></a></p><p class="medium-feed-snippet">Ignoring the data issues will not fix them.</p><p class="medium-feed-link"><a href="https://medium.com/@clairehelenscanlon/the-blueprint-for-connected-data-611e25ee3022?source=rss-140494af2f7c------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://medium.com/@clairehelenscanlon/the-blueprint-for-connected-data-611e25ee3022?source=rss-140494af2f7c------2</link>
            <guid isPermaLink="false">https://medium.com/p/611e25ee3022</guid>
            <category><![CDATA[data-silos]]></category>
            <category><![CDATA[data-governance]]></category>
            <category><![CDATA[technology]]></category>
            <category><![CDATA[business-leadership]]></category>
            <category><![CDATA[data-engineering]]></category>
            <dc:creator><![CDATA[Claire Scanlon]]></dc:creator>
            <pubDate>Fri, 26 Jun 2026 09:50:05 GMT</pubDate>
            <atom:updated>2026-06-26T19:44:30.629Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[Hidden Dangers of AI in Data Ecosystems]]></title>
            <link>https://medium.com/towards-data-engineering/moving-at-the-speed-of-risk-565cb4842083?source=rss-140494af2f7c------2</link>
            <guid isPermaLink="false">https://medium.com/p/565cb4842083</guid>
            <category><![CDATA[data-engineering]]></category>
            <category><![CDATA[artificial-intelligence]]></category>
            <category><![CDATA[data-infrastructure]]></category>
            <category><![CDATA[ai-security]]></category>
            <category><![CDATA[risk-management]]></category>
            <dc:creator><![CDATA[Claire Scanlon]]></dc:creator>
            <pubDate>Mon, 20 Apr 2026 13:21:33 GMT</pubDate>
            <atom:updated>2026-04-28T03:11:12.352Z</atom:updated>
            <content:encoded><![CDATA[<p><strong>TL;DR:</strong> Imagine a F1 race car with no brakes. That’s how we are using AI right now.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*xRroayYXMyv6DY1t260dkA.png" /></figure><p>Normally, I would be writing the next article in my data silos series. Normally, I’m much more positive than this. But there’s a big difference between being honest and pretending like everything is fine. These aren’t normal times. Today, I will share a growing concern of mine.</p><p>There are reasons why the 2025 Stack Overflow Developer survey results showed widespread AI adoption while trust and developer confidence are declining.</p><p><strong>Artificial Intelligence Is Everywhere</strong></p><p>AI’s rapid innovation and growth has been outpacing security and capacity across every industry since 2025. We are deploying AI faster than organizations can understand, govern or secure it. We are embedding these AI-generated security vulnerabilities into company data infrastructures.</p><p>I’m a data person. I’ve always been an early adopter. I was one of the first people who got Facebook when it expanded beyond college campuses. I love technology. But that excitement about innovation has diminished.</p><p>It is not because of Anthropic’s newest model. We have had this concerning problem for a while now. Anthropic was just the first one to speak up. They were made the problem. They are not the problem. The real issue is the reckless speed at which we are moving without adding any guardrails.</p><p>The rapid pace will be at our own expense if we don’t step on the brakes and slow down. Operationally, psychologically, and, most importantly, in terms of security.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*w3QQTTylA9W_JoFl743ztQ.jpeg" /></figure><h4>Hidden Risks</h4><p>While AI has exploded, the guardrails protecting our data have quietly faded away. Cybersecurity has diminished. This is something many have not noticed. In addition, financial institutions are now embedding AI deep into their ecosystems without fully grasping the risks.</p><p>I recently talked to someone who worked at a bank. They told me they use “regression modeling” to check the AI tool, which is deeply embedded into their data ecosystem. I was floored. Regression testing is fine for basic math and validation, but it misses the bigger security vulnerabilities. It doesn’t catch smart hackers or weird logic mistakes.</p><h4>You Can’t Trust AI</h4><p>This is an concerning trend. People are placing far too much trust in their AI tools when they shouldn’t be.</p><blockquote><strong>The Reality Check: </strong>You cannot control AI if you don’t know where your data comes from, who owns it, why it made changes and/or how it’s being changed. Don’t just trust the AI if it did something random. Look into it, otherwise, you’re just guessing without auditing and security checks.</blockquote><h4>Speed Over Safety</h4><p>The tech industry is choosing speed over quality. The numbers are mind blowing.</p><ul><li>While AI has become 95% accurate at writing code that works (syntax), its ability to write safe code has remained flat at roughly 55%.</li><li>Approximately 62% of AI-generated code contains known vulnerabilities, such as cross-site scripting and SQL injection.</li><li>Only 54% of major code changes actually undergo a full security check.</li><li>66% of companies are shipping software twice as fast as they did last year.</li><li>Less code reviews are being done on AI-generated code (This is an observation from reading many blogs and articles by others in the same industry).</li></ul><p>In a data ecosystem, insecure AI code creates secret tunnels for hackers. It breaks the logic that runs our businesses.</p><p>AI also often creates its own shadow logic. It is a secret way of doing things that don’t follow your rules. If you don’t track the lineage of your data or audit the AI tool, you won’t be able to undo a mistake once it happens.</p><p>I have read a number of horror stories about unchecked AI tools deleting everything in company data ecosystems, as well as introducing AI-generated security hacks and vulnerabilities.</p><p>Don’t just trust the AI because it’s fast. If it does something unexpected or weird, look into it. We have to move away from blind trust. We need a system where every AI action and AI-generated code is recorded, owned and audited by a human.</p><p>Developers are also increasingly getting burned out. They are being pushed to deploy code faster than normal. They are also trying to fix AI-generated mistakes while keeping up with the daily explosion of growth.</p><p>AI is moving at a rapid and massive scale. Faster than any of us can keep up — even experienced developers.</p><h4>How We Take Back Control</h4><p>I’m not against innovation. I’m against being reckless.</p><p>AI is no longer just a chatbot. It is now embedded inside our banks, data infrastructures and internal systems. One bad model and/or bad actor can ruin everything. If we don’t start now, we may lose the chance to maintain control over our data security.</p><p><strong>To my tech people:</strong> We need to speak up about this as we are the ones who see it every day. We cannot sacrifice the safety of our banks, our apps, and our personal data for innovation. This isn’t sustainable.</p><h4>Taking Control</h4><p>Here are a few ways to protect your data.</p><ul><li>Treat AI code as insecure until it is reviewed. Every line of code and action made by AI needs a human security review.</li><li>Use semantic validation. Don’t just check if the numbers line up. Validate the logic behind the AI’s decisions.</li><li>Update your centralized documentation and embed AI safety checks into every layer. It should be accessible to everyone.</li><li>Give every dataset an owner. If a dataset doesn’t have a specific owner, it has an increased security risk.</li><li>Prioritize stability over the illusion of growth. We shouldn’t sacrifice security, stability and/or the sanity of our developers for the sake of growth. Real sustainable innovation requires a stable foundation.</li></ul><p>There are many other ways to strengthen the security of your data infrastructure as AI evolves.</p><p><em>What is the biggest AI-generated problem you have experienced integrating AI into your data stack? I know there’s some horror stories out there.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=565cb4842083" width="1" height="1" alt=""><hr><p><a href="https://medium.com/towards-data-engineering/moving-at-the-speed-of-risk-565cb4842083">Hidden Dangers of AI in Data Ecosystems</a> was originally published in <a href="https://medium.com/towards-data-engineering">Towards Data Engineering</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Data Governance Breaks Data Silos]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/@clairehelenscanlon/data-governance-breaks-data-silos-f5c08141f73a?source=rss-140494af2f7c------2"><img src="https://cdn-images-1.medium.com/max/2600/1*cg957zVwRVaJxFR596Axnw.jpeg" width="6000"></a></p><p class="medium-feed-snippet">How to turn fragmented data into a shared and trusted source of truth.</p><p class="medium-feed-link"><a href="https://medium.com/@clairehelenscanlon/data-governance-breaks-data-silos-f5c08141f73a?source=rss-140494af2f7c------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://medium.com/@clairehelenscanlon/data-governance-breaks-data-silos-f5c08141f73a?source=rss-140494af2f7c------2</link>
            <guid isPermaLink="false">https://medium.com/p/f5c08141f73a</guid>
            <category><![CDATA[leadership]]></category>
            <category><![CDATA[data-governance]]></category>
            <category><![CDATA[data-silos]]></category>
            <category><![CDATA[data-management]]></category>
            <dc:creator><![CDATA[Claire Scanlon]]></dc:creator>
            <pubDate>Tue, 27 Jan 2026 19:24:45 GMT</pubDate>
            <atom:updated>2026-02-20T19:38:53.530Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[The Commitment Gap]]></title>
            <link>https://medium.com/@clairehelenscanlon/the-commitment-gap-17ba0da4f2d4?source=rss-140494af2f7c------2</link>
            <guid isPermaLink="false">https://medium.com/p/17ba0da4f2d4</guid>
            <category><![CDATA[leadership]]></category>
            <category><![CDATA[data-silos]]></category>
            <category><![CDATA[organizational-change]]></category>
            <dc:creator><![CDATA[Claire Scanlon]]></dc:creator>
            <pubDate>Wed, 03 Dec 2025 12:25:18 GMT</pubDate>
            <atom:updated>2026-06-26T03:33:41.111Z</atom:updated>
            <content:encoded><![CDATA[<h3>Close the Leadership Gap</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*hUfgsNPAMMkCp6eoLFE_lg.jpeg" /></figure><h3>Introduction</h3><p><em>What if the biggest cause to data silos wasn’t technology?</em></p><p>You’ve been there. You need a decision to be made to do your job or move forward with a project. But that decision never comes.</p><p>You start wondering, “Why does this keep happening?” You can’t figure out how to fix the issue.</p><p>Many of us blame tools. Bad software. Fragmented systems. Incomplete data. Bad communication. But these are just symptoms while the disease spreads.</p><p>The real problem? A gap in leadership commitment.</p><h3>What is the Commitment Gap?</h3><p>The commitment gap is the disconnect between words (“we need centralized and integrated data”) and actions (no follow-through).</p><p>The proof is in the numbers. Companies with committed leaders have a 72% success rate at breaking down data silos. Without committed leaders, the success rate is only 29%.</p><p>This disconnect between words and action creates a ripple effect. Teams lose confidence. Decisions freeze. Silos persist. And nobody realizes the actual blocker isn’t the technology. It’s the leadership commitment.</p><p>Here are seven data-backed reasons why this gap exists:</p><ul><li><strong>Competing Priorities:</strong> Leaders juggle multiple initiatives. When quarterly pressure hits, silo-breaking loses priority. 35% of projects lose momentum because sponsors become unavailable during budget cycles (<a href="https://www.prosci.com/blog/3-reasons-executives-fail-at-sponsorship">Source</a>).</li><li><strong>Lack of Visible Sponsorship: </strong>Leaders confuse budget approval with real sponsorship. They don’t attend meetings, use new systems or celebrate wins. Prosci data shows 29% success with invisible sponsors vs. 72% with active ones (<a href="https://www.prosci.com/blog/primary-sponsors-role-and-importance">Source</a>).</li><li><strong>Organizational Inertia: </strong>Humans are habitual. Systems are built around silos. When employees were asked about blockers of silo-breaking, 42% blamed organizational culture (&quot;we&#39;ve always done it this way&quot;), and another 42% blamed organizational structure. Technology? Barely mentioned (<a href="https://stacks.cdc.gov/view/cdc/208200/cdc_208200_DS1.pdf">Source</a>).</li><li><strong>Bandwidth: </strong>Executives sponsor too many initiatives at once. Nearly 50% of teams rate sponsor effectiveness as poor/fair when leaders juggle competing demands (<a href="https://www.prosci.com/blog/3-reasons-executives-fail-at-sponsorship">Source</a>).</li><li><strong>Role Misunderstanding:</strong> Leaders don’t know what active sponsorship requires. 52% of sponsors don’t understand their role — they confuse passive support (budget) with active participation (meetings, decisions, visibility) (<a href="https://empower.prosci.com/best-practices-change-management-executive-summary">Source</a>).</li><li><strong>Lack of Training: </strong>Organizations don&#39;t train leaders on sponsorship skills. This includes how to communicate, remove obstacles, build coalitions. Project teams assume leaders &quot;naturally know&quot; when they don&#39;t (<a href="https://www.prosci.com/blog/3-reasons-executives-fail-at-sponsorship">Source</a>).</li><li><strong>Leadership Alignment Gaps: </strong>When C-suite leaders aren’t aligned on breaking data silos, they all send mixed signals to their teams. Teams don’t know what to do. Initiative feels optional. 70% of transformations fail due to lack of engagement (S<a href="https://www.aimbusinessschool.edu.au/why-abs/blog/why-70-of-change-management-initiatives-fail">ource</a>) and vision clarity. 82% of companies cite leadership alignment as biggest goal barrier (<a href="https://www.gallup.com/workplace/390830/true-impact-leadership-engagement.aspx">Source</a>).</li></ul><p>These seven blocks are all interconnected. These aren’t isolated problems. Organizations that address only one or two blockers see small gains (30–50% improvement). The companies that tackle all seven see a whopping 150%+ in efficiency gains.</p><h3>How To Fix The Commitment Gap</h3><p>The good news? Every block has a fix. When you address them together, results compound. No more waiting for the &quot;right data.&quot; No more frozen decisions. No more silos.</p><p>Here’s how to close the commitment gap:</p><h4>Leadership Alignment (Foundation)</h4><p>CEO meeting: Get ALL bosses in one room. Agree on ONE clear goal. Every boss tells their team the same story. Each champions their department + company. Result: 5x faster progress.​</p><h4>Fix Competing Priorities (Too Many Projects)</h4><p>Limit leaders to 3 top projects at once. Rank all work. If breaking data silos is #1, lock that priority and block leaders’ calendars first. The CEO should protect these resources and prevent distractions.</p><h4>Bandwidth</h4><p>Protect leaders’ time by reserving at least 4 hours monthly just for sponsorship activities. Limit projects to manageable numbers. CEOs should enforce this discipline.</p><h4>Role Misunderstanding</h4><p>Provide a simple one-page sponsor charter on day one, clearly outlining responsibilities, and have leaders commit by signing it. This reduces confusion (which affects over half of sponsors).</p><h4>Lack of Training</h4><p>Train leaders with focused coaching programs (like Prosci’s 6-hour sponsor briefings) so they learn how to communicate, remove obstacles, and support teams effectively. Effective training leads to six times more success.</p><h4>Lack of Visible Sponsorship</h4><p>Leaders need to show up, attend key meetings, use shared data themselves, and celebrate wins publicly. When leaders disappear, teams lose faith because they mirror what bosses do.</p><h4>Organizational Inertia</h4><p>Between months 6 and 8, make new behaviors stick with mandatory check-ins, rewards for collaboration, and automated cross-team workflows.</p><h3>Conclusion</h3><p>Leadership commitment isn’t optional. It’s the foundation. The commitment gap isn’t about whether leaders will commit. It’s about <em>how they commit</em>. And that difference determines everything.</p><p>Without addressing commitment gap blocks, technology will fail. Processes will stall. Data silos will persist. Billions will be wasted. Your team will be frustrated.</p><p>Organizations need to address leadership commitment before investing in new tools or processes. Technology can’t save you until leaders step up first. The best tool won’t do anything to break silos if your executives aren’t visibly participating, aligned on priorities, and following through.</p><p>The path forward is clear. Close the leadership commitment gap first.</p><p><em>That’s how you actually break down silos for good. Because without it, nothing changes.</em></p><p>Stay tuned for the next article in this series about data silos.</p><p><strong>Reference: </strong>This article builds on the first article about data silos and the hidden costs. Read the article <a href="https://medium.com/@clairehelenscanlon/hidden-costs-of-data-silos-30ec05ed14c6">here</a>.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=17ba0da4f2d4" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Why Your Data Silos Are Costing More Than You Think]]></title>
            <link>https://medium.com/@clairehelenscanlon/hidden-costs-of-data-silos-30ec05ed14c6?source=rss-140494af2f7c------2</link>
            <guid isPermaLink="false">https://medium.com/p/30ec05ed14c6</guid>
            <category><![CDATA[data-management]]></category>
            <category><![CDATA[data-silos]]></category>
            <category><![CDATA[efficiency]]></category>
            <category><![CDATA[business-intelligence]]></category>
            <category><![CDATA[data-strategy]]></category>
            <dc:creator><![CDATA[Claire Scanlon]]></dc:creator>
            <pubDate>Wed, 01 Oct 2025 10:21:08 GMT</pubDate>
            <atom:updated>2026-06-26T03:31:39.085Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1000/1*hXSg2X4zE_BIqz5FfATRow.jpeg" /></figure><p><strong><em>Ever wasted time trying to find data you need?</em></strong></p><p>It is incredibly frustrating when you can’t find the information you need. Many people brush it off as a minor inconvenience.</p><p>But it is much bigger than a simple inconvenience. It is a barrier to productive collaboration, accurate data-driven decision-making and operational efficiency.</p><p>It is called data silos.</p><h4>What is Data Silos?</h4><p>It’s more common than you realize. You probably did not realize there was a word to describe it until now.</p><p>Data silos happen when different teams or departments in the same company keep their data isolated. The teams don’t share information with each other. The sales, marketing, and finance teams are all storing critical information in separate spots. Everyone ends up working with only bits and pieces of the full picture.</p><p>This causes inaccurate decision making — caused by partial and incomplete data.</p><p>Disconnected data impacts collaboration and creates missed opportunities. Targeted campaigns can fall short. Finance departments can operate without real-time sales data — leading to inaccurate budget forecasts. It causes many problems.</p><h4>Why This Matters</h4><p>Data silos is a massive economic burden. We are talking about trillions of dollars in lost productivity, inefficient processes and missed revenue. Employees waste hours weekly searching for scattered information. Poor data integration increases security risks and weakens compliance efforts.</p><p><strong>Statistics on Data Silos</strong></p><ul><li>The global economic cost of data silos is estimated at around $3.1 trillion annually. This causes lost revenue, productivity and inefficiencies. (Source: <a href="https://www.jpmorgan.com/kinexys/content-hub/collective-intelligence-from-data-silos">JP Morgan</a>)</li><li>Employees spend about 12 hours weekly searching for disconnected data lost somewhere in silos. This directly reduces productivity. (Source: <a href="https://venturebeat.com/data-infrastructure/report-data-silos-cause-employees-to-lose-12-hours-a-week-chasing-data">Forrester</a>)</li><li>IDC market research highlighted inefficiencies caused by data silos can cause revenue losses up to 30%. Fragmented data landscapes increase operational complexity and costs. (Source: <a href="https://www.datadynamicsinc.com/blog-disentangle-from-the-shackles-of-data-silos-the-key-to-unlocking-the-transformative-power-of-your-data-assets/">Data Dynamics</a>)</li><li>The average cost of data breaches caused by data silos is about $4.35 million per event globally. IBM’s 2025 Cost of a Data Breach Report indicates a global average breach cost of $4.44 million. Data silos creates major exposure risks while increasing breach severity and recovery costs. (Source:<a href="https://www.ibm.com/think/x-force/2025-cost-of-a-data-breach-navigating-ai"> IBM</a>)</li><li>Bad data caused by silos costs companies on average $12.9 million annually in direct losses from inefficiencies and errors. (Source: Gartner)</li></ul><h4>Breaking Down Silos</h4><p>Data silos does not have to be an inevitable part of today’s business world. It is solvable. By integrating data across teams and systems, organizations can find the information they actually need — all of it.</p><p>Solving data silos increases collaboration, accelerates decision-making and improves compliance while increasing efficiency and profits.</p><h4>Strategies To Solve Data Silos</h4><p>In this series on data silos, I will be sharing strategies to break down these barriers. You’ll be able to reshape fragmented data into integrated strategic assets.</p><p><strong><em>Stay tuned for the next post in this series.</em></strong></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=30ec05ed14c6" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Seeing Beyond the Bias: How to Sharpen Your Perception and Make Clearer Judgments]]></title>
            <link>https://medium.com/@clairehelenscanlon/seeing-beyond-the-bias-how-to-sharpen-your-perception-and-make-clearer-judgments-006bd2b0b33a?source=rss-140494af2f7c------2</link>
            <guid isPermaLink="false">https://medium.com/p/006bd2b0b33a</guid>
            <category><![CDATA[analyzing-data]]></category>
            <category><![CDATA[data]]></category>
            <category><![CDATA[personal-biases]]></category>
            <dc:creator><![CDATA[Claire Scanlon]]></dc:creator>
            <pubDate>Wed, 30 Oct 2024 23:44:28 GMT</pubDate>
            <atom:updated>2024-11-17T05:41:04.310Z</atom:updated>
            <content:encoded><![CDATA[<p><em>Have you ever made a snap judgment about someone, only to be proven completely wrong?</em></p><p>We all have. That quick assessment — based on appearance, a single interaction or even just a strange point of view — can sometimes lead us down the wrong path. It is not a great feeling to have.</p><p>It is human nature to rely on shortcuts and to fill in the gaps with assumptions. These mental shortcuts, known as biases, can cloud our judgment and prevent us from seeing the full picture.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*4SUPw3W9wE3CqHaLP1VM1Q.jpeg" /><figcaption>Distortion</figcaption></figure><p>As someone who navigates the world with hearing loss, I am acutely aware of how biases shape perceptions. I see firsthand how quickly people can jump to conclusions based on what they <em>think </em>they know.</p><p>For example, I can only read 14% of lips without the auditory information. I am a terrible lip reader. But it doesn’t stop people from assuming that I am good at reading lips — even after I tell them this information three times. They’re not listening to understand, they’re listening to reply. Their own biases are in the way of actually hearing what I am saying. They already made that judgement based on the way I talk. Because of this, they continue to assume I can read lips when I really can’t read lips.</p><p>But there is a way for everyone to tackle their own biases. By cultivating a more mindful approach to observation and looking at it from all angles and cues, we can break free from these limitations.</p><p>There would be more informed and compassionate judgments. There would be more active listening.</p><p>In her insightful book <em>Visual Intelligence</em>, Amy Herman explores how we can train ourselves to see more clearly with not just with our eyes, but with our minds.</p><p>It is a skill that is valuable and relevant to everyone. By understanding the different types of biases, being self aware and challenging our assumptions, we can unlock a deeper level of understanding and make decisions that are more aligned with our values.</p><h4>The Many Faces of Biases</h4><p>Biases come in many forms.</p><p>There’s <em>unconscious bias</em> — the subtle prejudices we hold without even realizing it.</p><p><em>Confirmation bias </em>leads us to seek out information that confirms our existing beliefs, while ignoring evidence to the contrary.</p><p>The <em>halo effect</em> makes us attribute positive qualities to someone based on a single favorable trait.</p><p>The <em>anchoring bias </em>causes us to over rely on the first piece of information we receive, even if it is irrelevant.</p><p>These biases can creep into our lives in countless ways. We might judge a job applicant based on their appearance. We might assume someone’s personality based on their social media posts. We might assume we know more about someone else’s life than we actually do. We might make a financial decision based on a friend’s advice rather than doing solid research.</p><p>If we look for red flags in significant others — we will find red flags. What you may see tends to not be accurate, especially if you’re looking at it from a specific angle without exploring other angles. This is confirmation bias.</p><p>The consequences can range from missed opportunities to damaged relationships to harmful stereotypes.</p><p>The book encourages us to think like art detectives. Like an art historian analyzing a painting while looking for hidden details and layers of meaning, we can learn to analyze situations with a more critical eye.</p><p>By questioning our assumptions and seeking out different perspectives and angles, we can start to peel back the layers of bias and see the world with more clarity.</p><h4>A Different Way of Seeing</h4><p>Living with hearing loss has given me a unique perspective on the power of observation. I heard much less auditory information growing up than I do now.</p><p>Growing up, I learned to use visual cues, body language and subtle shifts to fill in the blanks. These data points, along with the auditory information I now have, helps me understand the world outside of my own lens.</p><p>This has made me aware of how much we miss when we rely solely on our initial impressions. We don’t know everything and we shouldn’t assume to know everything.</p><p>Developing this skill is like developing a superpower. By tuning in to the nuances of nonverbal communication, you hone the ability to read people, to sense their emotions and to discern their true intentions.</p><p>This heightened awareness has not only helped me navigate social situations, but it has also made me a more empathetic and insightful communicator. It helps me be a more active listener.</p><p>This resonates deeply with Herman’s concept of visual intelligence. It is about training ourselves to be more attentive observers — to notice the details that others might miss and to question the stories we tell ourselves about what we see. It is about recognizing that our perceptions are shaped by our own experiences and biases. By challenging those biases, we can gain a more accurate and nuanced understanding of the world.</p><h4>Sharpening Your Visual Intelligence</h4><p>How can we cultivate this visual intelligence? Herman offers a number of practical strategies in the book — and I found these to be incredibly valuable in my own life.</p><p><strong>Active Looking</strong>: This involves consciously paying attention to details, asking questions and challenging our assumptions. By doing this, we actively engage with the world around us. We then seek to understand the “why” behind what we see.</p><p><strong>Seeking Diverse Perspectives:</strong> It is easy to get stuck in our own echo chambers. Especially when we are surrounded by people who share our views. By actively seeking out diverse perspectives, we challenge our own biases and gain a more complete understanding of any situation.</p><p><strong>Cultivating Curiosity</strong>: Curiosity is the key to unlocking new insights and overcoming bias. By asking questions, challenging our own conclusions and remaining open to new information, we can break free from the limitations of our own perspectives.</p><p>These skills can be practiced in everyday life.</p><p>When meeting someone new or someone you haven’t seen in a long time, resist the urge to make snap judgments. Instead, pay attention to their body language, listen actively to what they have to say and ask thoughtful questions.</p><p>When faced with a decision, seek out diverse perspectives and challenge your own assumptions. When confronted with information that contradicts your beliefs, be open to the possibility that the information might be wrong.</p><h4>The Clarity of Objective Judgment</h4><p>The benefits of overcoming bias are numerous. We make better decisions, build stronger relationships and navigate conflict with greater ease.</p><p>We become more empathetic and compassionate individuals, capable of understanding and appreciating the perspectives of others.</p><p>In my own life, I see first hand how these principles can lead to positive change. Challenging my own biases and seeking out diverse perspectives has helped me build a successful career, accurately read and navigate challenging social situations, and develop deeper and more meaningful relationships.</p><p>The book <em>Visual Intelligence</em> provides a powerful framework for applying these principles in various contexts.</p><p>Whether you are a business leader making strategic decisions, a teacher interacting with students, or just someone who wants to improve their relationships: the ability to see clearly and objectively is essential.</p><h4>A World Seen Anew</h4><p>Bias is a part of human nature, but it does not have to control us. By cultivating visual intelligence, we can learn to recognize and overcome our biases. This would lead to clearer judgments, more informed decisions and a more just and equitable world.</p><p>I encourage you to read the book <a href="https://a.co/d/0GqEjJR">Visual Intelligence</a> and explore the concepts. Practice and build your skills of active looking, seeking diverse perspectives and cultivating curiosity.</p><p>By challenging your assumptions and embracing a more objective perspective, you can unlock a deeper level of understanding. This would create positive change in your own life and the world around you.</p><p>After all, the ability to see clearly is a gift we can all cultivate.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=006bd2b0b33a" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[The Power of Early Exploratory Data Analysis]]></title>
            <link>https://medium.com/@clairehelenscanlon/the-power-of-early-exploratory-data-analysis-17b90c3bd0aa?source=rss-140494af2f7c------2</link>
            <guid isPermaLink="false">https://medium.com/p/17b90c3bd0aa</guid>
            <category><![CDATA[data-analytics]]></category>
            <category><![CDATA[python]]></category>
            <category><![CDATA[data-profiling]]></category>
            <category><![CDATA[exploratory-data-analysis]]></category>
            <dc:creator><![CDATA[Claire Scanlon]]></dc:creator>
            <pubDate>Fri, 04 Oct 2024 22:09:31 GMT</pubDate>
            <atom:updated>2026-04-22T16:36:25.777Z</atom:updated>
            <content:encoded><![CDATA[<h4>From identifying data quality issues to understanding data structure, EDA is the foundation for successful data analysis.</h4><p><strong><em>Update as of April 2026: </em></strong><em>Correction needed. This concept is actually called data profiling. The article utilizes Python to understand the ins and outs of the data before proceeding to work on the data.</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/877/1*LZ9Ape3M0L21j-a51piB6A.png" /></figure><p>Just like a detective needs to know what the evidence is before carefully examining the evidence, data analysts need to understand the data in order to analyze the data.</p><h3>What is Exploratory Data Analysis?</h3><p>Exploratory Data Analysis (EDA) is the process of investigating and summarizing your dataset’s main characteristics. It is a bird’s eye view of your data landscape before zooming in on the details.</p><h3>Why Doing EDA Early in the Process Matters</h3><p>By performing EDA following the data collection step, you get the following benefits:</p><ul><li><strong>Identifying Data Quality Issues Early: </strong>Detecting missing values, outliers, and inconsistencies in order to save headaches and time.</li><li><strong>Knowing What Questions to Ask: </strong>Understanding your data’s structure and characteristics helps you formulate more targeted questions and develop more effective analysis strategies.</li><li><strong>Avoiding false assumptions: </strong>Not assuming anything about the data without knowing the nuances.</li><li><strong>Strategically Handling Missing Data:</strong> Identifying the extent and patterns of missing data will inform your strategies for handling these gaps.</li><li><strong>Understanding Column Fields and Data Types: </strong>Understanding the columns and data types early on in the process helps you formulate a strategy for merging datasets together.</li></ul><h4>Early Exploratory Data Analysis: Example</h4><p>For this example, I utilized Python and Pandas below.</p><pre>Python<br>import pandas as pd <br><br>dataset = pd.read_csv(&#39;your_data.csv&#39;) # Load your data<br><br># Get a glimpse of the data<br>print(dataset.head())  # Shows the first few rows<br><br># Understand the structure<br>print(dataset.info())  #  Provides column names, data types, and non-null values<br><br># Generate summary statistics<br>print(dataset.describe()) #  Gives you descriptive statistics for numerical columns <br><br># Count missing values<br>print(dataset.isnull().sum()) #  Tells you how many missing values are in each co</pre><p>By doing this right after collecting the data, I now understand the data’s structure, types and potential issues. This simple EDA process provides crucial insights.</p><ul><li><strong>Dataset Overview: </strong>dataset.head() shows the first few rows, giving a quick glimpse of the data’s content.</li><li><strong>Data Structure: </strong>dataset.info() provides information about column names, data types, and non-null counts, helping identify potential type mismatches or unexpected null values.</li><li><strong>Statistical Summary:</strong> dataset.describe() offers a statistical overview of numerical columns, including count, mean, standard deviation, and quartiles. This helps spot potential outliers or unexpected distributions.</li><li><strong>Missing Data: </strong>dataset.isnull().sum() quantifies missing values in each column, guiding decisions on data imputation or removal strategies.</li></ul><h4>The Impact of Early EDA on Project Success</h4><p><strong><em>Conducting EDA early in your data analysis process can significantly impact the success of your project.</em></strong></p><ul><li><strong>Time Efficiency: </strong>By identifying issues early, you avoid wasting time on analyses that may need to be redone later.</li><li><strong>Improved Accuracy:</strong> Understanding your data helps you choose appropriate methods, leading to more accurate results.</li><li><strong>Better Communication:</strong> EDA findings provide a foundation for explaining your approach and results to stakeholders.</li><li><strong>Increased Confidence:</strong> Knowing your data inside and out boosts your confidence in subsequent analysis steps.</li><li><strong>Iterative Improvement:</strong> Early insights from EDA can guide refinements in data collection for future projects.</li></ul><h3>Conclusion</h3><p>Incorporating EDA as an early step in your data analysis workflow is not just good practice — it is crucial for robust, efficient and insightful analysis. When you take the time to understand your data in the beginning, you set a strong foundation for all subsequent steps in your analysis process.</p><p>EDA is not a one-time task but an iterative process. As you clean your data and progress through your analysis, you may need to return to EDA techniques to reassess your dataset and ensure your analysis remains on track.</p><p>By making EDA a priority in your data analysis journey, you aren’t just working with data — you are truly understanding it. In the world of data analysis, understanding is the key to unlocking valuable insights and driving informed decision-making.</p><blockquote>How has early EDA improved your data analysis projects? Share your experiences and tips in the comments below!</blockquote><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=17b90c3bd0aa" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Different Color Palettes in Data Visualizations]]></title>
            <link>https://medium.com/@clairehelenscanlon/different-color-palettes-in-data-visualizations-04619284b33d?source=rss-140494af2f7c------2</link>
            <guid isPermaLink="false">https://medium.com/p/04619284b33d</guid>
            <category><![CDATA[branding]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[data-storytelling]]></category>
            <category><![CDATA[data-visualization]]></category>
            <dc:creator><![CDATA[Claire Scanlon]]></dc:creator>
            <pubDate>Mon, 01 Jul 2024 16:41:01 GMT</pubDate>
            <atom:updated>2024-07-01T18:48:29.741Z</atom:updated>
            <content:encoded><![CDATA[<h3>Elevate Your Data Visualizations with Strategic Color Palettes</h3><h4>Ever wondered how to make your data visualizations pop with the right colors?</h4><p><strong>It’s not as simple as grabbing your brand’s color palette.</strong></p><p>I have been developing my portfolio website, applying my marketing background to build my personal brand and writing a personal brand manual. It includes different elements of my brand, including color palettes and typography.</p><p>While I’m comfortable with data-driven strategies and decision making, visual design hasn’t been a strength of mine. It never was, which is why I am in the data field. But I have a marketing background.</p><p>Marketers know that brand manuals ensure consistency across platforms — in colors, typography, tone of voice, and more. While researching color palettes for my personal brand, I wanted to know how to integrate brand colors into data visualizations for a cohesive look.</p><p>My research revealed that different data visualization types require specific color palettes, each with distinct purposes and applications. Understanding these nuances proved challenging, leading me to believe that other data analysts might also be unaware of this information.</p><p><strong><em>The different color palettes used in data visualizations are:</em></strong></p><ul><li>Categorical Color Palette</li><li>Visually Equidistant Palette</li><li>Single Hue Palette</li><li>Sequential Color Palette</li><li>Divergent Color Palette</li><li>Alert &amp; Focus Palette</li></ul><h3>Categorical Color Palette</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*9rqROz4fXdun1IQjspT0rA.jpeg" /></figure><h4>Purpose:</h4><p>Distinguishes categories within visualizations, using contrasting colors that may or may not be visually equidistant.</p><h4>Focus:</h4><p>Show differentiation between categories.</p><h4>How It Works:</h4><p>Used for various types of visualizations where categories need to be differentiated.</p><h4>Examples:</h4><ul><li><em>Sales Data: </em>In a bar chart comparing sales figures for different products, a categorical palette can use distinct colors to clearly differentiate each product category, even if the colors are not perceptually equidistant.</li><li><em>Demographics:</em> In a stacked bar chart showing the age distribution of a population, different colors can be used for each age group, allowing for easy identification and comparison.</li><li><em>Financial Reports:</em> A bar chart comparing revenue or profit figures for different departments or product lines might use a categorical palette to distinguish each category clearly.</li></ul><h4>Brand Palette Inspiration:</h4><p>To tie the categorical palette to the brand color palette, directly use the brand colors if they offer enough contrast. Add colors that complement the brand colors to expand the palette.</p><h3>Visually Equidistant Palette</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*LbIIjsyjM3v98g1QHCdjpQ.jpeg" /><figcaption>Source: <a href="https://www.learnui.design/tools/data-color-picker.html#palette">https://www.learnui.design/tools/data-color-picker.html#palette</a></figcaption></figure><h4>Purpose:</h4><p>Visually equidistant palettes are a subtype of categorical palettes. It is used when the goal is to ensure each category in a visualization stands out equally, without one color appearing more dominant or important than another.</p><h4>Focus:</h4><p>Shows perceptual equality between colors to avoid visual bias.</p><h4>How It Works:</h4><p>Often created using color models like HCL that align better with human perception.</p><h4>Examples:</h4><ul><li><em>Survey Results:</em> In a pie chart showing the distribution of responses to a multiple-choice question, a visually equidistant palette ensures each response option is equally represented visually, avoiding bias towards any particular answer.</li><li><em>Multivariate Analysis: </em>When visualizing the relationships between multiple variables in parallel coordinates plots, a visually equidistant palette helps differentiate the lines representing each variable, making it easier to track their individual patterns.</li><li><em>Sentiment Analysis:</em> In a word cloud visualizing the frequency of different words in a text corpus, a visually equidistant palette ensures that words with similar frequencies are represented with similar visual prominence, avoiding a skewed perception of word importance.</li></ul><h4>Brand Palette Inspiration:</h4><p>To tie the visually equidistant palette to the brand color palette, create variations of the brand colors (shades, tints, tones) that are visually equidistant. Use a tool to generate a visually equidistant palette based on the brand colors.</p><h3>Single Hue Palette</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*DIcQs0QjY72dAi7htBFfkg.jpeg" /><figcaption>Source: <a href="https://www.learnui.design/tools/data-color-picker.html#single">https://www.learnui.design/tools/data-color-picker.html#single</a></figcaption></figure><h4>Purpose:</h4><p>The purpose of the single hue palette is to show a range of values for a single variable, typically with darker shades representing higher values and lighter shades for lower values.</p><h4>Focus:</h4><p>Variation in intensity of one color.</p><h4>How It Works:</h4><p>Uses different shades or tints of a single hue to create a gradient effect.</p><h4>Examples:</h4><ul><li><em>Customer Lifetime Value:</em> Shows customer lifetime value (CLTV) using shades of a single color (e.g., purple), with darker shades representing higher CLTV.</li><li><em>Elevation Map: </em>A topographic map uses different shades of green and brown to represent varying elevations, with darker shades indicating higher altitudes.</li><li><em>Website Heatmap:</em> Shows areas of high user interaction on a webpage using varying shades of a single color (e.g., red), with darker shades representing higher engagement levels.</li></ul><h4>Brand Palette Inspiration:</h4><p>To tie the single hue palette to the brand color palette, select one brand color and create variations in saturation and lightness.</p><h3>Sequential Color Palette</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*atREXU_BiUeHrSGEGcuyuw.jpeg" /><figcaption>Source:<a href="https://colorbrewer2.org/#type=sequential&amp;scheme=Blues&amp;n=5"> https://colorbrewer2.org/#type=sequential&amp;scheme=Blues&amp;n=5</a></figcaption></figure><p>Sequential color palettes are used to represent ordered data with a hierarchy, like in bar charts or line charts, where color intensity increases with value.</p><h4>Purpose:</h4><p>Visualizes data that has a natural order or ranking, with lighter colors for lower values and darker colors for higher values.</p><h4>Focus:</h4><p>Ordered data progression.</p><h4>How It Works:</h4><p>Uses a continuous gradient of colors, often from light to dark, to represent the progression of values.</p><h4>Examples:</h4><ul><li><em>Sales Trends: </em>Displays monthly sales figures over a year using a sequential color palette ranging from light to dark shades of green, indicating increasing sales.</li><li><em>Time Series Data: </em>Represents stock price fluctuations over time using a sequential color palette ranging from light to dark shades of red, indicating higher prices</li><li><em>Risk Assessment Heatmap: </em>Visualizes the risk levels associated with different projects or investments, with lighter colors representing lower risk and darker colors representing higher risk.</li></ul><h4>Brand Palette Inspiration:</h4><p>To tie the sequential palette to the brand color palette, start with a brand color and transition to lighter/darker shades. Use multiple brand colors as anchor points in the palette.</p><h3>Divergent Color Palette</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*OtgDdSRYicEj0oC78rhyYQ.jpeg" /><figcaption>Source: <a href="https://www.learnui.design/tools/data-color-picker.html#divergent">https://www.learnui.design/tools/data-color-picker.html#divergent</a></figcaption></figure><p>The divergent color palette is split around a neutral midpoint, perfect for data with critical midpoints, like temperature anomalies or budget variances.</p><h4>Purpose:</h4><p>Shows variations from a central value or baseline, with two distinct color schemes diverging from the center.</p><h4>Focus:</h4><p>Deviation from a midpoint.</p><h4>How It Works:</h4><p>Uses two different color gradients that meet at a midpoint, often representing a neutral or baseline value.</p><h4>Examples:</h4><ul><li><em>Financial Data: </em>Visualizes stock price changes relative to a benchmark using a divergent color palette with red for negative changes, green for positive changes, and white for no change.</li><li><em>Sentiment Analysis: </em>Represents sentiment scores for different texts using a divergent color palette with red for negative sentiment, green for positive sentiment, and yellow for neutral sentiment.</li><li><em>Temperature Anomaly Map:</em> Visualizes temperature deviations from a historical average. Blue shades would represent colder-than-average temperatures, red shades would represent warmer-than-average temperatures, and white or neutral colors would indicate temperatures close to the average.</li></ul><h4>Brand Palette Inspiration:</h4><p>To tie the divergent palette to the brand color palette, use two contrasting brand colors as endpoints, with a neutral color in the middle. If there’s one dominant brand color, use its complementary color as the other endpoint.</p><h3>Alert &amp; Focus Palette</h3><h4>Purpose:</h4><p>The alert &amp; focus palette draws attention to specific data points or areas of interest in a visualization.</p><h4>Focus:</h4><p>Highlights important information.</p><h4>How It Works:</h4><p>Typically uses bright, contrasting colors that stand out from the rest of the palette.</p><h4>Examples:</h4><ul><li><em>Financial Fraud Detection:</em> Identifies potentially fraudulent transactions in a dataset using bright orange to alert investigators.</li><li><em>Website Analytics: </em>Marks sudden drops in website traffic or conversions using bright yellow to indicate potential issues.</li><li><em>Dashboard Alerts: </em>Data dashboards might use red or orange to highlight critical metrics or performance issues that require immediate attention.</li></ul><h4>Brand Palette Inspiration:</h4><p>To tie the Alert &amp; Focus palette to the brand color palette, choose a bright, high-contrast brand color or its complementary color for alerts. Ensure the alert color stands out against the background.</p><h3>Helpful Resources:</h3><p>Palette Generator: <a href="https://www.learnui.design/tools/data-color-picker.html">https://www.learnui.design/tools/data-color-picker.html</a></p><h3>Sources used:</h3><ul><li>Antonio Cotroneo, “12 Data Visualization Color Palettes for Telling Better Stories with Your Data,” Heavy.AI Blog, April 15, 2021, <a href="https://www.heavy.ai/blog/12-color-palettes-for-telling-better-stories-with-your-data">https://www.heavy.ai/blog/12-color-palettes-for-telling-better-stories-with-your-data</a></li><li>Maxene Graze and Jonathan Schwabish, “Building Color Palettes in Your Data Visualization Style Guides,” Journal of the American Medical Informatics Association, February 2024, <a href="https://www.ncbi.nlm.nih.gov/pmc/articles/PMC10797256/">https://www.ncbi.nlm.nih.gov/pmc/articles/PMC10797256/</a></li><li>Lisa Charlotte Muth, “Which Color Scale To Use When Visualizing Data,” Datawrapper Blog, March 16, 2021, <a href="https://blog.datawrapper.de/which-color-scale-to-use-in-data-vis/">https://www.datawrapper.de/blog/which-color-scale-to-use-when-visualizing-data-part-1</a></li></ul><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=04619284b33d" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Excel Features for Clean and Organized Data]]></title>
            <link>https://medium.com/@clairehelenscanlon/excel-features-for-clean-and-organized-data-53a89ef9565c?source=rss-140494af2f7c------2</link>
            <guid isPermaLink="false">https://medium.com/p/53a89ef9565c</guid>
            <category><![CDATA[productivity]]></category>
            <category><![CDATA[data-preparation]]></category>
            <category><![CDATA[microsoft-excel]]></category>
            <category><![CDATA[data-analytics]]></category>
            <category><![CDATA[data-science]]></category>
            <dc:creator><![CDATA[Claire Scanlon]]></dc:creator>
            <pubDate>Sun, 14 Apr 2024 14:19:32 GMT</pubDate>
            <atom:updated>2024-04-14T14:30:22.627Z</atom:updated>
            <content:encoded><![CDATA[<p>Data analysts understand the critical importance of working with clean, organized, and accurate data.</p><p>Ensuring data integrity is vital. You want to eliminate as many errors and biases as possible to ensure the data is accurate and reliable for making informed business decisions.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*le4DBkSUwCxgnidlWzn73g.png" /></figure><p>Microsoft Excel is a valuable tool working with data. It is important to note that Excel has limitations when it comes to the size of data. With that being said, it is best used for small to medium datasets, while big datasets should be on a different platform. Despite this limitation, Excel has many features that are incredibly useful for data cleaning and manipulation.</p><p>In this article, we’ll explore some of those useful Excel features for streamlining data cleaning and manipulation.</p><h3>Text Functions</h3><h4>LEFT</h4><p>The LEFT function in Excel extracts one or more characters from the left side of a text string. This is useful when you only need a piece of text. This is helpful when you’re dealing with long lists of names or addresses.</p><h4>RIGHT</h4><p>Similar to LEFT, the RIGHT function extracts characters from the right side of a text string. It also trims off unnecessary bits at the end of text, such as extra spaces or punctuation marks.</p><h4>MID</h4><p>The MID function in Excel allows you to pull out a specific chunk of text from the middle of the cell. It is useful for isolating particular information within longer text strings.</p><h4>CONCATENATE</h4><p>CONCATENATE combines different pieces of text from different columns together into a single column. Data can be in many different areas in the spreadsheet which makes it incredibly hard to analyze at times. CONCATENATE brings scattered information together into an organized format. It makes the data easier to understand and analyze.</p><h4>PROPER</h4><p>The PROPER function capitalizes the first letter of each word in a text string. Imagine you’re analyzing a dataset that includes customer names. Some names are written in all lowercase, while others are written in all uppercase. This inconsistency can skew your analysis results because Excel treats “john” and “John” as two different entities.</p><h4>LEN</h4><p>The LEN function returns the number of characters in a text string. Knowing the length of text data is important. For example, the length of each customer review provides insight into the depth of customer feedback. Another example is it identifies inconsistency in character lengths. This is important because inconsistent lengths can indicate data quality issues.</p><h3>Advanced Excel Formulas</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/804/1*XvQBEPNqBPpsMrIFt9iMlg.png" /><figcaption>XLOOKUP in Microsoft Excel</figcaption></figure><h4>XLOOKUP</h4><p>This is my personal favorite and it is a versatile alternative to VLOOKUP.</p><p>XLOOKUP is an asset when working with dynamic data structures that change over time. It is adaptable to evolving datasets, where columns or rows may be added, removed, or rearranged. The adaptability ensures efficient data retrieval.</p><h4>IFERROR</h4><p>Errors in Excel formulas can disrupt data analysis and interpretation. <br>IFERROR serves as a protective shield around Excel formulas. It prevents issues with formulas from getting out of control and preventing it from impacting the entire dataset. Instead of displaying error messages, IFERROR tells the formula to display a specific value instead. It is crucial for maintaining data integrity during analysis.</p><h4>TRIM</h4><p>The TRIM formula removes all leading, trailing, and duplicate spaces from the data. It gets rid of unnecessary spaces at the beginning, end, and in-between words, making sure the data is clean and accurate. It helps with improving the cleanliness and quality of data in Excel.</p><h4>SUBSTITUTE</h4><p>The SUBSTITUTE formula replaces part of a text string with a different text string. It keeps the data consistent and organized. It is invaluable as it ensures your data has integrity and accuracy.</p><p><em>Note: An alternative to the SUBSTITUTE function is the “Find and Replace” tool in Microsoft Excel. It does the same task.</em></p><h4>UPPER/LOWER</h4><p>The UPPER and LOWER functions convert text to all uppercase or all lowercase, respectively. The consistency with capitalization is key to standardizing the data. This standardization ensures uniformity across text fields — it enables accurate and high-quality data analysis.</p><h3>Conclusion</h3><p>Clean and organized data is imperative for accurate data analysis. Messy data creates inaccurate results which can negatively and indirectly impact the bottom line of a business.</p><p>While Excel has limitations with bigger datasets, it is still a valuable tool and should be utilized to the full potential during the data analysis process. Excel’s features allow for streamlined data processes and enhanced data quality.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=53a89ef9565c" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[The Power of Self-Awareness: Effective Leaders Who Confront Their Own Bias]]></title>
            <link>https://medium.com/@clairehelenscanlon/the-power-of-self-awareness-effective-leaders-who-confront-their-own-bias-a92bd26f0b72?source=rss-140494af2f7c------2</link>
            <guid isPermaLink="false">https://medium.com/p/a92bd26f0b72</guid>
            <category><![CDATA[culture]]></category>
            <category><![CDATA[leadership]]></category>
            <category><![CDATA[self-awareness]]></category>
            <dc:creator><![CDATA[Claire Scanlon]]></dc:creator>
            <pubDate>Thu, 05 Oct 2023 04:56:58 GMT</pubDate>
            <atom:updated>2023-10-05T05:04:39.348Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*NMT-RrH3UuNPuOpPD5XOkQ.jpeg" /></figure><h3>Introduction</h3><p>In the ever-evolving landscape of business and leadership, one question stands out prominently: <strong><em>What makes an effective leader?</em></strong></p><p>The answer is multifaceted, but there’s one trait that consistently stands out — self-awareness. In today’s blog post, we will delve into the profound impact of self-awareness in leadership, especially when it comes to confronting our own biases. We will explore the real-world implications, practical benefits, and inspiring examples of leaders who harnessed the power of self-awareness to drive positive change and innovation.</p><h3>The Self-Aware Leader’s Advantage</h3><p>Imagine a leader who possesses a deep understanding of their own biases. This leader is not only aware of their strengths and weaknesses but also acknowledges their preconceived notions, prejudices, and the potential impact of these biases on decision-making. Such leaders have a distinct advantage in today’s diverse and dynamic business world.</p><h4>Enhanced Decision-Making</h4><p>Leaders who acknowledge their biases can make more informed decisions. They recognize the potential for bias to cloud their judgment and take deliberate steps to mitigate its influence. Research by McKinsey &amp; Company has shown that diverse leadership teams make better decisions and achieve better financial results. Self-aware leaders actively seek diverse perspectives, fostering a culture of inclusivity and innovation.</p><h4>Improved Team Dynamics</h4><p>Self-aware leaders set the tone for their teams. By openly addressing their biases, they create an environment where team members feel comfortable doing the same. This leads to enhanced collaboration and productivity. In fact, a Harvard Business Review study found that teams led by self-aware leaders outperform those led by leaders lacking self-awareness.</p><h4>Increased Trust and Authenticity</h4><p>Authenticity is a hallmark of effective leadership. Leaders who confront their biases and admit to their imperfections gain the trust and respect of their teams. When leaders are authentic, their teams are more likely to be engaged and committed to the organization’s goals.</p><h3>Real-World Implications and Benefits</h3><p>The benefits of self-aware leadership extend far beyond theory. Let’s delve into some real-world examples and statistics that highlight the profound implications of self-awareness in leadership.</p><p><strong>Example 1: Starbucks’ Bias Training</strong></p><p>In 2018, Starbucks faced a highly publicized incident in which two African American men were wrongfully arrested at one of their stores. Howard Schultz, then the Executive Chairman, responded by taking a bold step. He closed all Starbucks stores in the U.S. for a day to provide racial bias training to employees. This decision was a testament to Schultz’s self-awareness and his commitment to addressing bias within the company. It sent a powerful message about the importance of confronting bias, both internally and externally.</p><p><strong>Example 2: Salesforce’s Equal Pay Audit</strong></p><p>Salesforce, under the leadership of CEO Marc Benioff, conducted a comprehensive pay equity audit. The company invested $6 million to close the gender pay gap within its workforce. Benioff’s self-awareness regarding gender bias and pay disparity led to tangible action. Today, Salesforce is recognized for its commitment to diversity and equality.</p><h3>Statistics</h3><p>A study conducted by the Center for Talent Innovation found that employees of self-aware leaders are 2.5 times more likely to feel empowered and trusted. Furthermore, a report by Boston Consulting Group revealed that diverse leadership teams generated 19% more revenue compared to their less diverse counterparts.</p><h3>Practical Applications for Self-Aware Leadership</h3><p>Now that we’ve seen the compelling benefits of self-aware leadership, it’s time to explore practical applications. Here are some actionable steps for leaders aiming to cultivate self-awareness and address their biases:</p><h4>Regular Self-Reflection</h4><p>Allocate time for self-reflection. Journaling or seeking feedback from peers can help you identify biases and areas for improvement.</p><h4>Diverse Mentorship</h4><p>Surround yourself with mentors and advisors from diverse backgrounds. Their insights can provide invaluable perspectives.</p><h4>Bias Training and Education</h4><p>Invest in bias training for yourself and your team. Make it an ongoing commitment to ensure lasting change.</p><h4>Inclusive Decision-Making</h4><p>Actively seek input from diverse team members when making critical decisions. Encourage open discussions about potential biases.</p><h4>Measurable Goals</h4><p>Set concrete goals related to diversity, equity, and inclusion. Regularly assess progress and adjust strategies accordingly.</p><h3>Conclusion</h3><p>In the journey of effective leadership, self-awareness stands as a formidable ally. Leaders who confront their biases, acknowledge their imperfections, and actively seek growth have the power to drive meaningful change. The real-world examples and statistics we’ve explored make it abundantly clear that self-aware leadership is not just a theoretical concept; it is a tangible force for positive transformation.</p><p>As leaders, let us embrace self-awareness as a superpower. Let us acknowledge our biases, challenge our assumptions, and create inclusive environments where innovation and excellence thrive. The path to becoming a self-aware leader is not always easy, but it is undeniably rewarding. With self-awareness as our compass, we have the opportunity to shape a brighter and more equitable future for our organizations and the world.</p><p>I challenge you to ask yourself: Are you ready to harness the power of self-awareness and become an effective leader who confronts their own bias? The choice is yours, and the potential for impact is boundless.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=a92bd26f0b72" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>