Technology and Tools for Data Analysis

As we have seen in the previous chapter, Data Science is a multidisciplinary approach that combines concepts and practices from the fields of mathematics, statistics, AI, ML and Deep Learning. Data Science also encompasses Data Analytics.

Data access, processing, transforming and loading are the key processes that prepare the data for further analysis. Most tools make use of SQL and Python as the underlying technology for data analysis. While various tools have their own user interface and define their own workflows, it is important to note that SQL and Python are likely used as the basic building blocks. The typical stack of tools and technology for data analysis is depicted below.

We will now look at some of the popular tools for data analysis and their capabilities.