Powerpivot support

Hi, I have a use case where I need to mimic for our users, Analysis Services-like functionality in Excel, as we consider moving from the Microsoft BI stack to Redshift.

For this, Powerpivot is an attractive option, and I was wondering if anyone has successfully tried the Redshift OLE DB driver with Powerpivot, and if there are any pitfalls to be mindful of. Any information/insights will be helpful as I go down this path. Thanks!

I'm not an expert in Powerpivot, but to my best knowledge several companies are using the OLEDB provider with it. If I hear about issues/pitfalls, I will update this thread.