• Today is: Monday, November 30, 2015

10 most popular analytic tools in business

2-Which-software-col copy
Gaurav Vohra
January15/ 2011

Business analytics is a fast growing field and there are many tools available in the market to serve the needs of organizations. The range of analytical software goes from relatively simple statistical tools in spreadsheets (ex-MS Excel) to statistical software packages (ex-KXEN, Statistica) to sophisticated business intelligence suites (ex-SAS, Oracle, SAP, IBM among the big players). Open source tools like R and Weka are also gaining popularity. Besides these, companies develop in-house tools designed for specific purposes.

Here is a list of 10 most popular analytic tools used in the business world.

Commercial software

MS Excel

MS Excel: Almost every business user has access to MS Office suite and Excel. Excel is an excellent reporting and dash boarding tool. For most business projects, even if you run the heavy statistical analysis on different software but you will still end up using Excel for the reporting and presentation of results.

While most people are aware of its excellent reporting and graphing abilities, excel can be a powerful analytic tool in the hands of an experienced user. Latest versions of Excel can handle tables with up to 1 million rows making it a powerful yet versatile tool.


SAS: SAS is the 5000 pound gorilla of the analytics world and claims to be the largest independent vendor in the business intelligence market. It is the most commonly used software in the Indian analytics market despite its monopolistic pricing. SAS software has wide ranging capabilities from data management to advanced analytics.

SPSS Modeler

SPSS Modeler (Clementine): SPSS Modeler is a data mining software tool by SPSS Inc., an IBM company. It was originally named SPSS Clementine. This tool has an intuitive GUI and its point-and-click modelling capabilities are very comprehensive.


Statistica: is a statistics and analytics software package developed by StatSoft. It provides data analysis, data management, data mining, and data visualization procedures. Statistica supports a wide variety of analytic techniques and is capable of meeting most needs of the business users. The GUI is not the most user-friendly and it may take a little more time to learn than some tools but it is a competitively priced product that is value for money.

Salford Systems

Salford systems: provides a host of predictive analytics and data mining tools for businesses. The company specialises in classification and regression tree algorithms. Its MARS algorithm was originally developed by world-renowned Stanford statistician and physicist, Jerome Friedman. The software is easy to use and learn.


KXEN: is one of the few companies that is driving automated analytics. Their products, largely based on algorithms developed by the Russian mathematician Vladimir Vapnik, are easy to use, fast and can work with large amounts of data. Some users may not like the fact that KXEN works like a ‘black box’ and in most cases, it is difficult to understand and explain the results.


Angoss: Like Salford systems, Angoss has developed its products around classification and regression decision tree algorithms. The advantage of this is that the tools are easy to learn and use, and the results easy to understand and explain. The GUI is very user friendly and a lot of features have been added over the years to make this a powerful tool.


MATLAB: is a statistical computing software developed by MathWorks, MATLAB allows matrix manipulations, plotting of functions and data, implementation of algorithms and creation of user interfaces. There are many add-on toolboxes that extend MATLAB to specific areas of functionality, such as statistics, finance, image processing, bioinformatics, etc. Matlab is not a free software. However, there are clones like Octave and Scilab which are free and have similar functionality.

Open Source Software


R: R is a programming language and software environment for statistical computing and graphics. The R language is an open source tool and is widely used by the academia. For business users, the programming language does represent a hurdle. However, there are many GUIs available that can sit on R and enhance its user-friendliness.


Weka: Weka (Waikato Environment for Knowledge Analysis) is a popular suite of machine learning software, developed at the University of Waikato, New Zealand. Weka, along with R, is amongst the most popular open source software used by the business community. The software is written in the Java language and contains a GUI for interacting with data files and producing visual results and graphs.

Update 1

World Programming system recently launched its version 3. The version has a lot of improvements that take it very close to Base SAS. This tool is rapidly becoming popular with expert analysts who are looking for cheaper options to SAS. Search this blog for the term “WPS” for more interesting information on this exciting tool.

Update 2- July 2015 by Gunnvant Singh

Organizations use a variety of products to extract insights from the data. The complete spectrum of the products ranges from simple tools like excel to number crunching mammoths like SAS or R.

Let us take a look at some other popular data analytics tools today, not mentioned in the lists above.

  1. SQL: It is the primary data storage tool across all organizations. It is still being used to manipulate data and produce reports. Anyone who wishes to be in the analytics industry needs to know SQL.
  2. Tableau: Tableau as a tool has been adopted by most analytics companies. Its visualization capabilities are well recognized in the industry. It is used mostly to produce visualizations and reports. It also allows users to explore the data before beginning the task of predictive modelling.
  3. Orange: It uses the concept of visual programming and simplifies the task of predictive modelling. All major predictive algorithms are built into the software. One can also add functionalities by writing scripts in python. The fact that it is open source makes it all the more attractive.
  4. KNIME: The company behind KNIME provides a suite of products catering to different needs. It also like orange makes use of visual programming.
  5. Azure ML: This is one product from Microsoft that is poised to be the next big thing. This product is actually an ecosystem that gives users the ability to create data products by integrating machine learning module (mostly R libraries) with a robust backend and a pretty frontend. The data connections can be made from different sources, SQL servers, Hadoop clusters.



Click here to read more about analytics courses.

Click here to read the Beginner’s guide to analytics.

Related articles:

Want to also refresh yourself with the terms that get thrown around in the field of analytics? Take a look at the article Analytics Terminology by Gaurav Vohra, Co Founder and CEO of Jigsaw Academy and  find out all you need to know about those big and small analytics terms you’ve heard but not sure what they really mean

Interested in learning about other Analytics and Big Data tools and techniques? Click on our course links and explore more.
Jigsaw’s Data Science with SAS Course – click here.
Jigsaw’s Data Science with R Course – click here.
Jigsaw’s Big Data Course – click here.

You may also like

What is Cluster analysis? Clustering is the  process of breaking down a large population that has a high degree of variation and noise into smaller groups with lower variation...
Cluster analysis for business Clustering is the process of grouping observations of similar kinds into smaller groups within the larger population. It has widespread application in...
Hypothesis Testing Types of t-tests in SAS This post has been written by Jigsaw Faculty Kafeel Basha Let me begin this article by explaining exactly what a t- test is. I will then explain when...
ANOVA & Chi Square Using the Language of SAS-... By: Kafeel Basha- Jigsaw Academy Faculty In my first post ANOVA & Chi Square Using the Language of SAS- Part 1 we looked at some of the procedure...
  • How do businesses analyze large quantities of data? | Jigsaw Academy | Training for careers in Analytics Reply
    5 years ago

    […] article discusses some of the most popular tools in the market today. analytic techniquesAnalytics […]

  • Analytics Education | Jigsaw Academy | Training for careers in Analytics Reply
    5 years ago

    […] Analytic tool training: There are a large number of different software available in the market for analytics. Some are script based, some are GUI based. While it is not possible to train on every available software, it is a good idea to be trained on some of the most popular tools like Excel and SAS language or the R software. You can read more about the popular analytic tools here. […]

  • Books on Business Analytics | Jigsaw Academy | Training for careers in Analytics Reply
    5 years ago

    […] 10 most popular analytic tools […]

  • 10 questions about career in analytics | Jigsaw Academy | Training for careers in Analytics Reply
    4 years ago

    […] 10 most popular analytic tools […]

  • RangaPrasath.S Reply
    4 years ago

    Really your websites gives lot of interesting and useful stuffs on Analytics thanks for sharing ..Keep posting!! Cheers!!

  • Anita Ghatnekar Reply
    4 years ago

    I am looking for Sales Analysis and Inference from that

  • shiv Reply
    3 years ago

    whats the authenticity of data that you present here?

  • Alfredo Reply
    3 years ago

    I delight in, cause I discovered exactly what I was having a look for. You have ended my four day lengthy hunt! God Bless you man. Have a great day. Bye

  • choi nhac Reply
    3 years ago

    Pretty nice post. I simply stumbled upon your blog and wanted to mention that I’ve really enjoyed surfing around your weblog posts. After all I will be subscribing for your feed and I am hoping you write again very soon!

  • mực in Reply
    3 years ago

    It is perfect time to make some plans for the long run and it is time to be happy. I have read this post and if I could I want to counsel you few attention-grabbing things or suggestions. Maybe you can write subsequent articles relating to this article. I want to learn more things about it!

  • greg Reply
    3 years ago

    what’s your opinion of stata?

  • travel sites Reply
    2 months ago

    worth enough for me. Personally,

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>