Data to Decisions

Automation, Integration, Analytics, Reports & Dashboards

How to Import and Analyze Common Types of File Data Sources

This blog post provides a worked example of how to import and analyze Microsoft Access Data. We lear

Overview

This blog post provides a worked example of how to import and analyze Microsoft Access Data. We learn how to use the Access Database integration interface to consume the sample Northwind database into Flow. A step-by-step walkthrough is provided which details how to denormalize the various relational tables into a consolidated flattened set for analysis. We learn how to apply generic expressions to compute new data points on the fly. Finally, we learn how to leverage Flow's multidimensional analysis engine to compute hypercubes and summarize the data.

How to Import and Analyze Common Types of File Data Sources

 

 

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