Iterate on renewables design from design studio

[mcharg]

@mcharg to do a bar chart with renewables vs non-renewables.

@jkwonatx to explore what we can do with disbursements data and production data.

@cthomasONRR will do research on whether we can convert production numbers to lightbulbs.

[mcharg]

This is what it looks like with a stacked bar chart with renewables vs. non-renewables. You can barely see the renewables.

[mcharg]

The percentages are mostly less than 1%, so they also wouldn't show up on a pie chart.

[mcharg]

Here's an option that shows the tiny slice for renewables along with a breakout of geothermal and wind within that slice.

[mcharg]

Spreadsheet with the numbers I used, in case anyone else wants to play with it. https://doimspp.sharepoint.com/:x:/r/sites/NRRD/Shared%20Documents/General/NRRD/Design/Renewables%20Fact%20Sheet/Sketches/RenewableRevenue.xlsx?d=w2ccb7ea61c10484f8fc2ac2a2b7187cc&csf=1&web=1&e=G7ndIv

[jkwonatx]

working on a Miro board to help organize ideas:

https://miro.com/welcomeonboard/aExlNUp4aEpMSENwaGJrQzJxaFN3UHhqVmFxTDZZbEVhOXAxY0RCempxeXlVSEcySGhHYUM0dlB3UlRqb3NyV3wzMDc0NDU3MzYxNDk2OTQ0ODI3?invite_link_id=821363958953

[jkwonatx]

update: 12/23 -- I think this exercise is going somewhere. I put this together based on what I remember, so the next step I want to take is to refer to the design studio presentation to fill in blanks and check for any misunderstanding on my part.

[cthomasONRR]

I talked with Maroya about converting production numbers to lightbulbs. She would like to keep our first draft to have existing data only. If Kimbra wants something else, we can then add this concept to it.

I did some initial research, and found some very rough estimates for powering homes for a year. This seemed be be a better comparison than lightbulbs, because we are dealing with such large production numbers.

I can take some of these general conversions and try to apply them to units other than Kilowatt hours, but for right now Maroya would like me to hold off and focus on other work.

[mcharg]

@jkwonatx Your mind map is a great way to visualize the problem.

[jkwonatx]

How we'd describe a successful fact sheet:

• Use data visualization we already have
• Summarizes our data on the renewables effectively

• Useful to the users *consider including a section for the content -- insightful, educational

  I'll keep them in mind as I work on the prototypes. I appreciate all the positive feedback on my little Miro board. Hope that was worth your while.

  I'll have a couple of prototypes by next week's interns meeting.

[cthomasONRR]

I saved the renewables disbursement data excel sheet here. I used the query data tool to create this excel, and it worked really well! Here are some image ideas. (All graphs are in the excel too.)

Geothermal 201-2021, and 2021 only: My concern with the 2021 geothermal data is that there are recipients with negative values, which we will have to take space on the infographic to explain.

Wind 2017-2021, and 2021 only: Wind disbursements are so dominated by U.S. Treasury that is doesn't make an interesting visual.

Combined Geothermal and Wind Disbursements, for 2021 only: Showing recipient details in the bar chart leads to the same issues mentioned above. Maybe the way to go is this simple pie graph just showing the grand total for both geothermal and wind.

@mcharg @Maroyafaied @jkwonatx Let me know what yall think! Maroya, I know you requested no new visuals, so maybe this will be waiting for second draft if Kimbra asks for us to include disbursements?

[Maroyafaied]

@cthomasONRR thanks for working on this, the negative numbers for Geothermal would raise questions and need to be explained. I still think we start with a prototype that doesn't involve new visuals and have the disbursement visuals in another prototype in case there's interest in it.

[cthomasONRR]

@Maroyafaied I agree. I think my last pie chart with just 2021 grand totals (no recipient breakdowns) is the way to go if we're asked to add disbursements.

[mcharg]

I agree, as well.

[mcharg]

We could also do a circle chart of the last option instead of a pie, if we want to use a chart style we already have.

[jkwonatx]

Jae's Board - Renewable Fact Sheet ver1.pdf

[jkwonatx]

Besides the data viz options that made to the draft above, I've also considered the following: revenue trends, year to year and renewable vs non-renewable.

On the trends, the dramatic uptick seen in 2019 made the graph look erroneous (I may have missed the specifics on this during our previous discussions). If not for the uptick, the graph would show a trend that seems constant, with not much change to show. Either way, without understanding what the graph means, I didn't feel it a good data to showcase.

On the latter, the renewables accounted for a paltry quarter of a percentage of the total revenue, which rendered the visual almost meaningless.

We'd already discussed both points at the design studio, just thought I'd reiterate here to let you know that I've explored the options again.

[jkwonatx]

Before the next interns meeting, I'll create a hi-fidelity sketch using Axure based on the feedback I received today at the interns meeting. Thank you all for your thoughts and feedback.

Jae's Board - Renewable Fact Sheet ver 2.pdf

[jkwonatx]

Axure version.

https://3tp68j.axshare.com

[mcharg]

@jkwonatx I added comments on the Axure prototype.

[jkwonatx]

Thank you! @mcharg I read the comments. I'll make changes this weekend.

[Maroyafaied]

@jkwonatx I need to look at this but I have a concern with showing disbursement if values are negative.

[Maroyafaied]

@jkwonatx this would be the FY21 disbursement data for Geothermal and Wind, I don't think we should display disbursement in this way because of the negative data. Another idea is to display disbursement by state for just Geothermal or we don't do any disbursement data and just extend the revenue section and include revenue type tables you have on the right. @mcharg @cthomasONRR thoughts?

[mcharg]

I like doing it by state. Is the line that's blank for state Indian?

[mcharg]

Or we could show that it's negative, so leadership can see it and realize why we don't want to show it.

[Maroyafaied]

@mcharg I'm not sure what the blank value is indicating but it looks like the negative disbursement funds are associated with it.

[mcharg]

@Maroyafaied I think it's all the disbursements to the federal government.

[cthomasONRR]

I think it's best to keep disbursement graphic as simple as possible. We will have a map for revenue and a ton data listed in tables for production. That's a ton of information. Maybe keeping disbursements simple will make the infographic more digestible? I feel like any way you try to subdivide disbursements, you run into issues with with negatives or blanks, and that leads to more questions than answers for the viewer.

Maybe this pie chart, converted to the circle graphics currently on the NRRD site (like Shannon initially suggested) is best:

[Maroyafaied]

@jkwonatx to summarize our discussion, we'll do 2 prototypes summarized below. Please don't hesitate to ask questions. Thanks

1st Prototype: Revenue - shows updated map with 9 locations with a table displaying top 4 and content in the bottom. Disbursement - circle chart with table. Production-same

2nd Prototype: Revenue - shows updated map with 9 locations with a table listing all 9 locations without content. Disbursements - no disbursements. Production-same

[cthomasONRR]

I'll have time first thing tomorrow morning to pull updated datasets. I will link to them here once I have them compiled. Thanks!

[cthomasONRR]

@Maroyafaied @mcharg @jkwonatx

I pulled the most updated data from NRRD. I compiled the revenue, disbursement, and production data in a spreadsheet here

Here is an updated screengrab of Revenue FY 21 for Renewables:

For revenue data, there is a bit of revenue in 'location not published' that won't appear on the map:

For disbursements, I had just CY 2021 previously. I had to manually get Fiscal Year 2021 because our FY datasets don't include commodity. I did this by getting CY 2020 and CY 2021 monthly data by commodity in Query Data, and manually making the dataset include months in FY 21 only. Here are the true FY 21 Disbursement by commodity:

For production, we only have FY 2020 right now. Here are those updated numbers: On Query Data with the trendline:

[cthomasONRR]

Also, I did a "circle packing" image for disbursements using https://app.rawgraphs.io/

[jkwonatx]

Options A and B @mcharg @cthomasONRR @Maroyafaied

https://bxuqc4.axshare.com

[mcharg]

@jkwonatx These look good. Can you put them on separate pages in the prototype without the comments, so we have them clean to review with leadership?

[Maroyafaied]

@jkwonatx looks good, I put a couple of comments. Thanks

[cthomasONRR]

@jkwonatx @Maroyafaied @mcharg I added in some comments to the wireframe. It looks great! I just had some minor nit-picky things about the data. Let me know if anyone has any questions. Thanks!

[jkwonatx]

@cthomasONRR @Maroyafaied @mcharg I've made the update to the Renewables. Please note that there are two pages to review now.

https://n1ugvx.axshare.com

[jkwonatx]

Version 6; made changes to Option A based on Christine's feedback.

https://mtm1pz.axshare.com

[cthomasONRR]

Updated Disbursements FY 21 data. I found a better way to pull this data. This is WAY more accurate than what I did previously. Apologies- I'm still new to Query data and should not have used it for this. We can add a blurb about disbursements going to the U.S. Treasury and State & Local Governments.

@jkwonatx Don't worry about updating this for the prototype tomorrow. We will emphasize that the data isn't finalized.

[jkwonatx]

https://zw7izs.axshare.com

@mcharg @Maroyafaied I've made the update to Option A as we've discussed yesterday

@cthomasONRR if you have a moment, could you check the disbursements copy ("Total disbursements from all commodities for FY 2021 were $8,776,260,163. Geothermal and wind make up 0.24% of the total.") for accuracy? Feel free to comment either here or on the Axure Cloud, whichever is convenient for you. Thank you!

[cthomasONRR]

@jkwonatx With my updated numbers, Geothermal and wind make up 0.26% of the total. Your total in the blurb is correct. The image I have in the comment above are the better disbursement values to use for geothermal and wind. The changes are minor, so don't worry about updating the numbers for today. We can reiterate to them that the numbers aren't finalized. Thanks so much for all your work on this!!!

[Maroyafaied]

@jkwonatx It looks great, I also ran the numbers and got the same as @cthomasONRR but I agree don't worry about making updates.

[Maroyafaied]

The leadership team went with Option A and asked to include trend line for disbursements and add content comparing year over year. I will close this issue and create another to proceed working on this.