Marc Lelijveld

Business & Management

Information & Communications Technology

Media & Information

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

Haastrecht, South Holland, Netherlands

Marc Lelijveld

Data Platform MVP | FastTrack Recognized Solution Architect | MS Certified Trainer | Data & Analytics consultant

Data Platform MVP, FastTrack Recognized Solution Architect, Microsoft Certified Trainer, Power BI enthusiastic, public speaker and passionate for everything which transforms data into action! Working at Macaw in the Netherlands as a Data & AI consultant.

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/

Current sessions

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

During MS Build 2022, Microsoft announced Power BI Datamarts, a new artifact in the Power BI ecosystem which should minimize the gab between self-service analyst and central BI teams, or IT if you will. Now, analyst should be able to get their ad-hoc analytics experience started, just from the Power BI Service.

But what exactly are Power BI Datamarts are, and how to position them next to Power BI dataflows and datasets or even in your end-to-end data estate. Where to get started with Datamarts?

During this session, I will walk you through Power BI Datamarts and show them in practice, so that after the session, you can start taking advantage of them yourself directly!

After this session, you will be able to:
- You will be able to explain what Datamarts are, and how they are different than dataflows and Datasets.
- You know when you can consider to use Datamarts, and where your central data platform is still required.
- You know how and where to get started with your first hands-on experience with Power BI Datamarts.


Power BI processing patterns

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.

After this session you will be able to;
- Configure incremental refresh.
- Refresh individual tables in a published Power BI model.
- Orchestrate your Power BI refresh end to end.


Data modeling for experts with Power BI

Have you been working with Power BI for a while? Then it is time to take the next step with your data modeling skills!

You might have heard about Power BI composite models. But in order to implement them successfully, it is important to understand the different storage modes that Power BI has. This is key for a successful implementation and also understand the possible dangers of the storage mode behaviors.

More over, let's also talk Calculation groups! You might have been creating numerous calculations in the past for year to date, quarter to date and many other common patterns. With Calculation Groups you can limit the number of redundant measures by creating a common expression parts in a group, that can be applied on top of multiple measures.

And finally, we will combine the two together. Dealing with calculation groups in composite models. Cause there are some key-elements you have to keep in mind. Potentially this combination can lead to wrong results, if you do not understand the behavior of the remote and local engine and with that dealing with wholesale and non-wholesale queries.

During this demo-rich session I will take you on a tour through all above mentioned features and cases, and explain them one by one. So that after this session you will be able to;
- 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


Analytics at scale with Power BI and Azure Synapse Analytics

For Power BI solutions, we see it can be challenging to load data from APIs, or to store historical snapshots. This is where you can really benefit from the capabillities of a data platform. Also, if you already have an amazing data platform, we see it can be challenging to load all of its data into a Power BI dataset and still have a performant solution, or to refresh data in near real-time. Finally, daisy-chaining all the steps in the data flow – from source to report/dashboard – can be tricky to design, especially if you don’t want to do a full refresh of the Power BI dataset for performance reasons.

The advanced capabilties of both worlds can really complement eachother. Learn how to design and build a truly scalable solution that spans both Power BI and Azure Synapse Analytics. We will help you to get the best out of both worlds, sharing our learnings and best-practices along the way in a demo-rich session!

After the session you will be able to:
• Better design and implement complex data models, including hybrid tables, aggregations, and combined storage modes (import, DirectQuery, dual).
• Orchestrate the end-to-end data processing, with a pipeline chain from data ingest in the data lakehouse to the incremental Power BI dataset refresh.
• Use different techniques to identify performance bottlenecks in your solutions and how to solve those ("does it fold"?).
• Implement a cost-efficient solution, that still meets the scalability demands.


Responsiveness and mobile ready reporting

Over time, we build tons of reports. But only in a very few cases, there is decent time spend on responsiveness and mobile readiness of reports. Have you even tried how your report looks on a smartphone?

During this session I will walk you through the do's and don'ts of mobile reporting, where you should care about and how to optimize the mobile experience!


Application Lifecycle Management for Power BI

In Power BI we are used to create reports and dashboards really quickly, but in most cases we forget to think about governance, development and maintenance at an enterprise wide scale.
During this session I share some best practices about applying DTAP (Development, Test, Acceptance and Production), or better known as multi-tier deployment.

During this session I will tell you all about Power BI deployment pipelines and how this helps in setting up Application Lifecycle Management for Power BI content. The session will not only cover deployment pipelines in the Power BI service, but also how you can integrate them with Azure DevOps and bind to other processes.

After this session you will be able to:
- Understand the importance of Application Lifecycle Management
- Know how to setup and use Power BI Deployment Pipelines
- Integrate deployment pipelines in Azure DevOps


Data modeling 101: Understanding the basics of a good data model

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? During this session we will lift of from basic level and build up in complexity to understand the key element of a good data model! Everything presented in this session will include real-life examples and can be directly brought to practice.

After this session 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.


Advanced data modeling with Power BI

Got the basics in place and building a decent well performing data model in Power BI is a piece of cake for you? Time to take the next step!
During this session we will build up complexity and start integrating more advanced patterns in Power BI data models, covering topics like working with aggregations, composite models and more!

After this you will be able to:
- Leverage one and bi-directional relationships
- Overcome and handle ambiguous data models
- Successfully implement aggregations
- Work with real live scenarios containing multiple fact tables


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.


Enable the business and make Artificial Intelligence accessible for everyone!

Microsoft is doing a great job in enabling every user to apply Artificial intelligence in his or her daily business by implementing AI functionality in Power BI, Microsoft's end-user BI and analytics tool. Finding insights from the data can be challenging with the massive volumes of data generated today. This is where AI can help to automatically find patterns, help users understand what the data means, and predict future outcomes. But most important of all, enabling the business to make data driven decisions!

In this session I will tell you all about the AI capabilities which Microsoft offers within Power BI and made available for each and every user within the organization. I'll show you how business users will be able to work with this, without writing a line of code. A session with an overview of AI and a bunch of live demos on how you can implement AI to your daily business. Even a lot of features which are there for a while, but a lot of people don’t know about.

In this session:
- Power BI Dataflows
- Azure Cognitive Services
- Key Influencer visual
- Decomposition Tree visual
- Q&A visuals


External tools for Power BI, how to create them!

Power BI offers an add-in to work with 3rd party external tools like Tabular Editor, DAX Studio and ALM toolkit. The fact that you can use a tool of your own preference is already really cool! But did you know that you can build external tools yourself pretty easy? Even as a non-developer like I am, you can build an External Tool for Power BI!

After this session you:
- Know different External Tools for Power BI, and how you could use them
- Understand what is needed to build your own External Tool
- Know where to get started building your own External Tool

Power BI offers an add-in to work with 3rd party external tools like Tabular Editor, DAX Studio and ALM toolkit. The fact that you can use a tool of your own preference is already really cool! But did you know that you can build external tools yourself pretty easy? Even as a non-developer like I am, you can build an External Tool for Power BI!

After this session you:
- Know different External Tools for Power BI, and how you could use them
- Understand what is needed to build your own External Tool
- Know where to get started building your own External Tool


Past and future events

Techorama Netherlands 2022

10 Oct 2022 - 12 Oct 2022
Utrecht, Netherlands

dataMinds Connect 2022

10 Oct 2022 - 11 Oct 2022
Mechelen, Flanders, Belgium

Power BI Next Step

19 Sep 2022 - 20 Sep 2022
Billund, South Denmark, Denmark

DATA:Scotland 2022

1 Sep 2022 - 2 Sep 2022
Glasgow, Scotland, 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?"
15 Jun 2022
Hoofddorp, North Holland, Netherlands

DataGrillen 2022

2 Jun 2022 - 3 Jun 2022
Lingen, Lower Saxony, Germany

Techorama 2022 BE

23 May 2022 - 25 May 2022
Antwerpen, Flanders, Belgium

Data Saturday Stockholm 2022

21 May 2022
Stockholm, Sweden

Power BI Gebruikersdag 2022

31 Mar 2022 - 2 Apr 2022
Utrecht, Netherlands

SQLBits

8 Mar 2022 - 12 Mar 2022
London, England, United Kingdom

Power BI Summit 2022

7 Mar 2022 - 11 Mar 2022

Power BI Fest

20 Nov 2021

PowerPlatform French Summit (2021)

18 Nov 2021 - 19 Nov 2021

#DataWeekender v4.2

6 Nov 2021

Power BI Next Step 2021

17 Sep 2021
Copenhagen, Capital Region, Denmark

Techorama 2021 Spring Edition

17 May 2021 - 19 May 2021
Antwerpen, Flanders, Belgium

Power BI Summit

19 Apr 2021 - 24 Apr 2021

dataMinds Saturday

13 Mar 2021

Virtual Scottish Summit 2021

22 Feb 2021 - 27 Feb 2021

Global Power Platform Bootcamp - 2021

19 Feb 2021 - 20 Feb 2021

Global Power Platform Bootcamp 2021 - Italy

19 Feb 2021

PowerPlatform French Summit (2020)

19 Nov 2020 - 20 Nov 2020

#DataWeekender #TheSQL

17 Oct 2020

LightUp

14 Jul 2020 - 15 Jul 2020

Power Saturday 2020

6 Jun 2020
Paris, Île-de-France, France

Power BI Gebruikersdag 2020 (CANCELLED)

26 Mar 2020 - 28 Mar 2020
Utrecht, Netherlands

Scottish Summit

29 Feb 2020
Glasgow, Scotland, United Kingdom

Power Platform Bootcamp Brussels 2020

15 Feb 2020
Brussels, Brussels Capital, Belgium

Power BI Days Belgium 2020-01

25 Jan 2020
Kontich, Flanders, Belgium

DATA:Scotland 2019

13 Sep 2019
Glasgow, Scotland, United Kingdom

DataGrillen 2019

20 Jun 2019 - 21 Jun 2019
Lingen, Lower Saxony, Germany

Power Saturday 2019

14 Jun 2019 - 15 Jun 2019
Paris, Île-de-France, France

Power BI Days Belgium 2019-04

13 Apr 2019
Mechelen, Flanders, Belgium

Power BI Gebruikersdag 2019

30 Mar 2019
Utrecht, 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.
27 Mar 2019 - 29 Mar 2019
Amsterdam, North Holland, 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.
27 Mar 2019 - 29 Mar 2019
Amsterdam, North Holland, Netherlands

Power BI Days 2019-01

26 Jan 2019 - 27 Jan 2019
Mechelen, Flanders, 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.
11 Sep 2018 - 12 Sep 2018
Copenhagen, Capital Region, Denmark

Power BI Gebruikersdag

24 Mar 2018
Utrecht, Netherlands