Data Analytics

cybersecurity myth tools

Machine Monitoring IoT Solution with Azure Services and Power BI

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.
Power BI strategy meeting

10 KPIs Manufacturers Should Track for Operational Excellence

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.
power bi report on desk

A Look at Power BI as a Business Intelligence System: Power Query M

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.
three ships in ocean

How to Protect PHI Data by Limiting External Access to Power BI

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.
reviewing power bi reports

Data Granularity Challenges with the Power BI Google Analytics Connector

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.
Business people in conference room

12 Questions to Elicit Business Intelligence Requirements

There are differences between gathering reporting requirements & software development requirements. You have to focus on what the business wants to know not do.
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.
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.
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.