I intend to analyze data derived from the user behavior on Stack Overflow (i.e. the number of questions asked in the last five years, upvotes, number of users common to "Android" and "iOS" dev environments, etc.). I have to use the data retrieved to create models depicting the manner in which these two technologies have grown over time. It would really help me if someone (who has prior experience with deriving data from Stack Exchange) could give some inputs on this.
Here are some queries to get you started:
- The number of questions asked in the last five years
- number of users common to "Android" and "iOS" dev environments (415,220 at the time of posting)
More ready-made queries can be found in What SEDE examples would be most useful to new users?
The explanation of the schema can be found in Database schema documentation for the public data dump and SEDE and The Data Explorer as a FAQ for itself. The database is hosted in a SQL Server instance so you can use most of the T-SQL statements.
In this answer of mine you'll find an ERD model.