Blanco – BI Performance Optimization

Blanco – BI Performance Optimization


BLANCO entrusted this project to ASPA to meet the need of optimizing the performance of BI reporting needed to improve response times for a system that handles a high volume of data. In order to do this, ASPA and BLANCO, chose four parallel lines of action:

– Business Intelligence Accelerator: Implementation, adaptation and stabilization of this tool in the BI environment.


– InfoCube archiving of non-cumulative stocks: Performing an archiving of historical data and the corresponding mark to reduce the size of the database, the volume at that time amounted to 990 million records.

– Optimization of InfoCubes and reports: Conducting analysis and improvement of design of more problematic structures, as well as the heavier queries.

– Broadcaster and Precalculation Service: Planning and pre-calculation of reports with longer access to database.


Blanco is a Spanish Multinational Company, dedicated to the design, manufacture and marketing of all kinds of accessories and clothing for the young urban woman and man. The company offers the latest fashion trends in their own outlets.

The chain is composed, as of today, over 170 stores, including Spain, Portugal, UK and Saudi Arabia, all located in the main areas of the major cities and in the most prestigious shopping centers. They also have nearly 2,000 employees among the stores staff and the people who work at the headquarters and logistics platform.

In addition to creating a unique product, its goal is to offer fashion to their customers and make shopping a pleasant experience. Its target is a young urban audience that demands fashion and quality at reasonable prices. The company sells 18 million apparels a year and has highly optimized logistics processes that minimize the time of supply of goods, with the objective of receiving new models every week.