Data to Decisions

Automation, Integration, Analytics, Reports & Dashboards

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 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

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

 

 

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

 

 

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