Julian.Kellett

Foundational Principles for Data Engineering in Support of the BHAGs

by

Data Engineering is a crucial enabler for BMT’s data transformation goals. The following principles define the scope and commitments of Data Engineering to support our broader strategic aims: Conscious Design Promote forward thinking around usability and interoperability of the data and user-centric design principles of sustainable data products Purpose-Driven Platform: The modern data platform is … Read more

Project.Value

by

Purpose The Project Value fact table is designed to display summarised financial data related to project hours, costs, and revenues. It integrates with dimension tables, such as project_details and client_details, to provide a comprehensive view of the financial performance of each project. The primary purpose is to support project management, strategic decision-making, and financial analysis … Read more

Project.Dates

by

Purpose: The purpose of this DataMart view is to provide a comprehensive timeline overview of a project’s key dates, from its creation to completion. It consolidates important project milestones such as planned and actual start and finish dates, delivery estimates, and project modifications. This view is designed to help stakeholders monitor project timelines, identify delays, … Read more

Employee.Employment

by

Purpose: The purpose of this DataMart view is to provide a clear snapshot of an employee’s current and historical employment status within a company. It captures essential details such as employment dates, employment type, and agreement, with a focus on determining whether an employee is currently active or not. This view is useful for HR … Read more

Release 41

by

Additions Employee.Employment The purpose of this DataMart view is to provide a clear snapshot of an employee’s current and historical employment status within a company. It captures essential details such as employment dates, employment type, and agreement, with a focus on determining whether an employee is currently active or not. This view is useful for … Read more

Renewing the SAS Token

by

Security Reminder Keep your SAS URL secure! Avoid sharing it with unauthorised individuals, as anyone with the link can perform the permitted actions. Impact of Expiry: The SAS token will expire on the se date in the URL (e.g., se=2024-10-22T18:23:02Z). If your SAS token expires before renewal: To prevent disruptions, ensure you renew your token … Read more

Understanding the SAS URL

by

A SAS (Shared Access Signature) URL provides secure delegated access to resources in an Azure Storage account. The SAS URL you’ve shared grants specific permissions (like read, write, or delete) over a defined period. Here’s a guide on how to use it: Key Components of the SAS URL: Security Reminder Keep your SAS URL secure! … Read more