CoE & Governance

Power BI Centre of
Excellence

Client: Global Medical Devices Company

Designed a Power BI Centre of Excellence end-to-end — governance framework, tiered best practice guidelines for viewers, Pro developers, and BI team developers, training programme, and workspace architecture. Delivered the governance foundation: a SharePoint-based CoE hub with role-specific best practice guides, and contributed workspace standards covering naming conventions, DEV/Test/Prod environments, and premium capacity efficiency rules as part of the wider BI team.

Governance Framework Tiered Best Practice Guides SharePoint CoE Hub Workspace Standards DEV/Test/Prod Architecture Premium Capacity Rules
Viewer Consume published reports. No edit access. Sensitivity label awareness.
Pro Developer Build in DEV workspaces. Follow naming & model standards. Peer review required.
BI Team Developer Own PROD deployments. Manage capacity, RLS, certified datasets & CoE standards.
DEV
Active development & iteration. Pro license only. No shared capacity.
Test
UAT & performance review. Peer sign-off required before promotion.
Production
Premium capacity. BI team governed. Certified datasets & RLS enforced.
Outcome
A structured governance foundation adopted by the BI team — clear standards that reduced ambiguity and enabled scalable self-service reporting.