Blueprints

Spikes, proposals and architectural artefacts from real projects. Anonymised and preserved.

All Blueprints

16 Apr 2026: Pinning Power BI Reports To Dynamics

Is it possible to pin Power BI dashboards to Dynamics?

9 Apr 2026: Optimisation of Power BI Reports

A walkthrough on identifying and fixing slow Power BI reports.

2 Apr 2026: Allowing Dynamic KPI Selection

A practical walkthrough of implementing dynamic KPI selection in Power BI.

26 Mar 2026: Advanced Filtering

How to handle Customers having different filtering requirements

19 Mar 2026: Actuals vs Targets Without a Warehouse

Investigation into whether it was possible to build an actuals vs target report using Power Query

12 Mar 2026: Multiple Workspaces in the Same Tenant

A clear five-step workflow that deals with the situation when a customer has multiple production workspaces.

5 Mar 2026: A Slicer For Overlapping Categories

Creating a slicer when the underlying categories are not mutually exclusive and instead overlap is a modelling layer solution not a slicer setting.

26 Feb 2026: Approach To Switching Fee Models

Three migration strategies for a core data model change and the new reporting opportunities that are unlocked.

19 Feb 2026: Star Schema Proposal

My unsolicited view of the existing data architecture.