The architecture was implemented in the BI@AWS project in the AWS Cloud. Various AWS-native tools were used in the process. ● Loading data from the source into the data lake: Python. In particular, the implementation of the GDPR and the dynamic loading of the raw data could be performed well with this. ● The Snowflake DB was used for the implementation of the EDW. This is a database developed for data warehousing that runs natively in the AWS Cloud. ● Snowpipe was used to transfer the data from the data lake to the EDW layer.
Project procedure illustration :
The concrete solution for the customer was that the access to the data overview was simplified. Ad- ditionally, the Scalefree Consultants developed a GDPR-compliant data infrastructure for the client. For the multi-temporal analysis of data, the access was simplified. Further, network resources have been significantly secured to prevent unauthorized access. Adding to the result, knowledge transfer through knowledge management systems and workshops with users was achieved. Finally, a clean documentation and guideline was created by Scalefree regarding the integrated system.
Scalefree International GmbH Schützenallee 3, 30519 Hannover, Germany
P: +49 (511) 879 893 41 M:+49 (175) 811 0336 F: +49 (511) 879 893 49
info@scalefree.com www.scalefree.com
CEOs: Michael Olschimke & Christof Wenzeritt
3/3
New Business Intelligence and Analytics Landscape for a Insurance Company © Scalefree International GmbH 202 3
Powered by FlippingBook