3.3.1 Silver (standard) 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 SILVER management capabilities cleansing maintenance analysis analytics dashboards assessment / data analytics analytics support glossary modelling operational performance exception scheduling transformation reconciliation profiling quality quality quality history acquisition lineage – – – – – – Data Data Data Data Data Data Data Data Database Automated Retrospective Real-time Requirements history Resilience Business Predictive ETL ETL ETL ETL ETL ETL Performance Security reporting Analytics Data warehousing Data hosting Use Case / Scenario broker retention SILVER reports and and level compliant Government sovereignty Multi-service management management OLAP NSW Onshore/offshore Data Archive Audit Predefined Cloud Centre provision Backup Semantic Self-service administration Full-service administration Service recoverability facility Analytics Data warehousing
3.3.1 Silver (standard) – 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 SILVER 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 and reporting ETL – reconciliation reporting ETL – scheduling capabilities ETL – performance Resilience Database support Security Business glossary Performance Analytics Data warehousing Use Case / Scenario SILVER Semantic OLAP Predefined reports Self-service administration Full-service administration Cloud compliant hosting facility NSW Government Data Centre Onshore/offshore management Service level management Multi-service broker provision Data sovereignty Backup and recoverability Archive and retention Audit Analytics Data warehousing
analyticsdatawarehousing_standard_v1.1_11012016.docx