Analytics Architecture Optimization

Context:

As a consequence of a piling up of data volume in an analytical pattern without a Data Warehouse, some analytical documents were taking more than 3 minutes to load, which is unacceptable to an end user.

Benefits:

Load times went from 3 minutes average to 2 seconds.
Analytics Architecture simplified by querying 1 data source instead of 5.
End user was happy again.

Work added: 06.10.20

Up