Roadmap: to Level 5 Readiness

Month Theme / Focus Area Key Actions Tangible Evidence / Deliverables Success Indicators Month 1 Baseline review & planning • Confirm current Level 5 competency scores and priorities• Align with manager/mentor on fellowship expectations• Map your influence across Data Engineering + Analytics disciplines Updated self-assessment & evidence tracker Clear alignment between Data Engineering objectives and … Read more

Personal Playbook: Shiny Keys Mindset 

I thrive where challenge, novelty, and passion meet. I learn visually and by doing things myself. Engagement is key for me – if my brain isn’t bought in, it can’t focus on the task. Guide me with clarity of purpose, insight, novelty and challenge and I’ll deliver energy, creativity, and continuous improvement.  🧩 How I Work Best  … Read more

Personal Playbook: Shiny Keys Mindset

I thrive at the intersection of curiosity, novelty, and real-world value, but I also perform best when work is structured, collaborative, and purposeful.Exploration and improvement energise me, yet clarity of expectations and harmony in the team keep me focused.Guide me with clarity of purpose, and I’ll deliver energy, creativity, and continuous improvement. 🧩 How I … Read more

12 Monthly Themes for Digital Transformation

October – Foundations of DigitalHow do we define digital transformation across our teams, and what does “digital first” mean in practice? November – Collaboration & ConnectionExploring tools, practices, and mindsets that make hybrid and cross-team collaboration work. December – Data as a Shared AssetWhat does “data is for everyone” look like, and how do we … Read more

Perspective: Julian

A Personal Wiring Profile — Series Analysis Every individual brings a unique blend of tendencies, motivations, and working patterns to their role. This personalised perspective explores your natural wiring based on the Shiny Keys Playbook you wrote — a remarkably candid and revealing expression of how you think, create, collaborate, and deliver. Your pattern blends … Read more

Common Data Model (CDM): Structure & Query Guide

How to query a CDM view (Power Query / M) Use the datamart domain value as @dataMart and the view name as @viewName. Naming conventions Sales Pipeline Covers all stages of customer acquisition and order-to-cash pipeline. Marketing (marketing) Activities and campaigns to generate awareness and leads. Collection Definition Views Base views Campaigns, channels, lead gen … Read more

🌟 Transparency Meets Simplicity – Updates to the Data Dictionary in myBMT

Hey everyone 👋 We’ve been working hard behind the scenes on something that we think will really help you. 🔍 What’s New? We’ve significantly expanded the Attribute Lineage and Data Dictionary tooling in myBMT. This means: It’s a fully transparent journey from requirement ➡ mapping ➡ code — all in one place. 😅 One Small … Read more

Minor Incident Report: Headcount Submission and Reporting Misalignment

🧾 Incident Summary: Discrepancies were identified between the Headcount report and the Management Accounts (MA) reporting figures. The headcount submission process also suffered from data entry issues, retrospective updates, and manual effort required to maintain alignment across periods. 🔍 Root Cause Analysis 1. Inconsistent Timing of Submissions 2. Differences in Ownership and Definition 3. Submission … Read more

Incident Report Definitions

🔹 Minor Incident Report (MIR) Definition:A Minor Incident Report documents issues that do not materially impact core reporting outputs, system availability, or regulatory obligations, but still highlight: Purpose: Examples: 🔸 Serious Incident Report (SIR) Definition:A Serious Incident Report is raised when the incident: Purpose: Examples: 🚨 Deciding Between Minor and Serious You can use this … Read more

Lesson Learnt: Avoid Web.BrowserContents()

📌 Key Takeaway: Always use Web.Contents() when connecting to authenticated web resources or APIs, especially if publishing to the Power BI Service.Reserve Web.BrowserContents() for desktop-only scenarios like scraping HTML pages with dynamic content — and expect no scheduled refresh capability. ⁉️ Scenario We encountered a frustrating authentication issue when trying to refresh a published Power … Read more