Open Source Business Intelligence



 

Open Source Business Intelligence framework

 

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

Helical Insight’s self-service capabilities is one to reckon with. It allows you to simply drag and drop columns, add filters, apply aggregate functions if required, and create reports and dashboards on the fly. For advanced users, the self-service component has ability to add javascript, HTML, HTML5, CSS, CSS3 and AJAX. These customizations allow you to create dynamic reports and dashboards. You can also add new charts inside the self-service component, add new kind of aggregate functions and customize it using our APIs.
Helical Insight’s self-service capabilities is one to reckon with. It allows you to simply drag and drop columns, add filters, apply aggregate functions if required, and create reports and dashboards on the fly. For advanced users, the self-service component has ability to add javascript, HTML, HTML5, CSS, CSS3 and AJAX. These customizations allow you to create dynamic reports and dashboards. You can also add new charts inside the self-service component, add new kind of aggregate functions and customize it using our APIs.
Helical Insight, via simple browser based interface of Canned Reporting module, also allows to create pixel perfect printer friendly document kind of reports also like Invoice, P&L Statement, Balance sheet etc.
Helical Insight, via simple browser based interface of Canned Reporting module, also allows to create pixel perfect printer friendly document kind of reports also like Invoice, P&L Statement, Balance sheet etc.
If you have a product, built on any platform like Dot Net or Java or PHP or Ruby, you can easily embed Helical Insight within it using iFrames or webservices, for quick value add through instant visualization of data.
If you have a product, built on any platform like Dot Net or Java or PHP or Ruby, you can easily embed Helical Insight within it using iFrames or webservices, for quick value add through instant visualization of data.
Being a 100% browser-based BI tool, you can connect with your database and analyse across any location and device. There is no need to download or install heavy memory-consuming developer tools – All you need is a Browser application! We are battle-tested on most of the commonly used browsers.
Being a 100% browser-based BI tool, you can connect with your database and analyse across any location and device. There is no need to download or install heavy memory-consuming developer tools – All you need is a Browser application! We are battle-tested on most of the commonly used browsers.
We have organization level security where the Superadmin can create, delete and modify roles. Dashboards and reports can be added to that organization. This ensures multitenancy.
We have organization level security where the Superadmin can create, delete and modify roles. Dashboards and reports can be added to that organization. This ensures multitenancy.
We have organization level security where the Superadmin can create, delete and modify roles. Dashboards and reports can be added to that organization. This ensures multitenancy.
We have organization level security where the Superadmin can create, delete and modify roles. Dashboards and reports can be added to that organization. This ensures multitenancy.
A first-of-its-kind Open-Source BI framework, Helical Insight is completely API-driven. This allows you to add functionalities, including but not limited to adding a new exporting type, new datasource type, core functionality expansion, new charting in adhoc etc., at any place whenever you wish, using your own in-house developers.
A first-of-its-kind Open-Source BI framework, Helical Insight is completely API-driven. This allows you to add functionalities, including but not limited to adding a new exporting type, new datasource type, core functionality expansion, new charting in adhoc etc., at any place whenever you wish, using your own in-house developers.
It handles huge volumes of data effectively. Caching, Pagination, Load-Balancing and In-Memory not only provides you with amazing experience, but also and does not burden the database server more than required. Further effective use of computing power gives best performance and complex calculations even on the big data even with smaller machines for your personal use. Filtering, Sorting, Cube Analysis, Inter Panel Communication on the dashboards all at lightning speed. Thereby, making best open-source Business Intelligence solution in the market.
It handles huge volumes of data effectively. Caching, Pagination, Load-Balancing and In-Memory not only provides you with amazing experience, but also and does not burden the database server more than required. Further effective use of computing power gives best performance and complex calculations even on the big data even with smaller machines for your personal use. Filtering, Sorting, Cube Analysis, Inter Panel Communication on the dashboards all at lightning speed. Thereby, making best open-source Business Intelligence solution in the market.
With advance NLP algorithm, business users simply ask questions like, “show me sales of last quarter”, “average monthly sales of my products”. Let the application give the power to users without knowledge of query language or underlying data architecture
With advance NLP algorithm, business users simply ask questions like, “show me sales of last quarter”, “average monthly sales of my products”. Let the application give the power to users without knowledge of query language or underlying data architecture
Our application is compatible with almost all databases, be it RDBMS, or columnar database, or even flat files like spreadsheets or csv files. You can even connect to your own custom database via JDBC connection. Further, our database connection can be switched dynamically based on logged in users or its organization or other parameters. So, all your clients can use the same reports and dashboards without worrying about any data security breech.
Our application is compatible with almost all databases, be it RDBMS, or columnar database, or even flat files like spreadsheets or csv files. You can even connect to your own custom database via JDBC connection. Further, our database connection can be switched dynamically based on logged in users or its organization or other parameters. So, all your clients can use the same reports and dashboards without worrying about any data security breech.
Our application can be installed on an in-house server where you have full control of your data and its security. Or on cloud where it is accessible to larger audience without overheads and maintenance of the servers. One solution that works for all.
Our application can be installed on an in-house server where you have full control of your data and its security. Or on cloud where it is accessible to larger audience without overheads and maintenance of the servers. One solution that works for all.
Different companies have different business processes that the existing BI tools do not encompass. Helical Insight permits you to design your own workflows and specify what functional module of BI gets triggered
Different companies have different business processes that the existing BI tools do not encompass. Helical Insight permits you to design your own workflows and specify what functional module of BI gets triggered