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

 

 

How to Denormalize (Join) Data Using Flow Analytics

Overview This blog post demonstrates how to configure the denormalize function in order to join disc

Overview

This blog post demonstrates how to configure the denormalize function in order to join disconnected data sets together. A worked example is provided which shows how to import and merge various delimited files. The denormalize action is used to join the data from the separate files together in order to consolidate them into a single set for analysis. Once the data is joined, we learn how to use hypercubes to aggregate and summarize the data.

How to Denormalize (Join) Data Using Flow Analytics

 

 

 

A Basic Introduction to Multidimensional Analysis Using Flow

Overview This article presents a basic introduction to multi-dimensional analysis and analytics-orie

Overview

This post presents a basic introduction to multi-dimensional analysis and analytics-oriented processing using Flow. It discusses data sets, measures, dimensions, and hypercubes; then it provides a step-by-step example of building a workflow to analyze some fictional A/B test data.

An Introduction to Multidimensional Analysis