Data to Decisions

Automation, Integration, Analytics, Reports & Dashboards

An End-to-End Data Analytics Walkthrough

Overview This blog post provides a worked example of an end-to-end automated business intelligence s

Overview

This blog post provides a worked example of an end-to-end automated business intelligence solution. This blog post demonstrates how to load data from different sources, join the data together, cleanse and correct data quality issues, compute hypercubes, and design a dashboard. I then demonstrate how to deploy the solution to the autonomous agent framework for continuous execution.

An End-to-End Data Analytics Walkthrough

Flow Crash Course - Part 8 - Data Visualization / HyperCube Visualization / Multi-dimensional Tables

This is the eighth blog post in our crash course series on Flow. In this blog post, I provide an int

Overview

This is the eighth blog post in our crash course series on Flow. In this blog post, I provide an introduction to HyperCube Visualizations and Multi-dimensional HyperCube Tables in the Flow Computing Framework.

Flow Crash Course - Part 8 - Data Visualizations and HyperCube Multi-dimensional Results

Flow Crash Course - Part 6 - HyperCube Computation

This is the sixth blog post in our crash course series on Flow. In this blog post, I provide an intr

Overview

This is the sixth blog post in our crash course series on Flow. In this blog post, I provide an introduction to HyperCube Computation in the Flow Computing Framework.

Flow Crash Course - Part 6 - HyperCube Computation

Flow Crash Course - Part 4 - Basic Data Summary Functions

This is the fourth blog post in our crash course series on Flow. In this blog post, I provide an int

This is the fourth blog post in our crash course series on Flow. In this blog post, I provide an introduction to Basic Data Summary Functions in the Flow Computing Framework.

Flow Crash Course - Part 4 - Basic Data Summary Functions

Build HyperCube-Based Autonomous BI Dashboard

In this blog post, I demonstrate how to build a hypercube-based autonomous BI dashboard. I explain t

Overview

In this blog post, I demonstrate how to build a hypercube-based autonomous BI dashboard. I explain the current-state landscape of BI reporting and data analytics technologies. I provide details on the current limitations of existing BI approaches to automated reporting. I then define the characteristics required for a next-generation BI analytics and reporting framework capable of meeting the current and emerging reporting requirements that most businesses face. I provide a worked example demonstrating how to develop a solution which answers these emerging challenges. In the worked example, I show how to compute hypercubes from raw data and use those hypercubes as the basis for n-dimensional drill through dashboards. I explore various transformations and aggregation techniques across hypercubes to demonstrate how to summarize data across multiple dimensions. I show the power of Flow's multidimensional visualization and pivot engine by creating visualizations which allow for 5+ levels of drill-down. I finish the example by designing an interactive dashboard and showing how to distribute the completed report across an organization. Finally, I cover how to deploy the developed workflow to Flow's agent framework to continuously and autonomously execute our reporting tasks on a schedule.

How to Build HyperCube-Based Autonomous BI Dashboard

 

 

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

 

 

 

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

Building Tables and Pivot Tables in Flow Analytics

Overview In this post, we'll build a six-step workflow that produces Pivot Table and Table results.

Overview

In this post, we'll build a six-step workflow that produces Pivot Table and Table results. It shows how to load data, use expressions to derive time-period values from a date field, build a hypercube using those time-period values as dimensions and, finally, how to create and view pivot table and table results using the hypercube.

Building Tables and Pivot Tables in 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