✅ What You’ll Need 🛠️ Step-by-Step Power Query Approach Step 1: Load both tables into Power Query Step 2: Create a Cross Join (Employee × Month) Step 3: Add FTE Logic (Human Version in M) Now, for each row (i.e. employee × month), add a custom column to calculate the monthly FTE: 🧾 Final Step: … Read more
Purpose This playbook guides the phased migration from existing DataMart views (202409) to CDM-standard views, including core, meta (dates, codes, values), and item tables. It supports the transition to IFS Cloud and ensures a consistent, scalable data model across all domains. MVP Scope Domains required for MVP: Phased Delivery Approach Phase 1: Live Data Seeding … Read more
Project Description This initiative aims to integrate Business Opportunity Pipeline data from SharePoint Lists and Deltek Vision sources into the central Data Warehouse. The primary objective is to enable consistent, automated global reporting ahead of the GMIS ERP rollout across the APAC, NA, and EU regions. The integration will align with the existing Business Opportunity … Read more
🔗 How to Configure VNet Peering for Azure Data Factory and Oracle Integration This guide walks you through securely connecting Azure Data Factory (ADF) to an Oracle Virtual Machine hosted in a different Virtual Network. By setting up VNet Peering and configuring a Managed Virtual Network Integration Runtime (IR), you can enable private, secure data … Read more
Project Description The PinPoint Application Tracking System Integration project aims to integrate the PinPoint recruitment platform with internal systems, specifically by: The goal is to streamline recruitment data flow, ensuring that job postings are automatically synchronised, consistently formatted, and securely integrated into internal systems. Risks & Issues Key Risks Key Issues Main Tasks & Deliverables … Read more
Project Description The Regional Project Data Integration aims to integrate legacy project data from Deltek Vision systems in the APAC, NA, and CAN regions into the Data Warehouse. This integration will enable automated business reporting before the GMIS ERP system is implemented in these regions. The main objective is to ensure that historical and active … Read more
1️⃣ Overview The Data Warehouse (DWH) enforces role-based access control (RBAC) and Multi-Factor Authentication (MFA) to secure access across: All users must authenticate using MFA when accessing database resources and storage accounts. Access Governance and Security 2️⃣ User Access and Membership Groups Volumes – Users and Type 3️⃣ SQL Server Access Control SQL Server permissions … Read more
The following Power Query (M) script demonstrates how to extract a list of dates from a table, convert them into a formatted string, and use them dynamically in an API request: Step-by-Step Guide Explanation: Application in get.myhistory This approach can be used within get.myhistory to dynamically retrieve historical records by supplying a list of relevant … Read more
Overview The Splash View is a flexible data exploration tool in myBMT, providing interactive access to various structured data formats, including: This tool allows users to explore data visually and programmatically, ensuring seamless interaction across multiple file formats. 1️⃣ Availability Where can I find the Splash View? 🚿 Wherever you see the shower icon in … Read more
Microsoft Fabric is designed to integrate multiple analytics workloads, including data engineering, data science, and business intelligence, within a unified platform. While our current Medallion structure already has a logical progression of data refinement (Bronze → Silver → Gold), there are key differences in architecture, tooling, and approach that we might consider while emulating a … Read more