business intelligence tools. Archives

Is your Business Intelligence tool really Intelligent?

According to Forrester blog a typical BI tool costs $1,50,000/- and ETL costs about the same. Services, hardware and implementation generally scale up to 5 times the software cost. It is after investing so much that most businesses realize that the solution they have purchased is not really future ready. As the business expands, number of

BI tools, business intelligence tools., helical insight, open source business intelligence tools.

Share with

CrossTab Usage in Adhoc

In this article you will learn how to use Crosstab in Adhoc. Crosstab report can be easily used for comparing the data values between multiple entries. Drag and drop the columns into canvas and create a report. Here we would be using Travel data. In order to visualize the report in a crosstab format, click

BI tools, business intelligence tools., Cross Tab, helical insight, Open source BI tools

Share with

Functions Applied on Columns

Different functions like sum, group by, and Count etc. can be applied to the variables. If the user drags or selects a column in the selection area, a function would be applied to that column by default, depending upon the type of variable. Mostly, a group by function is applied automatically for categorical variables and

adhoc module, BI tools, business intelligence tools., helical insight

Share with

Create and Edit Metadata

Metadata is basically a logical DB schema which gets stored locally in Helical Insight server (as a .metadata extension) and allows users to define which tables, columns they would want to keep. Thus, different Metadata can be created for the different set of users like finance metadata, sales metadata, operations metadata which then can be

BI tools, business intelligence tools., metadata-workflow, Open source BI tools, workflow

Share with

Create, Edit, Share & Delete Data Source

In this blog, we will how to connect to a data source in Helical Insight. Overview of Data Sources Tab The list of Data sources is present as a collection of icons for each database. User can search for the data source by typing in the search box. User can also search based on type

adhoc datasource, BI tools, business intelligence tools.