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
Commercially sensitive data includes any information that, if compromised, lost, or disclosed without authorisation, could cause moderate financial, competitive, reputational, or operational harm to the organisation. Handling such data requires additional care to ensure compliance with internal policies, contractual obligations, and regulatory requirements. 1. Key Characteristics of Commercially Sensitive Data Commercially sensitive data typically falls … Read more
In its most basic definition, sensitive data is a specific set of “special categories”: Article 9 of the GDPR prohibits special category data from being processed unless you can rely on an exemption.
Microsoft Fabric is designed to integrate multiple analytics workloads, including data engineering, data science, and business intelligence, within a unified platform. While our current Medallion structure already has a logical progression of data refinement (Bronze → Silver → Gold), there are key differences in architecture, tooling, and approach that we might consider while emulating a … Read more
BMT’s reporting strategy aims to maximize data use through data governance, Microsoft-based and native IFS technologies, and a common data model for accuracy and consistency. This will enable advanced analytics to enhance decision-making. The strategy also includes the implementation of a federated data governance model, where regional businesses will follow a centralised set of Data … Read more
These requirements have been derived to align with the Business Processes to shown alignment to the level 1 and level 2 processes arranged by business use case. ID Use Case Requirement L1 Process L2 Process Metric and Purpose Report Type Business Owner 1 Statutory Reporting / Board Campaign Summary Opportunity Management Lead Management Summarise the … Read more
14.1 Key Points In this section, we summarise the critical elements of the Reporting Strategy that have been discussed throughout the document. 14.2 Benefits and Outcomes This section outlines the advantages and expected results of implementing the Reporting Strategy. The table below provides a concise overview of the key points and their corresponding benefits and … Read more
13.1 Futureproofing with Microsoft Fabric As Microsoft transitions to Fabric, an integrated end-to-end analytics platform, BMT must prepare to leverage its features effectively. The following steps will ensure readiness: Fabric integrates workloads like Data Engineering, Data Factory, Data Science, Data Warehouse, Real-Time Intelligence, Industry solutions, Databases, and Power BI into a shared SaaS foundation. Each … Read more
12.1 Change Management Process Change Management is implemented with a single process covering changes to Data, Systems and Processes. Users are able to raise Change Requests which are then reviewed and actioned. At all points users are kept informed about their change requests. All Change Requests are logged centrally and are available to all users, … Read more
11.1 Training and User Support Requirements Develop training programmes to help users effectively utilise reporting tools. Establish a support system for addressing user queries and issues. 11.2 Training To support the digital skills development of user the Power BI and Data Visualisation is generally applicable to new users or users who are new to this … Read more