Search – talk-data.com

Title & Speakers	Event
In-Person only - Next Level Power Query & DAX \| Michiel Rozema & Henk Vlootman 2023-10-18 · 17:00 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!	In-Person only - Next Level Power Query & DAX \| Michiel Rozema & Henk Vlootman

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!

Activities & events