Helical IT Solutions Pvt. Ltd.

One stop destination for all your BI needs


Cloud Based BI

Cloud is next evolution in BI. BI is not restricted to fixed infrastructure. Nowadays it's possible to have BI in cloud.


BI dashboard is a data visualization tool that displays the current status of metrics and key performance indicators (KPIs).


BI mashup can be a data mashup, charts mashup or maps mashup. Usually mashups are used in dashboards.


On-Line Analytical Processing (OLAP) is a category of software technology that enables analysts, managers and executives to gain insight into data.

Custom Plugins

If you have an all together different set of requirement, an entirely different workflow, your own set of proceesses and hence, you need a plugin for jasper/pentaho.

Mobile BI

Whether on the road, in a meeting, or at home instant access to business information has become a necessity for competitive organizations.


Today's businesses are changing at breakneck speed & a proper reporting tool/reports helps you keep track of your business.

Self Service BI

Self service BI is a facility that enables end users to become more independent, self-reliant and less dependent on IT.

Data Modelling and ETL

Data modelling is a process used to define and analyze data requirements needed to support the business processes.

Data Warehousing

A data warehouse or enterprise data warehouse (DW, DWH, or EDW) is a database used for reporting and data analysis.

Geographical Charting

We can help you with geographical charting i.e. displaying your geographical data distributed by category, regions or entities on maps like google map, bing maps etc.

Data Mining

Data mining is the automatic or semi-automatic analysis of large quantities of data to extract previously unknown interesting patterns.

An agile, efficient and much faster way of developing ETL jobs using advanced features like more control,visualization, reporting, plug & play modules, reusability etc.

Though there are many ETL tools available in the market, but using them also come with their own inherent problems, some of which are highlighted below,

Best Practices: Each and every developer does the ETL development according to his logic and his method of development; hence more often they forget to follow the best practices. These best practices are related to error handling, naming conventions, QA, QC etc.

Lack of standardization: Often not following the best practices on logging, error handling, naming conventions, documentation etc leads to lack of standardization between the different ETL jobs which have been developed amongst the different ETL developers.

Lack of control for end user: Generally in any ETL, an end user or IT administrator is often not able to see and monitor what exactly is happening. He has absolutely no control of the jobs, flags, status etc.,

Read More…


  • Helical BI work using Jaspersoft in Training & Leadership Domain

    Envision Global Leadership – Training & Leadership

    Domain : Training and Leadership
    Geography : US
    Client Description :
    Client Description : Envision is into training and leadership, helping companies to grow and develop through transformational change. Their suite of services include training, assessment, leadership classes, teleseminars, webinars etc. Envision makes its client fill… Keep Reading
  • Helical work on Talend Big Data for Numerify

    Numerify – Business Analytics on Cloud

    Domain : Business Analytics
    Geography : US and India
    Client Description : Numerify is a funded futurisitc company which wants to build a disruptive cloud-native platform to deliver business analytics. Numerify founders include industry veterans from Oracle, Microsoft, IBM, Microstrategy and Hyperion. Helical was a part… Keep Reading
  • Helical BI work in Ecommerce


    Domain : Technology
    Geography : US
    Client Description : Mabuhay63 focuses on providing ecommerce solution on the cloud and focuses a lot on reliability, usability, simple yet highly efficient design and offering a seamless shopping experience to users. They are primarily using open source tools which… Keep Reading
  • Helical BI work for Predikto


    Domain : Asset Intensive Organizations
    Geography : Atlanta, United States
    Client Description : Predikto is helping a lot of companies which rely on physical assets (esp oil & gas, transportation, pulp & paper, metal & mining). The companies (like mfg, industrial ), they have  a-lot of… Keep Reading
  • Travel Domain Business Intelligence Developed by Helical

    IBNTech – Travel Domain

    Domain : Travel Domain
    Geography : Pune, India
    Client Description : IBNtech is a fast growing technology company providing solutions and ITES to Hedge funds, Fund of Funds, Banking, and Finance and Accounting (F&A) verticals internationally for clientèle in UK and USA. Their range of services… Keep Reading
  • Sage Human Capital

    Sage Human Capital – HR Business Intelligence

    Domain : Sage Human Capital - HR Capital Consulting
    Geography : US
    Client Description : It is a human capital consulting company. They needed some system in place which could help in tracking the candidate progress, followup status, accepted, rejected and sending the reports automatically to… Keep Reading
  • Healthcare Insurace

    hCentive – Healthcare Insurance

    Domain : hCentive - Healthcare Software Insurance
    Geography : US & India
    Client Description : hCentive provides cloud-based, healthcare technology solutions that help consumers & businesses connect, communicate and engage with health plans in an undemanding and informed manner when acquiring health insurance. Hcentive provides browser-based, user-configurable… Keep Reading
  • Unified Social - Social Business Intelligence

    Unified Social Media

    Domain : Social Media Platform Management
    Geography : US
    Client Description : Unified is the enterprise marketing technology company for brands and agencies that need to activate social audiences and impact consumer actions.  They are managing the social media platform for many big clients and for… Keep Reading
  • Energy Domain Business Intelligence

    Vortecy Energy Consulting

    Domain : Energy Efficiency
    Geography : US
    Client Description : Vortecy is a US based company which is also into energy domain. They have installed their devices at different locations and collecting data. From this data they are providing intelligence to the clients, analysis and analytics… Keep Reading

Press Releases

  • Helical Scrunch - Product Release

    Helical IT has launched a new product ‘Helical Scrunch’ to solvethe existing ETL issues faced by the companies. It will reduce thetime, effort and resource requirement by approximately 30-70 percent Helical Scrunch provides an extensive control to an end user/IT admin via web interface. Helical Scrunch will lessen the complications which exist in ETL Solutions, thus resulting in saving time and resource requirement and creation of muc...Read More...

  • Jaspersoft Helical Partnership

    Owing to it's technical expertise over Jaspersoft tool, Helical IT is proud to announce that it has became Jaspersoft System Integration Partner. We work on the entire Jaspersoft BI suite (which includes CE, EE, Cloud), starting from ETL (talend open studio, talend integration suite), BI solution development, cloud and mobile deployment, SSO implementation, application integration, other charting engine integration, security implementation (...Read More...

  • Helical IT Raises Funding

    Helical IT raised seed funding of Rs 25 lakhs from Singapore based investor in the month of May. We were able to raise funding within 6 months of our operation, and wrapped up the entire process within 3 weeks of starting to search for funding. Funding has helped the company to expand its operations, hire aggressively and also start working on their products. Coverage of :

stalking huh, we would love that

feel free to leave us a message

Contact Us

Well, good to see you using this form :)

Feel free to write anything you like , we usually reply to all emails within 24 hours or so.


Hyderabad Address:

#704, Unit 4, Topaz Complex, 7th Floor,

Somajiguda, Hyderabad – 500082

Phone : 040-42205298


Nikhilesh Tiwari: +91 78 9394 7676

Nitin Sahu: +91 88 9793 1981


Nikhilesh Tiwari: nikhilesh@helicaltech.com

Nitin Sahu: nitin@helicaltech.com

About us

We are capable of providing simple, practical & affordable solutions which are suitable for business users right from CEO, CXO, line managers & to every end user of the enterprise. We have a quick turn around time & can provide mobile BI solutions, on premises or hosted SaaS solution, hence catering to every type of need.

Whether your enterprise is already using a business intelligence solution, or just starting to explore the possibilities, Helical can help you on all the aspects right from tool selection, ETL, Data warehouse designing & consultation, solution developement & analytics as well! We povide integration of disparate data sources and offers your users powerful interactive tools like balanced scorecards, personalized dashboards, key performance indicators, automated alerts, graphical mining, cross tab reporting and more!

Our solutions can be accessed on mobile, can be implemented on SaaS, can be accessed via web browser & also can be seamlessely integrated on your softwares or website as well.

We invite you to use the contact information on our web site to contact us today. We would be pleased to schedule a demonstration of for you and to show you what true business intelligence can do for your enterprise.

Kindly send a mail on nikhilesh@helicaltech.com

  • Creating HTML Table with JSON Data dynamically in HDI(Helical Dashboard Insights)

    This blog will teach you how to create HTML Table with JSON Data dynamically in HDI(HelicalDashboard Insights) : To create html table with json data dynamically in hdi , we need two files Demo.EFW template.html In “Demo.EFW” file , we have to call template.html file Demo.EFW:- <?xml version=”1.0″ encoding=”UTF-8″ ?> <efw> <title>HDI Demo</title> <author>Rupam</author> <description>Demo Dashboard</description> Keep Reading ..

  • Calling Static jrxml files inHDI

    This blog will teach you how to call Static jrxml  files in HDI (Helical Dashboard Insights). To call static jrxml file from hdi , we need 3 files “.EFW” extension file “.html” file Required “.jrxml” file Eg:- here I have integrated “SkillChart” in jasper and now I want to call its jrxml through hdi So Keep Reading ..


    In liferay, Administrator of any Organization is able to delete, update or change user details of any other organization which is not secure to organizations. User Details of any other organization should not display to any other organization admin. To avoid the above scenario, it is required to change permissions and role for organizations admin. Keep Reading ..

  • Business Intelligence Project Lifecycle

    Business Intelligence Project Lifecycle Project Planning Project life cycle begins with project planning. Obviously, we must have a basic understanding of the business’s requirements to make appropriate scope decisions. Project planning then turns to resource staffing, coupled with project task identification, assignment, duration, and sequencing. The resulting integrated project plan identifies all tasks associated with Keep Reading ..

  • How to Optimize Tmap Component in Talend

    How to Optimize Tmap Component in Talend Optimize Tmap component in Talend If Lookup table has few rows: Open tmap select lookup model as Load Once .This will load lookup data one time before mail flow starts. This Lookup data will be stored in memory then main flow execution is very fast with comparing with Keep Reading ..

  • Finding MySQL Database Size

    Finding MySQL Database Size Here’s the SQL script to list out the entire databases size. SELECT table_schema “Data Base Name”, SUM( data_length + index_length) / 1024 / 1024 “Data Base Size in MB” FROM information_schema.TABLES GROUP BY table_schema; SELECT TABLE_NAME, table_rows, data_length, index_length, round(((data_length + index_length) / 1024 / 1024),2) “Size in MB” FROM information_schema.TABLES Keep Reading ..

  • D3 Candle-Stick chart Integration with HDI (Helical Dashboard Insights)

    D3 Candle-Stick chart Integration with HDI (Helical Dashboard Insights) What is HDI:- HDI allows the developer to create Dynamic chart, Dashboard .It is too much user friendly and developer friendly by the point of customization. What is D3 Candle-Stick Chart:- A  Candle-Stick concisely encodes several dimensions of data into a simple glyph. Required Result set:- -> Keep Reading ..

  • Customize Tooltip in D3 Charts

    Customize Tooltip in D3 Charts Simplest way to customize your tooltip in d3 charts. To achieve a customize tooltip you need to follow these simple steps. Step 1: First, think what you can show in tooltip. I have created pie chart using d3 charts.In my case I am showing a total votes of my candidate. Keep Reading ..

  • How Bootstrap grid works (continued)

    How Bootstarp grid works (continued) In the last article, we had a look at the container, rows, columns and nesting. Now we are going to cover offset, push and pull. Offset Usually the columns come one after the other, but what if we want to provide some extra space between or center a ten column Keep Reading ..

  • Unit Test and JUnit Introduction

    Testing is the process of checking the functionality of the application whether it is working as per requirements and to ensure that at developer level, unit testing comes into picture. Unit testing is the testing of single entity (class or method). Unit testing is very essential to every software company to give a quality product Keep Reading ..

  • File encryption/decryption using AES Algorithm

    In this article the reader will learn about plain text file encryption using AES(Advanced Encryption Standard) algorithm. In modern day cryptography AES algorithm gained much popularity because of its strength. The message to be encrypted is called the plain text or clear text. The encrypted message, which is not in human readable format is called as Keep Reading ..

  • How to Configure Jasper Apache-Tomcat’s Java Heap Size?

    How to Configure Jasper Apache-Tomcat’s Java Heap Size? Identify apache-tomcat location from jasperserver installation place. Location can be look like “/opt/jasperreports-server-cp-5.0.0/apache-tomcat/bin”. If Tomcat running as a Linux Service incase it is a windows service it can be look like “C:\Jaspersoft\jasperreports-server-cp-5.5.0a\apache-tomcat\bin” Open and navigate through bin directory as shown in the screen shot below. Edit setenv.bat Keep Reading ..

  • Exception in thread “main” java.lang.OutOfMemoryError: GC overhead limit exceeded

    Different causes for OOM Every one in java development face java.lang.OutOfMemoryError now and then, OutOfMemoryError in Java is one problem which is may be due to Improper memory management by the Java code Insufficient hardware memory available to process the code Programming mistakes Memory leak Types of OOM Any of the above reason can result Keep Reading ..

  • Tuning a slow PostgreSQL Function

    Tuning a slow PostgreSQL Function The problem I faced: I had a postgreSQL function which was getting executed from a BI Report. It was called several times in a loop with different parameters for a single report execution. The function performed poorly. The postgreSQL function had 2 “select” queries which returned a resultset based on Keep Reading ..

  • Create CrossTab In HDI(Helical Dashboard Insights) :

    Creating CrossTab In Helical Dashboard Insight (HDI) This blog will teach you how to create Cross Tab in HDI (Helical Dashboard Insights). CrossTab uses PivotTable.js.Which is a JavaScript Pivot Table Library with drag and drop functionality. ‘PivotTable.js’ basic function is to turn a data set into a summary table and then optionally add a true Keep Reading ..

working with us is more fun

Checkout our current job postings


  • Requirement for ETL Developer

    Knowledge on Mongo DB and Hadoop
    PDI/Talend/Jasper ETL/ ETL. Experience with the design of ETL solutions integrating multiple data source systems,data analysis, modeling, SQL tuning and design specific to a data warehouse / Business Intelligence environment (dimensional modeling)Linux/UNIX
    2years Total Experience with the design of ETL solutions integrating multiple data source systems,data analysis, modeling, SQL tuning and design specific to a data warehouse / Business Intelligence environment (dimensional modeling)Linux/UNIX
    Requirement based out of Hyderabad. Kindly send in profiles to nikhilesh@helicaltech.com Phone Number : +91 78 9394 7676

  • Requirement for Java Developer

    JAVA: J2EE, Spring Framework, Hibernate,Java Design pattern Web Application Engine: Sitemash, Velocity Web Server: Apache httpd Web Server, Apache Tomcat Web Server Databases: MySQL, Postgres and Any other database skillset is always welcome
    Pentaho: Pentaho BI server, 3rd Party Integration Application, BI plugin development for Pentaho Data Integrator, Pentaho report designer, Pentaho Analyzer Jasper: BI server, 3rd Party Integration Application, BI plugin development for Jasper BI server, iReport plugin Data Warehouse: Data Model design to create Data Marts/Data Warehouse/ODS/Transactional System Requirement based out of Hyderabad. Kindly send in profiles to nikhilesh@helicaltech.com Phone Number : +91 78 9394 7676