How to add a custom Python package in Azure Synapse Analytics
Do you often find yourself repeatedly using the same Python functions across multiple notebooks, and are you looking for ways to streamline your workflow? If so, this article is a must-read for you. Discover how to optimize your process and boost your productivity!
Published September 13, 2023
Table filters vs column filters in Power BI and the concept of expanded tables
Are you using table or column filters in your DAX measures? There's a big difference between the two, and it can have a big impact on performance. In this article, I will explain the difference between table and column filters, the concept of expanded tables, show you how they impact performance, and give you 2 examples of how to use table filters effectively.
Published September 2, 2023
How to handle different granularities in Power BI
Picture this for example: you are dealing with your daily sales figures and suddenly you need to compare them with long-term yearly targets. This request comes very often from stakeholders. How would you handle this in your data model? DAX? Well like almost everything in Power BI, there is more than one solution…
Published August 15, 2023