Helical Insight is an Open Source Business Intelligence (BI)Framework which is used for creating reports and dashboards from a variety of data sources. You can be using relational databases, NoSQL databases or columnar databases; you can connect to your database in 4 easy steps. Helical Insight is one of the best business intelligence tools for SQLite and it supports connection to SQLite using a relevant JDBC driver that can be found here. Once connected, you can quickly start creating the reports in under 10 minutes. You can easily connect to SQLite using our documentation on connecting datasources.
Reporting for SQLite
Helical insight also has a module called canned reporting. With this module it is possible to create pixel perfect canned reports also for SQLite. The adhoc module and the dashboard designer module allows creation of charts, data visalization, maps, infographs and dashboard for SQLite.
Helical Insight has a simple drag and drop interface to create reports, dashboards, infographs, map based analytics and canned reports using the columns of your SQLite database. You can use the various visualizations and customizations available readily or you can insert your own JS and CSS to create your own customizations. What’s more, you can cache the query results and set your own cache refresh times. The extensible database feature gives you the freedom to change databases at any point in time, while using the same reports. The reports are easily shareable using the URL and can be viewed on all popular web browsers. You can also embed the reports in your product or website. Helical Insight also supports various types of SSO including LDAP, CAS, ADFS, OAuth, Open Source authentication mechanism.
Key Benefits of Helical Insight:
- Easy drag and drop interface for creation of reports, dashboards, canned reports, map analytics and infographs.
- In-built workflow engine which can be used to define various workflows.
- It is one of the few business intelligence tools for SQLite that supports threshold based alerting as well as dynamic database switching.
- The tool has API-first architecture. Every functionality is supported by an API at the backend, giving more flexibility during integration with any product.
- Easy scheduling of reports and dashboards
- No data storage, so data security is enhanced
- Add your own JS, CSS, visualizations and database functions
- Easily white label the application
Helical Insight is a business intelligence tool especially popular among SMEs and startups that are looking for more flexibility in creating reports while keeping costs minimal. Product companies looking to integrate and embed dashboards into their product choose Helical Insight as the preferred business intelligence software for SQLite. The tool is available in two versions – community edition which is free of cost and an enterprise edition which is reasonably priced and offers a plethora of options with its drag and drop interface and canned reports interface. A free trial of the enterprise edition is available here. The extensive product blog and forum provide excellent step by step instructions on the product usage.
You can refer to the following links to know more about this unique open source BI tool:
Getting started : https://www.helicalinsight.com/getting-started/getting-started-hi/
User Guides : https://www.helicalinsight.com/guide/
Video Guides : https://www.helicalinsight.com/videos/
Getting started with metadata: https://www.helicalinsight.com/ad-hoc-report-module/create-and-edit-metadata/
Getting started with Adhoc: https://www.helicalinsight.com/getting-started/getting-start-with-adhoc-designer/
Getting started with user role management: https://www.helicalinsight.com/getting-started/user-role-management/
Getting started with Dashboard designer: https://www.helicalinsight.com/dashboard-designer-customization/dashboard-designer-overview/
White Labelling : https://www.helicalinsight.com/helicalinsight-v1-0-0/white-labelling/
Whereas if you are looking to use our Community Free version then you can find the documentation information here in the category “Community Reporting” Reach out to us at email@example.com in case of any questions