Data Team

This dive into aggregation tables will help you decide when to use them in Power BI to improve your data model and query performance.

This blog covers the advantages of using dimensional data models in your Power BI datasets + some additional tools that can optimize your dataset performance.

Here's how we use the data protection features within SQL Server to protect confidential data and make it available to only those authorized to see it.

We custom-made an IoT framework with Azure components and Power BI to implement a scalable solution to source, stream and show machine performance in real-time.

By designing and implementing a dynamic scaling plan for your Azure solution, you can get the resources you need while reducing cost at the same time.

In my last post, I explained why I would want to use Fuzzy Lookups for my various matching needs. Now I want to explain the how.

The idea to implement AD groups was first realized when trying to dynamically populate O365 group membership, that can be done with PowerShell.