Data to Decisions

Automation, Integration, Analytics, Reports & Dashboards

Import and Analyze JSON Data with Flow Analytics

Overview In this blog post, I provide a worked example demonstrating how to import and analyze data

Overview

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.

How to Import and Analyze JSON Data with Flow Analytics