09-14-2019 15:34 PM
This report analyses the popularity of baby names in the UK from 1904 to 2017. The data source is a simple file of names and associated rank in each year for both boys and girls names, from the Office of National statistics- see statistical bulletin here.
The audience for this report is assumed to be manufacturers of personalised baby name products who need to ensure that they keep up with baby name trends in order to ensure continued sales. In order to illustrate this point, I have created and incorporated some dummy sales data for this ficticious company.
The analysis is split into multiple areas:
- Key Trends: For a comparison of any two years in that range (as per the date slider at the top), this shows the names which were most popular in the first year selected vs those in the last year selected. The most popular names in each year are charted over time to see if those names have held/gained/lost popularity over time. The bottom part of the page focuses specifically on those names which have had the largest decline and largest growh over the period, visualised as slope charts (inspired by the ONS bulletin!).
- Baby Names Comparison: This allows the user to select a series of specific names (Rather than just seeing those which were most/least popular in a particular year or over time), and see the change in rank for these names. It uses the OKViz Smart Filter custom visual from SQL BI and the Animated Bar Chart race
-Sales Data: This attempts to answer the 'So what' of the data visualisation, looking at the correlation of sales for particular personalised products (dummy data) and the popularity of that name for each year.
In addition there are a number of pages which are hidden from the report though are used in bookmarks - they contain select charts from other pages (With particular names highlighted) and annotations, and are meant to represent the distilled message presented to senior audiences which has traditionally been done in PowerPoint.
This report was highlighted as part of a presentation on Storytelling With Data which I presented at the Power Platform World Tour London in August 2019. To view a recording of this session see below/here