Oilily - thedatacooks.com

CUSTOMER

Oilily

INDUSTRY

Fashion retail

ORGANIZATION

60+

COUNTRY

Worldwide

How Oilily Transformed Its Sales Insights

Oilily, a renowned fashion brand known for its vibrant designs, needed to streamline their sales and inventory data from multiple sources to create a unified view. With their data spread across both e-commerce platforms and ERP systems (initially Styleman and later ItsPerfect), they required a comprehensive solution that could integrate these streams, clean and transform the data, and deliver actionable insights. The Data Cooks were brought in to build a robust ETL solution and provide data visualizations for key performance metrics such as sales, returns, sell-through rates, and year-over-year growth.

The challenge

Oilily’s sales and inventory data was dispersed across different platforms, with Styleman as their previous ERP system and ItsPerfect as the new one. This transition added complexity to the integration, as the data from the two systems needed to be consolidated without disrupting ongoing operations. Moreover, they needed clear insights into crucial business metrics—sales, returns, and sell-through rates—while comparing growth against last year’s performance. Without a unified data source, making informed, timely decisions was difficult.

The Solution / Added Value

The Data Cooks delivered a full-scale solution that integrated all sales and inventory data into one source of truth. Here’s how we tackled the project:

ETL Solution for Data Integration: We built an ETL pipeline that efficiently pulled data from both Oilily’s e-commerce platforms and their ERP systems (Styleman and ItsPerfect). This ensured seamless integration of historical data from Styleman with new data from ItsPerfect, creating a consistent, reliable data source for ongoing analysis.
Data Cleaning and Transformation: Throughout the project, we applied advanced data cleaning and transformation techniques, ensuring that all data was standardized and formatted correctly. This was essential for maintaining accuracy across different platforms and for preparing the data for visualization.
Power BI Dashboards: We designed interactive Power BI dashboards that provided real-time insights into sales performance, returns, sell-through rates, and growth compared to the previous year. The visualizations allowed Oilily’s management to monitor these KPIs in an easy-to-understand format, empowering them to make data-driven decisions about inventory management, marketing, and growth strategies.

Conclusion

With The Data Cooks’ data integration and visualization solution, Oilily now has a unified view of their sales and inventory across all platforms. The integration of their e-commerce and ERP data into one source of truth has improved their ability to track key metrics such as sales, returns, and sell-through rates. Moreover, by comparing growth versus last year in real time, Oilily is better positioned to optimize their business operations and drive future growth.