Interactive Crosstab Tool


I learned a few things about presentation of data as an analyst. One, it’s subjective – if something looks ugly, people call it a ‘data dump’. If you organize the exact same data in a nicer way, they love it. I saw a lot of shortcomings in the CSVs we delivered and thought that there has to be a better way to use technology to allow for stat testing, easy exploration for clients, and clean legibility + aesthetics (and I wanted to rely on good old Excel, no Tableau).

I can’t post due to excel for web limitations on macros, but here is my part-VBA-part-Photoshopped-part-Excel vision for a useful crosstab. I have taken the brand out of these survey results for this portfolio:

Coverpage:

Dashboard: