With version 7.1.0.366 RC1 of Open Source BI product Helical Insight, Instant BI introduces three new modes to handle user questions: Auto, Fast, and Think.

Instant BI Modes – Auto, Fast, and Think Modes

1. Auto Mode

Auto Mode automatically identifies the complexity of a user’s question and selects the appropriate approach.

  • For simple questions, it provides a direct answer using fast mode.
  • For complex questions, it uses Think Mode for deeper analysis.

2. Fast Mode

Fast Mode is designed to provide quick answers to straightforward questions using a direct question-and-answer approach.

Instant BI Modes – Auto, Fast, and Think Modes

Example:

“What is the total travel cost this month?”

Instant BI Modes – Auto, Fast, and Think Modes

3. Think Mode

In Think Mode, the LLM breaks a complex business question into smaller supporting questions (also called sub-questions) and analyzes them before preparing the final response. These supporting questions are displayed in the response along with the analysis.

Think mode can be used to ask advanced questions like:

Forecasting Kind of Questions

  • Based on historical trends, what are the expected travel costs and travel volumes for the next year?
  • Which travel types and travel mediums are expected to have the highest usage in the next year?

Decision Kind of Questions (for Strategy & Action)

  • What areas should be considered to reduce meeting cancellations and their associated travel expenses?
  • What areas should management focus on to reduce travel expenses while maintaining travel volume and positive meeting outcomes?

Root Cause Analysis Kind of Questions

  • Why do some clients have higher meeting cancellation levels and different meeting impacts than others?
  • What factors contribute to higher travel expenses across different travel mediums and booking platforms?

History & Pattern

  • How have travel costs and meeting volumes changed over the years?
  • How have meeting cancellations varied by client and cancellation reason over the years?

Example: Think Mode Analysis

Example: “Which booking platforms and payment modes should be investigated for travel cost optimization?”

When a complex question like this is asked, Instant BI model automatically switches to auto mode. Then the application thinks and figures out the list of all the sub-questions which might be required to answer this complex question. Then the AI of Helical Insight application gets the answers of all of these questions. We can see the list of all the questions and their respective answers also in the response.

After getting all the responses, it co-relates all the responses and then gives a single answer to the asked question.

Instant BI Modes – Auto, Fast, and Think Modes

At the answer, we can also see that there are attributions present, such as [1] and [2], clicking on which it opens the corresponding supporting questions from which this information is received.

Instant BI Modes – Auto, Fast, and Think Modes

Users can also click the arrow at the right end of a supporting question to expand it and view the answer or analysis generated for that question.

Summary

  • Auto: Automatically selects the appropriate mode.
  • Fast: Provides quick answers to simple questions.
  • Think: Performs deeper, multi-step analysis for complex questions.

Exploring Instant BI Response Actions

In Instant BI, users can inspect how the LLM processes a question and work with the visualizations generated in response. The available actions help users understand the analysis, adjust filters, change the chart type, and continue editing in Helical Insight Report Designer.

1. Understanding LLM Processing

The response section provides options to understand how the LLM analyzed the question and generated the answer. Hover over the available icons to view the name of each function, such as “Working”.

These details help users inspect how a question was handled in Fast or Think Mode, including the supporting questions, analysis steps, and perspectives considered by the LLM.

Instant BI Modes – Auto, Fast, and Think Modes

2. Available Visualization Actions

At the top we are having the below kind of options on a created analysis.

Instant BI Modes – Auto, Fast, and Think Modes

Option Description
Maximize First option is maximize, allowing you to maximize this chat and see it in a full screen. Once maximized, at the top right you have the option to close the full screen mode.
Preview By default the AI assisted analytics opens in preview mode.
Semantic Fourth option is semantic option. This option opens up information of various things like which all tables and columns, dimensions etc were used to create this analysis. We can also see the number of tokens (input and output token) were used to create this analysis, model used etc.
SQL This option allows you to see the SQL which got generated and verify it. This option is more useful for technical users.

And at the bottom of the created AI analysis, we have the below set of options.

Instant BI Modes – Auto, Fast, and Think Modes

2.1. Change Visualization

Allows users to change the visualization type without consuming additional LLM tokens. Users can select from the available chart types, such as Bar, Line, Area, Point, Doughnut, Heatmap, and others. Please note that based on the number of dimensions and measures which are present in the response, certain set of visualization only might be relevant.

Note that it is even possible to ask for changing the visualization even from the LLM chat as well.

Instant BI Modes – Auto, Fast, and Think Modes

2.2 Open Filters

If the created reports has any filters, when this option is clicked it opens the filter panel, allowing users to modify the available filters and apply different conditions to the generated visualization.

Instant BI Modes – Auto, Fast, and Think Modes

2.3. Explore This Chart

When this option is clicked, the created AI analysis gets redirected and opened in the Helical Insight Report Designer with the generated visualization. Users can make further changed like customize the report, modify fields, apply filters, and make other required changes.

Instant BI Modes – Auto, Fast, and Think Modes

These options provide users with greater control and transparency over Instant BI responses. Users can inspect the LLM’s analysis, change visualizations, apply filters, and further customize generated charts using the Report Designer.

2.4 Explain This Chart

When you hover over the created analysis, at the bottom you can also see “Explain this chart”. When we click on this, the data of this SQLQuery response got to LLM and it explains the chart. By default we do not include such information in the response because it helps us to reduce the tokens usage.

Instant BI Modes – Auto, Fast, and Think Modes

Instant BI Modes – Auto, Fast, and Think Modes

Usage of Instant BI in Helical Insight

Before using Instant BI AI module of Helical Insight, it is important to configure the LLM API key and then create the semantic model. There are also options to self host LLM and use it via Ollama (especially useful for sectors like banking, healthcare, pharma etc).

Need Help with Helical Insight?

In case of any other questions, please reach out on support@helicalinsight.com or you can post your questions on https://forum.helicalinsight.com/.

Leave a Reply

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