Brief
The client wanted to update their visuals created for the annual survey of diversity in literary magazines. Previously, they had been using PowerPoint, they wanted something that was more impactful, but still felt familiar to the audience.
Analysis
The analysis is in three parts:
- The articles in each magazine are analysed for the year by gender and type of article.
- These values are compared to previous years performance.
- For the magazines in the 'Main Count' section of the survey, there is an additional section providing demographic details as recorded through a survey.
Survey data can be complex to analyse, so a significant chunk of the time was spent putting it into the right structure in Excel.
Tools
Excel & Tableau.
Using Tableau parameter functionality was critical in this work, as we needed to create the same analysis for around 50 magazines. Parameters allow users to select the magazine of interest from a drop down list.
