06-16-2018 13:48 PM
This report highlights the books featured on the New York Times (NYT) Bestsellers List between 1942 and 2017 with a particular focus on the books which have been featured as #1.
The intended audience for this report are book fans/readers of the NYT Bestsellers List looking to explore titles they might like to read next, or literature journalists reporting on the history of, and featured books on, the NYT Bestsellers list.
The contents below highlight the key questions each report page answers in the story it tells. In addition this report showcases some key functionality which can be achieved in Power BI reports including expandable/collapsable panes on each page (one for filters and one for page navigation), and a number of Custom Visuals (e.g. Pulse Chart, Enlighten Data Storyteller, Narratives for PBI, Strippet Browser, Timeline Storyteller).
The design for the report is based on the Power BI Gartner Bake Off Example developed by the PBI Product team. The data sources for the report include an API from the NYT Booksellers Site, Google Books data and the dataset behind a Tableau report on the same topic developed by Katie Smith.
Key Questions answered by the report:
Which books have been most successful in (with the longest number of consecutive weeks at #1) through the history of the NYT Bestsellers List (Overall/by Genre)?
Which Genres have the highest number of distinct successful authors (Who have had #1 books)? Who are the authors that have had #1 Books in each Genre?
Which Genres have had the highest number of books at #1 (overall/for a given period)? What are these #1 books and who are the authors of them?
Which genre has the highest number of ‘one-hit wonders’ (books that have only appeared on the NYT bestsellers once) overall or over a given period? What are these books and who are the authors of them?
What is the gender diversity across #1 Bestselling book authors? Has there been a marked change in this diversity mix over the history of the NYT list or over the past few years in particular?
For a given Genre:
Latest Year Analysis
We hope you enjoy the report and we welcome any questions you might have about it
Rishi & Alex
Nice report guys. I like the way you have included the contents page, which shows how you break down a question/requirement.
I remember seeing this approach last year with the Hawaii report and think it is a really good approach to developing a report.