Gašper Kamenšek is a renowned BI consultant, trainer, and Excel expert from Slovenia, celebrated for his mastery of Power Query, Power Pivot (DAX), and Excel-based solutions. With over 20 years of experience, Gašper has established himself as a leading figure in the world of data analytics and business intelligence. He is the founder of Excel Olympics, a platform dedicated to empowering professionals with advanced Excel and Power BI skills.

Gašper is an 8-time Microsoft MVP, a prestigious recognition of his exceptional contributions to the Excel and Power BI communities. He has delivered over 900 courses and seminars, captivating more than 7,000 participants with his engaging teaching style and practical insights. As a speaker, Gašper has graced the stage at more than 60 conferences and events worldwide, sharing his expertise and inspiring audiences to unlock the full potential of their data.

In addition to his training and consulting work, Gašper is the creator of the blog Excel Unplugged, launched in 2014. The blog serves as a valuable resource for professionals seeking tips, tricks, and advanced techniques to enhance their Excel proficiency. His passion for Excel and Power BI extends to his YouTube channel, where he shares tutorials and insights with a growing global audience.

When not lecturing or working on BI projects involving PowerPivot, SQL, Excel, or VBA, Gašper indulges in his hobbies of music and photography, showcasing his creative side.

Gasper has been a Speaker in each of the previous editions of Bulgaria Excel Days.

Gasper Conference topic:

Solving Complex Relationships with DAX: Virtual Joins and TREATAS

Key Focus: Relationship modeling in DAX without the physical model

Outline:

• Using TREATAS, INTERSECT, EXCEPT, CROSSFILTER, and USERELATIONSHIP
• Modeling many-to-many (M2M) relationships in DAX
• Overriding model relationships dynamically
• Scenarios with disconnected slicers

Ideal for: Advanced modelers and those dealing with complex data schemas.