Data Analytics

While it may be tempting to choose only the newer data lake format, or the tried-and-true data warehouse, both have pros and cons that we explore in this blog.

Here is a high-level view of Power BI and its ETL part that is behind the External Data Section that makes it a “kitchen sink” Business Intelligence system.

In this walkthrough, we demonstrate how a health provider can restrict the sensitive data in their Power BI service environment to only their trusted network.

The Google Analytics connector for Power BI lets you to build a dataset consuming data from your GA solution, but it comes with unique challenges and solutions.

There are differences between gathering reporting requirements & software development requirements. You have to focus on what the business wants to know not do.

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.

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.