Spikes, proposals and architectural artefacts from real projects. Anonymised and preserved.
Is it possible to pin Power BI dashboards to Dynamics?
9 Apr 2026: Optimisation of Power BI ReportsA walkthrough on identifying and fixing slow Power BI reports.
2 Apr 2026: Allowing Dynamic KPI SelectionA practical walkthrough of implementing dynamic KPI selection in Power BI.
26 Mar 2026: Advanced FilteringHow to handle Customers having different filtering requirements
19 Mar 2026: Actuals vs Targets Without a WarehouseInvestigation into whether it was possible to build an actuals vs target report using Power Query
12 Mar 2026: Multiple Workspaces in the Same TenantA clear five-step workflow that deals with the situation when a customer has multiple production workspaces.
5 Mar 2026: A Slicer For Overlapping CategoriesCreating 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 ModelsThree migration strategies for a core data model change and the new reporting opportunities that are unlocked.
19 Feb 2026: Star Schema ProposalMy unsolicited view of the existing data architecture.