02-06-2020 06:28 AM
Getting access to the data that matters to you, when you need it, can be of the upmost importance. There can be information that is too crucial to not have on-the-fly access. Power BI gives you the capability of retrieving mission critical information, at your finger-tips, with DirectQuery.
My goal is to demonstrate the Power within Power BI via:
I had the desire to make a non-parameter driven report, unlike my previous creation, which was built on pushing dynamic parameters to new heights.
Thus, the idea of building an interactive report inspired by modest infographics appealed to me. I leveraged KPIs and iconography to present all up trending for new book additions and book activity. The design is crafted by five primary genres, Fiction, Other, Fantasy, Nonfiction, Media and their respective subgenres.
Selecting the Data
The City of Seattle’s Open Data Program offers a wide range of interesting datasets. I decided to leverage the Checkouts by Title, which consists checkouts by title for all physical and digital items from 2005 to present. So, the raw data set is rather hefty with more than 25 million rows of data.
Some Issues I encountered:
Here are some advanced capabilities within Power BI and SQL Server that I utilized:
Interesting Findings and Other Thoughts
A great dashboard leads to interesting discoveries within the data. As a an avid reader I found facts that stood out to me, as well as some technical musings.
What does readership look like for your favorite author?
I can't say for sure but I have achieved a similar outcome by using the Sparkline custom visual available in the store. You can overlay this onto other visuals or it can stand up on it's own.