FRENES
Book a call

International building materials group

The health crisis translated into business impact, country by country, region by region, in a single dashboard.

At the start of the pandemic, the leadership of a multinational present in many countries needed to understand, country by country, how the crisis was hitting operations, and to anticipate demand.

Industry / Materials
  • Tableau
  • Data storytelling
  • Crisis management

Outcome

A single command center connecting public health, mobility and business data, from the global view down to the region.

Context

At the start of the pandemic, the leadership of a multinational present in many countries needed to understand, country by country, how the crisis was hitting operations, and to anticipate demand.

The challenges

  • Understand, country by country, how the health crisis was hitting operations.
  • Anticipate demand in a situation that changed every week.
  • Heterogeneous sources: public health data, mobility and internal data.
  • Leadership that needed a clear reading, from the global picture down to the local one.

What we did

Steering through a crisis in real time: the COVID-19 command center of an international building materials group

  1. Bring heterogeneous sources together

    Public and internal data integrated into one consistent model.

  2. Pick the indicators that really signal risk

    Defined with the business: the ones that point to an impact on operations, not just the ones that describe the health situation.

  3. Tell the story from global to local

    A clear visual narrative, from the global view down to local decisions, with navigation by theme.

  4. Keep the data current

    Regular refreshes to follow how the situation evolved.

Architecture

From scattered signals to prioritized decisionsPublic health, mobility and business data brought into one model, then told from the global view down to the region.
  1. Sources
    • Public health
    • Mobility
    • Orders, deliveries, payments
  2. Integrated model
    • Risk indicators
  3. Global view
    • Map
    • Risk levels
  4. Country view
    • Rankings
  5. Region view
    • Top and bottom regions
  6. Decisions
    • Leadership

What we built

A multi-page interactive dashboard bringing together three families of data:

  • Public health: confirmed cases, deaths, tests, positivity rate, hospital capacity, 10-day trends, doubling times and projected curves with their minimum and maximum ranges.
  • Mobility: how movement evolved, country by country.
  • Business: deliveries by business line compared with the previous year with 7-day moving averages, online ordering adoption against total orders, payment delays, leading order indicators and a probability-of-breakdown signal.

A story, from global to local

  • A global overview with a world map and risk levels (high, medium, low).
  • Country rankings that combine health trends and business impact.
  • Drill-down from global to country to region, with the most and least affected regions.
  • A navigation menu by theme: country overview, orders, deliveries, payment delays, mobility, leading indicators.

What changed

Leadership could read, in one place, how the health situation translated into business impact, region by region, and prioritize action accordingly.

Technologies
  • Tableau
  • Data modelling
  • Data storytelling
Format
Multi-page interactive dashboard, built in Tableau: we choose the tool that fits the context, not the other way round.

Contact

A decision to make fast, on scattered data?

Let's start with an assessment: the right sources, the right indicators, and the best way to tell the story.

Book a callStart with an assessment[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