The Future of Financial Analysis with Advanced Analytics.

The way to conduct financial analysis is changing fast. In the last two decades, companies generally have undergone an intense process of computerization initiated by the field of accounting, with the use of management systems such as ERPs and CRMs. Today they produce much more ta anata than ever before and this equity needs to be analyzed from both the finance and investment standpoint as well as Data Analytics and Advanced Analytics.

In this article we will briefly compare the main changes that are occurring in the way financial analysts work with regard to their future in relation to the area of ​​Advanced Analytics.

Key motivators of changes in how to do financial analysis

The connectivity of recent years has generated new business models that could never before be imagined, being able to serve varied audiences 24 hours a day and with an unprecedented scalability in history, such as Uber for example. In addition, the volume of data has grown in size and complexity, creating a potential for insights and transformations in business that can be sure of purely financial analysis, done only by conventional methods.

Traditional Financial Analysis and Advanced Analytics Techniques

Financial analysis has well-established and widespread analysis methods. To say whether or not a company is interesting for business or investment is a task that is often satisfied by the analysis of past accounting / financial indicators. To do this, each analyst has specific criteria to evaluate the economic and financial feasibility of new investments, serving both corporate finance and personal finance.

Data Analytics methods, in turn, can be used to automate and optimize financial decisions, according to methods that are already used in the area. However, it is also possible, when using Advanced Analytics techniques, to incorporate machine learning and artificial intelligence algorithms to develop predictions in an innovative and yet unexplored way in the market: this is what will generate a great competitive advantage for companies in the financial market. industry 4.0.

Data Analytics and Advanced Analytics in practice :

Automate and optimize financial analytics with Data Analytics:

creation of datasets with automatic updating with macroeconomic data (basic interest rate, inflation, GDP, among others);

collecting data from financial statements in an automated way, either from companies open via API of already existing databases, or from closed companies, through extraction of tables of PDF files, for example;

creation of automated descriptive reports on the main changes in the macroeconomic scenario.

Make predictions with Advanced Analytics – machine learning, artificial intelligence, among others:

models adaptable to changes in economic and financial reality, capable of making recommendations and indicating directions for decision making.

If the financial analyst uses spreadsheets, such as Excel, to do his analyzes, he can then optimize the data extraction and cleaning processes with Data Analytics techniques and in the end obtain an output from an Excel spreadsheet so that he can work and perform the financial analyzes you are already accustomed to do. However, the great competitive advantage lies in the hands of analysts who can use Advanced Analytics to transform the way in which they perform their own financial analysis.

The area of ​​finance is also strongly influenced by the use of econometric methods to make forecasts. However, the use of conventional econometric models usually refers to models that are static. Several tests of robustness are usually made to validate such models, but the problem is that much of it is not adaptable to changes in economic and financial reality, typical situation due to the dynamism of financial markets. This versatility and adaptability to change are characteristics of models that use machine learning and artificial intelligence techniques in a coherent implementation of the data analytics culture among financial analysts.

The Data Analytics culture presents a different way of acquiring analytical knowledge from the traditional model. Achieving Analytics knowledge is more decentralized by the effect of the internet and the sharing of programming codes in package form (influence of computer science and versioning techniques). That is, instead of the analyst spending months or even years creating all the calculations in an isolated way in an Excel spreadsheet to reach a conclusion, with the culture of Data Analytics it is possible to import complete sets of codes that perform complex analyzes on the data in minutes, greatly speeding up the process.

To get an idea of the growth of this type of approach in problem solving, we present below the volume of packages added to the main repository of R language packs – CRAN.

The possibilities become so broad in this new mode that, in a few seconds, it is possible to install and execute commands for automatic generation of Internet Memes, like this one, with only 4 command lines.

For more information on this small package, see this article.


The same process facility extends to financial packages, such as:

TTR, tidyquant, PerformanceAnalytics, PortfolioAnalytics, quantmod, Quandl, among others.

Earlier we wrote about the need to incorporate R, given the traditional limitations of Excel – Leaving from Limited Excel to R or better Python? 

Comparison of traditional methods of financial analysis, Data Analytics and Advanced Analytics Typically, traditional financial analysis methods include stable, well-judged valuations without the need for presentation or discussion of the methods used. Already in Analytics methods, communities share codes and tools, not just concepts. See the table below for a comparison of the two approaches.

  Financial analysis Data Analytics Advanced Analytics
Replication level and analysis speed Low, since each worksheet is auto contained and changes are not shared Intermediate, using good practices of scripting and collaborative work. Spreadsheets in Dataset format. High, using structured systems to operate in a distributed way. Multiplatform of scalar form.
Use of Artificial Intelligence low Intermediate High
predictive analysis Trend analysis with strong use of temporal series, use of regression methods. In general, these are robust but static models. Predictions with statistical weights of all variables analyzed, with a wide range of generic algorithms available for analysis Continuous improvement of accuracy, speed and assertiveness of predictive models with weights in all variables discovered by the algorithms themselves.
analyzes focus Internal financial health data of the organization, comparison with similar organizations. Macroeconomic analyzes made on the basis of theoretical premises. Internal data, data linked to macroeconomic aspects, analysis of texts (such as minutes and explanatory notes), investigation of relationships also with non-financial data. Internal and external data at various levels of granularity.
Key Analysis Tools Excel and transactional systems such as:

ERPs (Link)

CRMs (Link)

SCMs – (Link)

Statistical and econometric software, such as: SPSS, Eviews, Stata.

R, Python or other specific programming notebooks, Data cleaning tools, data mining algorithm suites.

Pure text editors (example: Sublime)


Git – Code versioning and creative artifacts

Machine learning platforms and artificial intelligence, which contemplate the use of several algorithms. Use of distributed computing platforms, such as Spark and Hadoop.
license Closed Code Tools Open Code Tools Mix of open and closed code tools
Analyst main activities Analysis of financial statements and indicators. Development of economic / financial reports. Definition of financial analysis structures, preparation of Datasets, information flow of the indicators that compose the datasets. Not limited to financial indicators. Implantation of large-scale models in an integrated way to the transactional systems.

Final considerations and recommendations

The deeper impact of shifting the profile of financial analysis to Analytics paradigms occurs in the nature of the work of financial analysts, which becomes oriented to package orchestration and data flow through scripts, with less technical dependence on the IT sectors and Development.

For those who work in the area of financial analysis and intends to adapt to new market trends, increasingly based on data, we recommend an in-depth study of the basic packages of programming languages (mainly R and Python), how to use code versioning methods (such as Git or Github), participate in Data Science best practices communities in your region, or even online communities.

What is Aquarela Advanced Analytics?

Aquarela Analytics is the winner of the CNI Innovation Award in Brazil and a national reference in the application of corporate Artificial Intelligence in the industry and large companies. Through the Vorteris platform and the DCM methodology, it serves important clients such as Embraer (aerospace), Scania, Mercedes-Benz, Randon Group (automotive), SolarBR Coca-Cola (food retail), Hospital das Clínicas (healthcare), NTS-Brasil (oil and gas), Auren,SPIC Brasil (energy), Telefônica Vivo (telecommunications), among others.

Stay tuned following Aquarela’s Linkedin!

1 Comment

  1. seethalakshmi says:

    I would like to thank you for the efforts that you have made in writing this blog about financial data analytics. It is helpful for the people who want to know about it.

Leave a Reply

Your email address will not be published. Required fields are marked *

Send this to a friend