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...Read More


BI dashboard is a data visualization tool that displays the current status of metrics...Read More


BI mashup can be a data mashup, charts mashup or maps mashup. Usually mashups are use...Read More


On-Line Analytical Processing (OLAP) is a category of software technology that enable...Read More

Custom Plugins

If you have an all together different set of requirement, an entirely different workf...Read More

Mobile BI

Whether on the road, in a meeting, or at home instant access to business information ...Read More


Today's businesses are changing at breakneck speed & a proper reporting tool/repo...Read More

Self Service BI

Self service BI is a facility that enables end users to become more independent, self...Read More

Data Modelling and ETL

Data modelling is a process used to define and analyze data requirements needed to su...Read More

Data Warehousing

Helical can consult, design and implement Data Warehouse either in Star schema or Sno...Read More

Geographical Charting

We can help you with geographical charting i.e. displaying your geographical data dis...Read More

Data Mining

Data mining is the automatic or semi-automatic analysis of large quantities of data t...Read More

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


  • University of Bridgeport

    University of Bridgeport : Education Domain

    Domain : Education
    Geography : US
    Client Description : University of Bridgeport (UB) is a private, independent university which provides diversified courses for Under Graduate and Post-Graduate programs for the students and is ranked among top 20 University in USA. Every year they give admissions to…Keep Reading
  • Canadian Bearings

    Canadian Bearings : Supply Chain Domain

    Domain : Supply Chain
    Geography :  US
    Client Description : Canadian Bearing is an organization specializing in supply chain management. They focus on delivering products and solutions efficiently to their customers. They also became industry supplier for many Canadian manufacturing companies because of their performance, continuous…Keep Reading
  • Bitach

    Bitach : Insurance Domain

    Domain: Insurance
    Geography : USA
    Client Description : Bitach is a Financial company specializing in Account Receivable Management, offering range of services for the growing companies. In this area they buy, collect, sell, consult and also specialize in distressed consumer receivable and recurring payment administration. They…Keep Reading
  • synchr

    SyncHR : Human Resource Domain

    Domain : Human Resource
    Geography : USA
    Client Description : SyncHR is an organization that provides HR solution for the enterprise users. This solution help the enterprise users to manage their HR process by giving advantages over traditional systems and it brings transparency in the system.…Keep Reading
  • technip

    Technip : Energy and Utility Domain

    Domain : Oil & Energy
    Geography : Global
    Client Description : With more than 30,000 employees worldwide, Technip is a company that carries out project management, engineering and construction for the energy industry. They deliver best quality solution to their clients to meet the energy challenges.…Keep Reading
  • CA Technologies

    CA Technologies : IT Domain

    Domain : IT
    Geography : US, India
    Client Description : Established in 1976 CA Technologies is a public listed and is one of the worlds biggest software corporation. The software and services provided by them are being used by many Fortune 500 companies. Helical had played…Keep Reading
  • PCNI

    PCNI : NGO BI Solution

    Domain : NGO
    Geography : US
    Client Description : Pathways Community Network Institute is a nonprofit organization that strengthens responses to poverty and homelessness through increased collaboration and effective use of data and technology. Pathways data and services empowers other NGOs to coordinate and provide better…Keep Reading
  • envision

    Envision Global Leadership – Training & Leadership

    Domain : Training and Leadership
    Geography : USA
    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
  • Numerify

    Numerify : Business Analytics on Cloud

    Domain : Business Analytics
    Geography : US and India
    Client Description : Numerify is a funded futuristic 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

    Mabuhay63 : Technology Domain

    Domain : Technology
    Geography : US
    Client Description : Mabuhay63 focuses on providing e-commerce 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
  • Predikto

    Predikto : Manufacturing Domain

    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…Keep Reading
  • ibntech

    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 : USA
    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
  • hCentive

    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 : Social Media Analytics

    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

Case Studies

  • Case Study on CA Technologies

    CA technologies, a fortune 500 company with more than 75000+ employees, is into IT services and products. CA software and solutions helps the customer in driving productivity, providing differentiated user experience and growth opportunities. The portfolio of solutions that CA technologies offers are IT portfolio investments, services and assets management, application delivery, performance optimization and security. CA technologies is also capab...Read More

  • Case Study on Sage Human Capital

    Sage Human Capital is US leading human resource company. They have revolutionized HR recruiting industry by bringing introducing some innovative concepts like “talent as a service” and “SmartSource” and boast of clientele like Accenture, Jaspersoft, McAfee, Salesgenie, Adidas, Text100 to name a few.

  • Case Study on Bitach Insight

    Bitach is a financial company specializing in Account Receivable Management; offering range of services for the growing companies. In this area they buy, collect, sell, consult and also specialize in distressed consumer receivable and recurring payment administration.They purchase and manage portfolios of consumer distressed assets ranging from Healthcare receivables, Charged off Credit Card accounts, Overdraft Accounts, and Personal Lines of Credit to name a few.

  • Case Study on Envision Global using Helical Insight (HI)

    Envision Global Leadership (EGL) is an institute having expertise in providing training on leadership development. Envision helps the organization seeking leadership development by providing training for mid to upper level executives. They also provide advance level training and certifications for the executive coaching skills. Moreover envision provides the thoughtful insights, tools for the organization to improve the organizational productivity.

  • Case Study on PCNI OpenHMIS Reports

    Pathways helps communities strengthen responses to poverty and homelessness through increased collaboration and effective use of data and technology. The OpenHMIS Project is a collaborative effort, sponsored by Pathways Community Network Institute and the Georgia Dept. of Community Affairs, to build a common platform for creation of Internet-based tools to assist communities/agencies in providing services to the homeless. The OpenHMIS Proje...Read More

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 much better ...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 (appli...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 :   .my-inner-div { margin...Read More

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.

Your Name (required)

Your Email (required)

Subject (required)

Your Message (required)





Hyderabad Address:

Lakshmi Nilayam, H.No-1-10/66/A,

Near Holy Trinity Church, Chikoti Garden,

Begumpet, Hyderabad – 500016

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

  • Switch Datasource based on user logged in Jasper Server

    Switch Datasource based on user logged in Jasper Server This tutorial shows you how to switch two different jdbc datasource using custom datasource in jasper server. Cosider you have two jdbc datasource in jasper server and you want to select datasource1 if jasperadmin logged in to jasper server otherwise it will pick other datasource2. Implementation …Read More

  • Beginners Guide in Understanding Different Types of Joins

    INNER JOINS When we decide that one table won’t be enough for getting our desired output then we try to attach one more table to the existing table is known as JOINS. Now Inner Joins in other words is doing the same thing as the definition of joins goes but with an additional advantage which …Read More

  • Getting Started with gulp

    Getting Started with gulp While working on a project, one is bound to have a bunch of repetitive tasks such as testing, minification, compiling less/sass/templates, etc., because we are humans, we are bound to make mistakes at one point or another (one can forget to minify some files, or recompile after some changes, etc.), and …Read More

  • Roles and Permissions in liferay

    Roles and Permissions in Lifeary  Role is a collection of permissions. In liferay, We can create role  and assign this particular role to any user. After assigning, this user will inherit all the assigned permisions. There are different kind of roles in liferay: 1) Regular Role 2) Organizaition Role 3) Site role To define permissions …Read More

  • Analytical Functions in MySQL:

    Analytic function syntax : Analytic_function(argument) OVER (PARTITION BY argument ORDER BY argument); Where argument : column name Analytic functions operate on subsets of rows, similar to aggregate functions in GROUP BY queries, but they do not reduce the number of rows returned by the query. Eg :Lets take the example of calculating Avg from emp table group by deptno: Traditional way : …Read More

  • Issues while implementing loops in Pentaho Data Integration

    Issues while implementing loops in Pentaho Data Integration Generally for implementing batch processing we use the looping concept provided by Pentaho in their ETL jobs. The loops in PDI are supported only on jobs(kjb) and it is not supported in transformations(ktr). While implementing loops in PDI, we have come across many blog suggesting us to …Read More


    USING PARMETERS IN iREPORT   Most basic knowledge any new learner would have of word parameter -“ parameter is a limit or boundary which defines the scope of a particular process or activity ”. And technically we can define it as – “A numerical or other measurable factor forming one of a set that defines …Read More

  • Batch process implementation in kettle (Pentaho Data Integration):

    Batch process implementation in kettle (Pentaho Data Integration): In order to implement the batch process we needs to have the looping logic. But I did not find any component or suitable method in kettle to create those loops. So I have created a way to resolve that problem in one of my project and updated …Read More

  • How to write a BLOG??

    We all think that we should share our hard earned knowledge with others. This has never been easier with the onset of the Internet and the magical facility of BLOGGING. Now all one needs to do is set up a blog site and blabber away of what one knows. But as uncle Ben said to …Read More


    WATCHDOG INTRODUCTION For those embedded systems that can’t be constantly watched by a human, watchdog timers may be the solution. The watchdog timer is an important device in the embedded system , which is used to develop reliable products. Most of the embedded systems need to be self-reliant in order to restart and restore the system if …Read More

  • What is Node.js?

    What is Node.js? A lot of the confusion for newcomers to Node is misunderstanding exactly what it is. The description on nodejs.org definitely doesn’t help. An important thing to realize is that Node is not a webserver. By itself it doesn’t do anything. It doesn’t work like Apache. There is no config file where you point it …Read More

  • JavaScript Good Parts

    Here, I’m going to discuss few concepts of JavaScript which are well aware to everyone but there are some loop holes which users are not aware of. The main focus of this post is to discuss and write a better code. First, we discuss about for in problem. Let’s take this code: for (name in …Read More

  • JavaScript inheritance explained

    In this blog article, I will discuss about the JavaScript inheritance as it is one of the non-trivial concepts especially to a Java Programmer. As Douglas Crockford says it is really the world’s most misunderstood programming language though very powerful. JavaScript inheritance is based on prototype and it supports Single inheritance. Multiple inheritance using mixins …Read More

  • STLC (Software Test Life Cycle)

    STLC (Software Test Life Cycle) Life-cycle in simple term refers to the sequence of changes from one form to other form. These changes can happen to any tangible or intangible things. Every entity has a life-cycle from its inception to retire / demise.In a similar fashion, Software is also an entity. Just like developing software …Read More

  • Data Partitioning in MySQL

    To increase the Query execution Performance in MySQL , we found the solution to do the data partitioning on the table. What is Data Partitioning? Partition enables you to distribute portions of individual tables across a file system according to rules which you can set largely as needed. In effect, different portions of a table …Read More

working with us is more fun

Checkout our current job postings


  • Requirement for ETL Developer (Talend / Kettle)

    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

    2 years 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 niyotee@helicaltech.com
  • Requirement for Java Developer

    JAVA : J2EE, Spring Framework, Hibernate,Java Design pattern
    Web Application Engine : Sitemash, Velocity
    Web Server : Apache http 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 niyotee@helicaltech.com

  • Requirement for Front-End developer

    We are looking for candidate having skillsets on front-end development.
    Requirements :

    1. Must be well acquainted with HTML5, CSS3 and JavaScript framework.
    2. Must have working knowledge of UI frameworks like bootstrap, foundation, etc.
    3. Should have worked with at least one MVC framework like BackboneJS, AngularJS, etc
    4. Knowledge of ReactJS preferable
    Educational Background : BE / B.Tech / MCA with good technology understanding.
    If interested, kindly mail us your updated CV on niyotee@helicaltech.com

  • Requirement for BI developer

    We are looking for suitable candidate with 2+ years experience having skillsets on BI development.
    Preferred Requirements:

    • Must have reporting and dashboard development experience
    • Experience on jasper server, installation, troubleshooting
    • Adhoc, domain, OLAP experience
    • Experience on Jaspersoft Integration
    • White labeling of Jaspersoft
    • Good communication skills
    • Addon java development experience
    Educational Background : BE / B.Tech / MCA with good technology understanding.
    If interested, kindly mail us your updated CV on niyotee@helicaltech.com