Fashion Enterprise Data Warehouse

Technology Reply designs and implements specific Data Warehousing solutions for fashion companies

Scenario

Technology Reply responds to the need of large multinationals specialized in fashion to have a centralized database that allows the use of all the data coming from the various information systems. This database is the Enterprise Data Warehouse, Enterprise because it has to manage the information assets of all the brands that make up the group's portfolio, managing their peculiarities but also facilitating the transfer of knowledge and calculation rules between one brand and another.

Through Data Integration processes, data are acquired from heterogeneous sources, validated, integrated and made available through coherent and well-organized data structures. The data thus validated and structured are used for the construction of specific Datamarts that collect metrics and KPIs, even very complex ones.

The Data Integration and the feeding of the various Datamarts take place through structured ETL/ELT processes governed by a process management framework developed with the aim of standardizing the development of flows, reducing the effort for the acquisition of new information, ensuring the correct loading of data and that in case of anomalies, through notification alerts, allows a better management of any problems.

Information management is focused in order to meet all the needs of the typical processes of companies operating in this sector, covering the entire supply chain: from the procurement of raw materials, warehouse and production movements (supply chain), through orders of the finished product (sell-in), financial analysis (active and passive cycle), up to the purchase of the final consumer (sell-out & CRM). Particular attention was paid to the definition and calculation of "Customer KPIs", metrics that aim to analyse customer behaviour so as to be able to implement effective and personalized responses for each customer segment (eg targeted promotional campaigns).

The data of the Enterprise Data Warehouse are then used as a single source of truth for the construction of institutional dashboards, to perform Data Analysis, as input to other processes / information systems or for Data Discovery or Data Science processes.

Solution

In addition to software development, Technology Reply designs, validates, implements and configures the architectural solution that best suits the company's needs. Depending on the needs and use cases, it is possible to implement the solution using On Premise or Cloud services and technologies. Storage and management of different types of data can leverage services such as Oracle Autonomous Data Warehouse, Oracle Object Storage, or Oracle Big Data Service.

Oracle Data Integrator, a comprehensive data integration platform that covers all integration needs, is used to implement and monitor ETLs, from high-volume, high-performance batch loads to different processes and integration systems.

Through Oracle Analytics the information is made available to business users and data scientists, while with Oracle APEX, a low-code development platform, it is possible to quickly create web applications and allow direct interaction with data. Our professionals follow all phases of the project, from the collection of requirements to provide the Application Management service once the solution has been put into production.

Advantages

Technology Reply's Data Warehouse solutions are characterized by:

  • Organization – Thanks to modelling and development standards, the information stored in the Data Warehouse is organized in coherent and clear structures, facilitating the recognition of the information stored in them.
  • Consistency – Through a dependency mechanism, data is updated at the exact moment it is possible to do so, that is, when all source objects have been updated. In this way, data consistency is always guaranteed.
  • Ease and correctness of developments – The implementation of new ETL processes is focused on calculation logics since the management is carried out by the loading framework and is common to all processes. There are also a series of automatic checks that minimize the number of development errors.
  • Monitoring – The ETL process management framework allows you to effectively monitor load times, added/modified data volumes and their quality.