I’ve been playing around with making advanced reporting and analysis possible using SQL, right in monday. It’s mostly been a pet project thus far, but it has potential for enterprises that employ business analysts, or if you’re tech-savvy.
SQL would enable you to query almost any insight from monday boards:
- Create complex reports beyond the built-in filters and formulas
- Perform historical trend analyses
- Combine data across multiple boards, teams, and departments
- Custom roll-ups across multiple groups using sum, average, min, max, count, histograms, quantiles, percentiles, median, mode, standard deviation, the list goes on.
The data could be viewed in board view, dashboard, used for charts, or be written to an actual board. Had my fun thus far, would take it further if people are keen. What do you need this for?