SQLBits 2020

Azure DW and Power BI, reporting at the speed of light!

In this action-packed demo full session, we will be showing you how to combine Azure DW and Power BI to get optimal performance for running your day to day reports.

In this action-packed demo full session, we will be showing you how to combine Azure DW and Power BI to get optimal performance for running your day to day reports.
On the Azure DW side we will have a small introduction on the architecture and the choices you must make. By using techniques like result set caching, distributing data and materialized views, you will be able to achieve the most optimal performance for your reporting environment.
On the Power BI side, we will show you how to consume your Azure DW data in a fast and seamless way. This will be achieved by optimizing your model with the help of features like Composite Models, Aggregated tables, and many other functionalities.
After this session, you will be ready to implement a scalable and fast performing reporting environment on huge amounts of data.