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 7 - Introduction to Results / HyperCube Dashboard Development

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

Overview

This is the seventh blog post in our crash course series on Flow. In this blog post, I provide an introduction to Results, Dashboard Design, and a first look at HyperCube Reporting in the Flow Computing Framework.

Flow Crash Course - Part 7 - Introduction to Results / HyperCube Dashboard Development

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

 

 

 

Building Grouped Reports with Flow Analytics

Here is the second in a series of posts focusing on building reports in Flow. A grouped report is an

Overview

Here is the second in a series of posts focusing on building reports in Flow. A grouped report is an advanced report produced by Flow. Grouped Reports organize records into one or more nested groups where each group is is a collection of records with a common column data value. There are two basic methods you can employ to create grouped reports in Flow. The first is to add a Grouped Report action to a new or existing workflow. The second way is to open a hypercube within the Flow portal then click on the report icon Create Report button in the toolbar located at the top of the hypercube view. This post will cover the first method.

Building Grouped Reports 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

An Introduction to Building Dashboards in Flow Analytics

Overview Flow enables you to build dashboards containing a variety of elements including tables, cha

Overview

Flow enables you to build dashboards containing a variety of elements including tables, charts, reports, and data summaries, among others. This post focuses on two methods you can use to build, populate, and update dashboards. I show how to add a new dashboard, then how to create and add chart result using one of the sample datasets provided. Next, I provide an in-depth discussion of adding workflow generated results to a dashboard.

An Introduction to Building Dashboards in 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

Building Tabular Reports in Flow Analytics

Building Tabular Reports in Flow Analytics Flow enables you to build many types of reports, such as

Overview

Flow enables you to build many types of reports, such as tabular, grouped, pivot tables, tables, and data summaries. Here is the first in a series of posts focusing upon building reports in Flow. You can learn more about these different types of reports in the Flow online help. A tabular report is the most basic type of report you can build in Flow, it is organized in a multicolumn, multirow format, with each column corresponding to a column in a dataset.

There are two basic methods you can employ to create tabular reports in Flow. The first is to add a Tabular Report action to a new or existing workflow. The second way is to open a dataset within the Flow portal then click on the report icon Create Report button in the toolbar located at the top of the dataset view. This post will cover the first method.

Building Tabular Reports in Flow Analytics