Visual Calculations: Making DAX easier

This is it. The day that the way that DAX became easier. After this, how you write DAX changes forever. Learn all about it in this session! The Power BI team has been working on exciting things related to DAX calculations, specifically targeted at making it easier to add typical business-type calculations (such as running totals or vs-first). Would you believe it if we told you that you don’t even have to type DAX anymore and still be able to get complex calculations done quickly? In this session, we will talk about this exciting new feature!

Join this session to learn more about this new feature which will make writing DAX statements so much easier and faster. Get ready to get your mind blown! See the future, today.

Visual Calculations: Making DAX easier

This is it. The day that the way that DAX became easier. After this, how you write DAX changes forever. Learn all about it in this session! The Power BI team has been working on exciting things related to DAX calculations, specifically targeted at making it easier to add typical business-type calculations (such as running totals or vs-first). Would you believe it if we told you that you don’t even have to type DAX anymore and still be able to get complex calculations done quickly? In this session, we will talk about this exciting new feature!

Join this session to learn more about this new feature which will make writing DAX statements so much easier and faster. Get ready to get your mind blown! See the future, today.

Power BI Unplugged (EN)

Visual Calculations: Making DAX easier

Visual calculations, the biggest innovation in DAX ever, has been in preview since February. Visual calculations revolutionize how you write DAX, making it possible to put together calculations that were previously prohibitively hard to write. Come join this session to learn all about the feature from the product team itself. In this demo-rich session, we will talk about the feature, how to use it, what's new and what's coming soon! We will also cover the things you need to know so you can be successful in using visual calculations. Come see it for yourself. See the future, today.

Power BI Unplugged (EN)

Modeling with Power BI Product Team

Come meet the Power BI product team to talk about modeling

Power BI Custom connectors

Power BI heeft een hele hoop verbindingen beschikbaar, maar niet naar de hele wereld. Een van de mooiste uitbreidingsmogelijkheden van Power BI Desktop is de mogelijkheid om custom connectors toe te voegen, zodat je wel kunt verbinden naar dat ene lastige systeem. In deze sessie laten we je zien hoe je dat doet!

Modeling in Power BI – the key to success

Come learn about modeling, including what’s new and exciting from the Power BI team that focuses on modeling. We will cover the basics of modeling and why you should care as well as show new features and demos. If you want to be successful using Power BI, you will want to join this session.

Level-up your Power BI data modeling skills (EN)

After a successful webinar series on Data Modeling with Power BI, Jeroen ter Heerdt (Program Manager in the Power BI team at Microsoft) and Marc Lelijveld (Data & Analytics solution architect & Most Valuable Professional) will bring all their best practices on Data Modeling with Power BI together in a full day precon. We will split the day in three sections, where we kick-off with the basics of data modeling. Then we continue with more advanced patterns to finish the day with expert level modeling by using all advanced features and techniques.

So, what is a good data model in Power BI? How do you make sure you have the basics in place so the model you build today, will still work next year? We talk about different modeling concepts, whether to use the data model or Power Query for transformations, the differences in calculated columns and DAX with their effects on your model and handling role-playing dimensions.

After the basics, it is time to level-up by considering more complex patterns like different types of relationships, overcoming ambiguity, and successfully implementing aggregations. Also, different types of storages modes come into play. Dealing with DirectQuery and Imported (cached) data in the same model on table level with user defined aggregations, but also hybrid tables with different storage modes in the same table. Of course, we will talk about composite models with Power BI datasets and/or (Azure) Analysis Services.

To top-off this day full of real-life examples, we will talk about calculation groups and their behavior in composite models. We make sure you finish the day with a list full of tips and tricks that can be directly brought to practice directly.

After this precon you will be able to:
- Explain basic dimensional modeling concepts
- Create a well working and performing data model in Power BI
- Decide when to use Power Query vs the data model
- Decide when to use Calculated columns or measures
- Handle complex situations with inactive relationships and role-playing dimensions.
- Leverage one and bi-directional relationships
- Overcome and handle ambiguous data models
- Successfully implement aggregations
- Work with real live scenarios containing multiple fact tables
- Understand and explain different types of storage modes in Power BI
- Combine DirectQuery and import storage modes in a composite model
- Successfully implement calculation groups
- Understand calculation groups in composite models and their behavior

Keynote

Power BI empowers individuals, teams and organizations to drive a data culture and meet the most demanding enterprise needs. In this session you will hear about the Power BI strategy, learn where we’re heading, and see some fun demos of the latest features. Get inspired to drive your next innovation!

Improvements to doing calculations in Power BI

For the last 1.5 years, the Power BI team has been working on exciting things related to DAX calculations, specifically targeted at making it easier to add typical business-type calculations (such as running totals or vs-first). Would you believe it if we told you that you don’t even have to type DAX anymore and still be able to get complex calculations done quickly? In this session, we will talk about this exciting development for the first time ever, so you have not seen or heard about this anywhere else! This is brand new and exciting! Join this session to learn more about this new feature which will writing DAX statements so much easier and faster and get ready to get your mind blown!

Improvements to doing calculations in Power BI

For the last 2 years, the Power BI team has been working on exciting things related to DAX calculations, specifically targeted at making it easier to add typical business-type calculations (such as running totals or vs-first). Would you believe it if we told you that you don’t even have to type DAX anymore and still be able to get complex calculations done quickly? In this session, we will talk about this exciting development!

Join this session to learn more about this new feature which will make writing DAX statements so much easier and faster. Get ready to get your mind blown! See the future, today.

Improvements to doing calculations in Power BI

For the last 2 years, the Power BI team has been working on exciting things related to DAX calculations, specifically targeted at making it easier to add typical business-type calculations (such as running totals or vs-first).
Would you believe it if we told you that you don’t even have to type DAX anymore and still be able to get complex calculations done quickly? In this session, we will talk about this exciting development. This is brand new and exciting!

Join this session to learn more about this new feature which will writing DAX statements so much easier and faster and get ready to get your mind blown!

DirectQuery for Power BI Datasets and Azure Analysis Services

In Nov 2018, we released composite models, which allow you to seamlessly add multiple DirectQuery sources and imported data to your models. We have heard your feedback that you would like to do this with sources you previously live connected to, like Power BI datasets and Azure Analysis Services sources.
In December, we started previewing DirectQuery for Power BI datasets and Azure Analysis Services. This long-awaited addition allows report authors to use DirectQuery to connect to Azure Analysis Services or Power BI Datasets and, if they want to, combine it other DirectQuery and imported data.
In this session we will discuss this important feature and what it means to you as a user and to your organization.

Deploying Apps in SQL Server 2019 Big Data Clusters

Deploy your Data Science work onto SQL Server 2019 Big Data Clusters in minutes and turn them into REST APIs. Impossible? Think again. You deploy any R, Python or Spark model or even a SSIS package onto SQL Server Big Data clusters in seconds.

Data Modeling and DAX with Power BI product team

This is your opportunity to ask your questions to the Power BI team product managers working on data modeling and DAX directly!

Data modeling for experts with Power BI

Have you been working with Power BI for a while? Then it is time to take the next step with your data modeling skills!

You might have heard about Power BI composite models. But in order to implement them successfully, it is important to understand the different storage modes that Power BI has. This is key for a successful implementation and also understand the possible dangers of the storage mode behaviors.

More over, let's also talk Calculation groups! You might have been creating numerous calculations in the past for year to date, quarter to date and many other common patterns. With Calculation Groups you can limit the number of redundant measures by creating a common expression parts in a group, that can be applied on top of multiple measures.

And finally, we will combine the two together. Dealing with calculation groups in composite models. Cause there are some key-elements you have to keep in mind. Potentially this combination can lead to wrong results, if you do not understand the behavior of the remote and local engine and with that dealing with wholesale and non-wholesale queries.

During this demo-rich session I will take you on a tour through all above mentioned features and cases, and explain them one by one. So that after this session you will be able to;
- Understand and explain different types of storage modes in Power BI
- Combine DirectQuery and import storage modes in a composite model
- Successfully implement calculation groups
- Understand calculation groups in composite models and their behavior

BI Power Hour

The origins of the BI Power Hour are lost in the mists of time. According to legend, this demo-filled session was born when the Microsoft product team realized their amazing tools could not be constrained by Marketing-approved conference sessions.

For more than a decade, the BI Power Hour has delighted and amused audiences around the world, while adamantly refusing to teach those audiences anything useful in the real world. In this demo-filled session, members of the Power BI team are joined by select MVPs to show your favorite BI tool used for purposes for which they were never intended.

We can't guarantee that you'll laugh, but we CAN guarantee that WE will laugh - and we can guarantee that you won't learn anything that you can use when you get back to work. If you've never experienced the BI Power Hour, be sure to come early and get a seat.

If you're a BI Power Hour veteran, you're probably already in line.

Data modeling 101: Understanding the basics of a good data model

What is a good data model in Power BI? How do you make sure you have the basics in place so the model you build today, will still work next year? During this session we will lift of from basic level and build up in complexity to understand the key element of a good data model! Everything presented in this session will include real-life examples and can be directly brought to practice.

After this session you will be able to:
- Explain basic dimensional modeling concepts
- Create a well working and performing data model in Power BI
- Decide when to use Power Query vs the data model
- Decide when to use Calculated columns or measures
- Handle complex situations with inactive relationships and role-playing dimensions.

Best Practices for Composite models on Power BI datasets and Analysis Services (EN)

Best practices for composite models on Power BI Datasets and Azure Analysis Services

The preview of composite models on Power BI Datasets and Azure Analysis Services leveraging DirectQuery launched in December 2020.
We have seen loads of great use cases but also some challenges. In this session, we will cover best practices for this feature so you can get the best results.

AI & Visual Wizardry: Power BI's Dual Path to Insight

"AI & Visual Wizardry: Power BI's Dual Path to Insight" is a session aimed at demystifying the process of data analysis and visualization using Power BI for a wide audience, including both developers and end-users. It provides a thorough exploration of Power BI's capabilities, focusing on how its advanced features can be utilized to navigate the complexities of data.

For developers, the session will cover the use of Power BI’s AI functionalities and visual calculations to create sophisticated, intelligent dashboards and reports. Key topics include generating DAX queries with ease, enhancing reports with AI-driven visuals, and utilizing visual calculations for dynamic reporting.

On the other hand, end-users will learn how to leverage Power BI’s intuitive tools to independently explore and extend their data analysis, with a focus on using the 'Explore' feature for creating ad-hoc analysis and employing natural language queries for interactive data insights.

This session is designed to empower participants from various backgrounds to confidently use Power BI, making data-driven decision-making more accessible and insightful for everyone involved.

Advanced data modeling with Power BI

Got the basics in place and building a decent well performing data model in Power BI is a piece of cake for you? Time to take the next step!
During this session we will build up complexity and start integrating more advanced patterns in Power BI data models, covering topics like working with aggregations, composite models and more!

After this you will be able to:
- Leverage one and bi-directional relationships
- Overcome and handle ambiguous data models
- Successfully implement aggregations
- Work with real live scenarios containing multiple fact tables