IDA IT x Power BI User Group

17:00 – Introduction to PBI Usergroup and the IDA Networks

17.15 – 18:15 - Supercharge Power BI with Azure Synapse Analytics – by Mathias Halkjær

Power BI is incredibly powerful at distributing and sharing data insights, through visualizations, across an entire organization. The democratization of Business Intelligence that Power BI brought with it is unparalleled. But Power BI on its own has its limitations and will often fall short, on its own, when designing end-to-end analytic platforms for enterprises. That’s where Synapse comes into the picture-for organizations, small and large, their current Power BI deployment can be supercharged with the capabilities of Azure Synapse.

In this session we will cover how to architect an end-to-end enteprise analytics platform so that we utilize the best of both worlds. The extremely versatile ETL capabilities of Synapse and the powerful data modelling in Power BI.
Along the way we will go through reasons to add-on Synapse to Power BI as well as some of the direct integrations between the two.

After this session you will leave with a much better understanding of how Azure Synapse Analytics can supercharge your Power BI deployment.

18:15 – 19:00 – Sandwiches and networking

19:00 – 19:45 – What’s the time – time intelligence functions in DAX – by Microsoft MVP Erik Svensen

The DAX language contains as a lot of time intelligence functions that works fine when we are working with the same period last year – but what when we start to work with weeks or fiscal years. In this session we will have a look at how we can work with these scenarios and how some of the built in time intelligence functions can solve these challenges. We will also look at how calculation groups can be used to limit the amount of measures in our model and add flexibility to work with time in our model.

19:45 – 20:00 – Q & A