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

  • Create Table Component (Dynatable) in HDI (Helical Dashboard Insights) :

    This blog will teach you how to Create Table Component (Dynatable) in HDI (Helical Dashboard Insights). Dynatable : It is a library , it uses jQuery . It is a framework using which we can easily search ,   sort and filter the html tables data and data is in JSON Format. Eg : – <table> Keep Reading ..

  • Learn Scheduling using Quartz

    Why do we need scheduling? Scheduling is needed if you want to automate the repetition of a task at specific intervals or        particular date. You could of course manually watch the time and execute your task, albeit an inefficient task. If anyone wants to do particular task after every 3 seconds, then who wants to Keep Reading ..

  • Resizing a Amazon AWS EC2 EBS-backed Instance

    Resizing a Amazon AWS EC2 EBS-backed Instance This blog talks about changing the instance type (or machine size) of your EBS-backed Instance, using the AWS management console. It is a very simple process – Stop your running instance Once stopped, you get an option to ‘Change instance type’. Select a new instance type. Start the Keep Reading ..

  • Multi valued column processing using Talend Open Studio

    Multi valued column processing using Talend Introduction Now days, source data files which are exported from the different database structures are having multiple fields in single column. These fields need to be extracted and processed independently and need to be identified with the key column for corresponding row. This specific scenario can’t be handled independently Keep Reading ..

  • Adding new chart in Helical Dashboard Insight (HDI)

    Adding new chart in Helical Dashboard Insight (HDI) 1) Adding the Pie Chart in HDI:- HDI use D3 (Data-Driven Documents) library. D3 allows you to bind arbitrary data to a Document Object Model (DOM), and then apply data-driven transformations to the document. For example, you can use D3 to generate an HTML table from an Keep Reading ..

  • Spring Security

    Spring Security Spring provides a configurable framework for implementing authentication and authorization for an application. The security framework provides ways to login and logout from an application. It also provides authentication at view level and method level. It can also provide you with the login page. Following are the provided by spring security framework • Keep Reading ..

  • Overview of Jasper Server Authentication & Authorization

    Overview of Jasper Server Authentication & Authorization In JasperReports Server, access control is determined by two separate mechanisms, authentication and authorization. Authentication is the process of verifying user credentials to give access to the server. Authorization is the process of checking permissions granted to users and roles to access resources within the server. Authentication Authentication Keep Reading ..


    TIMESTAMP A timestamp is a sequence of characters or encoded information identifying when a certain event occurred, usually giving date and time of day, sometimes accurate to a small fraction of a second. A timestamp is the current time of an event that is recorded by a computer. Through mechanisms such as the Network Time Protocol ( NTP ), a computer Keep Reading ..

  • Adding images to html in Jasper Reports

    In my last blog post I discussed about Generating jasper reports in different formats using json file as a data source.You can find my last post here. In this blog article I will discuss about exporting the jasperPrint object in different formats like pdf, html, csv, xls and docx using the newer API of jasper reports. Keep Reading ..

  • BI Solution For Property and Casualty Insurance Domain

    A BI solution will help an insurance company to get a holistic 360 degree view of customers, issues faced. Helical has got immense experience in developing BI solution in Property and casulaty insurance domain. Having built more than 50 reports, 20 dashboards, geographical dashboard, adhoc reports and OLAP cubes, these BI solution can be used Keep Reading ..

  • JavaScript Inheritance

    JavaScript Inheritance In my last post, I covered JavaScript Classes and now, I’ll continue with inheritance. JavaScript uses prototypal inheritance in contrast to classical. When a class is instantiated, it’s prototype is stored in __proto__ key of the object, which may in turn contain __proto__ from another parent class. This is called Prototype chaining. Lets Keep Reading ..

  • Deploy jar file in jasperserver without restarting service

    Option 1 – If you want to use your Jar in a several reports. You should “Add Jar” (as it called in iReport repository manager) to some folder in the Jasper Server folder tree. Then “Add reference” to this resource in Resources section of you specific report. Option 2 – You need a jar in Keep Reading ..

  • Steps to migrate oracle with pentaho

    Step 1:- Run script as DB admin. Script is available in location:- biserver-ce\data\oracle10g. Modify configuration file:- applicationContext-spring-security-hibernate.properties. Location:- pentaho-solutions\system\applicationContext-spring-security-hibernate.properties. original code:- jdbc.driver=org.hsqldb.jdbcDriver jdbc.url=jdbc:hsqldb:hsql://localhost:9001/hibernate jdbc.username=hibuser jdbc.password=password hibernate.dialect=org.hibernate.dialect.HSQLDialect Modified code:- dbc.driver=oracle.jdbc.OracleDriver jdbc.url=jdbc:oracle:thin:@localhost:1521/sysdba jdbc.username=hibuser jdbc.password=password hibernate.dialect=org.hibernate.dialect.Oracle10gDialect hibernate-settings.xml Location:- pentaho-solutions\system\hibernate\hibernate-settings.xml. Original code <config-file>system/hibernate/hsql.hibernate.cfg.xml</config-file> Modified code:- <config-file>system/hibernate/oracle10g.hibernate.cfg.xml</config-file> oracle10g.hibernate.cfg.xml:- Location:- pentaho-solutions\system\hibernate\ oracle10g.hibernate.cfg.xml Do not need to change any code in this Keep Reading ..

  • Facebook SSO With Liferay

    Here, I am going to explain how to authenticate lifeary through facebook login. Let me walk you through steps below: STEP-1 You first have to have a facebook application account. If you don’t have, create it. You can get more information here: http://developers.facebook.com/docs/guides/web STEP-2 Select Apps Menu and click on Create a new App   Keep Reading ..

  • Insert file contents into the database using Talend

    Insert file contents into the database using Talend There was a requirement to read a dynamically generated text file and put its contents inside the database which could be MySQL, Postgres or SQL server etc. In Talend you can’t change components, metadata and connections seamlessly from one database to another. Talend have provided independent component 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