Tax Reports Dashboard
Principle 06Connecting process to platformDashboard built to capture knowledge about undocumented SAS reports, with PowerShell monitoring for real-time job tracking. Identified a monitoring gap and delivered improved report ownership and enterprise-wide oversight.
What it replaced.
Inherited SAS tasks with no documentation. Had no visibility into job status—only learned about failures when teams complained. Limited ownership and resilience for high-priority reports.
How it works.
Built dashboard to capture knowledge, then PowerShell script to monitor folder locations based on report criteria (naming, file size). Enabled proactive vs reactive monitoring.
Verified before it ships.
The rules that produce these numbers are written as tests and run on every change — and every run, success or failure, writes to the record.
The same discipline, this tool’s stack.
Power BI · PowerShell · SQL Server · SAS