Power BI Top 10 Best Report Contest

February 3rd 2016

***Please vote for my entry here: What's in a Name?***

I was recently honoured with a top 10 placement in Microsoft's Best Power BI Report contest. Scroll down to see the actual report.

The contest featured many high-quality entries. You can see the full top 10 here, as well as vote for your favourite: Best Report Contest.

My report takes data from the Social Security Administration (USA) and the Office of National Statistics (UK) and compares them. I identify which names are predominately British (vs. American), which names have been poached from one country by the other, which names are unisex, which names are predominately male in one country and female in the other, and my favourite tab, which is name fashions by decade (both names that were fashionable, and names that were unfashionable).

Each tab of my report can be filtered by the first letter (if you want to find a particular name or are trying to choose a baby name with a particular letter). The bar charts that list names also have a tiny, invisible scroll bar to the right of the bar (between the end of the bar and the border of the box), so with a little trial & error you can scroll through all the names.

For example, did you know that Adele has been rising in popularity in the USA since 2008, but not the UK? Did you know that names like Charlotte and Gemma are more popular in the USA than the UK? Did you know that Miley was a fashionable name in the late 2000s, but has since become unfashionable? Did you know that Thelma was the name to have for girls born in the 1880s and 1890s?

As you can tell, I'm excited about my data. It's incredibly interesting. But unfortunately, I have the dubious honour of having the worst-looking top 10 best report. I built my report for a full wide-screen monitor, so on smaller scales it doesn't look all that great at all. A great reminder, if nothing else, that large font sizes are important in reports as much as in presentations.

For these reasons, I've made a few modifications to the report embedded below to make it clearer and easier to use. The report below is not identical to my competition entry. (I'm not trying to cheat...I just want to give the data justice for those who are interested in exploring).

The ability to embed my report on my website is thanks to Microsoft releasing the feature earlier today. This is one of the most exciting Power BI features so far (and that's saying a lot!). For more information, see Announcing Power BI "publish to web" preview (Microsoft Power BI Blog".

Prior to February 14, 2016, please, do consider registering for the Power BI website, and placing a vote for my entry. You can vote for it here: What's in a Name?. You may have to register for the Power BI community website first. Thank you in advance!

Finally, if you want to learn how to build reports like this for yourself, you can register for my Mastering Power BI pre-con at SQL Saturday Madison in April 2016.

My report is below. Note that there are multiple tabs that you can click between at the bottom (if you're looking at it and wondering "where's the data?").

Go back...

Visitor Comments

Post Your Own Comment

Note that comments may not appear immediately on this site.

Commenting is not available in this channel entry.