From: Omar Haddad, BI lead, Kestrel Logistics (fictional)
The regional sales reports are ready to go to the whole sales organization next week. Before they do, the workspace needs tidying and governing, and the release has to go through the pipeline.
The service: the Sales Analytics workspace (Production) with its Development and Test copies, the Regional Sales semantic model (on-premises SQL Server kl-sql-01), the Regional Sales, Executive Summary and Payroll Summary reports, and the gateway KL-GW-01.
Done looks like:
- Grace Kim (contract ended) is removed and Priya Shah can publish.
- Regional Sales refreshes every day at 06:00 New York time through the gateway.
- The reviewed model is Certified and the payroll report is Highly Confidential.
- East Managers and West Managers are in their RLS roles.
- The tested version 3 is released to Production, reading kl-sql-01.
- An app gives Leadership the Executive Summary and Sales Managers both sales reports.
Each step continues from your work in the step before. All names are fictional practice data.
Six steps, one service. Each step checks the whole service, so earlier work has to stay right while you add the next change. Think about what each change does to the people involved, not only to the settings: who gains access, who loses it, and what a Viewer sees.
The release goes from Test, with a rule that keeps Production on its own server.