could you explain "analytics are the dual of forms" a bit? sounds intriguing!
Ah that was just a bit of a rhetorical flourish.
Forms put data into databases, analytics take it out and do stuff with it. That's kinda like a dual, if you squint and wave your hands enough.
Where VBA is concerned, forms to put data into the database, and analysis/report programs that take it out again, have always been the main use cases.
Clojure has great potential for what you're describing.