Data Analytics

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.

Knowing what to measure is key, but where should a manufacturer begin, especially in operations? The best place to start is with your strategic business goals.

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.