How to Aggregate and Summarize Data

Data Aggregation and Summarization Overview

You need to group and summarize data from many different sources. The data you require needs to be linked, prepared, and joined to consolidate it for analysis. This data could be coming from different file sources, databases, web APIs, CRM systems, social platforms, or other specialized business applications and legacy systems.

With Flow Analytics workflows and a powerful configure-not-code workflow editor, you can easily access the entirety of your required data and perform any transformation, summarization, statistical calculation, and analytical task as part of the workflow. You can deliver the results of your analysis through powerful reports and dashboards to whoever needs to interact with the workflow output.

Get Started With Flow Analytics Workflows

Completely free - no trial period or credit card required.

Fully functional - access all the core features of the Flow platform.

Develop custom workflows - use our advanced, configure-not-code development environment to build custom solutions.

Free help and support - full documentation and how-to videos along with free online, telephone or email support.

An Example Data Aggregation and Summarization Workflow

Workflow Example 1 - Quarterly Sales Report

This workflow demonstrates the creation of a quarterly sales report from raw data using Flow. The required data exists across different delimited flat file data sources. We show how to apply actions which import and consolidate the various data sources into Flow's in-memory processing engine. We join the data to flatten it into a single dataset for report generation. Transformations are applied which extract Quarter, Year, and Month data points from a target date time value. We build a hypercube which aggregates the data by the extracted quarter, year, and month. We apply statistical calculations to compute our total sales and other critical metrics for each grouped period. We finish the example by delivering the report to the Flow Cloud and distributing it across our organization.

Watch Video

Data Aggregation and Summarization Actions Overview

Below are some example workflow actions provided by Flow which are used for data aggregation and summarization
Action Type Description  
Build Hypercube The Build HyperCube function creates a multi-dimensional analysis object from a target data collection. The HyperCube allows for powerful data summariziation and multi-dimensional statistics to be computed. view actions →
Hypercube Include The HyperCube Include function promotes an internal hypercube data point to the surface of the hypercube groupings. This internal data point value can be used as an axis in the creation of reports. view actions →
Slice Hypercube The Slice HyperCube function subsets a portion of a hypercube into a target result data collection. view actions →
Hypercube Expressions HyperCube Expressions allow for the design of multi-dimensional statistical computations across the hypercube analysis space. HyperCube Expressions allow for data to be summarized across many different dimensions at once and for computation to be weaved in and out of the hypercube. view actions →
Summarize Dataset The Summarize Dataset function computes a summary descriptive statistic profile for a target data collection. The result summary profile data collection is added to the working data container as a generic data collection object to support further manipulation and analysis. view actions →
Categorize Data The Categorize Data function assigns a data record to a classification grouping based on a set of logical conditions, fuzzy match criterias, text similiarity evaluations and other classification rule criteria. view actions →
Frequency Distribution The Frequency Distribution function creates a hypercube histogram data collection which evaluates the distribution of values based on a specific number of class intervals. The HyperCube frequency distribution result can be passed to additional multidimensional computations for further analysis. view actions →
Simple Moving Average The Simple Moving Average function evaluates a simple windowed moving average time series calculation against a target numeric data point. The moving average result values are stored as a new data point in the target data collection. view actions →
Weighted Moving Average The Weighted Moving Average function evaluates a weighted windowed moving average time series calculation against a target numeric data point. The moving average result values are stored as a new data point in the target data collection. view actions →
Cumulative Moving Average The Cumulative Moving Average function evaluates a cumulative moving average time series calculation against a target numeric data point. The moving average result values are stored as a new data point in the target data collection. view actions →
Describe Data The Describe Data function computes a summary descriptive statistic profile for a target data collection. The result summary profile data collection is added to the working data container as a generic data collection object to support further manipulation and analysis. view actions →
Profile Blank Data The Profile Blank Data function creates a profile of the missing values across all data points in a target data collection. The function evaluates the count of missing values, % of missing values, and distribution of missing values across each data point in a target collection. The result of the Profile Blank Data function is stored as a data collection into your working data container to support further analysis. view actions →
Language Summary The Language Summary function creates a word count language model profile for a target text data point. The Language Summary function can be used to summarize the frequency of the occurances of words across all values in a target data point as well as the frequency of the occurance of joint word pairs. The result of the Language Summary function is stored as a data collection into your working data container to support further analysis. view actions →
Bin Data Items The Bin Data Items function clusters rows into different "bins" of a fixed number of elements. These bin groupings can be used to sample and summarize data as well as for partionining operations across large data sets. view actions →
Denormalize Data The Denormalize Data function allows for the joining and subtraction of data sets by performing a match operation on a set of single or compound keys. The Denormalize Data operation can join datasets together as well as remove records of data in a parent data collection which exist in the child. view actions →
Perform Lookups The Lookup function allows you to perform a targeted join operation which looks up data points from a child data collection into a parent data collection based on matching across single or compound keys. view actions →
Append Datasets The Append Datasets function allows you to append and merge two datasets together by stacking the "Append From" data collection onto the bottom of the "Append Into" data collection. The Append Function supports jagged generic data append operations. view actions →
Single List Statistics The Single List Statistics library provides operations which allow for the design of statistical expressions and computations. Single List statistics functions can be evaluated over normal data points to create scalar summary statistic results as well as across hypercubes to design more complex multidimensional summary operations. view actions →
Time Series The Time Series function library provides operations for computing different time series expressions. These functions include moving differences, moving averages, imputation operations, interpolation and extrapolation operations. The Time Series functions can be evaluated against standard generic data collections as well as across more complex hypercube objects for multi-dimensional analysis. view actions →
Add Running Total The Add Running Total function computes a moving sum downwards across a target numeric data point value. The result values of the cumulative summation operation are stored in a target result data point. view actions →
Machine Learning: K-Means Cluster The K-Means Cluster Machine Learning operations learns an unsupervised cluster model based on a set of target input data points and a number of required clusters. The K-Means Cluster function allows for the automated discovery of patterns and relationships across data collections and the ability to predict these patterns and clusters on new data once learned. view actions →
Build Pivot Table Result The Build Pivot Table Result function creates an XY pivot view from a hypercube. The pivot table is used to summarize a specific view of a hypercube and deliver that summary view as an interactive result element to the Flow Cloud. The Pivot Table result can then be added to a dashboard and refreshed with up to date data whenever the workflow executes. view actions →
Build Table Result The Build Table Result function creates a hierarchical left-to-right pivot view from a hypercube. The pivot table is used to summarize a specific view of a hypercube and deliver that summary view as an interactive result element to the Flow Cloud. The Table result can then be added to a dashboard and refreshed with up to date data whenever the workflow executes. view actions →
Build Grouped Report Result The Build Grouped Report Result function creates a multi-dimensional grouped and layered report view from a hypercube. The grouped report is used to summarize a specific detail-breakdown view from a hypercube and deliver that summary view as an interactive result element to the Flow Cloud. The Grouped Report result can then be added to a dashboard and refreshed with up to date data whenever the workflow executes. view actions →
Generate Summary Items The Generate Summary Items function creates a set of grouped single value statistics for use in a report or dashboard. These grouped statistics are delivered to the Cloud Portal and are refreshed with updated values every time the workflow action executes. view actions →
Geo Drilldown The Geo Drilldown function creates a geographic drilldown map from a hypercube of location data. The geographic map allows you to visually display summary values associated with geo locations. The geographic map is delivered to the Cloud Portal and is refreshed with updated values every time the workflow action executes. view actions →
Add KPIs The Add KPIs function creates a collection of KPI result elements which measure whether a pass/fail criteria or objective is met. The KPI results are delivered to the Cloud Portal and are refreshed with updated values every time the workflow action executes. view actions →
Data Visualization The Data Visualization function creates an interactive data visualization element from a data collection or hypercube. The data visualization allows for interactive filterable and pivotable visualization componenets to be created and distributed via reports & dashboards. The data visualization result is delivered to the Cloud Portal and is refreshed with updated values every time the workflow action executes. view actions →
Hypercube Visualization The HyperCube Visualization function creates a multidimensional drill-down data visualization element from a hypercube. The HyperCube Visualization result is a special type of data visualization which can interactively summarize many different drill-down paths of data computed from a hypercube. The hypercube visualization result is delivered to the Cloud Portal and is refreshed with updated values every time the workflow action executes. view actions →

Additional Data Aggregation & Summarization Resources

Blog Posts
Post Description  
An End-to-End Automated Data Analytics Solution 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. view post →
A Powerful Way to Normalize / Flatten Any JSON Data for Analysis Flattening JSON data is often a difficult task. In this blog post, I demonstrate how to consume any JSON based data source into structured data for analysis. This blog post focuses on using the normalization adapter to automatically create relational tables from web and file-based JSON based sources. The technique outlined in this blog post will allow you to integrate tens of thousands of data sources on-demand and with no code. view post →
A Quick Data Cleansing Tutorial This blog post provides a worked example of an end-to-end data cleansing workflow. This blog post demonstrates how to load in dirty data, analyze the different data quality issues present, apply series of transformations to correct the data quality issues, and how to build a hypercube to summarize the tidy data. view post →
Flow Crash Course - Part 3 - Working Data Actions This is the third blog post in our crash course series on Flow. In this blog post, I provide an introduction to Working Data Point Actions in the Flow Computing Framework. view post →
Flow Crash Course - Part 5 - Generic Expressions and Data Point Computing This is the fifth blog post in our crash course series on Flow. In this blog post, I provide an introduction to Generic Expressions in the Flow Computing Framework. view post →
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 introduction to HyperCube Computation in the Flow Computing Framework. view post →
How to Build Automated HyperCube-Based Business Intelligence Dashboards In this blog post I provide a worked example demonstrating the development of hypercube BI dashboards. I show how to compute hypercubes from raw data and use those hypercubes to create different views of our data. I then demonstrate the power of Flow's data visualization and pivot engine by creating components which allow for multiple levels of filtering and interactivity. I finish the example by designing an interactive dashboard with the results and showing how to distribute the finished reports 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. view post →
A Quick Introduction to the Five Types of Filters in Flow In this blog post, I provide an introduction to the five filter actions in Flow. Filter actions are functions which select a specific subset of records from a designated data collection based on some target match criteria. This blog post introduces the different types of filters and provides a comprehensive worked video example demonstrating how to configure and implement these filters against a sample data collection. The filter actions are some of the most elementary and integral operations in the Flow computing framework. Mastering the different types of filters is key to data processing, data analytics, and business intelligence workflow design. view post →
How to Import and Analyze Common File Data Sources In this blog post, I provide a worked example demonstrating how to import and analyze different types of file-based data sources. File-based data sources are ubiquitous in business data analytics. This blog post focuses on how to work with data stored in delimited files, Excel workbooks, and XML documents. I provide an overview of each of these three data source types as well as a detailed explanation of the challenges of working with XML. I demonstrate how Flow is capable of automatically normalizing any XML irrespective of hierarchical complexity into structured data sets for analysis. I explain the advantages of the Flow approach to XML over traditional alternatives such as XPath. I finish the example by demonstrating basic analytics against the consolidated data by constructing and computing across various hypercubes. view post →
Perform a Word Count Analysis Using Flow This article demonstrates how to perform a word count analysis in Flow. In this blog post, I provide a worked example showing how to take in unstructured natural language data and compute a unigram language model against that data. The result of the language analysis returns a new profile dataset which holds each unique token present in our natural text and the count of times each word occurred. This blog post teaches a quick one-step technique for doing an initial exploratory analysis of unstructured text data. view post →
Denormalize - Join Datasets using Flow Analytics This blog post demonstrates how to configure the denormalize function to join disconnected data sets together. I provide a worked example that shows how to first import then join a collection of delimited files. After denormalizing the data, I show how to build and use a hypercube to aggregate and summarize the data. view post →
How to Perform a HyperCube Time Series Analysis This blog post provides a worked example of a hypercube time series analysis. Date expressions are used to extract and compute summary time dimensions from a raw datetime data point value. A hypercube is built on the extracted datetime dimensions. Time series computations are then performed on the hypercube to summarize changes in values over time. view post →
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 introduction to Basic Data Summary Functions in the Flow Computing Framework. view post →
Import and Analyze JSON data using Flow Analytics In this blog post, I provide a worked example demonstrating how to import and analyze data from JSON based sources. Flow allows for the consumption of JSON data into a tabular form for analysis without requiring any knowledge of structure or schema. I demonstrate how to leverage this functionality to read and flatten JSON from a web-based resource into a dataset. I then show how to apply transformations to the data by using the expression builder to calculate new data points on the fly. I show how to compute hypercubes against the flattened data and perform a simple language analysis, highlighting the ability to wrangle and analyze the data. Finally, I demonstrate how to export the transformed data to various file formats allowing us to persist the flattened set for use elsewhere. view post →
How to Analyze Blank / Missing Values in a Dataset In this blog post, I provide a worked example demonstrating how to perform an analysis of blanks on a target dataset. When analyzing data a typical first step is to get an understanding of where there are missing values. Identifying where there are missing values in your data can help you make more informed decisions about your analysis approach. view post →
Building Tables and Pivot Tables in Flow Analytics 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. view post →
An Introduction to Multidimensional Analysis This post presents a basic introduction to multi-dimensional analysis and analytics-oriented processing using Flow. It discusses datasets, measures, dimensions, and hypercubes; then it provides a step-by-step example of building a workflow to analyze some fictional A/B test data. view post →
Videos
Video Title Video Description  
Flow Tutorials - Fill Value FunctionThis video provides a worked example demonstrating how to use the Fill Value operator in the expression builder. The fill value operator allows you to fill a data point or variables value as part of your workflow.view video →
Flow Tutorials - Kaggle Data AnalysisThis video demonstrates the analytical capabilities of Flow by working through an exploratory analysis against sample data from Kaggle.view video →
Flow Tutorials - Euclidean DistanceThis video provides a worked example demonstrating how to configure and implement the Euclidean Distance operator in the expression builder.view video →
Flow Tutorials - LogBase10 FunctionThis video provides a worked example demonstrating how to configure and implement the LogBase10 arithmetic operator in the expression builder.view video →
Flow Tutorials - Log FunctionThis video provides a worked example demonstrating how to configure and implement the Logarithm operator in the expression builder.view video →
Flow Tutorials - CeilingThis video provides a worked example demonstrating how to configure and implement the Ceiling operator in the expression builder.view video →
Flow Tutorials - FloorThis video provides a worked example demonstrating how to configure and implement the Floor operator in the expression builder.view video →
Flow Tutorials - RoundToThis video provides a worked example demonstrating how to configure and implement the RoundTo operator in the expression builder.view video →
Flow Tutorials - Arithmetic MinThis video provides a worked example demonstrating how to configure and implement the Arithmetic Minimum operator in the expression builder.view video →
Flow Tutorials - Arithmetic MaxThis video provides a worked example demonstrating how to configure and implement the Arithmetic Maximum operator in the expression builder.view video →
Flow Tutorials - Absolute Value FunctionThis video provides a worked example demonstrating how to configure and implement the Absolute Value operator in the expression builder.view video →
Flow Tutorials - SubtractionThis video provides a worked example demonstrating how to configure and implement the Subtraction operator in the expression builder. This video shows how to subtract two data points and store the result of the operation as a new data point.view video →
Flow Tutorials - DivisionThis video provides a worked example demonstrating how to configure and implement the Division operator in the expression builder. This video shows how to divide two data points and store the result of the operation as a new data point.view video →
Flow Tutorials - AdditionThis video provides a worked example demonstrating how to configure and implement the Addition operator in the expression builder. This video shows how to add two data points and store the result of the operation as a new data point.view video →
Flow Tutorials - MultiplicationThis video provides a worked example demonstrating how to configure and implement the Multiplication operator in the expression builder. This video shows how to subtract two data points and store the result of the operation as a new data point.view video →
Flow Tutorials - Power FunctionThis video provides a worked example demonstrating how to configure and implement the Power operator in the expression builder.view video →
Flow Tutorials - Square RootThis video provides a worked example demonstrating how to configure and implement the Square Root operator in the expression builder.view video →
Flow Tutorials - Boolean Equality OperatorThis video provides a worked example demonstrating how to configure and implement the Boolean Equality operator in the expression builder.view video →
Flow Tutorials - NOr OperatorThis video provides a worked example demonstrating how to configure and implement the Boolean Nor (Not OR) operator in the expression builder.view video →
Flow Tutorials - Nand OperatorThis video provides a worked example demonstrating how to configure and implement the Boolean Nand (Not And) operator in the expression builder.view video →
Flow Tutorials - XORThis video provides a worked example demonstrating how to configure and implement the Boolean XOr (Exlusive OR) operator in the expression builder.view video →
Flow Tutorials - Bit OperatorThis video provides a worked example demonstrating how to configure and implement the Boolean Bit Transformation operator in the expression builder.view video →
Flow Tutorials - Not OperatorThis video provides a worked example demonstrating how to configure and implement the Boolean Not operator in the expression builder.view video →
Flow Tutorials - Or OperatorThis video provides a worked example demonstrating how to configure and implement the Boolean OR operator in the expression builder.view video →
Flow Tutorials - And OperatorThis video provides a worked example demonstrating how to configure and implement the Boolean And operator in the expression builder.view video →
Flow Tutorials - Get First Word FunctionThis video provides a worked example demonstrating how to configure and implement the Get First Word operator in the expression builder. The Get First Word operator allows you to extract the first word from a target string argument and is often used in natural language processing tasks.view video →
Flow Tutorials - Contains Non Alphanumeric FunctionThis video provides a worked example demonstrating how to configure and implement the ContainsNonAlphanumeric operator in the expression builder. The ContainsNonAlphanumeric is used to evaluate if target string values contain non-alphanumeric characters.view video →
Flow Tutorials - Remove SymbolsThis video provides a worked example demonstrating how to configure and implement the Remove Symbols operator in the expression builder.view video →
Flow Tutorials - Remove Alphabetic FunctionThis video provides a worked example demonstrating how to configure and implement the Remove Alphabetic operator in the expression builder.view video →
Flow Tutorials - Contains Alphabetic FunctionThis video provides a worked example demonstrating how to configure and implement the Contains Alphabetic operator in the expression builder.view video →
Flow Tutorials - Contains Numeric FunctionThis video provides a worked example demonstrating how to configure and implement the Contains Numeric operator in the expression builder.view video →
Flow Tutorials - First N Characters FunctionThis video provides a worked example demonstrating how to configure and implement the First N Characters operator in the expression builder.view video →
Flow Tutorials - Remove Numeric FunctionThis video provides a worked example demonstrating how to configure and implement the Remove Numeric operator in the expression builder.view video →
Flow Tutorials - Validate Email FunctionThis video provides a worked example demonstrating how to configure and implement the Validate Email operator in the expression builder.view video →
Flow Tutorials - Trim FunctionThis video provides a worked example demonstrating how to configure and implement the Trim operator in the expression builder.view video →
Flow Tutorials - Default Blanks FunctionThis video provides a worked example demonstrating how to configure and implement the Default Blanks operator in the expression builder.view video →
Flow Tutorials - EndsWith FunctionThis video provides a worked example demonstrating how to configure and implement the EndsWith operator in the expression builder.view video →
Flow Tutorials - StartsWith FunctionThis video provides a worked example demonstrating how to configure and implement the StartsWith operator in the expression builder.view video →
Flow Tutorials - Substring to End FunctionThis video provides a worked example demonstrating how to configure and implement the SubstringToEnd operator in the expression builder.view video →
Flow Tutorials - Last Index Of FunctionThis video provides a worked example demonstrating how to configure and implement the Last Index Of operator in the expression builder.view video →
Flow Tutorials - Word Count FunctionThis video provides a worked example demonstrating how to configure and implement the Word Count operator in the expression builder.view video →
Flow Tutorials - Remove Non-Numeric FunctionThis video provides a worked example demonstrating how to configure and implement the Remove Non-Numeric operator in the expression builder.view video →
Flow Tutorials - Format Phone FunctionThis video provides a worked example demonstrating how to configure and implement the Format Phone Number operator in the expression builder.view video →
Flow Tutorials - Replace HTML Tags FunctionThis video provides a worked example demonstrating how to configure and implement the Replace HTML Tags operator in the expression builder.view video →
Flow Tutorials - Contains HTML Tags FunctionThis video provides a worked example demonstrating how to configure and implement the Contains HTML Tags operator in the expression builder.view video →
Flow Tutorials - Remove Non Alpha Numeric FunctionThis video provides a worked example demonstrating how to configure and implement the Remove Non Alpha-numeric operator in the expression builder.view video →
Flow Tutorials - Substring FunctionThis video provides a worked example demonstrating how to configure and implement the Substring operator in the expression builder.view video →
Flow Tutorials - Contains FunctionThis video provides a worked example demonstrating how to configure and implement the Contrains String operator in the expression builder.view video →
Flow Tutorials - Replace StringThis video provides a worked example demonstrating how to configure and implement the Replace String operator in the expression builder.view video →
Flow Tutorials - Index Of FunctionThis video provides a worked example demonstrating how to configure and implement the Index Of operator in the expression builder.view video →
Flow Tutorials - Compute Length of StringThis video provides a worked example demonstrating how to compute the length of a string using the Length operator in the expression builder.view video →
Flow Tutorials - ProperCase FunctionThis video provides a worked example demonstrating how to configure and implement the ProperCase operator in the expression builder.view video →
Flow Tutorials - To Upper FunctionThis video provides a worked example demonstrating how to configure and implement the To Upper operator in the expression builder.view video →
Flow Tutorials - To Lower FunctionThis video provides a worked example demonstrating how to configure and implement the To Lower operator in the expression builder.view video →
Flow Tutorials - Concat With Space SeparatorThis video provides a worked example demonstrating how to configure and implement the Concat With Space Seperator operator in the expression builder.view video →
Flow Tutorials - Data Point AdditionThis video provides a worked example demonstrating how to perform addition operations against two data points.view video →
Flow Tutorials - Data Point MultiplicationThis video provides a worked example demonstrating how to perform multiplication operations against two data points.view video →
Flow Tutorials - Year Difference Date ArithmeticThis video provides a worked example demonstrating how to take the difference in years between two datetime data points by using the Year Difference Date Arithmetic operator.view video →
Flow Tutorials - Month Difference Date ArithmeticThis video provides a worked example demonstrating how to take the difference in months between two datetime data points by using the Month Difference Date Arithmetic operator.view video →
Flow Tutorials - Week Difference Date ArithmeticThis video provides a worked example demonstrating how to take the difference in weeks between two datetime data points by using the Week Difference Date Arithmetic operator.view video →
Flow Tutorials - Day Difference Date ArithmeticThis video provides a worked example demonstrating how to take the difference in days between two datetime data points by using the Day Difference Date Arithmetic operator.view video →
Flow Tutorials - Extract Day of Week StringThis video provides a worked example demonstrating how to configure and implement the Extract Day of Week String operator in the expression builder.view video →
Flow Tutorials - Extract Month StringThis video provides a worked example demonstrating how to configure and implement the Extract Month String operator in the expression builder.view video →
Flow Tutorials - Extract QuarterYear String FunctionThis video provides a worked example demonstrating how to configure and implement the Extract QuarterYear String operator in the expression builder.view video →
Flow Tutorials - Extract Quarter String FunctionThis video provides a worked example demonstrating how to configure and implement the Extract Quarter String operator in the expression builder.view video →
Flow Tutorials - Add/Subtract HoursThis video provides a worked example demonstrating how to add and subtract hours from a target datetime data point using the Add Hours operator in the expression builder.view video →
Flow Tutorials - Add/Subtract DaysThis video provides a worked example demonstrating how to add and subtract days from a target datetime data point using the Add Days operator in the expression builder.view video →
Flow Tutorials - Extract Days From NowThis video provides a worked example demonstrating how to compute the distance in days between a target datetime and the current date using the Days From Now operator in the expression builder.view video →
Flow Tutorials - Extract Hours From Now FunctionThis video provides a worked example demonstrating how to compute the distance in hours between a target datetime and the current date using the Hours From Now operator in the expression builder.view video →
Flow Tutorials - Minutes From Now FunctionThis video provides a worked example demonstrating how to compute the distance in minuets between a target datetime and the current date using the Minutes From Now operator in the expression builder.view video →
Flow Tutorials - From Unix Time Stamp FunctionThis video provides a worked example demonstrating how to configure and implement the From Unix Timestamp operator in the expression builder.view video →
Flow Tutorials - To Unix TimeStamp FunctionThis video provides a worked example demonstrating how to configure and implement the To Unix Timestamp operator in the expression builder.view video →
Flow Tutorials - Extract Numeric YearMonthThis video provides a worked example demonstrating how to configure and implement the Extract Numeric YearMonth operator in the expression builder.view video →
Flow Tutorials - Extract Numeric YearQuarterThis video provides a worked example demonstrating how to configure and implement the Extract Numeric YearQuarter operator in the expression builder.view video →
Flow Tutorials - Extract Numeric WeekdayThis video provides a worked example demonstrating how to configure and implement the Extract Numeric Weekday operator in the expression builder.view video →
Flow Tutorials - Extract Numeric WeekThis video provides a worked example demonstrating how to configure and implement the Extract Numeric Week operator in the expression builder.view video →
Flow Tutorials - Intro to Pop ChunkThis video provides a worked example demonstrating how to configure and implement the Pop Chunk function.view video →
Flow Tutorials - Extract Numeric Day of MonthThis video provides a worked example demonstrating how to configure and implement the Extract Numeric Day of Month operator in the expression builder.view video →
Flow Tutorials - Extract Day of YearThis video provides a worked example demonstrating how to configure and implement the Extract Day of Year operator in the expression builder.view video →
Flow Tutorials - Extract Numeric MonthThis video provides a worked example demonstrating how to configure and implement the Extract Numeric Month operator in the expression builder.view video →
Flow Tutorials - Converting Data Types and Generic ExpressionsThis video provides a guided introduction to data types in Flow. This video looks at how to to interconvert data types in a target generic data collection by using the Change Data Type function.view video →
Flow Tutorials - Add Data Point ActionThis video provides a worked example demonstrating how to configure and implement the Add Data Point action. The Add Data Point action allows you to add a data point with a default initial value to a target dataset.view video →
Flow Tutorials - Remove Data Points ActionThis video provides a worked example demonstrating how to configure and implement the Remove Data Points action in Flow.view video →
Flow Tutorials - Slice FunctionThis video provides a worked example demonstrating how to configure and implement the Slice function in Flow.view video →
Flow Tutorials - Reverse Generic Data CollectionThis video provides a worked example demonstrating how to configure and implement the Reverse Collection special function.view video →
Flow Tutorials - Foreach LoopsThis video provides an introduction to Foreach loops in Flow. This video provides a worked example demonstrating how to configure and implement a foreach loop using the Foreach workflow control action.view video →
Flow Tutorials - Compound Filter ExpressionThis video provides a worked example demonstrating how to configure a compound filter expression. This video teaches how to use the Filter Expression builder to add a workflow action which performs a complex filter on a set of joint conditional evaluations.view video →
Flow Tutorials - Extract Numeric QuarterThis video provides a worked example demonstrating how to configure and implement the Extract Numeric Quarter operator in the expression builder.view video →
Flow Tutorials - Fast Correlation Analysis Summary FunctionThis video provides a worked example demonstrating how to configure and implement the Fast Correlation Analysis summary function. This video teaches how to test correlations against a target data point of interest.view video →
Flow Tutorials - Variable InstantiationThis video provides a worked example demonstrating how to configure and implement the Add Variable action in Flow. This video looks at variable instantiation and how variables can be used to create control structures and as input to expressions.view video →
Flow Tutorials - Extract Year FunctionThis video provides a worked example demonstrating how to configure and implement the Extract Year operator in the expression builder.view video →
Flow Tutorials - Sum and DivisionThis video provides a worked example demonstrating how to configure and implement a compound expression using the Sum and Division operators.view video →
Flow Tutorials - Simple Filter ExpressionThis video demonstrates how to build a simple Filter expression in Flow. This video looks at how to use the Filter expression builder and narrow down elements that match or do not match a simple filter criteria.view video →
Flow Tutorials - Data Point Arithmetic MeanThis video provides a worked example demonstrating how to configure and implement the Arithmetic Mean statistical operator against a single data point using the expression builder.view video →
Building Arithmetic ExpressionsThis video provides a guided tutorial on how to create different types of arithmetic expressions using the expression builder.view video →
Intro to Working Data ObjectsThis video provides an introduction to Working Data objects in Flow. This video examines the 3 types of objects in a working data container - Datasets, HyperCubes, and Variables.view video →
Flow Tutorials - HyperCube ComputingThis video provides a worked example of multidimensional analysis and hypercube computing using Flow.view video →
Flow Tutorials - Twitter InterfaceThis video demonstrates how to connect to and pull data from Twitter using the Twitter Integration Interface.view video →
Flow Tutorials - DeduplicationThis video provides a worked example demonstrating how to implement and configure the deduplicate data operation in Flow. The deduplication operation is used to identify and remove duplicate values from a dataset based on a set of key datapoints.view video →
Flow Tutorials - Consume Crypto DataThis video demonstrates Flow's ability to connect to and consume data from any API without requiring code. This video looks at connecting to a Cryptocurrency Market Data API and shows how to automatically connect to and structure the data into an in-memory set for analysis.view video →
Flow Tutorials - Denormalization and HyperCubesThis video demonstrates a typical analysis process in Flow. This video gives a worked example showing how to join and denormalize data coming from various flat files. Datasets are flattened and transformed using the denormalization action and then converted into hypercubes for multidimensional analysis.view video →
Flow Tutorials - Portal SortThis video demonstrates how to use the Sort function in the Cloud Portal to perform a simple sort of a dataset.view video →
Flow Tutorials - Add Sample DataThis video demonstrates how to Add Sample Data to your Flow account from within the Flow Cloud Portal.view video →
Flow Tutorials - How to Launch Cloud ConnectThis video demonstrates how to launch the Cloud Connect workflow editor environment from within the Flow Cloud Portal.view video →
Getting Started With Flow - A Guided IntroductionThis video provides a guided introduction to the workflow development process in Flow. This video shows how to load sample data from the cloud, transform the data using various expressions, compute hypercubes, and how to design a dashboard which presents the results of the analysis.view video →
Flow Tutorials - Index FunctionThis video provides a worked example demonstrating how to configure and implement the Index function in Flow.view video →
Flow Tutorials - HyperCube CorrelationThis video provides a worked example demonstrating how to compute correlations across a hypercube in Flow. HyperCube Correlations allow you to compute correlations across your data in a multidimensional context.view video →
Flow Tutorials - Import Database TablesThis video provides a worked example demonstrating how to import relational database tables into Flow. This video shows how to use the Database Integration Interface to target tables from a database and load them into Flow's generic data for analysis.view video →
Flow Tutorials - HyperCube K-Means ClusterThis video demonstrates how to perform a K-Means cluster using the Machine Learning actions in Flow. After the K-Means cluster model is trained, this video demonstrates how to use the hypercubes to aggregate and summarize the results.view video →
Flow Tutorials - Text Analytics W/ Watson Cognitive AIThis video provides a worked example demonstrating how to perform various types of cognitive analytics against unstructured text using the Watson Cognitive AI actions in Flow.view video →
Flow Tutorials - HyperCube Time Series AnalysisThis video provides a worked example demonstrating how to perform a HyperCube Time Series analysis in Flow. This video takes a look at the Moving Difference time series operator evaluated across a hypercube which aggregates target data by a time period of interest.view video →
Flow Tutorials - Sample DataThis video provides a worked example demonstrating how to configure and implement the Sample Data action to take a random sample of a target dataset.view video →
Flow Tutorials - Filter Top NThis video provides a worked example demonstrating how to configure and implement the Filter Top N action to identify the Top/Bottom N values in a target dataset.view video →
Flow Tutorials - Describe Data FunctionThis video provides a worked example demonstrating how to configure and implement the Describe Data action to generate a summary statistics profile of a target dataset.view video →
Flow Tutorials - Correlation Analysis Summary FunctionThis video provides a worked example demonstrating how to configure and implement the Correlation Analysis summary function to evaluate all correlations against a target numeric data point.view video →
Flow - Word Count ExampleThis video provides a worked example demonstrating how to configure and implement the Language Summary function to generate a bag-of-words language model from a target string data point.view video →
Flow Tutorials - How to Use the Concat OperatorThis video provides a worked example demonstrating how to configure and implement the Concat operator in the expression builder.view video →
Flow - Train and Evaluate a Neural NetworkThis video provides a worked example demonstrating how to train and evaluate a neural network against the sample Iris dataset using Flow.view video →
Flow - Wrangle JSONThis video provides a worked example demonstrating how to connect and consume any JSON-based data source using Flow.view video →
Flow Tutorials - Train and Evaluate a Neural NetworkThis video provides a worked example demonstrating how to train and evaluate a neural network against the sample Iris dataset using Flow.view video →
Flow Tutorials - Train and Evaluate a Linear ModelThis video provides a worked example demonstrating how to train and evaluate a linear model using the Linear Regression workflow action.view video →
Flow Tutorials - Watson Cognitive Keyword ExtractionThis video demonstrates how to use the Watson AI Cognitve actions in Flow to analyze unstructured text.view video →
Flow Tutorials - Denormalization ExampleThis video provides a worked example of denormalization in Flow. This video demonstrates importing data from various flat files and joining the datasets together into a single dataset for analysis.view video →
Flow Tutorials - Word Count ExampleThis video demonstrates how to perform an analysis of language on unstructured text data. This video shows how to use the Language Summary analysis function to evaluate a word count across all text values in a target string data point.view video →
Flow Tutorials - Analysis of BlanksThis video demonstrates how to perform an analysis of blank or missing values in a dataset.view video →
Flow Tutorials - Import and Analyze MS AccessThis video provides a worked example demonstrating how to import and analyze a MS Access database. This video shows the computational power of Flow by flattening the target database and performing a multidimensional hypercube analysis against the data.view video →
Flow Tutorials - Import and Analyze JSONThis video demonstrates Flow's unique ability to consume any JSON source without requiring knowledge of schema or structure. JSON data from a target public api endpoint is absorbed by Flow.view video →
Flow + Watson Cognitive SEO Keyword ResearchThis video provides a guided tutorial on how to use Flow + Watson AI to perform SEO keyword research.view video →
Flow + Artificial Intelligence News AnalysisThis video demonstrates Flow's artificial intelligence capabilities by using AI to consume and analyze cryptocurrency news articles.view video →
Sample Workflows
Articles and Links
Get Started With Flow Analytics Workflows

Completely free - no trial period or credit card required.

Fully functional - access all the core features of the Flow platform.

Develop custom workflows - use our advanced, configure-not-code development environment to build custom solutions.

Free help and support - full documentation and how-to videos along with free online, telephone or email support.