2018-05-07

A Powerful Way to Normalize / Flatten Any JSON Data for Analysis

A Powerful Way to Normalize / Flatten Any JSON Data for Analysis


Flattening JSON data is often a difficult task. The tree-based nature of this data structure can make converting it into normalized tables anything but straightforward.

In this blog post, I present the fastest and most effective way of normalizing any JSON based data source into generic data collections for analysis. This blog post will demonstrate an extremely powerful technique that will allow you to consume and normalize JSON data from any api or file-based source instantly with no code. By mastering this technique - you will effectively be able to integrate tens of thousands of data sources on demand without having to worry about writing a line of code.

This blog post will demonstrate how to consume and flatten JSON from:

  1. A web-based source
  2. File-based source
  3. RESTful API

The technique outlined in this blog post will add a powerful tactic to your data analytics toolbelt and will allow you to consume any JSON instantly.

If you do not have a Flow account - register here. Flow is FREE for personal use.

Check out the 10-minute video here: