Purpose Role Assignments incl Project Manager etc Alternative to Project Manager in Project Details Plus Includes Sub-Project Assignment Use Case Owner: Martyn ColeTypical Use Case: Responsibility Assignment MatrixStyle: Fact Source Key Parameters CompanyProjectResource Sample Exec Response SEQ Dates Measures Codes SQL
Purpose The Project Customer Invoice (value) Fact TableDesigned to display quantitative data related to invoices generated for projects. This table integrates with dimension tables, such as client_details and project_details, to provide detailed insights into the financial aspects of projects, including invoicing, revenue, and billing trends. The primary purpose is to support forecasting, budgeting, and proactive project … Read more
Purpose The Project Customer Orderline (value) Fact TableDesigned to display quantitative data related to orders generated for projects. This table integrates with dimension tables, such as client_details and project_details, to provide detailed insights into the financial aspects of projects, including invoicing, revenue, and billing trends. The primary purpose is to support forecasting, budgeting, and proactive project … Read more
Purpose The Project Supplier Invoice (value) fact table is designed to display quantitative data related to invoices generated for projects. This table integrates with dimension tables, such as supplier_details and project_details, to provide detailed insights into the financial aspects of projects, including invoicing, revenue, and billing trends. The primary purpose is to support forecasting, budgeting, and … Read more
Create Parameters Create two parameters… Use a Token on myBMT The token allows the Datawarehouse to identify with the source of the report, as PowerBI cannot send environment details. (answers on a postcard please, if you know how) So the token is used to give the report a unique identifier myBMT | Token (bmt-dwh-uks-app-my.azurewebsites.net) Navigate … Read more
Purpose To construct and deliver a global marketing report capturing performance across channels and platforms, aligning results against campaign or core (BAU) KPIs and assumed customer behaviour. Use Case Owner: Emma O’NeillTypical Use Case: capturing performance across channels and platformsStyle: Fact Source Key Parameters CompanyDetails Sample Exec Response SEQ Dates Measures Codes SQL
Quality standards that apply to the development. Software Lifecycle used Software Quality tool(s) and methods used. The overarching goal of Data Warehouse Development Quality Plan is proactive problem-solving, where any anomalies or discrepancies are swiftly identified and rectified before they escalate into issues. Through continuous monitoring, analysis, and data observability, the reliability, accuracy, and accessibility … Read more
Purpose of Software Quality Plan The purpose of a Data Warehouse Development Quality Plan is to ensure that the development, deployment, and maintenance of the data warehouse, along with its associated components such as third-party data sources, Azure Data Factory (ADF) pipelines, and Data Marts, meet established quality standards. This plan serves as a comprehensive … Read more
Project Plan or other project management document. Data Discovery Stage: Objective: Identify data sources, understand data requirements, and define the scope of the DataMart project. Key Activities: Deliverables: Design Stage: Objective: Design the architecture, schema, and data models for the DataMart. Key Activities: Deliverables: MVP (Minimum Viable Product) Stage: Objective: Develop and deploy a minimum … Read more
Organisation/Team responsible for management of Service Desk requests/incidents. Escalation Routes All reports WILL provide a method of raising a Service Desk request for support. Once raised the following escalation routes will be followed. Issues Reporting (IT Service Desk) Stage Activity Comments Call Received Greet & Verify IdentityDocument Caller Details Problem Identification Listen & Clarify … Read more