The government and a lot of other companies are absolutely incapable of not using Excel and Azure services. It’s possible they could teach people new tools but databases, tables, excel files, VBA stuff, SQL etc… Is just not going to get changed. Alternatives are way too expensive and the sheer amount of work to make sure every single ETL rule is followed would be absolutely insane. The cybersecurity alone will make it a no go.
You don’t need excel, you could convert to libreoffice spreadsheets, there may be a few functions that need adjustment, but I have found its pretty much feature for feature. There are also so many SQL derivatives mariaDB, mySQL, postgresSQL.
There would be a few pains, but as Europe has already realized we need data and software sovereignty
The government and a lot of other companies are absolutely incapable of not using Excel and Azure services. It’s possible they could teach people new tools but databases, tables, excel files, VBA stuff, SQL etc… Is just not going to get changed. Alternatives are way too expensive and the sheer amount of work to make sure every single ETL rule is followed would be absolutely insane. The cybersecurity alone will make it a no go.
No AI will not solve this.
You don’t need excel, you could convert to libreoffice spreadsheets, there may be a few functions that need adjustment, but I have found its pretty much feature for feature. There are also so many SQL derivatives mariaDB, mySQL, postgresSQL. There would be a few pains, but as Europe has already realized we need data and software sovereignty
Postgres is very cheap.
VB is garbage and anything using it should have been scrapped decades ago.