Unlock the full potential of your data career by mastering the art of automation and community engagement. In this episode of the MC 65 FM podcast, we are joined by Bernat Agullo Rosello, a Senior BI Developer and Microsoft MVP, to discuss the intersection of DAX expertise and C sharp scripting.

We dive deep into Bernat’s unique journey, from learning multiple languages and living in Japan to becoming a leading voice in the Power BI community. You will learn how to save up to 40 percent of your development time through smart automation, the common pitfalls to avoid in DAX, and why the future of BI depends on more than just AI hype. Bernat also shares his experience leading the Power BI and Fabric Barcelona user group and provides a roadmap for how community involvement can accelerate your professional growth. Whether you are looking to refine your Tabular Editor skills or want to understand the shifting landscape of Microsoft Fabric, this conversation is packed with actionable insights for every data professional.

Chapters
0:00 Introduction and Guest Background
2:30 Languages and Living in Japan
5:45 Community Culture Differences Globally
8:15 Transitioning from Excel to BI Analytics
11:45 Falling in Love with DAX and Modeling
14:30 Common DAX Misconceptions
17:15 Scripting with C sharp in Tabular Editor
21:00 Why Every Developer Needs Tabular Editor
25:30 Automating Repetitive BI Tasks
29:00 The Impact of Automation on Mental Health
32:15 Managing Measure Dependencies and Scripts
35:00 Future Trends in Semantic Model Automation
38:15 AI in BI: Hype versus Reality
41:30 Exploring Unstructured Data and Fabric
44:00 Career Advice for Power BI Beginners
47:15 Building a Thriving Local Data Community
49:00 Final Advice and Closing Remarks

If you found these insights helpful, make sure to like this video and subscribe for more deep dives into the world of data. Follow Bernat on LinkedIn and check out the Barcelona Power BI and Fabric User Group to continue the conversation.

#PowerBI #DAX #TabularEditor #DataAnalytics #MicrosoftFabric