Presider Cuts Sales Area Analysis and Reporting Time by 70%
 
 

Presider Cuts Sales Area Analysis and Reporting Time by 70%

Printer View Printer View

With more than 40 years as a leader in its sector, Presider is one of the most important service centers in Italy providing steel used in metal structures. Its wide experience in complex manufacturing, the constant availability of beams and profiles, and the promptness and flexibility of its orders, make Presider an ideal partner for designers, steelwork businesses, and construction companies. Presider is a complete solution provider with advanced logistic sets, in-depth technical expertise, and flexibility to fit any situation. Based in the industrial hub of Avezzano (AQ), with a production area of 87,000 square meters, including 40,000 covered square meters, Presider produces more than 150,000 tons of materials per year to meet all the needs of its approximately 900 active customers.

Key to delivering on the needs of these 900 customers is Oracle Business Intelligence Suite, Enterprise Edition Plus 11g, which Presider recently upgraded to enhance its ability to manage sales reporting. Presider cut sales area reporting time by 70% and increased visibility into vital order and customer information needed to drive strategic decision-making.

 
 

 
 

Challenges

A word from Presider

  • "Oracle Business Intelligence Suite, Enterprise Edition Plus 11g, has become a valuable ally to Presider’s commercial team. The software’s advanced collaborative platform enables our users to produce ad hoc analysis and interactive reports, and has achieved strong benefits regarding efficacy and alignment to our business goals." – Franco Costantini, IT Manager, Presider

  • Meet its customers’ needs for prompt and flexible orders of steel products by using timely, actionable data to improve sales processes
  • Improve sales activity management by supporting the sales force with data analysis and real-time reports
  • Replace the previous, pure reporting system with a new tool to enable automatic synthesis analysis, graph creation, and activity scheduling
  • Improve analyses concerning the entry of new orders in real-time, negotiations monitoring, and customer classification
  • Eliminate time-consuming and complex manual operations to achieve visibility into new orders, exporting data into tables and graphs, and generating executive reports
  • Provide an immediate overview of the company enriched with detailed analyses for each division
  • Maintain the integrity and security of data from various sales areas

Solutions

Oracle Product and Services

  • Completed the update of Oracle Business Intelligence Suite, Enterprise Edition Plus 11g, thanks to the support of a dedicated migration tool designed to maintain old data and save components
  • Developed an infrastructure that can clean and aggregate large amounts of business data through strategic filters—such as an area manager—which are defined by the marketing department
  • Eliminated errors and manual extrapolations with use of these filters
  • Reduced operational efforts required by the sales staff to manage approximately 900 diverse steel product clients and more than100 daily orders  
  • Automated all the operational processes that do not involve user interaction, including sending weekly or monthly reports automatically, as attachments, to the sales network, the commercial director, and managing director
  • Reduced time required for sales analysis and reporting by 70%
  • Introduced new synthesis reports accessibile and personalized for each area manager in relation to his or her performance and agent network, provided through a new advanced internal access policy
  • Updated the previous static business graphics with new enhanced versions and flash animations for a more effective emphasis of results
  • Guaranteed timely reporting on service, in terms of budget, negotiations, and customer classification
  • Provided new tools to monitor quality and quantity trends on customers and sales, as well as budget gaps, while eliminating manual operations in Microsoft Excel
  • Created an interface with Google Maps that enables users to draw on the client database to display client addresses on maps, which improves geo-marketing analysis and optimizes agents activities and transfers