10 Most Popular Analytics Tools in Business

12

Update 2017: This article on most popular analytics tools was originally written more than 5 years ago.  It has been updated a couple of times since then. However, the industry has changed rapidly in this time and the article continues to generate a lot of interest.

I felt it was time now to do a complete revamp and share the latest and most updated list of analytics tools with the readers. You can read the original article here. 

The analytics industry has seen a paradigm shift in how and which analytics tools are used. We have seen the demise of the SAS monopoly, which had for long been the case, giving way to increased adoption of open source tools.

Want to know more?

Field will not be visible to web visitor

I have worked on SAS for many years and it is a fantastic tool. However, the high pricing of the software was always a deterrent. Most small and medium companies could not afford the tool, and neither did it make sense for them to invest in it as their analysis needs were different. The companies that have and could use it, often ended up paying more for the tool than the analyst who worked on the tool and this was not an optimal scenario.

If we needed analytics to work for us the way we wanted it to, there was a terrible need for industry-wide adoption of cheaper tools, and better if they were free.

In line with the growing importance of open source tools in the field of analytics, I have decided to switch the order of listing the top tools. I will start with the most popular open source tools this time and then move on to the commercial or paid tools.

Open Source Analytics Tools

Here are the 5 most popular open source analytics tools:

R – R is now the most popular analytics tool in the industry. It has surpassed SAS in usage and is now the tool of choice even for companies that can easily afford SAS. Over the years, R has become a lot more robust. It handles large data sets much better than it used to, say even a decade earlier. It has also become a lot more versatile.

1800 new packages were introduced in R between April 2015 and April 2016. The total number of R packages is now over 8000. There are some concerns about the sheer number of packages but this has certainly added a lot to R’s capabilities. R also integrates very well with many Big Data platforms which has contributed to its success.

Python – Python has been a favorite of programmers for long. This is mainly because it’s an easy to learn language that is also quite fast. However, it developed into a powerful analytics tool with the development of analytical and statistical libraries like numpy, scipy etc. Today it offers a comprehensive coverage of statistical and mathematical functions.

Increasingly, we are seeing programmers and other tech folks moving into analytics. Most of these guys are already familiar with Python and therefore it has become a tool of choice for many data scientists.

Want to know more?

Field will not be visible to web visitor

 

Apache Spark – Spark is another open source processing engine that is built with a focus on analytics, especially on unstructured data or huge volumes of data. Spark has become tremendously popular in the last couple of years. This is because of various reasons – easy integration with the Hadoop ecosystem being one of them. Spark has its own machine learning library which makes it ideal for analytics as well.

Apache Storm – Storm is the Big Data tool of choice for moving data or when the data comes in as a continuous stream. Spark works on static data. Storm is ideal for real time analytics or stream processing.

PIG and HIVE – Pig and Hive are integral tools in the Hadoop ecosystem that reduce the complexity of writing MapReduce queries. Both these languages are like SQL (Hive more so than Pig). Most companies that work with Big Data and leverage the Hadoop platform use Pig and/or Hive.

Commercial Analytics Tools

Now, let’s take a look at the 5 most popular paid analytics tools:

SAS – SAS continues to be widely used in the industry. Some flexibility on pricing from the SAS Institute has helped its cause. SAS continues to be a robust, versatile and easy to learn tool. SAS has added tons of new modules. Some of the specialized modules that have been added in the recent past are – SAS analytics for IOT, SAS Anti-money Laundering, and SAS Analytics Pro for Midsize Business.

Tableau – Tableau is an easy to learn tool that does an effective job of slicing and dicing your data and creating great visualizations and dashboards. Tableau can create better visualizations than Excel and can most definitely handle much more data than Excel can. If you want interactivity in your plots, then Tableau is surely the way to go.

Excel – Excel is of course the most widely used analytics tool in the world. I have seldom come across a data scientist who does not use Excel. Whether you are an expert in R or Tableau, you will still use Excel for the grunt work. Non-analytics professionals will usually not have access to tools like SAS or R on their machines. But everyone has Excel. Excel becomes vital when the analytics team interfaces with the business steam.

QlikView – Qlikview and Tableau are essentially vying for the top spot amongst the data visualization giants. Qlikview is supposed to be slightly faster than Tableau and gives experienced users a bit more flexibility. Tableau has a more intuitive GUI and is easier to learn.

Splunk – Splunk is more popular than some of the more known names like Cloudera and Hortonworks. It started as a ‘Google for log files’ which means its primary use was to process machine log files data. It has now become much more than that. Splunk has great visualization options and a web interface makes it easy to use.

Top Companies Using the Most Popular Analytics Tools

companies using analytics

This is the new and updated list of the most popular tools in the analytics industry. If you are interested in learning these tools, here is what you need to do.

To learn SAS, R, and Python, head to our Data Scientist Specialization. Spark, Storm, and other Big Data technologies are covered in the Big Data Analyst Specialization. We have a course on Analytics with Excel as well that will help you take your step into analytics.


Suggested Read

Top 5 Skills Every Data Scientist Should Know in 2017

Why Python is a Boon for Programmers

How to Become a Big Data Analyst?

Confused About a Data Science with R vs. Big Data Analytics with Hadoop Course?

What Should You Learn: R or Python?

 

12 Comments
  1. RangaPrasath.S says

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

  2. Anita Ghatnekar says

    I am looking for Sales Analysis and Inference from that

  3. shiv says

    whats the authenticity of data that you present here?

  4. Alfredo says

    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

  5. choi nhac says

    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!

  6. mực in says

    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!

  7. greg says

    what’s your opinion of stata?

  8. Medical Schools says

    I’ll definitely be back.|

  9. Physical Education says

    I must say that you’ve done a superb job with this.

  10. cheap travel says

    I’ve read this post and if I could I wish to suggest you some interesting things or suggestions. Maybe you could write next articles referring to this article. I desire to read more things about it!|

  11. xfinity promotionss says

    Simply wish to say your article is as surprising. The clarity to your put up is simply excellent and that i can suppose you’re an expert on this subject. Fine together with your permission let me to clutch your RSS feed to keep up to date with coming near near post. Thank you one million and please keep up the rewarding work.|

  12. pandiri pavankumar says

    Sas has been advised as the best tool for pharmacy/life science domain, is it still the same, or do you advise any tool other tool instead of sas especially for pharmacy/ do you advise any other tool in addition to sas

Leave A Reply

Your email address will not be published.

Want to know more?

Field will not be visible to web visitor