Data to Decisions

Automation, Integration, Analytics, Reports & Dashboards

Analyze Blank or Missing Data Values Using Flow Analytics

Overveiw In this blog post, I provide a worked example demonstrating how to perform an analysis of b

Overview

In this blog post, I provide a worked example demonstrating how to perform an analysis of blanks on a target dataset. When analyzing data a typical first step is to get an understanding of where there are missing values. Identifying where there are missing values in your data can help you make more informed decisions about your analysis approach.

How to Analyze Blank or Missing Data Values Using Flow Analytics

 

 

How to Deduplicate Data Using Flow Analytics

Overview This blog post demonstrates how to identify and remove duplicate records from a dataset. A

Overview

This blog post demonstrates how to identify and remove duplicate records from a dataset. I provide a worked example that shows how to configure and implement the deduplicate function against some sample customer data. The deduplicate function is a critical action which allows the workflow developer to create rich data validation and transformation rules. 

How to Deduplicate Data Using Flow Analytics

 

 

 

 

Doing Data Quality with Flow Analytics

In this article, I provide an introduction to measuring and evaluating data quality using Flow. I br

Overview

In this article, I provide an introduction to measuring and evaluating data quality using Flow. I briefly discuss data quality dimensions and data quality assessment. Then I examine how a schema-on-write approach increases the time and cost required to assess data quality along with a brief discussion of schema-on-read technology. I then introduce Flow's "Generic Data" technology as a solution to the deficiencies of schema-on-write and schema-on-read for data quality. Finally, I provide a hands-on working example of doing data quality in Flow Analytics using some sample name and address data. 

Doing Data Quality with Flow Analytics

 

 

Perform a Benford Analysis Using Flow Analytics

Overview n this post, we build a reusable eight-step Flow that performs a basic Benford's Analysis o

Overview

n this post, we build a reusable eight-step Flow that performs a basic Benford's Analysis on a sample data set. This Flow loads the sample data set then obtains the first digit from each observation, builds a hypercube and uses it to count the first digits, extracts a dataset containing the distribution and, finally, computes the expected distribution and compares it to the observed distribution by taking the difference.

Perform a Benford's Analysis Using Flow Analytics