Introduction

This JAMSTACK analytics is powered by SQL Frames, an in-memory analytics engine that runs entirely within the browser (no browser extensions required) and can process reasonably large sizes of data (million rows easily) and ideal for many enterprise use cases. Even with big data, it can serve as an in-browser accelerator where the heavy lifting is done on the backend and the final interactivity is performed on the browser.

For instructions on how to configure your docusaurus site to embed SQL Frames, review sqlframes-jamstack-analytics.

Why use this software?

Rapid prototyping

Traditionally a lot of time spent from gathering the requirements from the business users to actually delivering the analytics only to discover that the initial assumptions are not valid (perhaps due to data distribution) or the visuals don't look good to easily understand the data forcing everyone to go back to the drawing board. The reason for the long cycles is the fact that the data needs to be extracted from the source systems, transformed and loaded into the target systems before the final visuals can be developed. Fixing data models becomes mundane, error-prone chore forcing IT to spend more time on non-productive tasks and hence the delay in providing the value to the business.

Delightful UX

Once the data is loaded into the browser, all subsequent data transformations are done directly within the browser resulting in sub-second latency. This provides a smooth data analysis and interactivity UX making it delightful to work with data rather than dread the loading spinners.

Visualization, your way

Most visualization software provide a specific way of creating dashboards or rendering the visuals without giving options for being creative. For example, to present the quarterly results to the BU heads and the C-level executives as a blog or a story board mixing all the numbers with the narrative. By providing the analytics on a JAMSTACK powered by React and a powerful low-code SQL Frames API, you can decide on investing as much on the UX as desired by creating custom components.

Low-code declarative API

The API is based on familiar SQL constructs and just a few lines of code provides a lot of interactivity and no-code data exploration UX.

Analytics as code

While many tools provide their own file formats to store the analytics, this JAMSTACK integration of SQL Frames allows creating analytics as code that can be source controlled. This allows proper audit and the ability to reproduce the exact same report at a later time.