Standards Statement: Non-Proliferation of Information

To ensure efficiency, compliance, and trust in the Data Warehouse, we commit to the principle of non-proliferation of information. This means that data will be held and processed in a way that avoids unnecessary duplication, ensures clear lineage, and retains only what is required for business and regulatory purposes. Standards This approach ensures the Data … 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 where curiosity, novelty, and real-world value meet.Prettifying isn’t just polishing — it’s how I learn systems and make them modular.Guide me with clarity of purpose, and I’ll deliver energy, creativity, and continuous improvement. 🧩 How I Work Best 💪 Strengths I Bring ⚠️ Things I Need to Guard Against 🛠️ My Self-Management Strategies … 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

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

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

Proposal: Expanding Data Engineering to Embrace Fabric and AI Engineering Executive Summary

This proposal outlines a phased approach to broaden the scope of our Data Engineering capability, incorporating Microsoft Fabric as a unified analytics platform and evolving our approach to include foundational elements of AI Engineering. The goal is to create an agile, scalable, and intelligent data platform that supports operational analytics, predictive insights, and innovation. 1. … Read more

Value Presence Verification (RPV) + Last-Seen Tracking Framework

🎯 Purpose This framework ensures that values in complex metadata structures (e.g. project earned value, invoice accounting, or employee attributes) are verified for presence even when using incremental loads. It protects against stale data persistence or silent value loss, using metadata-driven auditing. 🧩 Problem Context In many CDM views, values are upserted using procedures like … Read more