talk-data.com

In this presentation, Michiel Rozema and Henk Vlootman will be presenting on Next Level Power Query & DAX.

This meetup is in-person only and is not recorded.

What to expect Power Query and the Power BI model, or Power Pivot in Excel, give you powerful possibilities to turn your data into valuable insights. These tools offer a visual way to build analytic solutions, which makes it easy to get started and quickly achieve powerful results. But it doesn’t end there: with a bit of coding, you have even more power in your hands.

In this session, we discuss two examples of techniques that go beyond what the UI allows you to do. First, we discuss custom functions in Power Query, for which we need to dive into the M language. The second example is the use of the new WINDOW family of functions in DAX. We demonstrate both with a single application: analysing box office results for popular movies.

Location: This event is to be held in Meeting Room 3, Canada Water Library, 21 Surrey Quays Rd, London SE16 7AR.

Timings: 17:30 Arrive anytime to meet, network, chat, work. 18:15 Presentation begins 19:45 Pub for more casual conversation over some drinks

Who are they?

Michiel Rozema is one of the top Power BI and DAX experts in the world. Working as Data Insight Lead for Microsoft in The Netherlands for 8 years, he was responsible for the Microsoft Data & Analytics business, and launched Power Pivot for Excel and Power BI in The Netherlands. Michiel was awarded the Microsoft Most Valuable Professional (MVP) award since 2019.

Since 1992 is Henk Vlootman a global-wide senior Power BI & Excel business consultant. Since 2013 Henk received the Microsoft Most Valued Professional (MVP) award, for his outstanding expertise and community leadership.

In 2018, Michiel and Henk founded Quanto, Collective Analytics. Quanto specializes in implementing Power BI solutions in medium and large organizations. Michiel and Henk are the authors of several Power Pivot and Power BI books. Since January 2022 “Extreme DAX” (Pack publishing) is available at Amazon.com. Both are regular speakers at Power BI conferences across the world.

See you on the Wed, 18th Oct for this exciting event.

Never stop learning!

Delve into advanced Data Analysis Expressions (DAX) concepts and Power BI capabilities with Extreme DAX, designed to elevate your skills in Microsoft's Business Intelligence tools. This book guides you through solving intricate business problems, improving your reporting, and leveraging data modeling principles to their fullest potential. What this Book will help me do Master advanced DAX functions and leverage their full potential in data analysis. Develop a solid understanding of context and filtering within Power BI models. Employ strategies for dynamic visualizations and secure data access via row-level security. Apply financial DAX functions for precise investment evaluations and forecasts. Utilize alternative calendars and advanced time-intelligence for comprehensive temporal analyses. Author(s) Michiel Rozema and Henk Vlootman bring decades of deep experience in data analytics and business intelligence to your learning journey. Both authors are seasoned practitioners in using DAX and Microsoft BI tools, with numerous practical deployments of their expertise in business solutions. Their approachable writing reflects their teaching style, ensuring you can easily grasp even challenging concepts. This book combines their comprehensive technical knowledge with real-world, hands-on examples, offering an invaluable resource for refining your skills. Who is it for? This book is perfect for intermediate to advanced analysts who have a foundational knowledge of DAX and Power BI and wish to deepen their expertise. If you are striving to improve performance and accuracy in your reports or aiming to handle advanced modeling scenarios, this book is for you. Prior experience with DAX, Power BI, or equivalent analytical tools is recommended to maximize the benefit. Whether you're a business analyst, data professional, or enthusiast, this book will elevate your analytical capabilities to new heights.