Improve dashboard as code

[JCZuurmond]

• Fix failing integration test
• Increase unit test coverage
• Minimize integration test surface
• Reduce code duplication
• Use dataclasses methods
• Refactor format query

[github-actions[bot]]

✅ 22/22 passed, 2 skipped, 7m6s total

_{Running from acceptance #94}