Julian.Kellett Ensuring Structured, Reusable, and Scalable Data Architecture 1️⃣ Purpose of the Common Data Standard The Common Data Standard (CDS) establishes a structured framework for defining DataMart views in a consistent and scalable manner. This standard: ✅ Promotes reusability across different datasets.✅ Ensures alignment between business logic and reporting needs.✅ Enables efficient data joins and minimises … Read more
Bridging Structured Data with Usability 1️⃣ Understanding the Layers: CDS vs. Utility Views The Common Data Standard (CDS) defines a structured, specialist-oriented view of data, ensuring consistency and modularity in reporting. However, for non-specialists, the Utility (Commodity) View simplifies data consumption by cross-combining relevant details into a single, user-friendly dataset. View Type Purpose Audience Example … Read more
1️⃣Overview The Data Dictionary serves as the backbone for structured data definitions across financials, operations, projects, compliance, and workforce domains. It ensures standardised terminology, clear metadata definitions, and structured governance for all key data entities. Key Functions: ✅ Standardised Definitions – Ensures clarity and uniformity across datasets.✅ Metadata-Driven Organisation – Supports schema validation and query … Read more
Summary This minor release of some 36 changes to ensure that all view definitions now include an Alias for the table in the FROM clause. These updates are cosmetic in nature and do not impact the performance of the DataViews. Key Updates Impact Next Steps For any queries or issues, please reach out to the … Read more
Purpose The get.myarchive stored procedure is designed to retrieve archived data from a specified DataMart view, allowing for historical analysis and structured retrieval. The procedure integrates data retrieval logic, version control, and debugging capabilities to ensure flexible and efficient access to archived data. Key Features Workflow Use Case This procedure is ideal for historical data … Read more
Purpose The Infrastructure.OSHrecords DataMart is designed to provide a structured and centralised repository for occupational health and safety (OHS) records sourced from the myOSH system via API exports. This DataMart enables efficient reporting, compliance tracking, and analysis of safety-related incidents, risk assessments, and other regulatory documentation. By transforming the raw API data into a well-structured … Read more
Proposal for a white paper on Common Data Model (Datamarts) Proposed Structure for the White Paper 1. Executive Summary 2. Introduction 3. Objectives 4. Proposed Standardised Format 5. Naming Conventions 6. Standardised Structure for Views 7. Metadata Format 8. Implementation Roadmap 9. Benefits 10. Conclusion Naming Suggestions for Views Here are some options for naming … Read more
This white paper proposes a comprehensive Data Protection Impact Assessment (DPIA) framework for the Data Warehouse, detailing the potential commercial and personal data risks across individual data marts—including Projects, Employee, and Customer—and introducing a “Defence by Design” methodology to mitigate these risks effectively. Objectives Data Marts Overview and Risk Assessment 1. Projects Data Mart 2. … Read more