Oney Data integrates Tableau to deliver data insights for 1,000 users


Integration of Snowflake as the back end of the insight sharing platform
Embedded analytics optimises data sharing flexibility
Tableau usage amongst international suppliers risen by 20% in a year

Oney Data, a subsidiary of Oney Bank, relies on large volumes of data to help its clients optimise their business decisions. With a strategy based on thousands of units of data, the company’s aim is to make this information as simple and readable as possible. For the last two years, Oney Data has used Tableau to centralise the management of its data and empower its employees in their day-to-day work.

Monetising data using Tableau

Oney Data’s mission is to help retailers analyse and monetise their data as effectively as possible. To do this, it collects vast volumes of information such as receipt and store data, bills of materials, product attributes, loyalty cards and geomarketing elements. Once collected and aggregated, this data has no real value unless it can be interpreted properly. Oney Data was able to use Tableau’s simple and visual interface to not only make the data actionable, but resell its key analytical findings under various packages.

In particular, Tableau’s embedded analytics functionalities allowed much more flexibility when it came to the company’s insight sharing and category management optimisation platform.

“Our platform has become the core of our activities,” explains Elodie Perrigaud, Chief Data Officer at Oney Data. “Whether we’re developing dashboards for nearly 1,000 users, more intelligent tools, range and promotion optimisation, or ad hoc analyses created in order to meet a specific requirement, we can make them available in an extremely interactive, intuitive and actionable way.”

This, in turn, has considerably sped up innovation and production throughout the company. Oney Data is now in a position to use its experience and algorithms to create tools that are specifically adapted to the needs of its customers.

“Using Tableau, we can develop a new tool in less than a month and adapt it to our customer’s precise situation within a few days or weeks,” says Elodie.

Our platform has become the core of our activities. Whether we’re developing dashboards for nearly 1,000 users, more intelligent tools, range and promotion optimisation, or ad hoc analyses created in order to meet a specific requirement, we can make them available in an extremely interactive, intuitive and actionable way

Optimising data management

Once Oney Data started using Tableau to produce reports, the company was able to improve its information flow management considerably and process large volumes of data much quicker (40 billion transaction lines analysed in 3 years). If the company were to precalculate everything, there would be no less than 800 billion possible combinations. Now that the reports are simplified, they can be directly added to the web platform once they are produced. Before deploying Tableau, individuals had to switch between six reports. Now there is one single dashboard that centralises all of the information. The teams no longer need to work on multiple Excel and Powerpoint files – they can quickly generate one simple and interactive report.

Employees at Oney Data now have an overall view of performance. For example, they can set up direct access for a group’s suppliers, allowing them to modify their product catalogues, optimise stock and share real-time data with the relevant people. With everything integrated into the insight sharing platform, Tableau has completely changed the way suppliers see their information. Before, they used to reprocess all the raw data in Excel, with an impact that was limited to a few key users – usually business analysts. Now, they not only use the data but also the insights created by its visualisation and the algorithms as a collaboration tool with the brand. In addition to this, they can share the reports much more widely than before.

“The best example? Since launching the new version, we have increased the number of users among international suppliers by nearly 20%, giving wider access to local category management teams as well as to the sales team,” says Elodie.

The integration of Snowflake as the back end of the platform has also allowed Oney Data to add several new dimensions. Firstly, data update times have decreased from seven days to just one day. This is still further reducing, as pre-calculations are no longer necessary. Meanwhile, this has allowed the dashboards to be much more flexible and include new data, such as anonymised customer data. Without Snowflake’s calculating power, Oney Data would have had to precalculate over 800 billion combinations, which would have been impossible.

The best example? Since launching the new version, we have increased the number of users among international suppliers by nearly 20%, giving wider access to local category management teams as well as to the sales team

A tool adapted to retailers

One of Oney Data’s main responsibilities is analysing and monetising activity data for the multinational retail group Auchan. As such, knowledge of the customer and its journey is critical. However, prior to Tableau its data management and report generation was not optimal, which slowed down processing as well as commercial activity for its partners. Thanks to Tableau's interactivity and rich visualisations, Oney Data has managed to find the best way to analyse data and transform it directly into specific action plans for Auchan.

This actionable data has allowed retailers (all the major brands, but also local brands who regularly access the platform) to multiply the sales of their products by accurately targeting their customers and better sorting their products. As a result, the relationship between retailers and buyers is improved as they can trade based on reliable and accessible real-time information.

Usually, when companies are considering a big data project, they often think of the technical aspects without any emphasis on the way in which the data will be interpreted or ultimately used. That’s what Tableau brings to Oney Data: data analysis through an interactive and intuitive visual presentation, meaning that the user can extract the useful information that they want and make a decision quickly and independently.

Furthermore, by using their own development in conjunction with a high-performing data visualisation tool, Oney Data can adapt and offer a bespoke service to each of its customers.

Major performance improvement

The teams started using it immediately and now employees work independently to track operations and budgets, or even analyse performance. Thanks to Tableau, they can dedicate more time to analysing and interpreting data rather than searching for it, sharing it, extracting it, and so on.

For users, it means a performance increase from one minute on the first load to less than five seconds, and enhanced flexibility thanks to the integration of new data sources, such as anonymised customers, geomarketing, web browsing and market data.

Thanks to this visual, customisable and scalable solution, within the space of a year the number of Oney Data suppliers has risen from 120 to 200 (both internationally and locally), and their Tableau users have increased from 500 to almost 1,000.