Power BI Challenge 17 - Environmental Data Reporting from Tim

Here’s Tim’s entry for Power BI Challenge 17. @tweinzapfel, feel free to add other details of your work.

image

image

image

image

image

image

image

image

Here’s how Tim described it:

Some Key Report Features:

  1. Even though each indicator is separate and not related to each other, the overall summary page can be filtered to specific states which then filter through all indicators on this page.
  2. Most pages include smart narratives to provide some key callouts to various topcs
  3. For the Precipitation analysis, there is a button to toggle between various rainfall trend charts. This was done to provide additional information without forcing the user to go to separate pages. Another key point here is that my analysis looks mostly at the percentage of rainy days versus the actual count. Because the data did not track rain amounts with a consistent number of days per year, I felt that this was a better comparison.
  4. For the Air Toxins analysis, I wanted to provide the user with the ability to toggle between looking at the data from a State perspective (which would look at trends for all toxins in the respective states) or from a Toxin perspective (which would look at trends across the various states). Buttons were added which would toggle the visuals between these two comparison approaches.

Lastly – some special credits for resources used in the development:

  • Icons used through were obtained from https://www.iconsdb.com/white-icons/
  • Idea for the cards used in the Air Toxics section was taken from Havens Consulting (https://www.havensconsulting.net/) using both a standard Card visual along with the custom visual Sparkline by OKViz
  • Radar Chart used on Air Toxics page done through the custom visual Radar Chart 2.0.2

To learn about the real-life scenario presented for the challenge, be sure to click on the image below.

image

This post is part of the Enterprise DNA platform improvements. Through these posts, members and non-members can showcase the resources and inspirations on how they come up with their challenge submissions. We hope all members can utilize it efficiently.

super impressive dashboard here. really love so many little features you’ve added.

really love the special cards that you’ve developed with sparklines. I reckon this is a super compelling visualization particularly trying to show variances in trends.

I think you’re really covered the entire brief here effectively and the user can simply navigate down to a very specific piece of analysis that they might want to review. It seems very intuitive and simple for the user.

I think the nice navigation you’ve got on the left hand side as well really is easy on the eye. Some effective icons and the change in color is really neat when someone clicks on a different page. so simple and effective.

and also the way you’ve used grids to layout your insights also has made a big difference to the way this report is viewed.

overall I’m super impressed by what you’ve created here and it completely covers the task that we were given for the challenge. at the base submissions for sure.