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.

Marc Lelijveld

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

Haastrecht, Netherlands

View Speaker Profile