Using publicly available data from the Berlin Senate, and with an healthy dose of webscrapping, i did a small visualization based on two factors :
- Entry Acceptance Rate of kids per school,
- non-German origin (“NDH”) of the kids per school.
The result is a sad reflection of the current situation.
As a sidenote, using Tableau is pretty straightforward when it comes to basic operations, but as soon as some advanced interactions are required, (e.g implement a dynamic filtering on several fields, or even worse, triggering a model computation), the amount of trickery becomes mindboggling, see for instance how to implement a basic Sankey Chart in Tableau.
An other shortcoming of Tableau is the lack of dynamic setting of data source. There is the Tableau Web Connector, but this only allows users to define the data source once at the creation of the dashboard.
You can find the related Source Code here.