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

OLAPs

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

  • Bitach

    Bitach

    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

    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

    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. For…Keep Reading
  • marketlinc

    MarketLinc

    Domain : Online Sales and Marketing
    Geography : USA
    Client Description : MarketLinc provides a web based sales and marketing solutions that help their client in unlocking the potential of their market. MarketLinc uses the advanced methodologies and strategies which helps their clients like in attaining…Keep Reading
  • CA Technologies

    CA Technologies

    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

    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)

captcha

Address

 

 

Hyderabad Address:

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

Somajiguda, Hyderabad – 500082

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

  • Passing values as parameters to Subreport from main report in Jasper

    Tool used: ireport What is subreport? Before going into details, let me tell you what is subreport and what is the relation between a main report and subreport. A subreport is a report which is used inside another report.  This functionality helps us during complex designs where the data comes either from different portions of …Read More

  • DDL and DML Operations in MongoDB

    MongoDB is an open-source document database that provides high performance, high availability, and automatic scaling. A record in MongoDB is a document, which is a data structure composed of field and value pairs As: { name:”ABC”, age:18, gender:”Male” } MongoDB is a document-oriented DBMS. Think of MySQL but with JSON-like objects comprising the data model, …Read More

  • Cookies with CORS

    Cookies with CORS CORS stands for Cross-Origin Resource Sharing and this is what wikipedia has to say about it. Cross-origin resource sharing (CORS) is a mechanism that allows many resources (e.g. fonts, JavaScript, etc.) on a web page to be requested from another domain outside the domain from which the resource originated. Once CORS is …Read More

  • Calling JRXML inside HDI(Helical Dashboard Insights) : -

                 Calling  JRXML  inside  HDI(Helical Dashboard Insights) : – This blog will teach you how to call JRXML inside HDI(Helical Dashboard Insights) : – To call JRXML inside Helical Dashboard Insights , we need 4 files required for HDI and one JRXML file. I have created one folder named “JRXML” …Read More

  • Creating Dynamic Drop Down List in Talend

    Creating Dynamic Drop Down List in Talend Created a sample job to retrieve the records from a particular table only by selecting the table name from a drop down list. First we have to create tables and load the data into the database. We have to get these tables in a particular database as drop down …Read More

  • Types of CDC supported by Talend Enterprise Edition

    Types of CDC supported by Talend Enterprise Edition :   CDC (Change Data Capture ) : The CDC architecture is based on the publisher/subscriber model. The publisher captures the change data and makes it available to the subscribers. The subscribers utilize the change data obtained from the publisher. The main tasks performed by the publisher …Read More

  • What is Software Testing? Why is software testing necessary?

    What is Software Testing? Nowadays,Software testing is plays an important role,which helps to improve the quality,reliability and performance of the software applications.Usually software testing is considered as one phase of the software development life cycle (SDLC). Software testing is the process in which the defects are identified,isolated and subjected for rectification to ensure that the …Read More

  • SQL Event Scheduling

    Event is responsible for making sure that a specified routine (section of query code) is executed at regular intervals that is specified by the user. An example of use of an Event would be as follows: A retail store owner wants to see his remaining stocks in his store, in the morning before he opens …Read More

  • Connection Time Out in AWS EC2

    Connection Time Out in AWS EC2 Possible reasons for timeout when trying to access EC2 instance The most likely one is that the Security Group is not configured properly to provide SSH access on port 22 to your i.p. The local firewall configuration does not allow SSH access to the server. The server is not …Read More

  • Create a row grouping in Table Component (Jasper Report)

    Create a row grouping in Table Component (Jasper) Consider an example currently you are showing the data as shown in below using tabular component. Example: State Person Name Tax Amount Iowa PQR 10,000 Iowa XYZ 15,248 Utah ABC 14,245 Utah DEF 13,256 Wisconsin GHI 12,789 Wisconsin JKL 11,100 But If you want to show the …Read More

  • I-Report Bands

                                                                                                            I-Report Bands   A jasper report is composed by a set of sections named as “bands”.  Every band contains few properties such as height. Band height should be greater than 0, otherwise it will never be visible to user.  The band height can grow if elements inside it are stretched. Default Bands in …Read More

  • Failover and Load Balancing in Jasper Server

    Failover and Load Balancing in Jasper Server Installing jasper instances For sample configuration I installed two Jasperserver instances: On two separate application server (2 tomcat servers running on different port), and with Single repository (OracleDB) For detailed installation steps refer http://helicaltech.com/installing-jasperreports-server-6-0-1-with-oracle-db-in-windows/ I installed jasper server instances on localhost. These jasper servers are running on: http://localhost:9080/jasperserver-pro …Read More

  • INNODB Backup and Recovery using mysqldump

    InnoDB is a storage engine for MySQL. MySQL 5.5 and later use it by default. It provides the standard ACID-compliant transaction features, along with foreign key support (Declarative Referential Integrity). It is included as standard in most binaries distributed by “MySQL AB”, the exception being some “OEM” versions. The key to safe database management is …Read More

  • Installing Java and Apache Tomcat on Ubuntu

    Installing Java and Apache Tomcat on Ubuntu   In order to Install Java and Apache Tomcat on Ubuntu: Make sure that Java and Apache Tomcat is not present(running) on Ubuntu. Use following command to check whether Java is present or not on Ubuntu.   Java –version If you get result similar to the below image …Read More

  • How to restrict Multiselect input control values in jaspersoft :

    How to restrict Multiselect input control values in Jaspersoft  This blog will teach the reader , how to restrict multiselect input control values in jasper without hampering the performance . DB : Postgres (foodmart) Table : customer Reporting tool : iReport Server : Jasperserver 5.6 I/P Parameter : country Requirement : Get All the informations …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