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

Level 5 Competency Self-Assessment Matrix

Competency Area Element Indicative Score (1–5) Target (6 mo) Evidence / Example Activities Priority Data Management Devise & implement MDM processes (classification, security, quality, ethics, retrieval & retention) 4 5 Introduced soft/hard delete strategy; implemented RPV & last-seen frameworks; designed employee / project / customer domain MDM structures; strong data security awareness (container-level). M Derive … Read more

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

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