newbie question: I am looking to move away from SSAS, but most of my data consumers are using Excel. What is user's experience in Excel when connecting to Pinot?

What's the data size. We are not aware of anyone who has tried Excel on Pinot. Pinot does support jdbc driver and you can probably try that. Here is more information on jdbc driver https://docs.pinot.apache.org/users/clients/jdbc