What are the best tools for data analysis (Paid & open source) in market trend in 2016 and increasing?

1. From Microsoft, there is SQL Server Services that support full business intelligence solution delivery requirements. Those services are SSIS, SSRS, and SSAS. 
2. HADOOP.
3. R Programming Language. It provides a banch of very important modules that can be used to achieve accurate statistical calculations and perform complex data analysis algorithms.

1. Apache Drill For data analysis

2. R- Programming for statistical data analysis

3. Horton and Cloudera For Bigdata Managment

4. Tableau for visual reporting and BI Dashboards

5. for smaller organsations, SSIS , SSAS and RS are best :)

If by data analysis you mean mathematical/statistical analysis then R and Python are good free tools. IBM SPSS is good statistical and data mining licensed/paid tool. 

For visual data analysis, Tableau and Qlikview is good. You can use Qlikivew for data analysis for free as long as you use it for your personal use on only your machine. 

Depeneds on the system that you would like to get data from. Wehn you talk about open source, the best choice would be Bigdata solutions. It is really powerful platform with multiple frameworks to ingest data (Apache Flume, Sqoop), Analyze the data (Pig latin, Impala, HQL, Spark), Machine learning (Mahout, Spark Mlib) etc.

When talking about paid, Splunk is one of the best log management and data analysis tools out there. It is very powerful.

OBIEE, QlickView, Business Objects, Cognos.

Actually the tools vary depending upon the various regions and industries. Still Business objects is the tool most widely used across enterprises.

i prefer you learn the concept of data analysis and then you can use any tool .. there is many tools depending on the size of your data size like ( SPSS or excel "MAX 1M Raw in excel 2016" ) you may use python or R and for data visualization you can use tableau or excel or Power BI

SAS or R

SAS is more widely used accross industry but R is quickly catching up.

From on wards its obvious about the Self service BI tools.

So we cant compare those products with SAP BO or other enterprise reporting tools.

However From SAP Self service BI tool 'Lumira' couldnt make that much impact on market since the Tableau, Qlik(QlikView& Qliksense) have bit top market in LSI & MSI. In addition to that Micosoft 'Power BI' also trying to achieve some market place since the mid of.

OBIEE,QlikView,Tablue,Buisness Objects,Congnos

SAP - Bussince Object tools