1. Concepts and definitions

Summary

Data analysis is an activity integrated with others such as data engineering and data science, sharing concepts and tools with them and often overlapping with them in the daily work of many organizations. For this very reason, a professional in the field needs to recognize what falls within the scope of data analysis and how it relates to the rest of the data lifecycle.

This creates the need to define and understand fundamental concepts in order to draw that distinction. As often happens in other fields, several of these concepts are borrowed from English and used that way every day, which in some cases adds to the confusion. Moreover, definitions are not always unanimous: they depend on each author and evolve over time. This calls for constant training, updating and reflection.

As an activity, data analysis mainly requires knowledge of statistics and of the domain (or the business), so as to be able to work with the data, draw conclusions and translate those conclusions into recommendations or actions (or simply produce information / knowledge for later use).

The role does not necessarily involve programming languages, although (at the field's current stage) learning to use them is usually highly advisable. Without them, experience with at least one visualization tool (Tableau, Power BI, Looker) and advanced use of spreadsheets (Excel, Google Sheets) are essential.

Returning to what was said, some degree of data transformation is also commonly needed. In that respect, Python, R and SQL are very helpful tools, which of course can also be used later in the analysis itself. In fact, their use has become increasingly mandatory for working with large volumes of data and building complex models, which would be unfeasible to implement with tools such as those mentioned above.

After the analysis, presenting the results is extremely important, and can even set an analyst apart. In that sense, a well-rounded data analyst has the ability to produce reports and visualizations, setting the technical side aside and showing the results of the analysis effectively and simply.

To sum up, data analysis has become a body of knowledge and techniques that, with the right tools and properly framed within a data analytics process, enables decision-making within organizations through the exploration of and inference from data.

Further reading