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
ANYONE CAN JOIN - Most of IDA's events are open to everyone, but you must have an IDA user profile in order to participate. It's free and non-binding - create a user profile now. As a member of IDA, you get a discount on many of our events, so please sign in with your member login when you sign up for an event. Read more about the benefits of an IDA membership here.