talk-data.com

In this meetup, we have Melissa De Korte showcasing some Power Query Magic.

Description: Let's tackle a real head-scratcher together: what to do when standard M functions just don't cut it, especially with the pesky case sensitivity issue in Power Query. If you've ever found yourself wrestling with the need to split data but dreaded the thought of messing up your letter casing to achieve it, this session has got you covered. We will build a custom splitter that tackles case variations with ease. This is for all data heroes out there who are looking to overcome these types of limitations, expanding their toolkit with a shiny new tool and the know-how to wield it. Get ready to level up your data game! About: Melissa de Korte is a passionate problem-solver known for her ability to simplify complex problems with Power Query and M. With an impressive track record as an Enterprise DNA Expert and Fabric Community Super User, Melissa has become an asset to the data community, actively engaging, supporting, and inspiring others. She posts regularly on LinkedIn using the hashtag #pqtodaysmenu and is co-author of "The Definitive Guide to Power Query (M)," a comprehensive resource essential for both beginners and seasoned professionals. Her work demystifies complex concepts and empowers users to harness the full potential of Power Query and the M language. Connect with Melissa: https://www.linkedin.com/in/melissa-de-korte-64585884/ https://www.amazon.com/Definitive-Guide-Power-Query-Transformation/dp/1835089720

YouTube Live link (and the recording) https://youtube.com/live/9OnGSbmxUSY

RSVP to this event to receive the recording and other event communication.

Zoom link to join https://us02web.zoom.us/j/85219206963?pwd=gdIbLAT0qGWceb7jrjYA9cpr5oHAqs.1

See you all there.

From Chaos to Clarity: Pattern Extraction Techniques in Power Query M

Join us as we unravel the mysteries of pattern extraction using Power Query and M. This session is designed to guide you through the maze of unstructured data, equipping you with techniques to spot, extract, and leverage patterns in your data. Whether you're new to the game or looking to polish your skills, we'll walk through each step, turning complex challenges into achievable goals. By the end of our time together, you'll have a new set of tools in your toolkit and the confidence to apply them to real-world scenarios.

Melissa de Korte is a passionate problem-solver known for her ability to simplify complex problems with Power Query and M. With an impressive track record as an Enterprise DNA Expert and Fabric Community Super User, Melissa has become an asset to the data community, actively engaging, supporting, and inspiring others.

She posts regularly on LinkedIn using the hashtag #pqtodaysmenu and is co-author of "The Definitive Guide to Power Query (M)," a comprehensive resource essential for both beginners and seasoned professionals. Her work demystifies complex concepts and empowers users to harness the full potential of Power Query and the M language.

https://www.linkedin.com/in/melissa-de-korte-64585884/

Dive into the comprehensive world of data transformation with "The Definitive Guide to Power Query (M)". This book empowers you with the knowledge and skills necessary to effectively utilize Power Query for complex data transformation tasks. You will develop expertise in practical techniques, advanced M language concepts, and optimization strategies. What this Book will help me do Understand the fundamentals of Power Query and its functionalities. Learn to perform complex data transformations using various Power Query functions. Gain insight into advanced M language structures such as custom functions and nested expressions. Develop skills in error handling and debugging to streamline your data processes. Master performance optimization techniques for efficient data handling with Power Query. Author(s) Gregory Deckler, Rick de Groot, and Melissa de Korte are seasoned professionals in business intelligence and data analytics. With years of experience using Power Query, they bring a wealth of knowledge and practical insight into tackling real-world data problems. Their combined expertise ensures a clear and immersive learning experience for readers, guiding them through fundamental to advanced topics. Who is it for? This book is ideal for business analysts, data professionals, and power users who wish to advance their data transformation capabilities. If you're someone with foundational experience in Power Query looking to become proficient or an industry professional aiming to optimize workflows, this book is tailored to suit your goals.