FRENES
Book a call

International jewelry house

Global sales tracked in near real time, and 4,000 to 5,000 self-service users on certified data.

Reporting on SAP BusinessObjects and SQL Server to migrate to Power BI and Google Cloud for finance, omnichannel and supply, with thousands of users worldwide.

Jewelry
  • Power BI
  • BigQuery
  • Microsoft Fabric
  • Migration

Key results

self-service users worldwide
4,000–5,000
standardized report templates on certified data
Around 20
finance users trained
100+
domains migrated: finance, omnichannel, supply
3

Context

Reporting on SAP BusinessObjects and SQL Server to migrate to Power BI and Google Cloud for finance, omnichannel and supply, with thousands of users worldwide.

The challenges

  • Legacy reporting on SAP BusinessObjects and SQL Server, to migrate without disruption for finance, omnichannel and supply.
  • Leadership expecting up-to-date global sales figures, without delay.
  • Thousands of self-service users, and the risk of conflicting numbers.
  • Sensitive data: access by location, cost data restricted to a few profiles.
  • A shared Fabric capacity to protect from load peaks.

What we did

Running BI for an international jewelry house

  1. Migrate to Power BI and BigQuery

    SAP BusinessObjects and SQL Server reporting moved to Power BI and Google Cloud (BigQuery), domain by domain: finance, omnichannel, supply.

  2. Redesign the global sales model

    Incremental refresh, calculation groups, currency logic pushed upstream, simplified relationships and standardized KPI definitions, for near real-time executive reporting.

  3. Organize managed self-service

    Standardized report templates on certified data models, user guides and visualization standards. A central BI portal catalogues certified models and reports by domain, with business sponsors, product owners and an adoption dashboard.

  4. Secure access

    Row-level security by location, object-level security on cost data.

  5. Run capacity and releases

    Fabric capacity peaks monitored to act before capacity is at risk, test plans and controlled releases, 100+ finance users trained.

Architecture

From legacy sources to decisions, on a certified foundationData converges in BigQuery, feeds certified semantic models, then standardized reports for each domain.
  1. Legacy sources
    • SAP BusinessObjects
    • SQL Server
  2. Google BigQuery
    • Datamarts by domain
  3. Certified models
    • Global sales
    • Finance
    • Supply
  4. Power BI
    • Standardized reports
    • BI portal
  5. Users
    • Leadership
    • Finance
    • Omnichannel
    • Supply
  • Security by location (RLS)
  • Protected costs (OLS)
  • Monitored Fabric capacity

Before

  • Reporting on SAP BusinessObjects and SQL Server
  • Currencies calculated in each report
  • Metrics defined team by team
  • No overview of what is certified and used

After

  • Power BI on Google BigQuery
  • Currencies calculated once, upstream
  • Standardized metric definitions
  • A central BI portal and adoption tracking

What changed

Leadership tracks global sales on certified numbers in near real time, and thousands of users build their analyses on the same foundation.

Technologies
  • Power BI
  • Google BigQuery
  • Microsoft Fabric
  • DAX
  • Calculation groups
  • Incremental refresh
  • RLS / OLS
Format
BI leadership and platform administration, working with the business sponsors and product owners of each domain.

Contact

Is legacy reporting slowing your decisions?

We move your BI to Power BI and the cloud, with self-service you stay in control of.

Book a callExplore BI modernization[email protected]

Case studies

More case studies

  • Luxury

    Global luxury group

    Industrializing Power BI and Fabric for a global luxury group

    Context
    Several teams of Power BI developers, manual releases, and no systematic check before production.
    Outcome
    100% of Power BI developers trained3 environments, DEV to PRD, with controlled promotion
    • Power BI
    • Microsoft Fabric
    • GitHub Actions
    • CI/CD
  • Healthcare / Medtech

    Medtech group

    Moving beyond Excel: a medtech group's first BI platform

    Context
    A medtech group with no BI platform: sales, marketing, finance and leadership ran the business from large Excel files and exports reworked by hand.
    Outcome
    130+ users across sales, marketing, finance and leadership-50% manual data handling
    • Power BI
    • CRM
    • Self-service
    • Automation