Speaker

Marc Lelijveld

Marc Lelijveld

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

Haastrecht, Netherlands

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/

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

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.

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

SQLBits 2023 - Full day training sessions Upcoming

March 2023 Newport, United Kingdom

dataMinds Connect 2022

October 2022 Mechelen, Belgium

Techorama Netherlands 2022

October 2022 Utrecht, Netherlands

Power BI Next Step

September 2022 Billund, Denmark

DATA:Scotland 2022

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, Netherlands

DataGrillen 2022

June 2022 Lingen, Germany

Techorama 2022 BE

May 2022 Antwerpen, Belgium

Data Saturday Stockholm 2022

May 2022 Stockholm, Sweden

Power BI Gebruikersdag 2022

March 2022 Utrecht, Netherlands

SQLBits 2022

March 2022 London, United Kingdom

Power BI Fest

November 2021

#DataWeekender v4.2

November 2021

Power BI Next Step 2021

September 2021 Copenhagen, Denmark

Techorama 2021 Spring Edition

May 2021 Antwerpen, Belgium

Power BI Summit

April 2021

dataMinds Saturday

March 2021

#DataWeekender #TheSQL

October 2020

LightUp

July 2020

Power Saturday 2020

June 2020 Paris, France

Power BI Gebruikersdag 2020 (CANCELLED)

March 2020 Utrecht, Netherlands

Scottish Summit

February 2020 Glasgow, United Kingdom

Power Platform Bootcamp Brussels 2020

February 2020 Brussels, Belgium

Power BI Days Belgium 2020-01

January 2020 Kontich, Belgium

DATA:Scotland 2019

September 2019 Glasgow, United Kingdom

DataGrillen 2019

June 2019 Lingen, Germany

Power Saturday 2019

June 2019 Paris, France

Power BI Days Belgium 2019-04

April 2019 Mechelen, Belgium

Power BI Gebruikersdag 2019

March 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.

March 2019 Amsterdam, 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, Netherlands

Power BI Days 2019-01

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

March 2018 Utrecht, Netherlands

Marc Lelijveld

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

Haastrecht, Netherlands