BusOpp: Meta_Dates

What this view is for Busopp.meta_dates provides the key lifecycle and timing dates for business opportunities. If core_details tells you what the opportunity is and meta_codes tells you how it should be categorised, meta_dates tells you when important things happened (or are expected to happen). This view is essential for understanding pipeline flow, forecasting, and … Read more

BusOpp: Meta_Codes

What this view is for Busopp.meta_codes provides the categorisation and contextual labels for business opportunities. If core_details tells you what the opportunity is, meta_codes tells you how it should be grouped, classified or interpreted. This is where things like type, category, region, ownership and other descriptive attributes live. Level of detail (grain) This view is … Read more

BusOpp: Core_Details

What this view is for Busopp.core_details is the starting point for all sales pipeline reporting. It represents a single business opportunity in its simplest, most recognisable form and provides the identity and linkage needed to explore the rest of the pipeline. If you’re asking “what opportunities do we have, and how do they connect to … Read more

Pivot-me: Working with long, thin meta tables

The meta_codes, meta_dates (and any derived meta_values) views are intentionally long and thin. This structure: That said, long thin tables aren’t always the easiest shape to work with directly in a reporting tool. Shaping meta data into a report-friendly form Once you’ve applied some basic filtering (for example, keeping only the code or date types … Read more

Release 85

1. Core Detail Views Updated views Change Impact / Rationale 2. Project Meta Values Views Updated views Changes / Notes Risks / Considerations 3. Meta Codes Views Updated views Changes Impact / Rationale 4. Feedback Meta Satisfaction View View Changes / Notes Action 5. Infrastructure OSH Records View Changes / Notes Impact 6. Base Architecture … Read more

Project Margin Variance Report – Requirements Specification

Version: 1.0Owner: Regional Finance DirectorPrepared by: Data Engineering 1. Purpose The purpose of this report is to provide clear and consistent visibility of margin performance across all active projects, comparing the originally approved bid margin with the latest forecast outturn margin. The report will support financial oversight, early risk identification, and commercial performance management at project, PRU, and regional levels. 2. Objectives 3. … Read more

Microsoft Fabric Deployment Pipelines

What are Deployment Pipelines? Pipeline Structure Stage Comparison in UI Item Pairing & Status Selective Deployment Deployment Rules Lakehouse & Deployment Pipelines in Fabric Deployment pipelines move Lakehouse metadata, including shortcuts, but do not copy data or table schemas. After deployment, shortcuts still point to the original source, and the Lakehouse will be empty unless … Read more