Accelerating financial planning
公司规模
Mid-size Company
地区
- Europe
国家
- Germany
- Belgium
- Netherlands
产品
- Talend Data Integration
技术栈
- ETL System
- QlikView
- Jedox
实施规模
- Enterprise-wide Deployment
影响指标
- Productivity Improvements
- Cost Savings
- Digital Expertise
技术
- 应用基础设施与中间件 - 数据交换与集成
- 分析与建模 - 预测分析
适用行业
- 食品与饮料
适用功能
- 商业运营
服务
- 系统集成
关于客户
Pernod Ricard is the second-largest wine and spirits company in the world, with a leading market position on every continent. The group employs over 18,500 people in 80 countries, with around 200 working at the Pernod Ricard Germany headquarters in Cologne. As the German subsidiary of the international wine and spirits company, Pernod Ricard Germany boasts a portfolio of well-known spirits such as Ramazzotti, Havana Club, Absolut Vodka, and Ballantine’s. For over 25 years, Pernod Ricard has been successfully operating in the German market and has long been the market leader. At the German site in Cologne, the warmth of the Rhine region meets the flair of French life, and the international spirits brands reflect the traditions and cultures of their homelands.
挑战
Until now, Pernod Ricard Deutschland GmbH used the parent company’s reporting structure, which was initially designed for another location and no longer met its requirements. Processing logistics data with the existing ETL tool was time-consuming and resource-intensive, with processes that were not transparent and difficult to adapt. The quality of data was not guaranteed, leading to inaccurate figures for reporting. The multidimensional planning solution developed over time no longer met performance requirements, necessitating a restructuring of content. A lack of transparency and unreliable data often provided inaccurate figures for reporting. Pernod Ricard sought an IT service provider capable of identifying individual data sources and understanding their use. The data had to be checked, corrected, backed up, and integrated into a single platform to obtain a 'single point of truth' for their corporate planning structure.
解决方案
Timetoact, Pernod Ricard’s partner, developed several solutions, partially covering the data source nodes and was the first contact partner for the transformation of the data platform. A complete redesign was decided upon, and Timetoact created a new ETL system from the data sources to the central data warehouse. Regular checks were done to verify the correctness of the information used. The new system provided a 'single point of truth' for the management team to reliably control German market activities. The project involved unifying various source systems in Germany and persuading individual subsidiaries to adopt a consistent planning format. Talend was chosen for its intuitive and transparent graphical user interface, which helped users understand the processes, and for its ability to integrate data from various sources and transfer it to BI solutions like QlikView or Jedox.
运营影响
数量效益
Case Study missing?
Start adding your own!
Register with your work email and create a new case study profile for your business.
相关案例.
Case Study
The Kellogg Company
Kellogg keeps a close eye on its trade spend, analyzing large volumes of data and running complex simulations to predict which promotional activities will be the most effective. Kellogg needed to decrease the trade spend but its traditional relational database on premises could not keep up with the pace of demand.
Case Study
HEINEKEN Uses the Cloud to Reach 10.5 Million Consumers
For 2012 campaign, the Bond promotion, it planned to launch the campaign at the same time everywhere on the planet. That created unprecedented challenges for HEINEKEN—nowhere more so than in its technology operation. The primary digital content for the campaign was a 100-megabyte movie that had to play flawlessly for millions of viewers worldwide. After all, Bond never fails. No one was going to tolerate a technology failure that might bruise his brand.Previously, HEINEKEN had supported digital media at its outsourced datacenter. But that datacenter lacked the computing resources HEINEKEN needed, and building them—especially to support peak traffic that would total millions of simultaneous hits—would have been both time-consuming and expensive. Nor would it have provided the geographic reach that HEINEKEN needed to minimize latency worldwide.
Case Study
Energy Management System at Sugar Industry
The company wanted to use the information from the system to claim under the renewable energy certificate scheme. The benefit to the company under the renewable energy certificates is Rs 75 million a year. To enable the above, an end-to-end solution for load monitoring, consumption monitoring, online data monitoring, automatic meter data acquisition which can be exported to SAP and other applications is required.
Case Study
Coca Cola Swaziland Conco Case Study
Coco Cola Swaziland, South Africa would like to find a solution that would enable the following results: - Reduce energy consumption by 20% in one year. - Formulate a series of strategic initiatives that would enlist the commitment of corporate management and create employee awareness while helping meet departmental targets and investing in tools that assist with energy management. - Formulate a series of tactical initiatives that would optimize energy usage on the shop floor. These would include charging forklifts and running cold rooms only during off-peak periods, running the dust extractors only during working hours and basing lights and air-conditioning on someone’s presence. - Increase visibility into the factory and other processes. - Enable limited, non-intrusive control functions for certain processes.
Case Study
Temperature Monitoring for Restaurant Food Storage
When it came to implementing a solution, Mr. Nesbitt had an idea of what functionality that he wanted. Although not mandated by Health Canada, Mr. Nesbitt wanted to ensure quality control issues met the highest possible standards as part of his commitment to top-of-class food services. This wish list included an easy-to use temperature-monitoring system that could provide a visible display of the temperatures of all of his refrigerators and freezers, including historical information so that he could review the performance of his equipment. It also had to provide alert notification (but email alerts and SMS text message alerts) to alert key staff in the event that a cooling system was exceeding pre-set warning limits.
Case Study
Coca-Cola Refreshments, U.S.
Coca-Cola Refreshments owns and manages Coca-Cola branded refrigerators in retail establishments. Legacy systems were used to locate equipment information by logging onto multiple servers which took up to 8 hours to update information on 30-40 units. The company had no overall visibility into equipment status or maintenance history.
