Key results

load time
-60%
self-service adoption
+50%
users trained
300+
users worldwide
2,000+

Context

Sales, client and operational reporting for a couture house, split across SQL Server, Cognos and Qlik Sense, for more than 2,000 users worldwide.

The challenges

  • Three reporting tools to bring together: SQL Server, Cognos and Qlik Sense.
  • More than 2,000 users worldwide, with different needs in finance, product and marketing.
  • Personal client data, subject to the GDPR.
  • Reports that were too slow to load.
  • BI projects with no shared standards.

What we did

Modernizing BI for an international couture house

  1. Own the Power BI product

    Product ownership of Power BI for the global business: sales, client and operational reporting.

  2. Start from the decisions to make

    KPI and requirements workshops with finance, product and marketing.

  3. Migrate end to end

    From SQL Server, Cognos and Qlik Sense to Power BI and Google Cloud: pipelines, testing, then user rollout.

  4. Protect personal data

    GDPR governance of client data and access controls.

  5. Standardize and deliver in Agile

    Power BI standards and templates (models, naming, UX/UI) adopted across every BI project; Agile delivery with a developer team.

Architecture

Three legacy tools, one platformLegacy sources are moved to Google Cloud, then served to the whole organization through standardized Power BI models.
  1. Legacy tools
    • SQL Server
    • Cognos
    • Qlik Sense
  2. Google Cloud
    • Pipelines
    • Testing
  3. Power BI models
    • Shared standards
  4. Reports
    • Sales
    • Clients
    • Operations
  5. Users
    • 2,000+ worldwide
  • GDPR
  • Access controls

Before

  • Three tools: SQL Server, Cognos, Qlik Sense
  • Reports slow to load
  • Each BI project with its own rules

After

  • One Power BI platform on Google Cloud
  • Load times 60% faster
  • Shared standards across every BI project

What changed

One Power BI foundation for global reporting, faster, and business teams who use it more on their own.

Technologies
  • Power BI
  • Google Cloud
  • SQL Server
  • Cognos
  • Qlik Sense
  • DAX
  • Agile / Scrum
Format
Power BI product ownership and Agile delivery, with a developer team.

Contact

Several reporting tools, none that everyone trusts?

We consolidate your BI on Power BI and the cloud, from inventory to adoption by your teams.

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