Orange's Gaming and Transmedia Department Analyses its Sales Data Using Talend Data Integration

The operator calculates commissions to be paid to each partner in several European countries, without changing existing processes.
The solution perfectly meets our needs, in terms of both performance and operation. It is easy to use thanks to its graphical programming mode, and also allows you to work directly on the Java code to refine the job or make customizations.
Sébastien Foucault, Manager of the Division of Development of Gaming and Transmedia Department

With nearly 210 million customers in 220 countries, France Telecom is one of the leading telecommunications operators in the world that has successfully converted into an integrated operator and has become a true benchmark for innovative telecommunications services in Europe. Since June 2006, Orange has been the leading Group brand in Internet (the leading broadband internet (ADSL) service provider in Europe), television (the top provider of IPTV services in Europe and second worldwide) and mobile services (the third mobile operator in Europe and the leading operator worldwide in launching High Definition mobile phones) in most of its markets. It also provides telecommunication services to businesses worldwide under the Orange Business Services brand.

Gaming: an essential component of Orange’s content strategy

Praised by Orange customers, gaming is an essential component of the operator’s content strategy. The Group relies on partnerships with leading market vendors and the capabilities of its networks to always deliver more innovative and attractive content. Orange also distributes a wide range of games for all screens, from video games to casual gaming through online gambling, and encourages the development of new types of games, such as location-based games or social games.

Orange’s Gaming and Transmedia Department maintains close relationships with gaming vendor partners through a method of revenue sharing. To improve its management, it wanted to calculate the amounts to be paid to its partners in several European countries such as Spain, Portugal, Switzerland, Belgium and Moldova. To do this, the department must aggregate all sales data for each game vendor by country (on average 4 to 5 vendors per country).

"At the time, we did not have any business intelligence solutions to support our decision-making. With our strategy firmly focused on open source solutions, we assigned a partner to conduct a needs study. Ultimately, two solutions were recommended: Pentaho and Talend," explains Sébastien Foucault, Manager of the Division of Development of Orange’s Gaming and Transmedia Department. "We conducted some tests, particularly using the Jaspersoft-Talend combination, but decided to adopt Talend independently because we realized that aside from the issues of moving and loading data, the solution can simplify other aspects of our business. In addition, the solution is easy to learn and customize, which helps us deal with the specifics of each country." 

After the development of a model for a specific game using Talend Open Studio for Data Integration and aiming to validate this choice, the Gaming and Transmedia Department decided to adopt Talend Data Integration to benefit from the shared repository and therefore facilitate exchanges between developers.

Movements, changes, consolidations

The project was initiated on the perimeter of one country, Spain. Since the information is sent in different formats, the first job consists of transforming all the data into a single format. Talend's solution ensures this task and then sends the data to an ODS (operational data warehouse), which is actually a buffer database system: the data is provided in different tables, and then it is subjected to quality and relevance testing. Finally, the validated data is transferred to the production data warehouse (a MySQL database).

"From the sales data correlated with other information, we create various reports: first, reports on the settlement by vendor and by country, and secondly, internal reports that allow us to determine, for example, which games are the most successful," adds Anne Huart, BI Project Manager for Orange’s Gaming and Transmedia Department. "In total, about two dozen reports help us get a comprehensive view of the current situation and analyze our business in detail. These reports are forwarded to our management and each country has access to its own statistical data, as well as customized reports."

These operations are repeated every month and scripts to automate them are currently under development - today the back office manages script organization, according to the nature of the received files. In all, several gigabytes of data are processed each month.

Ease of use and customization

Gradually, more countries are integrated into the system, which aggregates them to develop a comprehensive view of business. After a few months of use, the Gaming and Transmedia Department of Orange’s Content Division is satisfied with the performance of Talend Data Integration, highlighting its ease of use. "The solution perfectly meets our needs, in terms of both performance and operation. It is easy to use thanks to its graphical programming mode, and also allows you to work directly on the Java code to refine the job or make customizations. Only one training session with Talend helped us learn and master the tool," explains Sébastien Foucault. "In addition, it perfectly fits within our open source strategy, which aims not only to reduce development costs, but also to benefit from and contribute to the community via the forums on the Talend website. Lastly, the openness of the solution allows us to control our developments without relying on external specialists, which are often expensive."

While the attention of the Gaming and Transmedia Department is now entirely focused on the current project, that is the integration of new countries and quality testing, its successful experience serves as an in-house reference for the implementation of other projects.

"Today we have a clear picture of our business in each country that we cover and for each vendor with whom we work. This allows us to improve our decision-making and plan the future more accurately than before," concludes Sébastien Foucault. "With Talend, we have achieved all this with a limited budget and without requiring multiple resources from the IT department. In addition, the solution was integrated to our information system in a seamless manner and we did not have to alter the processes that already were in place. This is exactly what we were looking for."