Google x ADEO feedback: "Migrate more than 100,000 dashboards from BO to Looker"

Google x ADEO feedback:   "Migrate more than 100,000 dashboards from BO to Looker" The ADEO Group is one of the largest in the world of specialized distribution, with brands such as Leroy Merlin, Saint Maclou, Bricoman and others.    Adeo undertook an unprecedented project at the start of 2023: rationalizing and modernizing its (very) significant dataviz heritage: essentially SAP BO dashboards.     This XXL project called "Board Next" which was detailed by Google, ADEO and Ellipsys at the Big Data and AI Paris 2024 Show (in October 2025), has just been described in detail in IT Mag . We share with you the most significant aspects  Full article published in "IT Mag" on 12/12/2024 " Initial objective:   to go from 163,000 dashboards in 2023 to 40,000 by 2025   !”                                                                                                  Wassim M'Sallem, Product Leader Dataviz, Adeo   The others issues of this migration  1 main technological target:    GCP Looker  : this is the main target, mainly for its semantic layer quite close to that of BO, which allows a "Self BI" approach: data can be centralized and certified. This is crucial in ADEO's "data mesh" context. Furthermore, ADEO was looking for a solution allowing good interoperability with other technologies via APIs, as explained by Dipty Chander, Technical Account Manager at Google.    Power BI : this is the secondary target that meets use cases where the "time to market" is very short. The "move" has also been 100% automated. But we will not mention it.    The main stages from SAP BO migration to Looker Define the uses of SAP BO dashboards in source:   {openAudit}   made it possible to carry out an automated inventory of SAP BO dashboards to classify them according to their qualities and their actual uses.   This inventory and classification made it possible to build a plan with ADEO's 20 Business Units around the world. "The verdict: 40% of the SAP BO dashboards were either unused or redundant, out of the 163,000 on the platform."                                                                                           Wassim M'Sallem, Product Leader Dataviz, Adeo   Choosing Migration Automation   ADEO finally decided to migrate "only" 8000 reports / 400 BO universes.  It was measured that each of them represented 6 days of work in the absence of automation ☹ ...    Automation was therefore a natural choice.   The power of Ellipsys' {openAudit}  in reverse engineering data processing technologies, including in dataviz, has made it possible to address this complex subject. Main operating mode for migration:      The “fact tables”, which are central to SAP BO dashboards, have been adapted to become star data schemas in Looker.    The approach was optimized by recreating all the intelligence of BO reports in procedural code  to leverage the power of BigQuery GCP.   The template has been migrated to Look ML. If necessary, for a partial "As Is" migration.  Methodology: 3-team management, in 6 phases, for maximum efficiency  CONCLUSION  This migration was a huge success! The latest dashboards are currently being validated for final completion in mid-2025.     The project was managed by Ellipsys, with a timeline defined from the outset.  The conference film (30'):