With such vast, desperate data sources, I find that it can be a challenge to answer certain business questions that should be easy. Our core is great 3NF schema, but not well suited to analytical use cases.
I'm wondering what BI platforms other credit unions use to integrate and analyze their data. Have others created their own OLAP schema? If so, what data store? Any experience with Redshift, BigQuery, or other cloud services?
On the other hand, does anyone use a fintech partner in this area that they would recommend?
I'd appreciate your input!