CKW's Oracle data warehouse was not able to provide the data structure and performance needed for reporting and and operational data needs.
We designed data views that encapsulated the core business logic, deployed as in-memory columnar data store at the CKW's Tableau server, and built rich and dynamic Tableau reports that show detailed information about trading positions, financial performance and risks.
The data design and architecture ensures that we can feed reports and ad-hoc analysis from two data sources with up to ~100M rows, without having to rely on report-specific ETL.