Skip to content
knowhow
  • Home
    • Knowledge Base
  • Competency Model
    • Data Wrangling
      • Data Analyst
      • Data Architect
      • Data Engineer
      • Data Scientist
    • Knowledge Worker
      • Thinking Skills
      • Technology Use
      • Teamwork and Leadership
      • Personal Management
      • Lifelong Learning and Self-Direction
      • Communication
  • Customer Journey Bible
    • Customer Journey Bible
    • BHAGs
    • Reporting Strategy
    • Data Operations Plan
    • Data Operating Model
    • Quality Plan
    • Developer Portal (myBMT)
  • Solution Architecture
    • Data Warehouse Architecture
    • Canvas Model
    • Common Data Model
    • MVP
    • Pipeline
  • DataMart
    • Employee
    • Resource
    • Project
    • Customer
    • BusOpp
    • Infrastructure
    • Dates
    • Global
  • Projects

Dates

  • get.myView
    • Dates.Dim_Date
    • Dates.MyDate
    • Dates.Period

Recent Posts

  • Power BI guide: managing the current views & a simple pivot pattern
  • Standards Statement: Non-Proliferation of Information
  • 360 Feedback – Areas to Highlight
  • Look in the box first
  • Playbook: DataMart & Reporting Development Process
  • Personal Playbook: Shiny Keys Mindset 
  • Personal Playbook: Shiny Keys Mindset
  • 12 Monthly Themes for Digital Transformation
  • Common Data Model (CDM): Structure & Query Guide
  • 🌟 Transparency Meets Simplicity – Updates to the Data Dictionary in myBMT
  • Minor Incident Report: Headcount Submission and Reporting Misalignment
  • Incident Report Definitions
  • Lesson Learnt: Avoid Web.BrowserContents()
  • Release 72
  • Release 71
  • OCNS/CEFAS DataViews
  • Release 70
  • Proposal: Expanding Data Engineering to Embrace Fabric and AI Engineering Executive Summary
  • The Phoenix Project
  • Ali’s Tip of the Day: Rename All Columns in Power BI in One Go!

Recent Comments

  1. Julian.Kellett on Global.Company

    {"Current stable version":"202409","exec":"@version = ‘202409’","Development" : "@version = ‘beta’","Change":"Regional View"}

  2. Julian.Kellett on Global.Organisation

    {"Current stable version":"202409","exec":"@version = ‘202409’","Development" : "@version = ‘beta’","Change":"Regional View"}

  3. Julian.Kellett on BusOpp.Dates

    {"Current stable version":"202409","exec":"@version = ‘202409’","Development" : "@version = ‘beta’","Change":"Stable 09 View"}

  4. Julian.Kellett on Supplier.PurchaseOrderline

    {"Current stable version":"202409","exec":"@version = ‘202409’","Development" : "@version = ‘beta’","Change":"Stable 09 View"}

  5. Julian.Kellett on Supplier.Invoice

    {"Current stable version":"202409","exec":"@version = ‘202409’","Development" : "@version = ‘beta’","Change":"Stable 09 View"}

  6. Julian.Kellett on Supplier.Details

    {"Current stable version":"202409","exec":"@version = ‘202409’","Development" : "@version = ‘beta’","Change":"Stable 09 View"}

  7. Julian.Kellett on BusOpp.Dates

    Expected Condition The DataMart View BusOpp.Dates is in the style of 202409 As Found Condition The unversioned (beta) edition of…

  8. Ali Ahmed on How to Find the SQL Definition of a View in Oracle

    Double check your WITH READ ONLY — it’s typically only used on views, not raw SELECT queries unless you're defining…

  9. Julian.Kellett on Resource.Details

    {"Current stable version":"202409","exec":"@version = ‘202409’","Development" : "@version = ‘beta’","Change":"Cross Apply version"}

  10. Julian.Kellett on Employee.Hours

    {"Current stable version":"202409","exec":"@version = ‘202409’","Development" : "@version = ‘beta’","Change":"CTE Version"}

Archive

  • October 2025
  • September 2025
  • August 2025
  • July 2025
  • June 2025
  • May 2025
  • April 2025
  • March 2025
  • February 2025
  • January 2025
  • December 2024
  • November 2024
  • October 2024
  • September 2024
  • August 2024
  • July 2024
  • June 2024
  • May 2024
  • April 2024
  • March 2024
  • February 2024
  • January 2024
  • December 2023
  • October 2023
  • September 2023
  • August 2023
  • July 2023
  • June 2023
  • April 2023
  • March 2023
  • February 2023
  • January 2023
  • December 2022
  • November 2022
  • October 2022
  • February 2022
© 2025 knowhow • Built with GeneratePress