Excel can get data from APIs nowadays (and even use modern auth!). I've been reasonably successful at creating a data environment for my company in which all t

Excel can get data from APIs nowadays (and even use modern auth!). I've been reasonably successful at creating a data environment for my company in which all the data is exposed through REST APIs. The existing tooling for APIs in general is top notch. Also, you get a lot of architectural flexibility.