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
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
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
🧾 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
🔹 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
📌 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
This release documents updates to the Data Warehouse covering changes made since 30 June. It focuses on the continued rollout of CDM-aligned views and early implementation of Resource views. 🔁 Customer & Supplier Domains customer_core_details supplier_core_details 👥 Employee Domain employee_hours Absence-Related Views employee_item_codes_absenceemployee_item_dates_absenceemployee_item_values_absence employee_meta_codes 📁 Project Domain project_item_codes_forecastproject_item_values_forecast 🔧 Resource Domain (Initial Release) resource_item_codes_activityresource_item_values_activity
Changes busopp_dates_202409 Updated to source Wanted Delivery Date from the refactored QFACT_BUSINESS_OPP_OL (formerly FACT_BUSINESS_OPP_OL$). project_value_202410 Now filtered to exclude rows where CONTROL_CATEGORY is NULL. OCNS / CEFAS DataViews These views provide an overview of the product-related DataViews derived from OCNS (Offshore Chemical Notification Scheme) and CEFAS (Centre for Environment, Fisheries and Aquaculture Science) regulatory sources. … Read more
📘 Purpose This page provides an overview of the product-related data views based on OCNS and CEFAS environmental regulatory sources. These views support reporting, environmental compliance, and substitution warning analysis across various product categories. 🔍 Use Cases 🗂️ DataViews Summary The following views are published within the cefas schema: DataView Name Category Description Notes / … Read more
View: project_forecast_202409 Enhancements: Spark-SQL Compatibility and Safe-Code Updates Changes Implemented To improve compatibility with Spark SQL and prepare views for future transition into Fabric or Lakehouse environments, the following adjustments have been made: Outstanding Compatibility Issues 1. IIF() in object CODE should be CASE 2. Square brackets on reserved words (e.g. [identifier]) 3. CF$ field … Read more