Helical IT Solutions Pvt. Ltd.

One stop destination for all your BI needs


Services

Cloud Based BI

Cloud is next evolution in BI. BI is not restricted to fixed infrastructure. Nowadays...Read More

Dashboard

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

Mashups

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

OLAP

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

Reporting

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

CLIENTS

  • cadden-fig12_x001

    Flat World Knowledge : Education Domain

    Domain : Education
    Geography :  US
    Client Description : Founded in 2007, Flat World Knowledge is a publisher of college-level textbooks and educational supplements. BNET recognized Flat World Knowledge as an industry innovator for introducing an abundance-based disruptive business model to the college textbook industry. Doing pioneering work in…Keep Reading
  • 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

  • Case Study on University of Bridgeport

    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 admission to students from across the globe for various courses like Engineering, Management and so on. For managing students they are primarily using ERP which stores information like students, subjects, courses, grades, demographics etc.


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)

captcha

Address

 

 

Hyderabad Address:

Lakshmi Nilayam,

Plot no 7, H.No-1-10/66/A,

Near Holy Trinity Church, Chikoti Garden,

Begumpet, Hyderabad – 500016

Phone : 040-42205298

Phone

Nikhilesh Tiwari: +91 78 9394 7676

Nitin Sahu: +91 88 9793 1981

Email

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

  • Date Field Format Customisation in Adhoc View on Japser UI

    Date Field Format Customisation in Adhoc View on Japser UI Often while working with Adhoc Reports on jasper we get limited option for the availble date format in jasper. There are number of ways to fix this but one I am going to discuss here is by adding date format options in the backend of …Read More

  • Work Flow of Talend MDM

    Work Flow of Talend MDM   Talend MDM stores and manages the master data. It also provides platform to do data modelling for the master data. Domains are called entities here. The data is stored into XML format or in sql in relational database. It is based on the setting made according to preference.There are …Read More

  • Install and setup Talend MDM

    Master Data Management -MDM Master data is the mostly consistent data which is spread across the various systems in an enterprise and possibly their partners. It mostly contains Id, Code, Description and other properties which defines a particular domain. It is not the quantitative data related to a single transaction, it is not an operational …Read More

  • Points to remember while developing JRXML

    Few points needs to remember while developing JRXML 1) Use .equals() comparison operator for String fields If you want to compare string fields then use .equals() function instead of == operator. In Java, the == operator compares if the objects are the same instance while .equals() compares the state of object. 2) JRXML Detail Band …Read More

  • How to avoid duplication of values in the columns in PDI if column names are same?

    How to avoid duplication of values in the columns in PDI if column names are same? There can be requirements where we want same column names in the transformation (PDI). In such case the value of field is overwritten on another field. For ex: If for a company we want 3 pairs of Loan Id …Read More

  • How to disable columns in JasperReport Dynamically?

    Disabling Columns from JasperReport Dynamically We can disable columns dynamically from Jasper Report based on our requirement. I will give a simple example: Suppose we are generating a report for a company’s contribution and loan amounts and we want to disable columns with zero amounts. Select the column that you want to disable Go to …Read More

  • Service in Linux

    Service in Linux The service are set of programs that run as background process, so it is ready to use anytime by the users. The service gets started when the machine is rebooted automatically. How to create a Service? The creation of service is useful when the application is used everytime. This helps the user …Read More

  • WITH clause in MDX

    WITH clause in MDX In MDX queries, the WITH clause has an important role to play. WITH clauses are used to define some members which will be used in the SELECT clause for analysis purposes. The WITH clause contains either delarations of multiple sets and multiple members. Also, it is used to perform certain calculations …Read More

  • What is GUI Testing and Most common GUI Test Cases for Web based Application

    What is GUI Testing and Most common GUI Test Cases for Web-based Application: There are two types of interfaces in a computer application. 1.Command Line Interface is where you type text and computer respond to that command. 2.GUI stands for Graphical User Interface where you interact with the computer using images rather than text. The term …Read More

  • EDI 834 – Benefit Enrollment and Maintenance

    EDI 834 – Benefit Enrollment and Maintenance The EDI 834 transaction set represents a Benefit Enrollment and Maintenance document. It is used by employers, as well as unions, government agencies or insurance agencies, to enroll members in a healthcare benefit plan. The 834 has been specified by HIPAA 5010 standards for the electronic exchange of …Read More

  • Using SSH on Windows

    Using SSH on windows is not possible natively like *NIX systems. The most popular way of achieving this is by using a third party client known as PuTTY. But there is an alternate way of using SSH via Powershell/CMD. For this, you’ll need to install CygWin. While installing CygWin just make sure that you have …Read More

  • Charts in BIRT – A Simple Chart Example

    Charts in BIRT – A Simple Chart Example In this tutorial, we will create a BIRT report with a simple Bar chart showing the monthly sales in 3 different states of the US. We will be using the same food mart database in MySQL for a datasource. So, we are going to have 3 fields, …Read More

  • Jenkins

    JENKINS What is..? Jenkins is a tool (web application ) that helps in continuous integration of projects. It is open source and has capability to manage any types of build software. Jenkins can be seamlessly integrated with any testing and deployment environment. Continuous Integration. In software developement life cycle, there are various pahses of the …Read More

  • Get the Row Count in PDI Dynamically

    Get the Row Count in PDI Dynamically Often people use the data input component in pentaho with count(*) select query to get the row counts. And pass the row count value from the source query to the variable and use it in further transformations.The more optimised way to do so can be through the built …Read More

  • CROSSTABS in Pentaho Report Designer and few limitations — EXPERIMENTAL FEATURE

    CROSSTABS in Pentaho Report Designer (EXPERIMENTAL FEATURE) Crosstabs are easy and relatively easy way to visualize tabular data along two or more axis. Crosstabs are still experimental feature, and as such are not up to mark in BI reports. Alhough they are already used to create some really useful reports, they still have parts which …Read More

working with us is more fun

Checkout our current job postings

Jobs

  • 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

  • Requirement for Business Development Executive

    Job Description :

    • Working in Business Development cum Presales, you will be involved in generating new leads, pitching the client of our product and services, conversion. This could include meticulous planning and extensive documentation (which includes proposal writing, SOW – Statement of work and NDA)
    • Main area of focus will be to generate new leads with the aim of creating more sales and information awareness.
    • Scheduling appointments, preparing and delivering presentation to the client, having researched their business and requirements.
    • Working on sales follow-up activities.
    •  Maintaining customer relationships and ensuring customer loyalty through excellent customer service as well as meeting all client needs appropriate to their business.
    •  Working as part of a team and closely with other departments within the organization.
    • Creating awareness about the products and services through ATL and BTL marketing, digital marketing and blogs.
     
    Job Specification :
     
    • MBA in Marketing preferably IT background.
    • Strong presentation skills are essential.
    • Strong research and strategic analysis skills.
    • Excellent communication skills, both verbal and written and be able to cold call potential clients with confidence.
    • Skilled at agreeing and closing deals with clients.
    • Must be able to operate Microsoft Office and associated programs.
     
    Requirement based out of Hyderabad. Kindly send in profiles to niyotee@helicaltech.com