The Data Engineering Team plays a crucial role in ensuring the smooth operation and continuous improvement of our data services. However, many people may not fully understand how we structure our development cycles and why we operate in a particular way. This article aims to provide insight into a typical week in the life of … Read more
Role: Project ManagerContext: Large-scale technical consultancy engagement requiring coordination across engineering, finance, and delivery teams 🔪 Challenge The project manager needed to: Problems included: “I spent hours each week trying to make sense of data from five different places—and still couldn’t guarantee it was accurate.” 🚀 Solution The Data Engineering team: 🌟 Outcome “Now I … Read more
At the heart of every report, dashboard, and project delivery, there’s data—clean, consistent, and flowing on time. That’s what Data Engineering delivers. Whether you’re chasing a deadline, answering a tough question, or leading a major project—we make sure you have the data you need, when you need it. ⚖️ Clarity You get clean, reliable data … 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
This draft framework provides a robust SLA for DataMart availability, balancing business needs, technical feasibility, and stakeholder communication. 1. Availability Target Set a clear uptime percentage that aligns with the criticality of the DataMart to your business processes. 2. Operational Hours Define the expected operational hours of the DataMart. Specify if it needs to be … Read more
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
Requirements & Design This document is used to outline details related to reporting requirements of the project. Specifically, this document captures the technical specifications that are required for the successful design and development of business reports. Report Technical Specifications This section is used to describe the detailed specification related to how NUIT will develop a … Read more
Accuracy is the degree of closeness to true value. Precision is the degree to which an instrument or process will repeat the same value. In other words, accuracy is the degree of veracity while precision is the degree of reproducibility. What does accuracy mean? If a measurement is accurate, it means that it agrees closely … Read more