Are bank consultants allowed to advise clients by analyzing transaction patterns in their accounts?

A consultant can really do whatever they want, however, many countries do regulate on who can dispense financial advice on a professional basis.

Investment advice is more regulated. However, what you cite above, can be done, if a consultant is in this business.