Microsoft Fabric

Agile Fabric Foundation

The engineered starting point for Microsoft Fabric. Standards, compliance, medallion architecture and a metadata driven ETL framework, deployed as a working platform your team runs from day one. Fixed scope, fixed fee, agreed before we start.

In the Foundation

0 +

Microsoft Fabric engagements delivered in production

0 –10 wks

Typical path from kickoff to a production Fabric platform

0 %

Of our consultants hold current Microsoft certifications

0

Phase deployment framework, proven and repeatable

Why Agile Insights

Australia's leading Microsoft Fabric partner.

Day 1
Fabric since general availability

We have deployed Fabric into production across some of the country's largest and most regulated environments, and we know where it breaks at scale.

Weeks
Production, not pilots

Accelerators compress platform delivery from months to weeks. Value is visible in the first phase, not the last.

MVP
Microsoft MVPs and ex-Microsoft engineers

Architects and engineers with 10 to 28 years each in Microsoft data platforms, including former Microsoft consultants and Premier Field Engineers, leading every engagement.

Gov
Accredited for public sector

Active across NSW, Victorian, Federal and local government with security cleared resources, ISO 27001 certification and SOC 2 attestation.

1
One set of numbers

Golden semantic models and enforced standards mean every report agrees, and Copilot answers from the same definitions.

AI
Built AI ready, not retrofitted

Lineage, quality and access controls designed in so Azure AI Foundry, Copilot Studio and Agile Agents run on data you can defend.

The Platform at a Glance

One governed path from every source to every decision.

The Foundation deploys an end to end architecture where each stage is standardised, monitored and promotable through dev, test and production.

Ingest

Your Source Systems

ERP, CRM, finance, SaaS APIs, files and databases, registered in metadata.

Core IP

Metadata Driven ETL Framework

Config first ingestion, transformation and orchestration. Steps, dependencies, quality checks, retries and alerting are declared, not coded.

Store & Refine

Medallion Lakehouse on OneLake

Raw, refined and business ready layers with naming standards and incremental load patterns.

Model

Golden Semantic Models

One version of the truth with row level security and Copilot ready metadata.

Consume

Power BI, Copilot & AI Agents

Governed reports, self service workspaces and trustworthy AI answers.

Inside the Foundation

Everything a production Fabric platform needs, engineered in from sprint one.

Agile Fabric Foundation is our proprietary accelerator, refined across 150+ Fabric engagements. You do not start from a blank tenant. You start from a proven platform blueprint. Everything below sits inside the fixed scope, except the items marked optional, which are confirmed and priced in the discovery call.

Fabric Reference Architecture

Workspace topology, domains aligned to business functions, capacity sizing and OneLake structure aligned to Microsoft guidance.

Metadata Driven ETL Framework

Configuration first ingestion, transformation and orchestration. Processes, steps and dependencies are declared in metadata and handled transparently, so new sources are onboarded by config, not code.

Core IP

Bulk Source Onboarding

Automated schema extraction registers entire source systems at once, hundreds of tables mapped into the framework in a single pass.

Standardised Processes

Every pipeline follows the same pattern for scheduling, dependencies, logging, error handling and alerting. One way of working across the estate, so nothing is bespoke and nothing is a surprise.

Less to Monitor and Maintain

One framework, one control layer, one monitoring surface. Support effort stays flat as sources are added, instead of growing with every new pipeline your team has to learn.

Medallion Architecture

Raw, refined and business ready layers with naming standards, partitioning and incremental load patterns baked in and documented.

Data Quality & Validation

Quality rules defined in metadata and enforced between layers. Failed records are quarantined, surfaced and alerted, never silently loaded.

Security & Access by Design

Entra ID integration, RBAC, workspace and item level permissions, sensitivity labels and access policies configured at deployment, not retrofitted.

Purview Data Governance

Catalogue, lineage, classification and policy through Microsoft Purview, delivered with our Purview Foundations accelerator. A potential addition to the scope, confirmed and priced in the discovery call.

Optional Scope

Golden Semantic Models

Semantic models that enforce one version of the truth, with row level security and a standard design template across every report.

AI & Copilot Ready

Models built with the descriptions, metadata and governance that make Copilot answers trustworthy, and a foundation ready for AI agents.

IaC & CI/CD Pipelines

Bicep, Terraform and Fabric Git integration. Environment promotion from dev to test to production with automated checks on every release.

Platform Observability

A monitoring dashboard for pipeline runs, load status, failures and durations, so the platform team sees issues before the business does.

Capacity & Cost Governance

Capacity monitoring, consumption visibility and workload tagging, so Fabric spend stays predictable as adoption grows. Achieved in combination with Fabric Insights, our packaged admin and governance product.

With Fabric Insights

Operating Model & Handover

Roles, RACI, runbooks, as built documentation, training and a 90 day post handover support window. Your team owns and extends the platform.

The Engine Room

New data sources by configuration, not code.

Our metadata driven framework is the difference between a platform that scales and one that accumulates debt. Ingestion, transformation, orchestration, quality checks and error handling are all driven from metadata.

# Onboarding a new source: config, not code
source: TechnologyOne
landing: azure_blob
entities:
  – financials  load: incremental
  – property_rating  load: incremental
  – people_culture  load: full
transform: standard_medallion
depends_on: [landing_complete, dq_pass]
quality: standard_ruleset_v2
target: lakehouse.techone
schedule: daily_0400
alerts: teams, email

Illustrative configuration. Every source in the estate is registered the same way, with processes, steps and dependencies declared rather than coded.

How It Is Delivered

Six phases from greenfield to production. Documented, governed, handed over.

Typically 6 to 10 weeks end to end. The bands below are the eight week baseline; source complexity, environment readiness and any optional scope move it inside that range. We confirm the exact plan in the discovery call, before you commit.

Weeks 1–2

Assess & Discover

Workshops with stakeholders. Map sources, pipelines and current state. Define MVP scope and target architecture.

Weeks 2–3

Deploy Fabric & Frameworks

Stand up capacity, workspaces and connectivity. Apply IaC, security, RBAC and the reference architecture, plus Purview if it is in scope.

Weeks 3–5

Integration & Modelling

Ingest priority sources through the metadata framework. Build the lakehouse layers, semantic models and data products.

Weeks 5–6

Reporting & BI

Apply the design template. Build Power BI reports, KPIs and self service workspaces with a consistent look and feel.

Weeks 6–7

Source Control & CI/CD

Git integrated deployments, environment promotion, automated testing and release pipelines.

Weeks 7–8

Production & Handover

Cutover, monitoring, alerting and runbooks. Knowledge transfer, documentation and uplift of your internal team.

Indicative timeline of 6 to 10 weeks, confirmed at discovery based on your environment, source systems and any optional scope.

The Difference It Makes

Starting from the Foundation vs starting from a blank tenant.

The Foundation deploys an end to end architecture where each stage is standardised, monitored and promotable through dev, test and production.

Typical Fabric Build
With Agile Fabric Foundation
Time to production
Months, often stalled at pilot
Typically 6 to 10 weeks
Onboarding a new source
A new pipeline project each time
Registered by configuration
Governance & compliance
Retrofitted after go live
RBAC and labels at deployment, Purview when in scope
Data quality
Discovered by report users
Validated between layers, alerted
Deployment & releases
Manual publishing, no promotion path
Git integrated CI/CD, dev to prod
Operations
Tribal knowledge, single points of failure
Runbooks, observability, trained team
Ongoing effort to maintain
Grows with every pipeline added
One standard pattern, effort stays flat
Commercial model
Time and materials, scope emerges as you go
Fixed scope and fixed fee, agreed at discovery

Typical build reflects common patterns we assess in existing Fabric estates. Timelines are indicative and confirmed at discovery.

Scope, Options & Commercials

A fixed scope and a fixed fee, with two optional extensions defined in the discovery call.

The Foundation is sold as a package, not an open ended engagement. We agree the scope in discovery, price it, and hold it. Two extensions sit alongside it, each priced separately so you can add or defer them with the numbers in front of you.

Fabric Insights

Optional add-on

Purview Foundations

Optional scope

Fabric Insights + Purview Foundations

Cost visibility, usage analytics, catalogue and lineage across the tenant

Optional add-on

Agile Fabric Foundation

Reference architecture, metadata ETL, medallion, quality, security, CI/CD

This accelerator

Microsoft Fabric & OneLake

Your governed data platform on a single copy of the data

Platform

Scope, deliverables and price are agreed in the discovery call and written into the proposal. No open ended time and materials, no scope discovered halfway through the build.

Purview Foundations, Fabric Insights, additional source systems and extended enablement each carry their own price, so nothing is bundled in that you did not choose.

Selected assessments and MVP builds may be co funded through Microsoft partner investment programs, subject to eligibility and Microsoft approval. We manage the application.

The Platform at a Glance

One governed path from every source to every decision.

The Foundation deploys an end to end architecture where each stage is standardised, monitored and promotable through dev, test and production.

Local Government

Inner West Council

Production Fabric tenancy with dev, UAT and prod workspaces, TechnologyOne data ingested through automated pipelines, medallion architecture and governed Power BI semantic models. The platform is now reused for rates modelling and further integrations.

Local Government

Inner West Council

Production Fabric tenancy with dev, UAT and prod workspaces, TechnologyOne data ingested through automated pipelines, medallion architecture and governed Power BI semantic models. The platform is now reused for rates modelling and further integrations.

Local Government

Inner West Council

Production Fabric tenancy with dev, UAT and prod workspaces, TechnologyOne data ingested through automated pipelines, medallion architecture and governed Power BI semantic models. The platform is now reused for rates modelling and further integrations.

Local Government

Inner West Council

Production Fabric tenancy with dev, UAT and prod workspaces, TechnologyOne data ingested through automated pipelines, medallion architecture and governed Power BI semantic models. The platform is now reused for rates modelling and further integrations.

Why organisations hand this to us.

Microsoft Solutions Partner and Trusted Advanced Specialisation Partner, in the top 1% globally for Microsoft Data and AI. 150+ Fabric engagements delivered in production, every consultant certified and current, and an Australian delivery team that works alongside yours. Microsoft partner funding may apply to selected assessments and MVP builds.

Success stories

Platforms running in production today.

Questions, Answered Straight

Agile Fabric Foundation FAQ

What exactly is Agile Fabric Foundation?

It is our packaged accelerator for standing up Microsoft Fabric properly. It combines our reference architecture, metadata driven ETL framework, medallion patterns, data quality framework, governance pack, CI/CD pipelines and operating model playbook into a single engagement that takes you from greenfield to a governed production platform.

Fabric is easy to start and easy to sprawl. The Foundation gives you the standards, security model, ingestion framework, quality controls and promotion pipelines that most organisations only discover they needed six months in. You start at sprint three, not sprint zero.

A typical Foundation engagement reaches a production platform in 6 to 10 weeks, with priority data sources ingested end to end. Where it lands in that range depends on your environment, the source systems in scope, how quickly security and access approvals move, and any optional scope such as Purview. We confirm the plan in the discovery call before you commit.

Fixed scope, fixed fee. We agree the scope in the discovery call, then quote a fixed price in the proposal, and it does not move unless you change the scope. Optional items, such as Purview Foundations, Fabric Insights, additional source systems or extended enablement, are quoted as separate line items so you can take them or defer them. Microsoft partner funding may offset part of the cost for selected assessments and MVP builds.

Purview is a potential addition to the scope, not an assumption. The Foundation always includes the security and access controls that make the platform safe to run: Entra ID integration, RBAC, workspace and item level permissions, sensitivity labels and access policies at deployment. Full Purview capability, the catalogue, lineage, classification and policy layer we deliver as Purview Foundations, is scoped and priced in the discovery call, where we work out together whether it belongs in this phase or the next.

A configuration first ingestion and orchestration layer. Instead of writing bespoke pipelines for every source, your team registers sources, entities, load patterns and quality rules in metadata. The framework handles ingestion, incremental loads, validation, retry logic, logging and alerting consistently across the estate.

Yes, and it is a common starting point. Existing Power BI Premium, Synapse, Azure Data Factory or early Fabric estates are assessed first: we keep what is sound, retire what is not, and fold the rest into the Foundation standards using our Fabric migration accelerators. The discovery phase exists precisely to work out what carries forward and what gets rebuilt.

Yes, by design. Copilot and AI agents are only as trustworthy as the data foundation beneath them. The Foundation builds semantic models with the metadata, descriptions and governance that make natural language answers reliable, and a governed data estate that AI agents can safely build on.

Fabric Insights is an optional add-on, priced separately. It is our packaged admin and governance product, giving usage analytics, capacity and cost monitoring, licence rationalisation insight and governance alerting across your tenant. It is also how the capacity and cost governance outcome is achieved in full: the Foundation applies workload tagging and capacity discipline, and Fabric Insights gives you the tenant wide visibility and alerting on top. Many clients deploy it in the same engagement so cost and governance visibility are live at handover.

An executive sponsor and a product owner who can make scope calls, access to the source systems and the Azure and Fabric tenant, security and network approvals started early, and one or two of your own engineers or analysts working alongside us so knowledge transfers while we build rather than at the end. Fabric capacity is licensed by you directly from Microsoft; our fee covers delivery, not your Microsoft consumption.

No. Documentation, knowledge transfer and capability uplift are built into every Foundation engagement, including recorded walkthroughs and a 90 day post handover support window. The platform is designed for your team to own and extend.

Selected assessments and MVP builds may be co funded through Microsoft partner investment programs, subject to your eligibility and Microsoft approval. We manage the application for you.

Start the Conversation

Build your Fabric platform on a foundation that holds.

Book a scoping session with a principal consultant. We will look at your sources, your governance requirements and your goals, and tell you honestly what is worth doing and what is not.

1 · Discovery call

A working session, not a sales pitch. Your sources, your obligations, your target state, and whether Purview belongs in this phase.

2 · Scope and fixed price

We write the scope, deliverables and timeline, and quote a fixed fee. Optional items are separate line items you can take or leave.

3 · Kickoff

Workshops in week one, the platform standing up in week two, first data flowing through the framework shortly after.

Typically scheduled within 2 business days