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

  • 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)

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

  • 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

  • What are different types of dimensions in DataWarehouse?

    What is Dimension in Datawarehouse? Anything which measure facts like time,length,status,ID,date,place,codes,flags with its description,audit and other attributes is stored in table is called as dimension. It contains the description of the buisness, without dimensions it is very difficult to measure the facts. Dimension is the attribute of facts. Types of dimension in Datawarehouse? Conformed Dimension: …Read More

  • Scheduling Jobs in Pentaho Data Integration

    Scheduling Jobs in Pentaho Data Integration The following are the steps to schedule a kettle job: In the main kettle job (.kjb) , there is a START icon should be there. Double click on the icon and it will pop up a job scheduling window as follows: By default, the type is No Scheduling and …Read More

  • Merge Join Vs Stream lookup in Pentaho DI

    Merge Join Vs Stream lookup in Pentaho DI Merge Join: It joins two data sets which are coming from two table Inputs. In this steps the below Types of Joins are available: FULL OUTER: all rows from both sources will be included in the result, with empty values for non-matching keys in both data streams …Read More

  • Parameterized BIRT Reports – Multi-Select Parameter

    Parameterized BIRT Reports – Multi-Select Parameter This blog will help you add a multi-select parameter in BIRT report and filter the data. In the last blog, we parameterized a “sales report” by adding a single select parameter “store city” to it. (You may refer it here). We will now convert this same parameter to a …Read More

  • Cancelling long running queries using Jdbc API

    Cancelling long running queries using Jdbc API In this blog, I will share my experimentation with query cancellation timer. The objective is to cancel those queries which take a lot of time to execute. The Jdbc API provides Statement.cancel() method to cancel the statement being run. But, this method should be called from a different …Read More

  • Difference between SQL and MDX

    Difference between SQL and MDX The MDX (Multi Dimensional Expressions) syntax appears very similar to the SQL syntax and also functions somewhat similar to the way SQL performs. But there are many differences, basically conceptual differences, between SQL and MDX. The basic difference between MDX and SQL is the ability of MDX to reference multiple …Read More

  • A Simple yet Effective way to implement Rollback in Pentaho

                                                          A Simple yet Effective way to implement Rollback in Pentaho What is a Rollback mechanism? In database technologies, a rollback is an operation which returns the database to some previous state. Rollbacks are important for database integrity, because they mean that the database can be restored to a clean copy even after erroneous operations …Read More

  • DATA VISUALISATION USING D3 – JAVASCRIPT CHARTING LIBRARY

    D3 stands for Data-Driven Documents. D3.js is a JavaScript library for manipulating documents based on data. D3 helps you bring data to life using HTML, SVG and CSS. D3’s emphasis on web standards gives you the full capabilities of modern browsers. D3.js is written in JavaScript and uses a functional style which means you can reuse code …Read More

  • Window Function in Postgres

    Window Function in Postgres Part I: Functionalities of window function -> A window function performs a calculation across a set of table rows that are somehow related to the current row. Window function does not cause rows to become grouped into a single output row — the rows retain their separate identities. That makes it …Read More

  • Primitive Wrapper Types in JS

    In this post, I’m going to focus on basic concepts of JavaScript. So we are going to learn the concept of primitive wrapper types in JavaScript which is confusing to most. So, there are three primitive wrapper types and they are: 1: String, 2: Number and 3: Boolean. And these primitive wrapper types are reference …Read More

  • What is Exploratory and Adhoc Testing? And Exploratory Verses Adhoc Testing.

    What is Exploratory and Adhoc Testing? And Exploratory Verses Adhoc Testing. From Testing side two words: Exploratory and Adhoc are the most important and powerful words. Often most of the testers are confusing or feeling that both words are same, but there is always a big difference. In this article we are going to find-out …Read More

  • Parameterized BIRT Reports – Simple Parameter

    Parameterized BIRT Reports – Simple Parameter In this tutorial, we will parameterize a simple BIRT report by adding a single select dynamic parameter to filter the report. (To learn how to create a simple BIRT report without parameter you may refer this blog) We will take this simple sales report based on the FoodMart database. …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