"How to discover your data in a fast dynamic way?"
When starting a new project the first thing I want to do is get a feel for the data. Preferably in a fast and dynamic way. You can use the "Advanced Data Discovery module" to tackle this problem. The Advanced Data Discovery module consists out of 4 dynamic list boxes and a dynamic table which comes in handy when modeling a project, checking data quality, testing the interaction between fields or exploring your data.
Advanced Data Discovery sheet overview
Dynamic list box with field statistics
Useful to check interaction between fields while creating your data model
Dynamic Data Discovery
Field statistics based on current selections or based on the complete set
Fast data quality checks
Dynamic list box
A script reload is required
PS: Special thanks to the creator of the first version of the dynamic list box from who I could not trace back the blog post I encountered 3 years ago.