3.3.2 Gold (complex) Use Cases / Scenarios – cases’ that are anticipated in agencies are set out in the table below. The corresponding requirement sections of this standard are ticked in the columns. ‘Use and of design and capabilities Use Case / Scenario reporting metadata GOLD management cleansing capabilities maintenance analysis analytics dashboards assessment / data analytics analytics support glossary modelling operational exception performance reconciliation scheduling profiling quality quality quality history transformation acquisition lineage – – – – – – Data Data Data Data Data Data Data Data Database Automated Retrospective Real-time Predictive Requirements history Resilience Business Performance ETL ETL ETL ETL ETL ETL Security reporting Analytics Data warehousing Data Use Case / Scenario broker retention reports GOLD layer and and facility compliant Government sovereignty Multi-service management management OLAP NSW Onshore/offshore Data Archive Audit Predefined Cloud hosting Centre provision Backup Semantic Self-service administration Full-service administration Service recoverability Analytics Data warehousing
3.3.2 Gold (complex) – Use Cases / Scenarios ‘Use cases’ that are anticipated in agencies are set out in the table below. The corresponding requirement sections of this standard are ticked in the columns. Use Case / Scenario GOLD Data profiling Data quality Data quality dashboards Data quality assessment Automated data cleansing Retrospective analytics Real-time analytics Predictive analytics Requirements analysis and design Data modelling Data lineage Data history / maintenance of history Data acquisition ETL – operational metadata ETL – transformation capabilities ETL – exception management ETL – reconciliation reporting and reporting ETL – scheduling capabilities ETL – performance Resilience Database support Security Business glossary Performance Analytics Data warehousing Use Case / Scenario GOLD Semantic layer OLAP Predefined reports Self-service administration Full-service administration Cloud compliant hosting facility NSW Government Data Centre Onshore/offshore management Service management Multi-service broker provision Data sovereignty Backup and recoverability Archive and retention Audit Analytics Data warehousing
analyticsdatawarehousing_standard_v1.1_11012016.docx