Unified Analytics is an engineering design that appropriates inquiries straightforwardly to sources by means of the SAP Data Warehouse Cloud and assists with building more extravagant live information investigation on SAP Analytics Cloud consolidating SAP and non-SAP information, along these lines killing the requirement for information replication or duplication.

SAP revelation focus mission clarifying this engineering design

Related blog clarifying Data Federation between SAP Data Warehouse Cloud and Amazon Athena

In this blog, we will walk you through a new approval practice for this design done at an SAP Brim Solutions Strategic client, Decathlon for their business use case.

Client : Decathlon, A France based enormous outdoor supplies retailer.
Business Use Case and Motivation:
Decathlon's difficulties with current examination arrangement incorporate volume limit with information import and that information from their hyper scale sources couldn't be gotten live on outlines for improving investigation. Decathlon has a lot of deals and guage deals information split across a few tables put away in Apache Parquet design in their Amazon S3 information lakes. The normal result from the proposed arrangement is end of the import difficulties and bringing information live for improving near examination of estimated and genuine deals information on a story dashboard .

The Solution Architecture:
This utilization case serves to straightforwardly fit the Federated Analytics engineering where SAP Data Warehouse Cloud, SAP Analytics Cloud and Amazon Athena Services are coordinated to make the investigation arrangement start to finish.

Decathlon's Amazon Athena housed their athletic gear determined deals information just as verifiable week by week real deals information in tables and perspectives (questioned progressively straightforwardly against their few parquet records in Amazon S3 information lakes, approximately 40 million columns in for this approval).

This Amazon Athena is associated with SAP Data Warehouse Cloud where remote tables are demonstrated to look into Athena information.

Scientific models made off of the remote tables are utilized for changing, totaling and projecting the information straightforwardly questioned from Amazon Athena. The examination story made in their outer SAP Analytics Cloud inhabitant consumes these remote models to get the information for rich Visualizations.