Tools For Data Analysis

Home/Data Analysis/Tools For Data Analysis

What are the available Tools for Data Analysis? This is the first question I asked myself when I decided to start my career in Analytics. I used to have lots of other questions like – Which software or tools should I learn to begin my career and grow in the field of analytics? And which is best software for data analysis?.
tools for data analysis



50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates

Tools for Data Analysis will help you to perform analytics. Our easy to follow step by step learning path will help you in mastering Data Analysis. Start learning…

Tools for Data Analysis – Learning Path

Tools for Data Analysis – Learning Outcomes

  • Excel VBA Basic tutorials will help you getting started with the VBA
  • You will get to know the different tools available for Data Analysis
  • You can understand the purpose and scope of each tool
  • You can overall understanding of the Analytical tools
  • You can understand – What to learn and where to start?

I am a master in Statistics and I only know MS Office by that time. The first company which I went for the interview is one of the leading research companies in the world. And they tested my skills on Microsoft Excel and the understanding of basic statistical concepts. I got selected!:-)

In this tutorial I am going to discuss the different tools available in the market for data analysis. And the learning path – which should answer your questions like: Which tools I should learn? Where to begin?etc.

Tools for Data Analysis – Different Kinds of the Tools

The size of the data is growing rapidly at the same time we have lots of tools to deal with that data. We can categorize the software/tools based on the tasks and data that they can deal with. We can classify the available tools in the market based one request type (discussed in: Data Analysis – An Introduction) as Reports and Dashboard development Tools, Statistical Packages and BI Tools.

Tools for Data Analysis – Reports and Dashboard development Tools

Report generation and Dashboard development is a daily task for any organization. They want to understand the data on timely basis. They will generate the reports daily, weekly, monthly, yearly and ad-hoc reports and dashboards. There are many tools available in the market like MS Excel, Tableau, QlikView, Spotfire. These tools are only for develop the reports and dashboards, they are also adding the capabilities or functionality to perform on statistical analysis. Excel is spreadsheet application. And we can say Tableau, QlikView, Spotfire are BI Tools. They have powerful engines to perform ETL.

Tools for Data Analysis – Statistical Packages

SAS and SPSS are the leaders to perform the advanced statistical modelling. We also have many other open source tools like R to perform statistical analysis. You have many bulit-in procedures and tools to deal with your data. You can do extracting the data, data cleaning, formatting the data, Tabulation and statistical analysis. And you can SAS and SPSS are BI Tools as they have very powerful modules to perform ETL.

Tools for Data Analysis – BI Tools

MS SQL Server, Oracle, SAP, Microstrategy, Spotfire, QlikView, SAS, SPSS Modeler are the leaders in this market. They can deal with large amount of data and perform the ETL and drill-down Analysis. We will see more about BI concepts in a separate topic.

Understanding the Tools and Market

Tools for Data Analysis – MS Excel

Almost every organization uses MS Office suite and Excel. Excel is an excellent reporting and dash boarding tool. We can develop rich visualized dashboards, simulation tools using VBA programming available in the Excel. You can basic statistical techniques for analyzing the data. You may use some other tool for performing advanced statistical analysis, you will still end up with using Excel for the reporting and presentation. The built-in tools like Charts, Pivot tables, Add-ins and the VBA programming are making excel as powerful tool for reporting and dashboard and Tools development.The new Office 2013 added many new features for developing rich visualized dashboards.

analysis tools-excel

You can find more at official site.

Tools for Data Analysis – Tableau

I have used Tableau for developing dashboards and report. It is a very rich visualized dashboard development tool. It is very easy to prepare dashboards. You have the different options and applications in tableau. You can tableau desktop for developing the reports on your desktop. You can also use Tableau server to deploy your dashboards online, so that you can access from any where in the world. It is also providing a free version for public, you can connect to basic data sources like text, csv or excel file. recently they have enhanced data storage limit from 50 MB to 1 GB. so that you can around .
Another beauty of tableau is you can connect all types of database.

analysis tools-tableau

You can visit official site of for more information.

Tools for Data Analysis – TIBCO Spotfire

TIBCO Spotfire is very powerful BI Tool allows users to analyze data using statistics. It has ability to develop dynamic analytic applications and predictive analytics to speed decisions and help customers achieve their goals. You can sample screen-shot of TIBCO Spotfire here. You can read more at official site of

Tools for Data Analysis – Qlikview

Qlikview is another powerful BI Tool allows users to analyze data, it has scripting capability. So we can have more control to accessing the data. You can read more at official site of

Tools for Data Analysis – SAS

SAS is the leader in analytics world, it is the largest independent organization in the business intelligence market. It is the most commonly used software in the analytics, it has wide range of capabilities from data creation to advanced statistical analysis. It has many powerful and specialized module for dealing with different tasks like SAS DI, eminer, etc. Please visit the official site of for more information.

Tools for Data Analysis – IBM SPSS

SPSS holds the second position after SAS in the analytics world. It has wide range of tools to deal with all kind of analytics problems. It has Data Collection platform Dimensions (Now IBM PASW) for survey analytics, and SPSS Clementine (Now Modeler) for data mining and text mining and SPSS Statistics to perform basic to advanced statistical techniques. Please visit the official site of for more information.

Learning Paths

The following is the learning path, you can start learning from the basic excel to BI tool developed. The idea of launching this site is to help you in learning the skills required for your role. You may not to learn all the subjects mentioned here, you choose based on the projects you are handling and based on you professional goals.

Data Analyst:

Job Role 1: Mainly deal with copying the data from different sources, formatting the data, preparing the basic reports and dashboards. They are required to have the following skill set to deal with their projects:

  • Excel Basics: This will help you to copy the data from different sources
  • Excel Formulas: You can formulate and perform calculations on the data to achieve required results
  • Advanced Excel: You can summarize the data and prepare the reports/dashboards
  • Excel Macros (Not necessary, recommended): You can fasten you process with simple macros
  • PowerPoint: You can prepare the presentations by putting down your observations and figures

Related Resource External VBA Reference
Excel VBA Reference Project Management Reference
VBA Reference:
Excel Reference:
By |July 4th, 2013|Data Analysis|2 Comments

About the Author:

PNRao is a passionate business analyst and having close to 10 years of experience in Data Mining, Data Analysis and Application Development. This blog is his passion to learn new skills and share his knowledge to make you expertise in Data Analysis (Excel, VBA, SQL, SAS, Statistical Methods, Market Research Methodologies and Data Analysis Techniques).


  1. February 13, 2014 at 11:56 PM - Reply

    Data Visualization Software

    SQIAR () is a leading Business intelligence Company.Using Tableau,SQIAR rapidly transform your sea of uncorrelated data into meaningful interactive and actionable visual insights.SQIAR Provide Services in United kingdom and USA.

  2. October 30, 2015 at 5:44 PM - Reply

    Good article with precise information….

Leave A Comment

Related pages

colorful tabswhat is ddl and dml in sql serverclear comboboxcheckboxes in excel 2007excel vba write to text fileexcel vba button propertiesddl queries in sqlaccess vba msgboxexcel 2010 pivot table wizardvba macros excelremove duplicates vbaexcel expert tutorial pdfexcel 2007 hyperlinkpivot table setupadvanced ms excel tutorialinsert row on excelrun macro when excel openshow to program vbacount rows excel vbaexcel getopenfilenamehlookup vbaexcel combining worksheetsvb script excelvba filedialog filterexcel programming samplesado connectionstringhow to put drop down list in excel 2007hlookup tutorialdo while loop vba exceliserror excel formulatools in excel 2007 macro securityuseful excel macros exampleslearning sas by examplevba insert blank rowcoding macros in excelvba macros for beginnersvba active workbookadvanced pivot table excel 2007macro in xlspivot chart excel 2007vba close excelexcel formulas lenexcel checkbox valueexcel consolidate toolwhat is merging cells in exceldcl queriesvba excel cell referencecalendar timeline template excelexcel delete rowscopy data from multiple worksheets into onems excel advanced tutorialvba macro buttonhow to hide formula in excel without protecting sheetexcel vba syntax guidehow to use lookup function in excel 2010tutorial macros excelexcel vba toolswhat is the purpose of vlookuphow to remove blank rows excelfind duplicates in a columnnested if function excel 2010how to eliminate duplicate records in excelhow to lock an excel spreadsheetvba entirecolumnvba check file existsvba automationexcel vba status barexcel vba addressactiveworkbook saveasscripting.filesystemobject delete fileshortcut keys for excel 2007excel hyperlink buttonvba code to save excel fileadding lines to excel spreadsheetvba clean functionexcel vba print form