CG TECH

Success story

Building Services Contractor

They needed proof Microsoft Fabric would pay off before committing to a full rollout.

Microsoft Fabric Engineering and construction
← All success stories
Client
Building Services Contractor
Industry
Engineering and construction
Technologies
Microsoft Fabric, Power BI
Building Services Contractor

This client is an Australian building services and mechanical contractor specialising in heating, ventilation, air conditioning and refrigeration for commercial buildings.

The challenge

The client wanted to try Microsoft Fabric before a wider rollout.

What we did

We stood up a pilot with OneLake, daily data pipelines and a curated Power BI report on their key data.

We ran a focused Microsoft Fabric pilot to prove the value before a wider rollout.

What this involved

  • Set up a Fabric workspace with a OneLake-first design.
  • Built pipelines to bring in and shape up to five key tables with a daily refresh.
  • Modelled the data as a star schema for clarity and speed.
  • Built a curated Power BI report to show business value.
  • Wrote as-built documentation for the team.
  • Ran a knowledge-sharing session to build in-house skills.

The results

What Building Services Contractor got

Early wins on key datasets

Curated reporting on five key business tables, refreshed daily

A reusable base to grow on

A OneLake-first design ready to extend across the business

Stronger in-house data skills

As-built documentation and hands-on knowledge transfer

Let’s write yours next

Every story on this page started with one conversation about a problem worth fixing. Bring us yours and let’s see what’s possible.

Book a Discovery Session

More stories like this

Chemical Manufacturer

Microsoft 365

Microsoft Teams and SharePoint Online had been enabled but the team was not using them, and there was no governance around either.

We reviewed the setup, designed a best practice approach and set a phased roadmap for adoption.

Outcomes

  • 500+ orphan documents found
  • Idle Teams cleaned up
  • A clear path to adoption
Read the full story

Retirement Living Operator

Microsoft Fabric

Their reporting was manual and split across separate apps, each with its own licence.

We built one Microsoft Fabric platform, modelled the data and set up Power BI, with training to extend it.

Outcomes

  • One platform, many sources
  • Clean, reliable data
  • Team trained to build on it
Read the full story

Children’s Services Group

Power BI

Building each marketing list by hand was so slow the data was out of date before a campaign went out.

We linked their Power BI data to Mailchimp so the lists now update on their own.

Outcomes

  • Campaign prep cut by 95%
  • From days down to minutes
  • Staff run their own reports
Read the full story
Scroll to Top