Training & Development

After spending three decades in the aerospace industry, I’ve seen firsthand how crucial it is for different sectors to learn from each other. We no longer can afford to stay stuck in our own bubbles. Take the aerospace industry, for example. They’ve been looking at how car manufacturers automate their factories to improve their own processes. And those racing teams? Their ability to prototype quickly and develop at a breakneck pace is something we can all learn from to speed up our product development. It’s all about breaking down those silos and embracing new ideas from wherever we can find them. When I was leading the Scorpion Jet program, our rapid development – less than two years to develop a new aircraft – caught the attention of a company known for razors and electric shavers. They reached out to us, intrigued by our ability to iterate so quickly, telling me "you developed a new jet faster than we can develop new razors..." They wanted to learn how we managed to streamline our processes. It was quite an unexpected and fascinating experience that underscored the value of looking beyond one’s own industry can lead to significant improvements and efficiencies, even in fields as seemingly unrelated as aerospace and consumer electronics. In today’s fast-paced world, it’s more important than ever for industries to break out of their silos and look to other sectors for fresh ideas and processes. This kind of cross-industry learning not only fosters innovation but also helps stay competitive in a rapidly changing market. For instance, the aerospace industry has been taking cues from car manufacturers to improve factory automation. And the automotive companies are adopting aerospace processes for systems engineering. Meanwhile, both sectors are picking up tips from tech giants like Apple and Google to boost their electronics and software development. And at Siemens, we partner with racing teams. Why? Because their knack for rapid prototyping and fast-paced development is something we can all learn from to speed up our product development cycles. This cross-pollination of ideas is crucial as industries evolve and integrate more advanced technologies. By exploring best practices from other industries, companies can find innovative new ways to improve their processes and products. After all, how can someone think outside the box, if they are only looking in the box? If you are interested in learning more, I suggest checking out this article by my colleagues Todd Tuthill and Nand Kochhar where they take a closer look at how cross-industry learning are key to developing advanced air mobility solutions. https://lnkd.in/dK3U6pJf

Master the core SQL commands that drive 80% of tasks. This post focuses on practical, real-world applications of SQL for maximum impact. Fundamental SQL Commands 1. 𝗦𝗘𝗟𝗘𝗖𝗧: Retrieving specific data        𝚂𝙴𝙻𝙴𝙲𝚃 𝚏𝚒𝚛𝚜𝚝_𝚗𝚊𝚖𝚎, 𝚕𝚊𝚜𝚝_𝚗𝚊𝚖𝚎, 𝚎𝚖𝚊𝚒𝚕 𝙵𝚁𝙾𝙼 𝚌𝚞𝚜𝚝𝚘𝚖𝚎𝚛𝚜;    2. 𝗪𝗛𝗘𝗥𝗘: Filtering results        𝚆𝙷𝙴𝚁𝙴 𝚙𝚞𝚛𝚌𝚑𝚊𝚜𝚎_𝚍𝚊𝚝𝚎 >= '𝟸𝟶𝟸𝟹-𝟶𝟷-𝟶𝟷' 𝙰𝙽𝙳 𝚝𝚘𝚝𝚊𝚕_𝚜𝚙𝚎𝚗𝚝 > 𝟷𝟶𝟶𝟶;    3. 𝗚𝗥𝗢𝗨𝗣 𝗕𝗬: Aggregating data        𝚂𝙴𝙻𝙴𝙲𝚃 𝚙𝚛𝚘𝚍𝚞𝚌𝚝_𝚌𝚊𝚝𝚎𝚐𝚘𝚛𝚢, 𝚂𝚄𝙼(𝚜𝚊𝚕𝚎𝚜_𝚊𝚖𝚘𝚞𝚗𝚝) 𝙰𝚂 𝚝𝚘𝚝𝚊𝚕_𝚜𝚊𝚕𝚎𝚜    𝙵𝚁𝙾𝙼 𝚜𝚊𝚕𝚎𝚜    𝙶𝚁𝙾𝚄𝙿 𝙱𝚈 𝚙𝚛𝚘𝚍𝚞𝚌𝚝_𝚌𝚊𝚝𝚎𝚐𝚘𝚛𝚢;    4. 𝗢𝗥𝗗𝗘𝗥 𝗕𝗬: Sorting data        𝚂𝙴𝙻𝙴𝙲𝚃 𝚙𝚛𝚘𝚍𝚞𝚌𝚝_𝚗𝚊𝚖𝚎, 𝚜𝚝𝚘𝚌𝚔_𝚚𝚞𝚊𝚗𝚝𝚒𝚝𝚢    𝙵𝚁𝙾𝙼 𝚒𝚗𝚟𝚎𝚗𝚝𝚘𝚛𝚢    𝙾𝚁𝙳𝙴𝚁 𝙱𝚈 𝚜𝚝𝚘𝚌𝚔_𝚚𝚞𝚊𝚗𝚝𝚒𝚝𝚢 𝙰𝚂𝙲;    5. 𝗝𝗢𝗜𝗡: Combining related data        𝚂𝙴𝙻𝙴𝙲𝚃 𝚘.𝚘𝚛𝚍𝚎𝚛_𝚒𝚍, 𝚌.𝚌𝚞𝚜𝚝𝚘𝚖𝚎𝚛_𝚗𝚊𝚖𝚎, 𝚘.𝚘𝚛𝚍𝚎𝚛_𝚍𝚊𝚝𝚎    𝙵𝚁𝙾𝙼 𝚘𝚛𝚍𝚎𝚛𝚜 𝚘    𝙸𝙽𝙽𝙴𝚁 𝙹𝙾𝙸𝙽 𝚌𝚞𝚜𝚝𝚘𝚖𝚎𝚛𝚜 𝚌 𝙾𝙽 𝚘.𝚌𝚞𝚜𝚝𝚘𝚖𝚎𝚛_𝚒𝚍 = 𝚌.𝚒𝚍;    Advanced SQL Techniques 1. 𝗦𝘂𝗯𝗾𝘂𝗲𝗿𝗶𝗲𝘀: Nested queries for complex conditions        SELECT product_name, price    FROM products    WHERE price > (SELECT AVG(price) FROM products);    2. 𝗖𝗼𝗺𝗺𝗼𝗻 𝗧𝗮𝗯𝗹𝗲 𝗘𝘅𝗽𝗿𝗲𝘀𝘀𝗶𝗼𝗻𝘀 (𝗖𝗧𝗘): Simplifying complex queries        WITH monthly_sales AS (    SELECT EXTRACT(MONTH FROM sale_date) AS month, SUM(amount) AS total    FROM sales    GROUP BY EXTRACT(MONTH FROM sale_date)    )    SELECT month, total    FROM monthly_sales    WHERE total > 100000;    3. 𝗪𝗶𝗻𝗱𝗼𝘄 𝗙𝘂𝗻𝗰𝘁𝗶𝗼𝗻𝘀: Calculations across row sets        SELECT    department,    employee_name,    salary,    RANK() OVER (PARTITION BY department ORDER BY salary DESC) AS salary_rank    FROM employees;    4. 𝗖𝗔𝗦𝗘 𝗦𝘁𝗮𝘁𝗲𝗺𝗲𝗻𝘁𝘀: Conditional categorization        SELECT    customer_id,    CASE    WHEN lifetime_value > 10000 THEN 'VIP'    WHEN lifetime_value > 5000 THEN 'Premium'    ELSE 'Standard'    END AS customer_segment    FROM customer_data;    Optimization Tips - Use indexes on frequently filtered columns - Avoid SELECT * and only retrieve necessary columns - Use EXPLAIN ANALYZE to understand query execution plans Learning Strategy 1. Start with simple SELECT queries on a sample database 2. Progress to filtering and sorting data 3. Practice joins with multiple tables 4. Explore advanced techniques with real datasets 5. Participate in online SQL challenges and forums By mastering these SQL commands and techniques, you'll be well-equipped to handle a wide range of data analysis tasks efficiently. Regular practice with diverse datasets will solidify your skills. What's your favorite SQL trick for streamlining data ? Share your insights below!

It’s simple math 🧐 I use to think that motivation was the key to monumental success. Long story short, it’s not. It’s about the little things you do every day that will take you from reasonable to slightly unreasonable to completely unreasonable progress. Your future is not defined by how motivated you are, but by your daily routines and systems. I believe in this so much that we named our company Butterfly 3ffect to reflect the value of incremental gains. we believe that that’s how the best people and brands grow. Here’s how you grow the small way: 1. Start by setting achievable goals, like reading one chapter of a book each day or going for a short walk 2. Practice gratitude by writing down three things you're thankful for every night before bed 3. Engage in daily self-reflection, even if it's just for a few minutes, to assess your thoughts and actions 4. Incorporate small acts of kindness into your daily routine, like holding the door for someone or offering a genuine compliment 5. Learn something new every day, whether it's a fun fact, a new word, or a new skill 6. Prioritise self-care by getting enough sleep, staying hydrated, and taking breaks when needed 7. Surround yourself with positive influences, whether it's uplifting books, supportive friends, or inspiring podcasts 8. Embrace failure as a learning opportunity and a stepping stone to growth 9. Stay consistent and patient, knowing that small progress over time adds up to significant improvement 10. Celebrate your achievements, no matter how small, to stay motivated and encouraged along the way.

If you're learning SQL in 2025, this mindmap is your best friend. From beginners writing SELECT queries to advanced analysts optimizing joins and using window functions, this guide has it all: 1. 𝐒𝐐𝐋 𝐁𝐚𝐬𝐢𝐜𝐬 – SELECT, WHERE, ORDER BY, GROUP BY, and more. 2. 𝐅𝐢𝐥𝐭𝐞𝐫𝐢𝐧𝐠, 𝐒𝐨𝐫𝐭𝐢𝐧𝐠 & 𝐀𝐠𝐠𝐫𝐞𝐠𝐚𝐭𝐢𝐨𝐧s – Learn to slice data with conditions, BETWEEN, IN, and logical operators. 3. 𝐉𝐨𝐢𝐧𝐬 – Understand how to combine data from multiple tables with INNER, LEFT, RIGHT, and FULL OUTER joins. 4. 𝐖𝐢𝐧𝐝𝐨𝐰 𝐅𝐮𝐧𝐜𝐭𝐢𝐨ns – Use RANK(), LEAD(), LAG(), and ROW_NUMBER() for advanced analytics. 5. 𝐃𝐚𝐭𝐞 𝐅𝐮𝐧𝐜𝐭𝐢𝐨𝐧s – Work with time-based data using DATE_TRUNC(), EXTRACT(), NOW() etc. 6. 𝐀𝐝𝐯𝐚𝐧𝐜𝐞𝐝 𝐀𝐧𝐚𝐥𝐲𝐭𝐢𝐜𝐬 – Perform statistical analysis and integrate with ML tools like BigQuery ML and Snowflake ML. 7. 𝐂𝐓𝐄𝐬, 𝐓𝐞𝐦𝐩 𝐓𝐚𝐛𝐥𝐞𝐬 & 𝐒𝐮𝐛𝐪𝐮𝐞𝐫𝐢𝐞s – Reuse logic with WITH clauses, recursive queries, and subqueries. 8. 𝐏𝐞𝐫𝐟𝐨𝐫𝐦𝐚𝐧𝐜𝐞 𝐎𝐩𝐭𝐢𝐦𝐢𝐳𝐚𝐭𝐢𝐨n – Learn indexing, query planning, and writing efficient queries for dashboards. 𝐎𝐩𝐭𝐢𝐦𝐢𝐳𝐚𝐭𝐢𝐨𝐧 𝐓𝐢𝐩𝐬: - Use indexes on columns you frequently filter or join - Avoid SELECT * and only fetch the necessary columns - Use EXPLAIN or ANALYZE to understand query execution plans - Limit joins and subqueries when possible for better performance - Rewrite complex logic using CTEs or temp tables to improve readability 𝐇𝐨𝐰 𝐭𝐨 𝐋𝐞𝐚𝐫𝐧 𝐒𝐐𝐋 𝐄𝐟𝐟𝐞𝐜𝐭𝐢𝐯𝐞𝐥𝐲: – Practice simple SELECT, WHERE, and GROUP BY queries – Use sample datasets to understand INNER, LEFT, and FULL joins – Try window functions, date functions, and subqueries – Build dashboards or solve business problems using real-world data – Participate in SQL competitions or daily practice series Whether you're prepping for interviews, optimizing dashboards, or building data pipelines, this mindmap is your go-to reference. ♻️ Save it for later or share it with someone who might find it helpful! 𝐏.𝐒. I share job search tips and insights on data analytics & data science in my free newsletter. Join 15,000+ readers here → https://lnkd.in/dUfe4Ac6

In 2016, as I was just finding my footing as a #diversity, #equity, and #inclusion practitioner, I read an article titled, "Why Diversity Programs Fail" and learned that DEI work was not as straightforward as I had thought. From hundreds of interviews and 30 years of data from more than 800 US companies, sociologists Frank Dobbin and Alexandra Kalev found that the usual DEI interventions—mandatory diversity training, job tests, and grievance procedures—tended to REDUCE the representation of women, Black, Latine, and Asian managers. They detailed the unintended consequences of companies that deploy these intiatives: resentment and backlash, double standards, retaliation and more. There are many DEI initiatives and programs that work. Dobbin and Kalev found that programs that drive intergroup contact and draw on people's desire to look good meaningfully increase representation. Other research has found that standardizing hiring processes reduces hiring discrimination, developing competency criteria mitigates bias on promotions outcomes and feedback, designing the workday so people spend more time with others different from them lowers prejudice and increases belonging, and so on. But the $9.4-billion dollar DEI industry didn't get as big as it did by focusing on these evidence-based practices. Change management takes time, money, and coordination, and employers are often leery to take this approach unless forced. Instead, companies opt for one-off initiatives that they can breadcrumb their way toward the bare minimum—interventions that, unfortunately, tend to be either wholly ineffective or activate hostility and resentment that turn the clock back. As a solo practitioner in the late 2010s who was offering precisely the one-time trainings and workshops that were in-demand, this was all overwhelming to me. I knew that in my heart this work was important, but I also wanted my tactics to be effective. If I wasn't actually reducing discrimination, increasing retention, supporting thriving, then I wasn't doing my job properly. If the impact lay in adjacent work—coaching leaders to understand the role they had to play, working alongside HR teams to design standardized processes to mitigate bias, supporting employee resource groups to set better boundaries, designing impact measurement and infrastructure to support long-term behavior change, and so on—then I had to go in those directions. DEI is far from dead, but we can't pretend that the performative pre-backlash status quo was the best we had to offer. As I spoke to Vox in a recent article, this is our moment to double down on our impact, not just good intentions. We can't just aspire to design workplaces that are fair, accessible, inclusive, and representative for all; we have to actually demonstrate success, measurably and tangibly. Anti-DEI activists peddle fear. We beat them with hope—and the proof that we're building a better world for everyone than they could imagine.

Over the course of my career, I’ve learned to be okay with getting things wrong.       Not because it feels good (it doesn’t), but because every mistake creates an opportunity to learn and grow. And because it means someone trusted me enough to tell me when I missed the mark. That kind of honesty feels increasingly rare—especially in a world where AI is telling people exactly what they want to hear and where people increasingly gravitate toward information that confirms their beliefs.      That’s why I think one of the most valuable skills you can cultivate is this: Find people who will give you tough feedback.      Across my time at Microsoft, the Gates Foundation, and Pivotal, the moments that shaped me the most weren’t the wins. They were the times when someone I trusted pulled me aside and gave me feedback I needed to hear. These conversations helped me see what I’d missed and rethink how I was showing up, which made me a better leader. But they only happened because the people around me knew they could be honest, and in fact, I expected them to be. You can’t grow—or help your teams grow—if you act like you’re the only one with all the answers.      I’ve seen this in every place I’ve worked. The leaders who made the biggest impact weren’t the ones who got it right all the time. They were the ones who created the conditions for honesty. Their teams felt free to surface new ideas, ask tough questions, and admit their mistakes. And those leaders were humble enough to hear feedback about themselves—and then take the steps to do things differently.       My advice on how to build this skill? Seek out colleagues and mentors you can trust to give you honest feedback. Ask for it often. Be vulnerable—not defensive—and take the opportunity to understand what you didn’t see before. It will transform the way you learn, lead, and build teams that thrive. #SkillsontheRise 

One skill separates great communicators from average ones: Perspective-taking. The ability to see things from someone else’s point of view. But most people do it wrong. Here’s how to do it right, especially when you’re leading or being led: When you’re the boss, persuading down: You’re trying to convince Maria on your team to do something different. She’s pushing back. Your instinct might be to assert your authority. But that’s a mistake. Here’s why… Research shows: The more powerful you feel, the worse your perspective-taking becomes. More power = less understanding. So if you want to persuade Maria, don’t lean into your title. Do the opposite: dial your power down, just briefly. Try this: Before the next conversation, remind yourself: Maria has power too. I need her buy-in. Maybe she sees something I don’t. Lower your feelings of power to raise your perspective. From that place, ask: → What does she see that I’m missing? → What might be in her way? → What’s a win-win outcome? That shift changes the entire dynamic. Instead of steamrolling, you’re collaborating. And that’s how you earn trust and results. Now flip it. You’re the employee persuading your boss. It’s a high-stakes moment. You’re nervous. So do you appeal to emotion? No. Drop the feelings. Focus on interests. Here’s the key question: “What’s in it for them?” Not how you feel. Not your big dream. → Will it save time? → Improve performance? → Help them hit their goals? Make it about their world, not yours. Why? Because every boss has a mental shortcut: → Does this employee make my life easier or harder? Be the person who brings clarity, ideas, and upside. Not complaints, drama, or friction. In summary: → Persuading down? Dial down your power to see clearer. → Persuading up? Focus on their interests, not your emotions. Perspective-taking is a superpower, if you learn how to use it. Now practice, practice, practice.

Taking the plunge into major changes always brings a sense of unease. Let me elaborate. During my job hunt, especially when targeting my dream companies, I felt this uncertainty acutely. I frequently questioned myself: Am I truly prepared for this career transition? What if I get hired and feel out of place, like I don't belong? What if the job and the environment don't meet my expectations? Acknowledging my fear of change opened my eyes to numerous coping strategies. You just need to convince yourself that while change is daunting, staying stagnant is even more frightening. Here's how: Shift your perspective: Instead of viewing a new job or career path as a plunge into the unknown, see it as an opportunity to gain new skills and experiences. Reflect on your true aspirations: Consider what you genuinely want in the long run and determine if a career or workplace change is essential to achieving that. Identify Your Fears: Understand that fear of the unknown is normal. Take the time to figure out exactly what scares you about the job search – is it the financial uncertainty, the interview process, or the idea of learning new things? Once you pinpoint your fears, you can develop strategies to address them. Embracing change means opening yourself up to more experiences and growth. It might be intimidating, but the fear of looking back with regrets is even more so. Take the leap towards your dream life! (Need job search assistance? https://bit.ly/3SpnYor)

Leveraging this new OpenAI real time translator to phish via phone calls in the target’s preferred language in 3…2… So far, AI has been used for believable translations in phishing emails — E.g. my Icelandic customers are seeing a massive increase in phishing in their language in 2024. Before only 350,000 or so people comfortably spoke Icelandic correctly, now AI can do it for the attacker. We’re going to see this real time translation tool increasingly used to speak in the target’s preferred language during phone call based attacks. These tools are easily integrated into the technology we use to spoof caller ID, place calls, and voice clone. Now, in any language. Educate your team & family + friends. Make sure folks know: - AI can voice clone - AI can real time translate to speak in any language - Caller ID is easily spoofed with or without AI tools - AI tools will increase in believability Example AI voice clone/spoof example here: https://lnkd.in/gPMVDBYC Will this AI be used for good? Sure! Real time translations are quite useful for people, businesses, & travel. We still need to educate folks on how AI is currently use to phish people & how real time AI translations will increase scams across (previous) language barriers. *What can we do to protect folks from attackers using AI to trick?* - Educate first: make sure folks around you know it’s possible for attackers to use AI to voice clone, deepfake video and audio (in real time during calls) - Be politely paranoid: encourage your team and community to use 2 methods of communication to verify someone is who they say they are for sensitive actions like sending money, data, access, etc. For example, if you get a phone call from your nephew saying he needs bail money now, contact him a different way before sending money to confirm it’s an authentic request - Passphrase: consider using a passphrase with your loved ones to verify identity in emergencies (e.g. your sister calls you crying saying she needs $1,500 urgently ask her to say the passphrase you agreed upon together or contact with another communication method before sending money)