Most Active Speaker

Marc Lelijveld

Marc Lelijveld

Data Platform MVP | Technical Evangelist | Solution Architect Data Solutions & Insights

Haastrecht, The Netherlands

Data Platform MVP, Power BI and Fabric enthusiastic, public speaker and passionate for everything which transforms data into action! Working at Macaw in the Netherlands as Solution Architect and Technical Evangelist in the Data Solutions & Insights team.

What I like the most? Sharing my thoughts, experience, best-practices and enthusiasm about Microsoft data platform with others. I mostly do this in public speaking at usergroups, conferences, customer presentations and end-user training. Besides that I also have my own blog which you can find at https://data-marc.com/

Awards

Area of Expertise

  • Business & Management
  • Information & Communications Technology
  • Media & Information

Topics

  • power bi
  • Analytics and Big Data
  • Microsoft Data Platform
  • Microsoft Power platform
  • Data Modeling
  • Power Platform

Professionalizing your solution using Power BI Project Files and Git integration

Are you still storing and deploying your Power BI solutions as a whole in a binary, just in a pbix file? We all have to admit that we have that solution called "Power BI Solution v2_final.pbix and after that we create the final-final or the real-final version.

You might have a hard time checking which changes were made when, by whom if you work with multiple developers on the same solution and not even talking about your versioning strategy?

During this session we will deep dive into the new Power BI Project Files and how they can help you bringing your solutions to another level! We will explore the new meta data structure, how you can use different tools to develop your solution. All the way from text editors to Power BI Desktop, the Power BI Service and back! Also, we will deep-dive into properly versioning and deploying your solutions by taking full advantage of the workspace Git integration.

After this session you will be able to:
- Use and explain the advantage of Power BI Project Files
- Adjust your solution in the tool of your choice
- Setting up workspace Git integration
- Co-developing solutions with multiple people
- Restoring older versions of your solution

Visual Calculations: Making DAX easier

This is it. The day that the way that DAX became easier. After this, how you write DAX changes forever. Learn all about it in this session! The Power BI team has been working on exciting things related to DAX calculations, specifically targeted at making it easier to add typical business-type calculations (such as running totals or vs-first). Would you believe it if we told you that you don’t even have to type DAX anymore and still be able to get complex calculations done quickly? In this session, we will dive deep into visual calculations, covering everything there is to know about them including the lower level window functions.

Get ready to get your mind blown! See the future, today.

After this session you are an expert on visual calculations and ready to tackle any challenging calculation that comes your way!

Extending Power BI governance with Microsoft Purview

In this deep dive session, we will explore how Power BI and Microsoft Purview can work together to provide a comprehensive data governance and analytics solution. We will start by discussing the key features of each platform and how they complement each other, but also make sure where they differ from each other

Next, we will dive into real-world examples of how Power BI and Purview can be used together to gain insights from data. This will include using Purview to discover, classify, and catalog data sources. But before you can scan your Power BI tenant, we will learn you how to setup these scans within your tenant but also in a cross-tenant situation.

We will also discuss best practices and the do's and don'ts for integrating Power BI and Purview into your organization's data governance strategy, including considerations for data security and compliance.

You will learn how you can extend your Power BI Lineage with Lineage from your sources with the help of Purview.

By the end of this session, you will have a clear understanding of how Power BI and Purview can be used together to drive data-driven decision making in your organization.

Improvements to doing calculations in Power BI

For the last 1.5 years, the Power BI team has been working on exciting things related to DAX calculations, specifically targeted at making it easier to add typical business-type calculations (such as running totals or vs-first).
Would you believe it if we told you that you don’t even have to type DAX anymore and still be able to get complex calculations done quickly? In this session, we will talk about this exciting development. This is brand new and exciting!

Join this session to learn more about this new feature which will writing DAX statements so much easier and faster and get ready to get your mind blown!

A deep dive into Direct Lake

The new Direct Lake storage mode in Power BI promises to revolutionize data handling by blending the real-time nature of DirectQuery and the high performance of Import mode. Is this all just hype, or does Direct Lake truly deliver on these claims?

In this session, we will put Direct Lake under the microscope, conducting comprehensive performance testing across varied data sets and query types. We aim to stress test Direct Lake, uncovering where it meets expectations, where it excels, and where it has room for improvement.

The key areas we'll explore are:

• Direct Lake: Understanding what we know about the engine
• Analyzing performance across different scenarios
• Strengths and weaknesses
• Advice for data modelling for Direct Lake

By the end of this session, you'll have a well-rounded understanding of Direct Lake's capabilities, potential for your Power BI data modelling projects.

Query Performance Insights for Power BI datasets in Fabric

If you have shared your Power BI dataset with others in your organization for self-service analytics, you may be interested in understanding what queries they are using, as well as the performance and impact of these queries on the dataset and overall system capacity and health.

Even more interesting, with the concepts of Microsoft Fabric, where data is loaded on demand, it is more important to know which data you want to keep in active memory and keep warm, rather than what gets evicted from the system.

During this session, we will explore Azure Log Analytics integration on Power BI datasets to measure engine performance, query logging and other telemetry to gain deeper insights for further optimization of your Power BI datasets.

After this session you will be able to:
- Understand how to measure query performance
- Analyze which columns and tables are being used
- Know how to configure Log Analytics on your datasets
- Be able to setup a system to keep your data for direct lake datasets warm and in memory.

During this session you will find out how to measure query performance for Power BI datasets. As a next step we will delve into Direct Lake storage mode for Fabric to understand how data gets evicted from the system and how you can keep the data warm for optimal performance. In order to do this, we will explore Log Analytics integration on Power BI.

Unified Governance in Microsoft Fabric

With Microsoft Fabric, a new era has started in which more users will have all kinds of data workloads at their disposal. A vast variety of workloads like data ingestion, engineering all the way to modeling, visualizing and distribution of these artifacts all in one unified SaaS platform.

Coming from a Power BI world, various aspects like workspaces might be familiar to the Fabric experience. But with the growing ask for data tools and the introduction of Microsoft Fabric, governance on your platform has never been more important.

During this session we will explore a unified governance setup across all your analytics tools in Microsoft Fabric. Topics like data-mesh and domain structures, tenant configurations, lineage and above all compliancy and auditability will be discussed.

After this session, you will be able to
- Make the right considerations when it comes to governance structure in Microsoft Fabric
- Configure data-mesh patterns in Microsoft Fabric
- Have a comprehensive overview of your Fabric artifacts and how they relate
- Use out of the box functionality to monitor and audit your Fabric tenant

Successfully collaborate with externals in Power BI

Do you know where to start if you want to share Power BI artefacts like reports, dashboards or even datasets with external people not from your company? Or maybe even want to setup B2B collaboration by sharing datasets and co-author solutions?

During this session, Marc will cover all things sharing, tenant settings, the new cross-tenant dataset sharing feature and further B2B collaboration with Power BI. We will help you to get started with what questions you need to answer before starting and how to set it up so that everything works.

We will tell you all about it and make sure you will be well equipped after this session to get your external collaboration started. Also, we will provide you with a decision tree which will help you even after this session to know what approach to use.

Level-up your Power BI data modeling skills

After a successful webinar series on Data Modeling with Power BI, all webinar content is now packed together in a full day precon. The day will be in three sections, where we kick-off with the basics of data modeling. Then we continue with more advanced patterns to finish the day with expert level modeling by using all advanced features and techniques.

So, what is a good data model in Power BI? How do you make sure you have the basics in place so the model you build today, will still work next year? We talk about different modeling concepts, whether to use the data model or Power Query for transformations, the differences in calculated columns and DAX with their effects on your model and handling role-playing dimensions.

After the basics, it is time to level-up by considering more complex patterns like different types of relationships, overcoming ambiguity, and successfully implementing aggregations. Also, different types of storages modes come into play. Dealing with DirectQuery and Imported (cached) data in the same model on table level with user defined aggregations, but also hybrid tables with different storage modes in the same table. Of course, we will talk about composite models with Power BI datasets and/or (Azure) Analysis Services.

To top-off this day full of real-life examples, we will talk about calculation groups and their behavior in composite models. We make sure you finish the day with a list full of tips and tricks that can be directly brought to practice directly.

After this precon you will be able to:
- Explain basic dimensional modeling concepts
- Create a well working and performing data model in Power BI
- Decide when to use Power Query vs the data model
- Decide when to use Calculated columns or measures
- Handle complex situations with inactive relationships and role-playing dimensions.
- Leverage one and bi-directional relationships
- Overcome and handle ambiguous data models
- Successfully implement aggregations
- Work with real live scenarios containing multiple fact tables
- Understand and explain different types of storage modes in Power BI
- Combine DirectQuery and import storage modes in a composite model
- Successfully implement calculation groups
- Understand calculation groups in composite models and their behavior

This precon is a comprehensive training session on data modeling in Power BI, covering both basic and advanced topics. The session is divided into three sections, starting with the fundamentals of data modeling before moving onto more advanced patterns and finishing with expert-level modeling using all advanced features and techniques.

The first section covers the basics of data modeling, discussing various modeling concepts and techniques, including whether to use the data model or Power Query for transformations, calculated columns and DAX, and handling role-playing dimensions. Participants will learn how to create a well-working and performing data model in Power BI and understand the basic dimensional modeling concepts.

The second section focuses on more advanced topics, including different types of relationships, overcoming ambiguity, and successfully implementing aggregations. Participants will also learn about different types of storage modes, including DirectQuery and Imported (cached) data, and how to handle them in the same model, as well as composite models with Power BI datasets and/or (Azure) Analysis Services.

The final section covers expert-level modeling by discussing calculation groups and their behavior in composite models. The session provides real-life examples, giving participants a list of tips and tricks that can be applied directly to their work.

Upon completion of this precon, participants will be able to understand and explain different modeling concepts, decide when to use Power Query vs. the data model, and when to use calculated columns or measures. They will also be able to handle complex situations with inactive relationships and role-playing dimensions, leverage one and bi-directional relationships, and overcome ambiguous data models. Additionally, participants will learn how to work with real-life scenarios containing multiple fact tables, understand and explain different types of storage modes in Power BI, and successfully implement calculation groups in composite models.

Power BI refreshes - reinvented!

Have you always been scheduling your Power BI refresh in the service? Struggling to get your data available in your model in a short amount of time? Then this session is for you!

During this session, you will learn advanced patterns to optimally configure and refresh your Power BI data models in the service. We will not only discuss incremental refresh, but also how you can get your data available in your model in (near) real time.

We will discuss various patterns from high frequency refresh operations, single table or partition refreshes, detecting data changes in archived partitions and more advanced patters.

After this session you will be able to;
- Configure incremental refresh.
- Refresh individual tables and partitions in a published Power BI model.
- Connect your Power BI refresh to other processes and orchestrate centrally end-to-end.

End-to-end monitoring for a successful Power BI implementation

Implementing Power BI in your organisation is more then allowing people to download Power BI desktop and publish reports to the Power BI Service. People have to be aware of what Power BI is able to achieve for them! But how do you know who is creating what? Using what? Or maybe even more important, sharing (confidential) information with others?

With a Power BI end-to-end monitor you will be able to monitor all Power BI content allover your tenant. These actionable insights will help you to see who needs some extra help, but also in governing your data solutions within your organisation.

In this session I will show you which insights you will get with an end-to-end monitor and how you can monitor your own Power BI environment.

In this session:
- Logic Apps
- Azure Monitor / Azure Log Analytics
- API Registrations and API Connections
- Power BI REST API
- Power BI

This session includes some Azure components to collect data. Session is useful for people working at/for larger organisations.

Overcoming the Fear: Exploring Microsoft Fabric from a Power BI Angle

Discover the potential of Microsoft Fabric as it connects Power BI and Data Engineering, merging these domains into a unified landscape. This groundbreaking development may ignite your curiosity to explore new frontiers, even though the unfamiliar elements and tasks might seem daunting. Are you unsure about learning new skills such as Python, data integration pipelines, and Spark notebooks? Perhaps the thought of these technologies and coding languages is a bit intimidating because you've never used them before?

If you find yourself nodding along, then this session is perfect for you! Join us as we explore Microsoft Fabric from a Power BI perspective. We'll dive into the familiar components we already love, discussing the complete process from ingesting data to serving it to your end users. And the best part? Together, we'll build a solution using the full capabilities of Microsoft Fabric.

By the end of this session, you'll feel confident and ready to create your own solutions with Microsoft Fabric. It opens up exciting possibilities to expand your skills and venture into the fascinating world of data from various angles.

Discover the potential of Microsoft Fabric, bridging Power BI and Data Engineering for a unified landscape. Overcome initial apprehension about new technologies and coding languages, as this session provides a beginner-friendly exploration. From data ingestion to serving end users, we'll navigate familiar components and build a solution together, unlocking exciting possibilities and boosting your confidence in Microsoft Fabric.

Power BI Cruise Sessionize Event Upcoming

June 2024 Stockholm, Sweden

Data Point Prague Sessionize Event Upcoming

May 2024 Prague, Czechia

Power BI Gebruikersdag 2024 Sessionize Event

March 2024 Utrecht, The Netherlands

Data Saturday München 2024 Sessionize Event

February 2024 Munich, Germany

Fabric February 2024 Sessionize Event

February 2024 Oslo, Norway

Data Community Austria Day 2024 Sessionize Event

January 2024 Vienna, Austria

dataMinds Connect 2023 Sessionize Event

October 2023 Mechelen, Belgium

Data Saturday Holland 2023 Sessionize Event

October 2023 Utrecht, The Netherlands

Power BI Next Step 2023 Sessionize Event

September 2023 Copenhagen, Denmark

SQL Konferenz 2023 Sessionize Event

September 2023 Hanau am Main, Germany

DATA:Scotland 2023 Sessionize Event

September 2023 Edinburgh, United Kingdom

Data Saturday Rheinland 2023 Sessionize Event

June 2023 Sankt Augustin, Germany

Techorama 2023 Belgium Sessionize Event

May 2023 Antwerpen, Belgium

SQLBits 2023 - General Sessions Sessionize Event

March 2023 Newport, United Kingdom

SQLBits 2023 - Full day training sessions Sessionize Event

March 2023 Newport, United Kingdom

Power BI Gebruikersdag 2023 Sessionize Event

March 2023 Utrecht, The Netherlands

Power BI Summit 2023 Sessionize Event

March 2023

dataMinds Connect 2022 Sessionize Event

October 2022 Mechelen, Belgium

Techorama Netherlands 2022 Sessionize Event

October 2022 Utrecht, The Netherlands

Power BI Next Step 2022 Sessionize Event

September 2022 Billund, Denmark

DATA:Scotland 2022 Sessionize Event

September 2022 Glasgow, United Kingdom

Dutch Power BI Usergroup - Power BI Datamarts - what is it and how do I benefit from it?

For the Dutch Power BI usergroup, I presented my all new session "Power BI Datamarts - what is it and how do I benefit from it?"

June 2022 Hoofddorp, The Netherlands

Scottish Summit 2022 Sessionize Event

June 2022 Glasgow, United Kingdom

DataGrillen 2022 Sessionize Event

June 2022 Lingen, Germany

Techorama 2022 BE Sessionize Event

May 2022 Antwerpen, Belgium

Data Saturday Stockholm 2022 Sessionize Event

May 2022 Stockholm, Sweden

Power BI Gebruikersdag 2022 Sessionize Event

March 2022 Utrecht, The Netherlands

SQLBits 2022 Sessionize Event

March 2022 London, United Kingdom

Power BI Summit 2022 Sessionize Event

March 2022

Power BI Fest Sessionize Event

November 2021

PowerPlatform French Summit (2021) Sessionize Event

November 2021

#DataWeekender v4.2 Sessionize Event

November 2021

Power BI Next Step 2021 Sessionize Event

September 2021 Copenhagen, Denmark

Techorama 2021 Spring Edition Sessionize Event

May 2021 Antwerpen, Belgium

Power BI Summit Sessionize Event

April 2021

dataMinds Saturday Sessionize Event

March 2021

Virtual Scottish Summit 2021 Sessionize Event

February 2021

Global Power Platform Bootcamp 2021 - Italy Sessionize Event

February 2021

Global Power Platform Bootcamp - 2021 Sessionize Event

February 2021

PowerPlatform French Summit (2020) Sessionize Event

November 2020

#DataWeekender #TheSQL Sessionize Event

October 2020

LightUp Sessionize Event

July 2020

Power Saturday 2020 Sessionize Event

June 2020 Paris, France

Power BI Gebruikersdag 2020 (CANCELLED) Sessionize Event

March 2020 Utrecht, The Netherlands

Scottish Summit Sessionize Event

February 2020 Glasgow, United Kingdom

Power Platform Bootcamp Brussels 2020 Sessionize Event

February 2020 Brussels, Belgium

Power BI Days Belgium 2020-01 Sessionize Event

January 2020 Kontich, Belgium

DATA:Scotland 2019 Sessionize Event

September 2019 Glasgow, United Kingdom

DataGrillen 2019 Sessionize Event

June 2019 Lingen, Germany

Power Saturday 2019 Sessionize Event

June 2019 Paris, France

Power BI Days Belgium 2019-04 Sessionize Event

April 2019 Mechelen, Belgium

Power BI Gebruikersdag 2019 Sessionize Event

March 2019 Utrecht, The Netherlands

Power Platform Summit - Storytelling & interactive reports with Power BI Bookmarks & Drillthrough

Power Platform Summit Europe delivers the can’t-miss annual conference for users of the Microsoft Power platform – featuring education on all versions of Power BI, PowerApps, and Microsoft Flow. With credible peer-to-peer knowledge exchange at its core, this event provides focused learning and networking as users gain instrumental solutions for their everyday system challenges and larger organisational goals. In every industry and across the globe, Summit is well known as a premier user-centric experience.

March 2019 Amsterdam, The Netherlands

Power Platform Summit - End-to-end monitoring for a successful Power BI implementation

Power Platform Summit Europe delivers the can’t-miss annual conference for users of the Microsoft Power platform – featuring education on all versions of Power BI, PowerApps, and Microsoft Flow. With credible peer-to-peer knowledge exchange at its core, this event provides focused learning and networking as users gain instrumental solutions for their everyday system challenges and larger organisational goals. In every industry and across the globe, Summit is well known as a premier user-centric experience.

March 2019 Amsterdam, The Netherlands

Power BI Days 2019-01 Sessionize Event

January 2019 Mechelen, Belgium

Power BI World Tour

Presented at the Power BI World Tour in Copenhagen for an audience of 159 people about Storytelling and interactive reports in Power BI. I co-presented with one of the Microsoft Power BI Program managers.

September 2018 Copenhagen, Denmark

Power BI Gebruikersdag Sessionize Event

March 2018 Utrecht, The Netherlands

Marc Lelijveld

Data Platform MVP | Technical Evangelist | Solution Architect Data Solutions & Insights

Haastrecht, The Netherlands