Case Study: Rexel Holdings Australia

Through its distribution networks for professional customers in the industrial, residential, and commercial sectors, Rexel globally provides electrical solutions and equipment. Rexel operates in 34 countries with 2,300 branches, a distribution network of more than 40 banners and 29,000 employees. In 2011, Rexel recorded sales of €12.7 billion.

Rexel Holdings Australia operates 200 branches in Australia and 70 in New Zealand.

The previous Data Warehouse ETL process was developed in C# and had problems with

  • ETL data reconciliation
  • The business lacking trust in the integrity of the Data Warehouse data
  • Overnight processes working well into business hours

There was also frustration that prior attempts to deliver business intelligence had failed to understand the business needs and to deliver outcomes.

Crossjoin.Net was commissioned by Rexel Holdings Australia to rebuild the ETL process uniformly across all Australian ERP systems on the Microsoft SSIS platform and to deliver reports and analysis tools to the Executives and key business users. A reporting and analysis model was created in Microsoft SSAS with reports delivered by Microsoft Reporting Services and Analysis by Microsoft Excel. The SSAS model holds the security framework which gives permission to individuals or Active Directory groups enabling them to only see data relevant to them. The model was built to scale to a potential estimated 900 users.

The solution has meant that

  • The business has a fulfillment of the BI promise to have accurate and timely data available for fixed reports and responsive analysis
  • The business has high confidence in the data warehouse data
  • Analysis drives informed decisions. The new models were quickly adopted by the executives and have enabled top-down direction based on facts
  • Visibility has resulted in changes to product classifications and incentives driving the behaviour