Julian.Kellett

Release 42

by

New Versions 202410 Content Reviewed by AI Project Details Removal of legacy Project_Item_ID as HASHADD project [STATUS] Project Details_Plus ADD Project Manager EmailRemove Project Dates (for Project.Dates)Remove FINANCIALLY RESPONSIBLE (for Project.RoleAssignment)Remove CUSTOMER RESPONSIBLE (for Project.RoleAssignment) Project Dates First Version since Beta Project_Cost ADD PRU CodeREMOVE Dates (for Project.Dates)Include Currency (of Company)COALESCE(dim_proj.PROJECT_CURRENCY_CODE, dim_company.CURRENCY_CODE) AS CURRENCY_CODE Project_Value … Read more

MVC application to Power BI

by

1. Model (Data Model in Power BI): 2. View (Report/Visualisation in Power BI): 3. Controller (User Interaction in Power BI): Application of MVC to Power BI Workflow: Practical Example in Power BI: Benefits in Power BI: In conclusion, although Power BI doesn’t directly follow the traditional MVC framework, its architecture of separating the data model … Read more

Data & Analytics Stakeholder Domains

by

1. Base DataViews & DataMart Architecture 2. CRM and Transactional Data 3. Data Security and Governance 4. Signposting of Insights 5. Metadata and Data Lineage 6. Master Data Management (MDM) 7. ETL/ELT and Data Integration Processes 8. Analytics and Data Modelling 9. Data Lifecycle Management & Archiving 10. Data Quality and Stewardship 11. Real-Time Data … Read more

Data Operating Model with SOP Integration

by

Standard Operating Procedures (SOPs) guide the DOM’s processes, ensuring efficiency and consistency at each stage. Purpose & Scope of the Data Operating Model Standard Operating Procedures Across Key Stages Data Planning SOPs Data Acquisition SOPs Data Processing & Maintenance SOPs Data Publish & Share SOPs Snapshot & Archive SOPs Data Flow and Governance within the … Read more

Data Quality Dimensions and Standards

by

Data quality management within the DOM ensures that data remains accurate, consistent, timely, and reliable across the organisation. Accuracy How well does a piece of information reflect reality? Accuracy refers to the degree in which the data correctly portrays the real-world situation in which it was originally designed to measure. Data must be meaningful and … Read more

Governance Framework

by

The DOM’s governance framework defines clear roles, policies, and responsibilities, ensuring data is trustworthy, compliant, and effectively managed across its lifecycle. Data Governance Structure: Establishes an oversight committee and data stewards across departments to maintain quality. Roles & Responsibilities: Assign data owners, stewards, and custodians to manage, validate, and secure data across departments. Quality Control … Read more

Data Operating Capabilities:

by

A Data Warehouse & Data Mart Operating Model alone does not create quality and value but requires an intersection of process, people, and technology conceived around the data model to provide its actual value. Building processes and organisational structures to deliver compelling data products to users is the realisation of what the Data Operations Model … Read more