This repository contains example queries to easily create Business Intelligence (BI) reports and dashboards for Signalen.
- signals-overview.sql: an overview of signals with the most important related fields
- signals-areas.sql: for all signals retrieve the matching areas for all area types
- signals-sla.sql: for all signals retrieve the deadline and deadline*3
- signals-feedback.sql: retrieve the number of feedback items (total, positive and negative) per category
- users-per-department.sql: retrieve the users per department