Data warehouse solution for a leading apparel Retailer.

The client is a large multi billion-dollar retailer of apparel with stores across the United States and Europe.

Challenge

The company was losing customers & revenue and required a centralized merchandising planning, ordering and management system. Customer needed to respond to consumer buying trends; needed better visibility into inventory positions; and wanted to customize offerings at regional and local levels.

Solution

• iGlades designed a cloud-based Data Warehouse to assist with the decision support systems.
• Designed Data Marts for supplier, customer and sales and marketing information.
• The system design was star shaped schema geared towards serving as a central data storage hub for data from source systems to store data required for analytics.
• Used Talend fro data integration from the source systems.
• The solution was delivered in a smooth transition across all phases, ensuring tight coupling between the selected technology and the business needs, considerably enhanced time to market and reduced total cost of ownership.
• Through effective use of optimization and collaborative technologies in merchandising and inventory control the client was able to create real, differential customer value.

Benefits

• Enabled the Client to reduce suppliers to one-third fewer suppliers and spend 25 percent less on procurement.
• Executing Consistently Across Multiple Channels: Integrating data from multiple systems and harnessing the data through business intelligence helped the marketing efforts to deliver consistent quality customer experience and high levels of service.
• Customer sales and product information helped devise effective pricing strategies paving the way for better turns, higher margins and improved merchandise presentation.
• Customer is now able to accurately measuring Performance from brand effectiveness to vendor analysis and sales trends, analysis on top performers use fast and reliable access to timely, accurate data in order to react nimbly and intelligently to market changes and emerging trends.

Technologies used:

• Data Warehouse - Google Cloud
• Data Integration (ETL): Talend 3.x
• Business Intelligence - Apache Spark 3.x, Hadoop 3.x