Outcome

The analysis shaped the following year's Mexico strategy and was presented to the divisions in the United States, Mexico and Venezuela.

Context

A steel importer that needed to ground its sales strategy in scattered market data from public and private sources.

The challenges

  • Unstructured data from multiple public and private sources.
  • A Latin American steel market and its trends to understand.
  • Next year's sales strategy to ground in facts.

What we did

Informing an expansion decision for a steel importer

  1. Bring the data together

    Unstructured data from public and private sources organized into one consistent database.

  2. Analyze the market

    Analysis of the Latin American steel market and its trends.

  3. Share the findings

    Power BI reports shared with sales teams and managers to set the sales strategy.

  4. Carry the recommendation

    The analysis presented to the divisions in the United States, Mexico and Venezuela.

Architecture

From scattered sources to a shared decisionPublic and private data is consolidated, analyzed, then put in the hands of the people who decide.
  1. Sources
    • Public
    • Private
  2. Consolidated database
    • Structured data
  3. Market analysis
    • Latin America
    • Trends
  4. Power BI
    • Shared reports
  5. Decision-makers
    • Sales teams
    • Managers

Before

  • Unstructured data scattered across public and private sources
  • A market to understand before committing

After

  • One consistent database
  • Power BI reports shared with the sales teams
  • A Mexico strategy grounded in the analysis

What changed

The following year's Mexico strategy built on an analysis shared by the sales teams and leadership.

Technologies
  • Power BI
  • Data modelling
  • Market analysis
Format
Market analysis and Power BI reporting for the sales teams and leadership.
Related services

Contact

A strategic decision to inform?

Let's start with an assessment: your data, your questions, and what to build to answer them.

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