Marc Lelijveld
Data Platform MVP | Technical Evangelist | Solution Architect Data Solutions & Insights
Haastrecht, The Netherlands
Actions
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/
Links
Awards
Area of Expertise
Topics
Exploring Fabric Semantic Link for Power BI folks!
If you're coming from a Power BI world, the whole Fabric thing might scare you a bit. Then suddenly, there is something called Semantic Link, which allows connections from Fabric Notebooks to read both data and meta data from your Power BI Semantic Model (dataset).
You might wonder, what's all this? How does it work and how to take benefit from it? Especially when you're not familiar yet with notebooks at all.
In this session we will explore what Semantic Link is, how you as Power BI developer/engineer can make use of it and how it will strengthen your solutions in the end. Together, we will explore various aspects like:
- Warming up your data in direct lake datasets
- Querying Dynamic Management Views,
- Reading Semantic Model meta data to generate documentation
- Extend or even forecast your data using Semantic Link
By the end of this session, you will not only grasp the basics of Semantic Link but also gain practical insights into its application so you can bring it to practice directly!
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
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
Changing the way how we interact with data in the Era of AI
Why should we look at reports and search for a specific KPI, if you can just ask your personal assistant for the most recent status of that KPI? Chatting is the new way of interacting with your data in the Era of AI.
Join us as we delve into the future of data interaction and explore the transformative power of Microsoft Fabric. Discover how this technology enables us to have dynamic conversations with our data that go beyond traditional static reports. Prepare to revolutionize your approach to using data in the age of artificial intelligence.
During this session we will touch upon different technologies to support your data related conversations
- Natural language to SQL capabilities
- MS Copilot in Power BI
- AI Skills in MS Fabric
- Power Virtual Agents to bring conversations to MS Teams
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.
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!
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!
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.
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.
dataMinds Connect 2024 Sessionize Event Upcoming
Data Saturday & Fabric Friday Holland 2024 Sessionize Event Upcoming
SQL Konferenz 2024 Sessionize Event Upcoming
Power BI Next Step Sessionize Event Upcoming
Data Saturday Oslo 2024 Sessionize Event Upcoming
Data Saturday Rheinland 2024 Sessionize Event
Power BI Cruise Sessionize Event
Data Point Prague Sessionize Event
DataGrillen 2024 Sessionize Event
Power BI Gebruikersdag 2024 Sessionize Event
Data Saturday München 2024 Sessionize Event
Fabric February 2024 Sessionize Event
Data Community Austria Day 2024 Sessionize Event
dataMinds Connect 2023 Sessionize Event
Data Saturday Holland 2023 Sessionize Event
Power BI Next Step 2023 Sessionize Event
SQL Konferenz 2023 Sessionize Event
DATA:Scotland 2023 Sessionize Event
Data Saturday Rheinland 2023 Sessionize Event
Techorama 2023 Belgium Sessionize Event
SQLBits 2023 - General Sessions Sessionize Event
SQLBits 2023 - Full day training sessions Sessionize Event
Power BI Gebruikersdag 2023 Sessionize Event
Power BI Summit 2023 Sessionize Event
Global Power Platform Bootcamp 2023 - Belgium Edition Sessionize Event
dataMinds Connect 2022 Sessionize Event
Techorama Netherlands 2022 Sessionize Event
Power BI Next Step 2022 Sessionize Event
DATA:Scotland 2022 Sessionize Event
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?"
Scottish Summit 2022 Sessionize Event
DataGrillen 2022 Sessionize Event
Techorama 2022 BE Sessionize Event
Data Saturday Stockholm 2022 Sessionize Event
Power BI Gebruikersdag 2022 Sessionize Event
SQLBits 2022 Sessionize Event
Power BI Summit 2022 Sessionize Event
Power BI Fest Sessionize Event
PowerPlatform French Summit (2021) Sessionize Event
#DataWeekender v4.2 Sessionize Event
Power BI Next Step 2021 Sessionize Event
Techorama 2021 Spring Edition Sessionize Event
Power BI Summit Sessionize Event
dataMinds Saturday Sessionize Event
Virtual Scottish Summit 2021 Sessionize Event
Global Power Platform Bootcamp 2021 - Italy Sessionize Event
Global Power Platform Bootcamp - 2021 Sessionize Event
PowerPlatform French Summit (2020) Sessionize Event
#DataWeekender #TheSQL Sessionize Event
LightUp Sessionize Event
Power Saturday 2020 Sessionize Event
Power BI Gebruikersdag 2020 (CANCELLED) Sessionize Event
Scottish Summit Sessionize Event
Power Platform Bootcamp Brussels 2020 Sessionize Event
Power BI Days Belgium 2020-01 Sessionize Event
DATA:Scotland 2019 Sessionize Event
DataGrillen 2019 Sessionize Event
Power Saturday 2019 Sessionize Event
Data in Devon 2019 Sessionize Event
Power BI Days Belgium 2019-04 Sessionize Event
Power BI Gebruikersdag 2019 Sessionize Event
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.
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.
Power BI Days 2019-01 Sessionize Event
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.
Power BI Gebruikersdag Sessionize Event
Marc Lelijveld
Data Platform MVP | Technical Evangelist | Solution Architect Data Solutions & Insights
Haastrecht, The Netherlands
Links
Actions
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top