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

  • How to write basic MDX query

    How to write basic MDX query When writing MDX queries you need to make a clear distinction between the data and metadata.Cube data is what is being presented to the users, for example you would show the sales amount for Volkswagen Polo 2014 and Volkswagen Vento 2015. Metadata is how is the structuring of the …Read More

  • Drill Down in Same Panel in Pentaho CDE

    Drill Down in Same Panel in Pentaho CDE First create dashboard having two three panels as in example shown below :- In this example we are going to learn how we can drill down from bar chart in second panel to the table component in third panel with the relevant data. On clicking any of …Read More

  • Exploring cron

    Exploring Cron – II In our previous blog we have overview of how to create a cron expression. This blog will walk you through some solid example, which will help you to get detailed undertstanding of crontab (Chronos tab or chornological table) 1. How do I see the current cron tab entry? A) From command …Read More

  • Handling Rollback and Database transactions in Pentaho Data Integration.

    Handling Rollback and Database transactions in Pentaho Data Integration.     While inserting the data into the database table it often happens that when a job/transformation fails in between the data load the whole transaction gets rolled back. In general, the table output step in PDI will insert and commit any number of records until …Read More

  • Collection Part-1 : Java Arrays

    Arrays are objects which store multiple variables of the same type, it is a collection of similar type of elements that have contiguous memory location. The length of an array is established when the array is created. After creation, its length is fixed. An array of 10 elements. It is an array of size 10, …Read More

  • Pay less tax and save more take home through FSA (Flexible Spending Account) plans

    Pay less tax and save more take home through FSA plans (Flexible Spending Account) What are the Flex plans? Flex plans also known as flexible spending account (FSA) plans. Generally, these plans allow an employee to save more take home amount by paying less tax on his taxable income. Before you pay taxes on your …Read More

  • Use of Lateral Subqueries in PostgreSQL

    Use of Lateral Subqueries in PostgreSQL Lateral subqueries are subqueries appearing in FROM can be preceded by the key word LATERAL. This allows them to reference columns provided by preceding FROM items. (Without LATERAL, each subquery is evaluated independently and so cannot cross-reference any other FROM item.) In simple words, Lateral keyword allows to pass …Read More

  • Mondrian Cache Refresh Automation Mechanism in Pentaho BA Server

    REFRESH MONDRIAN CACHE ON THE BA SERVER One of the strengths of mondrian’s design is that you don’t need to do any processing to populate special data structures before you start running OLAP queries. More than a few people have observed that this makes mondrian an excellent choice for ‘real-time OLAP’ — running multi-dimensional queries …Read More

  • Ways to execute python code from Java

    There are many ways to execute Python code from with in Java. In case if your project has requirement to execute Python code from Java, here are few code samples that I have collected from Internet. Ways to use Python in Java Code 1. Using Jython ScriptContext: Python code that is written in a file …Read More

  • Converting TimestampRange to Timestamp with default value expression and passing it into the Dataset .

      Here when we are using our parameter class as net.sf.jasperreports.types.date.TimestampRange with default value expression like new java.sql.Timestamp((new Date()).getYear(), (new Date()).getMonth(),1,0,0,0,0) then it will return (2016-01-01 00:00:00) format / Year /Month / Week/ Day. new java.sql.Timestamp((new java.sql.Timestamp((new Date()).getYear(), (new Date()).getMonth(),(new Date()).getDate(),0,0,0,0)).getTime() + 86399000) then it will return(2016-01-01 23:59:59) format / Year /Month / Week/ Day. …Read More

  • Beginner’s Guide to E.T.L (Extract, Transform and Load) – Connection Set-Up

    Connection Setup for connection type: PostgreSQL [We are now setting up a connection to A database i.e if your source is a database] There are 3 ways of access provided for Connections using PostgreSQL a. Native (JBDC) b. ODBC c. JNDI a. Native (JBDC) I. Enter the Connection Name: Anyname II. Select the connection type: …Read More

  • Using MDM components in Talend

    Using MDM components in Talend There are basically 2 types a component can be used in Talend. 1. Built-in Built-in is giving in all the properties of a component manually yourself. Details like Server connection details, entities, elements, xpath etc., Once, one has given all the details for the connection as shown in the above …Read More

  • Beginner’s Guide to E.T.L (Extract, Transform and Load) – A Basic Process

    Loading Data from Source to Target Before we proceed it’s important to identify the tool you might need to accomplish the process of ETL, in my case i would be using the Pentaho Data Integration Application (keep in mind irrespective of the tool you use the steps or procedures are similar but the approach might …Read More

  • Beginner’s Guide to E.T.L (Extract, Transform and Load) – Introduction

    Introduction into E.T.L (Extract, Transform and Load) This a process related to data warehousing which involves the extracting of data out of the source system/Systems and placing it into a repository or Target. Extraction Extracting the data from source systems (Flat Files or other operational systems) and converted into one consolidated data warehouse format which is …Read More

  • Pentaho BA Server 6.0 : How to enable Pentaho Marketplace and Pentaho CDE(CTools) in the Enterprise Edition

    Enable Pentaho Marketplace and Pentaho C-Tools in Pentaho BA Server 6.0 EE Pentaho 6.0 is the first version of the Pentaho enterprise-class server with new features to automate, manage and enhance every stage of the data pipeline. Pentaho 6.0 also introduces inline analytic model editing for sharing user-created measures and metrics in a collaborative manner. …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