Purpose For the calculation of Resource Utilisation Use Case Owner: Martyn ColeTypical Use Case: Project Reporting PortalStyle: Fact Code & Source related to Resource.Capacity Source Key Parameters CompanyResourceProject Sample Exec Response SEQ Entity Dates Measures Codes SQL
Purpose For the calculation of Resource Utilisation Use Case Owner: Martyn ColeTypical Use Case: Project Reporting PortalStyle: Fact Code & Source related to Resource.Activity Source Key Parameters CompanyResource Sample Exec Response SEQ Entity Dates Measures Codes SQL
Purpose For the Calculation of Resource Utilisation Use Case Owner: Martyn ColeTypical Use Case: Project Reporting PortalStyle: Fact Code & Source related to Resource.Capacity Source Key Parameters CompanyResourceAbsence Group Sample Exec Response SEQ Entity Dates Measures Codes Resource Other Codes SQL
Purpose Date table for Financial Year Source Spreadsheet of Period Dates Parameters Date_KeyCompany Sample Exec Response SQL
Purpose Calendar Year Sample Exec Response SQL
Purpose Combined Date Table (myDate & Period) filtered for single company Sample Exec Parameters [Date_Key] Response Holiday Period SQL
Practical Fibonacci is a lightweight, confidence-based approach to job sizing. By using Fibonacci numbers to estimate effort, teams can express not just how long something might take — but how much clarity, confidence, and complexity is involved. This method encourages meaningful conversation about risk, unknowns, and deliverability, helping teams avoid underestimating large or unclear work, … Read more
Skill level Description Awareness This skill level is currently not defined. Working You can:design data architecture by dealing with specific business problems and aligning it to enterprise-wide standards and principleswork within the context of well understood architecture, and identify appropriate patterns Practitioner You can:design data architecture that deals with problems spanning different business areasidentify links … Read more
Strategy involves creating a plan to achieve a team or organisation’s objectives. Skill level Description Awareness You can:explain the strategic context of your work and why it is importantsupport strategic planning in an administrative capacity Working You can:work within a strategic context and communicate how activities meet strategic goalscontribute to the development of strategy and … Read more
Data standards involve established practices to make it easier and more effective to share and use data across government. Skill level Description Awareness This skill level is currently not defined. Working You can:develop data standards for a specific componentanalyse where data standards have been applied or breached, and undertake an impact analysis of that breach … Read more