(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
(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
(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
Treating the Report Designer as the Controller in Power BI makes sense because they are responsible for orchestrating how data (Model) interacts with the user interface (View). The designer’s decisions define how business rules are applied, how data is processed, and how the user interacts with it. In this sense, the Report Designer does act … Read more
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
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
BMT strives to deliver clarity through complexity and, with this, we start at home. This Reporting Strategy provides the framework on how we will deliver internal reporting that is clean, accurate and best in class. Purpose and Vision The Reporting Strategy is designed to unify BMT’s approach to internal reporting, embedding consistent standards for quality, … Read more
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
Objective: Design, develop, deploy, and maintain Datamarts with a focus on performance, security, and usability. Steps: Data Discovery and Requirements Gathering Datamart Design and Security Planning MVP Development and Iteration Deployment and Go-Live Maintenance and Performance Testing
Objective: Efficiently acquire data from various sources and ensure secure, accurate, and timely transport to the data lakehouse and data warehouse. Steps: Data Source Identification and Mapping Data Profiling and Classification Data Acquisition and Integration Transport to Data Warehouse Testing and Validation