22-25 April 2026 
Analytics at scale with Power BI and Azure Synapse
2022TL; DR
Learn how to design and build a truly scalable solution that spans both Power BI and Azure Synapse Analytics
Session Details
To really understand what this session is about, I want you to get to know these 2 personas!
» Meet Marc: over the years he has developed a self-service Power BI solution that is now being used by dozens of people! But his solution is in trouble... The business is asking him to load data from various APIs. And, they want him to store historical data in Power BI for trend analysis! ... How can he do this?
» Meet Dave: his data lakehouse solution in Azure Synapse Analytics is vital for multiple decision making processes. But his solution is in trouble... the Power BI reports on top of it can't seem to handle the volume of data, and at the same time the business is asking for near real-time data! ... What can he do?
Marc & Dave need to work together and combine their expertise to solve their challenges! Interested in the end result? Then you are the right audience for this session, come join us!
We will train you how to design and build a solution that will span 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 day.
After the training 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.
Feedback link https://sqlb.it/?6199
» Meet Marc: over the years he has developed a self-service Power BI solution that is now being used by dozens of people! But his solution is in trouble... The business is asking him to load data from various APIs. And, they want him to store historical data in Power BI for trend analysis! ... How can he do this?
» Meet Dave: his data lakehouse solution in Azure Synapse Analytics is vital for multiple decision making processes. But his solution is in trouble... the Power BI reports on top of it can't seem to handle the volume of data, and at the same time the business is asking for near real-time data! ... What can he do?
Marc & Dave need to work together and combine their expertise to solve their challenges! Interested in the end result? Then you are the right audience for this session, come join us!
We will train you how to design and build a solution that will span 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 day.
After the training 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.
Feedback link https://sqlb.it/?6199
3 things you'll get out of this session
Speakers
Dave Ruijter's previous sessions
Crafting Flight Simulations: The Art of Synthetic Data Generation
Embrace the flight simulator of the data world: discover how synthetic data creates rich scenarios without real-world data risks.
Navigating the Skies of Data: A Flight Through Feature Stores
Embark on a journey through the dynamic realm of Feature Stores. Learn how they streamline data processes for ML projects, acting as the control tower for feature management.
No more data quality surprises in your Databricks, Synapse or Power BI solutions!
In this demo-rich session you will learn how you can implement a framework for data quality validation and monitoring, spanning your end-to-end data platform including Power BI!
10 tips for a successful migration from Databricks and ADF to Synapse
Are you planning a migrating of your data platform to Azure Synapse Analytics? Is it currently based on Azure Databricks, Azure Data Factory, and Azure Data Lake Storage? Make sure to grab these 10 tips! We'll talk about Spark compatibilities, orchestration pitfalls and solution deployment differences.
Overview of Azure Synapse Analytics
Curious what Azure Synapse Analytics brings to the table? Bring your scuba gear, as we take a dive and explore everything it has to offer!
Marc Lelijveld
data-marc.com
Marc Lelijveld's previous sessions
Data modeling for experts with Power BI
Want to level up your Power BI data modeling skills? During this session you will learn how to deal with different source groups, storage modes and composite models in Power BI. Also, how to avoid redundant measures by implementing calculations groups and the challenge that comes when you combine calculation groups with remote and local Power BI models.
Successfully collaborate with externals in Power BI
Get started with B2B collaboration in Power BI. Get to know which questions to ask, how to set it up and leave the room well equipped to get your collaboration started!
We will provide you with best practices and ways of working and give you a decision tree to help you even after the session to make the right decisions.
Advanced data modeling with Power BI
After understanding the basics, lets take the next step in data modeling in Power BI!
Enterprise and multi-tier Power BI deployments with Azure DevOps.
Govern your Power BI estate and setup your DTAP approach for Power BI using DevOps or native deployment pipelines!