The Leroy Merlin Group has deployed technology from Teradata to create a worldwide decision-making environment based on an enterprise data warehouse.
Lille, France-based Leroy Merlin consists of six brand names in the do-it-yourself and home improvement markets (superstores, medium-sized stores and discount stores): Leroy Merlin, Bricocenter, Bricoman, Weldom, Aki and DomPro. The Leroy Merlin Group operates in France and Brazil, China, Greece, Italy, Poland, Portugal, Russia and Spain.
The Leroy Merlin Group, through its different worldwide businesses, is committed to improving homes and their surrounding environment and providing complementary solutions to clients and their needs.
The Leroy Merlin Group selected Dayton, Oh-based Teradata, a division of NCR Corp. to consolidate into a single enterprise data warehouse all of the disparate information-processing systems and data marts that were used by its various divisions. This multipurpose, comprehensive tool now combines information on all customers, purchases, sales, inventory and product reference numbers. It does this by company, product and country. The data is drawn from the various operating systems and the different client interaction channels. In addition, it applies to all countries and all companies.
By implementing the Teradata warehouse, the Leroy Merlin Group can establish active enterprise intelligence for its strategic and operational needs. Information is updated in quasi-real time for a diverse group of users, including department managers, marketers, purchasers, sales directors, internal department employees and analysts.
In all, the Teradata data warehouse currently receives 120,000 SQL queries per month for Leroy Merlin France. Leroy Merlin Group chose Teradata due particularly to its high-volume data requirements. Currently, the group manages up to 5.4 terabytes of data, and this number is expected to grow. The Leroy Merlin Group said it is experiencing average annual revenue growth of 15 percent. Moreover, the system is now used by more than 1,000 employees in France and soon will be used by nearly 6,000 worldwide. Teradata Professional Services is handling the installation and integration of data analysis and restoration platforms.