SFD

About SFD

SFD is a distribution network that sells offers and products from SFR.

Some figures

• 270 stores under the “Espace SFR” name 
• 2,200 employees 
• A subsidiary that is 49%-owned by Cegetel

A large-scale technical project for a high-performance management system

• 2,500 records per day integrated in 1.5 hours of processing
• 100 Reporting Services reports
• 6 Analysis services cubes
• 90,000 reports consulted per month
• 99% of reports shown in less than 3 seconds

Architecture of solution :

• SQL Server 2005
• Integration Services
• Reporting Services
• Analysis Services
  

Putting in place a data warehouse and analysis and reporting tools to offer the various departments in the company (Gen Mgt, Accounting and Finance, HR, Marketing, Sales, After-Sales etc.) a genuine management tool.

The challenges

Thanks to the new architecture and its new tools, SFD is able to deliver to all its employees the information they need to improve efficiency and responsiveness in the very competitive market of fixed and mobile telephony.

Benefits

The new DIS (decision-making information system) offers all the features of modern management tools: 

• Decompartmentalisation of information: no borders between the different functional areas (40% of project indicators are multi-departmental); 
• Easily accessible information: navigation is rapid and intuitive when accessing the required information; 
• Highlighting of critical information thanks to the use of alerts, ranking and Scorecard indicators.

These features enable SFD to meet its corporate management objectives by having: 

• monitoring / reporting indicators giving explanatory factors about performance
• management indicators enabling forward planning and quicker decision-making

The innovative approach used by Oresys enabled SFD to benefit quickly from an effective, long-lasting, upgradeable solution that fully met its users’ expectations.

With functional coverage covering all the reporting and management needs, for operational staff, functional departments and general management, this project was at the heart of the company’s business and is a concrete example of the potential of modern DIS.