FRENES
Book a call

Platform & modelling

The same numbers for everyone, and a cloud bill under control.

We model your data in Google BigQuery or Microsoft Fabric so that every report, every analysis and every AI assistant starts from the same foundation, with costs you can track and control.

SalesFinanceCRMFilesWarehouseBigQuery · FabricSales datamartFinance datamartSupply datamartReports · AI

Sound familiar?

  • “Every team has its own numbers, and nobody knows which ones are right.”
  • “Our BigQuery bill goes up every month and we don't know why.”
  • “Our transformations are SQL scripts only one person understands.”
  • “A change in production breaks reports without warning.”
  • “We want to launch AI, but our data isn't ready.”

Platform & modelling

What we deliver

  • One data model per domain

    SQL data marts organized by business domain (sales, finance, supply…), with shared metric definitions.

  • Versioned transformations

    Dataform on BigQuery, or Lakehouse and Warehouse in Fabric: SQL under Git, tested and documented.

  • Separate environments

    Development, testing and production, with a release process your teams master.

  • Costs under control

    Partitioning, clustering, optimized queries and consumption monitoring.

  • A platform you own

    Documentation and training: your teams evolve the platform without depending on us.

Platform & modelling

How we work

  1. Map

    Sources, usage, current costs and key metrics: we start from the decisions to make, not from the data available.

  2. Model

    A target model per domain, validated with the business before the first line of SQL.

  3. Build

    Versioned, tested transformations, separate environments, first data marts in production.

  4. Optimize

    Partitioning, clustering and a review of the most expensive queries.

  5. Hand over

    Documentation, training for your teams and, if you wish, monthly operations.

Start with an assessment

Typical durations
  • Data & AI Assessment2 weeks
  • Data Foundation3 to 8 weeks
  • Platform operationsA few days per month
Technologies
  • Google BigQuery
  • Dataform
  • SQL
  • Google Cloud
  • Microsoft Fabric
  • Lakehouse / Warehouse
  • Git
  • GitHub Actions

Case studies

  • 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
  • Jewelry

    International jewelry house

    Running BI for an international jewelry house

    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.
    Outcome
    4,000–5,000 self-service users worldwideAround 20 standardized report templates on certified data
    • Power BI
    • BigQuery
    • Microsoft Fabric
    • Migration

Platform & modelling

Platform & modelling

Frequently asked questions

BigQuery or Microsoft Fabric: which one?

Whichever fits your existing landscape best. On Google Cloud, BigQuery and Dataform are often the natural choice; if you run on Microsoft with Power BI, Fabric simplifies the chain. We work on both and recommend the option that is simplest for your teams to maintain.

Can you reduce our BigQuery bill?

Often, yes. The usual levers: partition and cluster large tables, rewrite the queries that scan too much data, and serve BI from pre-aggregated data marts. We first measure where consumption goes, then prioritize.

Do you also build data ingestion?

We build the transformations, the data marts and their release process. For large-scale ingestion or real-time streaming, we work alongside your data engineering teams or your existing integration tools.

Will our teams be able to maintain the platform?

That is a goal from day one: versioned SQL, naming conventions, documentation and training. We can also run the platform on a subscription while your teams take over.

Where should we start?

With the Data & AI Assessment: in two weeks, a clear picture of your platform and costs, and a prioritized roadmap.

Contact

The right numbers and a bill under control?

Let's start with an assessment of your platform and your costs.

Book a callStart with an assessment[email protected]