Helical Insight Open Source Business Intelligence Framework

Helical Insight software is world’s first Open Source Business Intelligence framework which helps you to make sense out of your data and make well informed decisions. Helical Insight is an open source business intelligence framework which is developer friendly. Creation and consumption of Business Intelligence solution is completely web based. Helical Insight uses Java as back end and HTML, JavaScript as its front end.

Helical Insight allows you to connect to any database, flat files, big data, API or any other custom data source.

Get Helical Insight Today
Choose the best open source business intelligence framework.

Strat your Free Trial

For reports and dashboards creation, it allows three methods:

  1. Instant BI : With an integrated machine learning and NLP, it allows you to just type your question and get instant business answers. This could be in terms of reports, dashboards, geographical dashboard etc. The same interface could also be used for customizing. At the backend complex algorithms understand the context, improves the vocab, apply filters, apply mathematical functions etc and show the relevant result.
  2. Self service BI : For slightly advanced user it provides option to drag and drop, add filters and create reports and dashboards on the fly without any technical knowledge. It has placed holders to add javascript, HTML, CSS, AJAX etc for further customization. The metadata layer here as well has the option of adding SQLQuery.
  3. Canned Reporting Module: : If your requirement is more on the traditional multi page pixel perfect document kind of reporting side then we do provide a new interface called canned reporting module also. Thus you can create reports like invoices, salary slips, bank statements, P&L statements etc.
  4. EFW : For advanced users like developers it also allows the option to use any editor and create analysis. This is something akin to Periscope allowing to write SQLQuery, HTML, CSS, JS and create a very very complex analysis as well.

Helical Insight can also work in an in-memory mode as well. It is having all the features which we generally expect from any BI product like caching, alerting and notification, email scheduling, exporting, self service interface, user role management, data security, metadata layer etc. Aside the entire frontend and backend is in the form of framework giving it an extensive flexibility.

Some of the USP of helical Insight includes :

  1. Business Intelligence Framework : Helical Insight is a completely API driven tool. Thus any functionality can be added and extended at the front end or back end. Use cases includes adding a new chart, adding a new exporting type, adding a new data source layer, adding a new security layer, fetching data directly from ETL, building outlook plugin of BI etc.

    Today with most of the tool if you want any new functionality you will have to depend on the vendor, but with us at each and every place we provide APIs which can be used to extend the functionalities. Functionalities can be added not only at the front end layer but also at back end layer.

    With today’s breakneck speed at which technology is changing, it is imperative that the solution which you build should be able to adapt for future technologies and that was the entire thought process behind developing a BI framework.

  2. Workflow : Helical Insight is the first tool in the market to come with an inbuilt workflow This allows you to define which action will happen, when it will happen and how will it happen. You can call our extensive API or you can also call external APIs as well and implement any action like time driven cache refresh, client specific white labeling, end to end BI automation, triggering some actions when data touches certain values etc.
  3. Canned Reporting : Helical Insight is one of the rare BI product which gives the ability to create both traditional document kind of pixel perfect report (like crystal report, SSRS etc) as well as new generation drag drop based dashboard and data visualization with our product.
  4. API Driven Interface: Helical Insight is a first completely API driven interface. It empowers developers to add functionalities without depending on the vendor. Every frontend functionality is supported by API. Using API you can do any of the functions like adding new charts inside adhoc, adding new chart customization types, add any new database support, new exporting type, new DBfunction, new aggregate function etc.
  5. Code Insertion:There are various placeholders which allow you to insert codes like Javascript, HTML, CSS, SQLQuery, Groovy code, Java etc. This gives it pretty strong flexibility.
  6. Open Source:Being open source you also get access to the source code as well as access to enterprise kind of features at a very cost affective rates in comparison to Periscope. It has a transparent pricing which is not dependent on the data size, number of users etc.

Please visit our home page to know more about features we provide: Open Source Business Intelligence – Helical Insight