Martin Bubenheimer
Power BI Architect - Ambassador for good data warehouse architecture, clean data models, high-performance scalable DAX code, and expert for financial modelling that workss
Nürnberg, Germany
Actions
Power BI architect for a global player in the pharmaceutical industry. Previously consultant for BI solutions in the Microsoft stack, consultant for requirements engineering, and product owner in a large Oracle data warehouse environment. Power BI influencer and Super User for both, the German and the global community.
Certifications: IREB requirements engineering and requirements modeling, Scrum master, Scrum product owner, Microsoft Power BI DA-100, DP-600, MCSE Data Management and Analytics, MCSA BI Reporting
Area of Expertise
Topics
DAX Performance Optimization with the No IF Challenge
DAX, as the query language of Microsoft Power BI – and, more precisely, already established in SQL Server SSAS and Excel Power Pivot before Power BI –, is not a procedural but a declarative language. Typical constructs of a procedural programming language, such as conditions and branches, are also available in DAX, but because of their poor optimization by the query optimizer, they should be understood as an emergency solution or exception and not used as a basic framework. In this session we will learn coding patterns that avoid conditional programming to keep measure performance high.
This session is targeting the experienced DAX developer that is still struggling with getting performance first time right or are looking for inspiration to easily create scalable code. The idea is also great for training in coding dojos with colleagues or at conferences. Frequent visitors of the SQLBI blog or YouTube channel will love this session! Duration: 60 minutes, scalable, workshop possible, in German possible
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top