Data Analytics

Team collaboration

How to Quickly Detect Tabular Referential Integrity Issues

How can you detect referential integrity issues in your tabular model? Here’s how to detect them, the tables they’re in, and which values are the problem.

Read More »

path through field

7 Things to Remember When Setting Up Fuzzy Lookups

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.

Read More »

Cloud Connectivity

3 Steps to Implement AD Security for an On-Premises Data Gateway

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

Read More »