Business Requirements for Reporting

3.1 High Level Business Reporting Requirements We recognise that specific report requirements are too detailed for a strategy document so instead we will introduce high level functional requirements and non-functional requirements derived from our data governance procedures.  An outline framework showing specific requirements is contained at the Annex.   The relationship between high level requirements, reports … Read more

Objectives

2.1 BMT’s Strategy and Vision BMT aims to be a global leader in addressing the most significant engineering challenges of our time. Our vision is to excel in ship design and become a credible digital competitor by transforming asset life cycle and environmental services. We strive to be recognised for our collaborative approach, investing in … Read more

Introduction

1.1 Why We Need a Data and Reporting Strategy In BMT we see a rapidly changing landscape of risks, opportunities and constraints around data.  Whether this is the data we use to make decisions every day to how we support our customers or our employees.  Our Business Strategy and our Business Risks build a picture … Read more

Release 53

Notes 1. ⚠️ DIFFERENT: project_cost_CAD.sql2. ⚠️ DIFFERENT: project_cost_USD.sql3. ⚠️ DIFFERENT: project_details_CAD.sql4. ⚠️ DIFFERENT: project_details_plus_CAD.sql5. ⚠️ DIFFERENT: project_details_plus_USD.sql6. ⚠️ DIFFERENT: project_details_USD.sql7. ⚠️ DIFFERENT: project_revenue_CAD.sql8. ⚠️ DIFFERENT: project_revenue_USD.sql Total number of different files: 8Total number of missing files in DEV CONTAINER: 0Total number of missing files in PRD CONTAINER: 0

Integration with Existing Systems

(Redrafted for Alignment with Integration Strategy) Key Takeaways 13.1 Integrations Strategy The Integration Strategy prioritises seamless connections between Enterprise Applications and the Global Data Warehouse to ensure standardised and accurate reporting. Key Objectives: The strategy is designed to support both real-time and batch data processing requirements, with scalability to accommodate future applications. 13.2 Integrations Architecture … Read more

Security and Access Control

(Redrafted for Alignment with Data Operations Plan) Key Takeaways 9.1 Security and Access Control Requirements 9.2 Security and Controlling Access All of our systems, data sources, data warehouses, data marts and reports are developed considering confidentiality, integrity and availability (CIA Triad).  The CIA Triad is an important concept in Information Security including ISO27001 and data … Read more

Data Modelling and Transformation

(Redrafted for Alignment with Data Operations Plan) Key Takeaways 7.1 Data Modelling and Transformation Requirements The following requirements have been identified relating to Data Modelling and Transformation: 7.2 Reporting Framework and Data Transformation The Reporting Framework (repeated at Figure 7.1) identified 3 typical data types used in various levels of reporting.  It is recognised that elements … Read more

Data Governance

(Redrafted for Alignment with Data Operations Plan) Key Takeaways 5.1 Compliance and Governance Requirement Ensuring compliance with industry regulations, internal governance, and data protection standards such as GDPR and ISO 27001 is paramount. Regular audits, risk assessments, and a robust data governance framework will underpin these efforts. Reporting practices will incorporate legal, commercial, and regulatory … Read more

Data Engineering and Transition to IFS Cloud

What good looks like Background:  By September 2025, all IFS data currently residing in the Apps 10 solution will transition to the IFS Cloud environment. Commitment: Data Engineering commits to ensuring uninterrupted delivery of DataMarts sourced exclusively from IFS Cloud, enabling the continuity of reporting assets. Prerequisites for a Successful Transition 1.    Reduction of Views … Read more

Release 52

Additions Employee.Absence This view combines employee data (DIM_EMPLOYEE_OL) with absence details (QFACT_ABSENCE_DETAILS_OL$) to facilitate the creation of a dataset used for tracking and analysing employee absences in detail. It generates structured JSON data for efficient reporting, compliance, and analytical purposes. Employee.AbsenceLimit This view creates a structured dataset for tracking and analysing employee absence limits. It … Read more