From Excel consolidation to one source of truth

A global outdoor-apparel brand consolidated Business Central, e-commerce and web analytics in Excel by hand. We built a Microsoft Fabric foundation, delivered Power BI executive dashboards, and handed it to the internal team.

  • Global outdoor-apparel brand
  • Data Intelligence
  1. 1source of truth
  2. 2 to 3executive dashboards, including sales and marketing
  3. Automatedpipelines and scheduled refreshes

The challenge

Nobody could see performance in one place.

A global outdoor-apparel brand lacked a centralized view of performance.

Reporting relied on fragmented Excel files and manual consolidation across Business Central, e-commerce and web analytics. That slowed decisions, introduced errors, and made new analyses hard to add.

The team needed a modern data foundation that was fast to deploy and simple to operate with a small staff.

  • Manual consolidation made reports late.
  • Errors entered the numbers at every consolidation.
  • Every new analysis added more manual work.

What we did

How the work ran

Use the Microsoft stack they already had, in a form a small team can run.

  1. 1

    Assess what was there.

    We assessed data flows, reports and pain points, and aligned scope and KPIs with leadership.

  2. 2

    Choose the foundation and set it up.

    We chose Microsoft Fabric because it fit Power BI and Business Central and kept the operating overhead low. We set up Dev, Test and Prod workspaces with Git and deployment pipelines, and defined security and governance.

  3. 3

    Ingest and model the data.

    Priority sources went into a Bronze layer. Silver applied quality and standardization. Gold was a star schema on Direct Lake, with core measures for sales and margin and product and date dimensions.

  4. 4

    Deliver the dashboards and hand them over.

    We delivered 2 to 3 executive dashboards, including sales and marketing performance, and ran UAT with business users. Documentation, knowledge transfer and scheduled refreshes went to the internal team.

Before and after

What changed

TopicBeforeAfter
ReportingFragmented Excel, consolidated by handOne source of truth in Power BI
Data qualityErrors at every consolidationAutomated pipelines and standardized data
What leadership seesReports that arrive lateTimely sales and marketing dashboards
ScaleEach new analysis adds workA path to grow as data and use cases grow

The results

From spreadsheet work to decisions on the numbers.

  • Power BI on Direct Lake is now the single source of truth, in place of spreadsheet consolidation.
  • Automated pipelines and standardized data cut manual work and reduce errors.
  • Executive dashboards give timely visibility into sales and marketing.
  • A lean team can run the Fabric setup, and it can scale as data and use cases grow.

Services on this project

The same work, for your team.

Technology used

  • Microsoft Fabric
  • Power BI
  • Direct Lake
  • Business Central
  • Git

Service: Data Intelligence

Facing a similar problem?
Tell us where you are today.

Discuss a similar project

We reply within 2 business days.