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 | Data & AI consultant

Data Platform MVP, FastTrack Recognized Solution Architect, 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

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


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!


Enterprise and multi-tier Power BI deployments with Azure DevOps.

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, Production, Acceptance and Production), or better known as multi-tier deployment.

By using Azure DevOps for deployment we bring back the structure and use a self-service tool in an enterprise environment. Beside deployment there is also version control and enterprise roll-out of your content in a managed structure.

In this session:
- Azure DevOps
- PowerShell
- Power BI REST API

Technical session for enterprise deployments of Power BI. Basic understanding of Azure DevOps and deployment frameworks is useful but not required.


Storytelling & interactive reports with Power BI Bookmarks & Drillthrough

How to make sure that the end-user of your Power BI report understands the information well? There is way more involved in presenting your data then only a chart. Think about interaction, presenting the right information at the right time and much more!

By using Story telling it is possible to tell the story behind the data. Where does the information need come from and how did we get to an answer? The complete storyline covered in your reports and dashboards to make sure the data is interpreted in the right way by the users.

During this session I well tell more about the principles of story telling. Beside of that this session will be covered with lots of Power BI demos. During these demos I will give examples of functionality within Power BI which can be used to create your own story in Power BI. I will not only show the end result, but also how to create a report or dashboard like that to tell your own story!

In this session:
- Bookmarks
- Buttons
- Sync Slicers
- Drillthrough


Power BI Cheat Sheet explained!

This session explains the Power BI Cheat Sheet that went viral on social media. The sheet is crammed with Power BI tips and best practices based on years of experience, but with little to no comments. No worries! We will describe, demonstrate and discuss all the items! And of course, there will be a Cheat Sheet for everyone attending!


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.


Use parameters to add extra flexibility to your Power BI content

You're probably applying a lot of steps over and over again every time you create your Power BI report. A waste of time! Apply parameters on the back-end in Power Query, but also in the front-end in your report to make your solutions much more flexible.

This session will give you examples on where you can use parameters in Power BI and which advantages this will have for you.

In this session:
- Power BI desktop
- Power Query
- DAX
- Power BI Service
- What IF Scenarios
- PowerShell Cmdlets for Power BI
- Power BI API
(optional items depending on time and audience)


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


Drive a data culture in your organization

How to enable your organization to become data driven? Drive a data culture within your organization! This session is all about why a data culture matters, how you can setup it up and how you can keep supporting the organization in driving the data culture!

How to enable your organization to become data driven? Drive a data culture within your organization! This session is all about why a data culture matters, how you can setup it up and how you can keep supporting the organization in driving the data culture!


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!

In this session I will show you how I build my model documentation external tool and how you can start doing this yourself!

After this session you:
- will understand why documenting your Power BI solutions is important
- know how I build the model documenter
- understand what is needed to build your own external tool
- will document every solution from now on

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!

In this session I will show you how I build my model documentation external tool and how you can start doing this yourself!

After this session you:
- will understand why documenting your Power BI solutions is important
- know how I build the model documenter
- understand what is needed to build your own external tool
- will document every solution from now on


Past and future events

Power BI Gebruikersdag 2020 (verplaatst naar 2022)

30 Mar - 1 Apr 2022
Utrecht, Netherlands

Power BI Next Step 2021

16 Sep 2021
Copenhagen, Capital Region, Denmark

Techorama 2021 Spring Edition

16 May - 18 May 2021
Antwerpen, Flanders, Belgium

Power BI Summit

18 Apr - 23 Apr 2021

dataMinds Saturday

12 Mar 2021

Virtual Scottish Summit 2021

22 Feb - 27 Feb 2021

Global Power Platform Bootcamp - 2021

19 Feb - 20 Feb 2021

Global Power Platform Bootcamp 2021 - Italy

18 Feb 2021

PowerPlatform French Summit (2020)

18 Nov - 19 Nov 2020

#DataWeekender #TheSQL

16 Oct 2020

LightUp

14 Jul - 15 Jul 2020

Power Saturday 2020

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

Scottish Summit

29 Feb 2020
Glasgow, Scotland, United Kingdom

Power Platform Bootcamp Brussels 2020

14 Feb 2020
Brussels, Brussels Capital, Belgium

Power BI Days Belgium 2020-01

24 Jan 2020
Kontich, Flanders, Belgium

DATA:Scotland 2019

12 Sep 2019
Glasgow, Scotland, United Kingdom

DataGrillen 2019

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

Power Saturday 2019

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

Power BI Days Belgium 2019-04

12 Apr 2019
Mechelen, Flanders, Belgium

Power BI Gebruikersdag 2019

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

Power BI Days 2019-01

25 Jan - 26 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 - 12 Sep 2018
Copenhagen, Capital Region, Denmark

Power BI Gebruikersdag

23 Mar 2018
Utrecht, Netherlands