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.

They needed proof Microsoft Fabric would pay off before committing to it. We ran a pilot on real data.

Why it mattered

Committing to a new data platform across a business is a significant decision, and vendor demonstrations tend to use tidy data. AE Smith wanted to see Fabric working on their own business tables, in their own environment, before deciding whether it was worth adopting more widely.

What we did

  • Provisioned the workspace. Microsoft Fabric with a OneLake-first architecture.
  • Built real pipelines. Ingesting and transforming up to five key business tables, refreshing daily.
  • Modelled it properly. A star schema for clarity and performance rather than a quick proof.
  • Delivered a working report. A curated Power BI report demonstrating business value on their own numbers.
  • Documented and handed over. As-built documentation plus a knowledge-sharing session with their internal team.

The difference it made

  • Quick wins on key datasets, so value arrived during the pilot rather than after it.
  • An informed decision about Fabric based on their real-world context.
  • A reusable foundation if they go enterprise-wide.
  • Internal capability built along the way rather than dependency created.

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

Queensland Government Department: Data Governance

Microsoft Purview

The department needed to move document management and collaboration to SharePoint Online while meeting its governance and compliance obligations, and plan a clean migration off file shares.

We assessed their governance position, deployed Microsoft Purview, proved the design in their own tenant and handed over a costed roadmap.

Outcomes

  • Retention that runs itself
  • Sensitive data protected
  • Audits without the scramble
Read the full story
Scroll to Top