Are there BI/OLAP tools for the MEAN.JS platform?

Question

Someone can indicate me a BI/ OLAP framework or at least a Chart Engine, preferably open-source, that integrates properly the platform MEAN.JS or MEAN IO architecturally SPA - Single Page Application?

I know the Keen.io. It is free in low transactional volume, but is not open-source.

The Pentaho is a great open-source BI tool, features Restful Services and supports Mongodb, but your Dashboard still advocates server-side Java and is one generation behind frameworks like Angular.JS and Node.JS, because they’re only migrating now to jQuery and Bootstrap.

Thank you for any contribution.

Answer 1

There is an open-source option, which is Cubes, which uses the Slicer tool http://cubes.databrewery.org/

It is made in Python and has a Javascript client library: https://github.com/Stiivi/cubes.js/

You can configure and use this tool as an OLAP server and run queries through javascript directly in the browser and get the result as JSON.

References: https://stackoverflow.com/questions/25133209/olap-server-for-nodejs

Answer 2

Discovery 1

There is an amazing API, similar to jQuery in order to manipulate the GIFT for you to compose Chart charts, call D3.JS - Data-Driven Documents - d3js.org

Discovery 2

There is a Charts mechanism called NVD3 - nvd3.org, built on top of D3.JS, that allows you to employ reusable Chart components in your applications Javascript.

Discovery 3

There is a module Angular.JS called Angularjs-NVD3-Directives http://cmaurer.github.io/angularjs-nvd3-directives/, integrating the Chart components of NVD3 within directives of Angular.JS, allowing you to use them natively in your applications Angular.JS.

The Open Source Solution for MEAN Stack

You can integrate components Angularjs-NVD3-Directives with Pentaho Restful services via Mongoose accessing your data Mongodb to build control panels (dashboards and Scoreboards) for your applications.

You’ll still need to write code to integrate each of the components of a control panel such as grid layout, themes, field projection and visibility, filter, sorting, dynamic tables (pivot) and Chart charts.

Today, the process of developing control panels is not simple and straightforward, but you already have an open source solution good enough to design impressive applications.