NEWS FLASH: After 6-8 weeks of waiting, you can now write queries for beta sites using the data explorer
The data explorer uses TSQL which seems to be similar to regular SQL with a few variations. You can browse existing queries and yoink stuff from them as well.
For instance, taking this query from Jon Ericsson, I created a version for The Workplace. I am horrible at SQL though, as I am not a programmer.
But I'm sure some of you are! Let's try to identify things that we as a community want to look at, such as:
- Are close votes increasing or decreasing?
- Is our ratio of up/downvotes increasing or decreasing?
- Are we getting more one-off questions, or are there regular users?
- Are questions after a popular question of higher or lower quality?
If you create a query, just link it here, and we can all take a look at it and collaborate on it, and we can track the data we get from it.