AEA365 | A Tip-a-Day by and for Evaluators

Jun/14

24

DVR TIG Week: Rakesh Mohan, Lance McCleve, Tony Grange, Bryon Welch, and Margaret Campbell on Sankey Diagrams: A Cool Tool for Explaining the Complex Flow of Resources in Large Organizations

We are Rakesh Mohan, Lance McCleve, Tony Grange, Bryon Welch, and Margaret Campbell of the Office of Performance Evaluations, an independent agency of the Idaho State Legislature.

Last year, the Legislature asked us to explain how funds move through the Department of Health and Welfare—the agency with the state’s largest budget. Legislators, including budget committee members, had difficulty understanding the department’s financial information. Given agency complexities and its sheer number of financial transactions (over two million in 2013), no one in recent history had brought together the separate parts of its financial records to explain how the parts function.

Communicating the flow of dollars was the trickiest piece of the study. We considered narratives, tables, and traditional flowcharts. Ultimately, we used Sankey diagrams that helped stakeholders visualize funds moving through the department making them the most useful features of our report.

One diagram shows how dollars flow through a program over a year.

Mohan 1

The second diagram illustrates funds flowing into, out of, and within a program.

Mohan 2

Sankey diagrams depict resources within a system by mapping their flow from an initial set of values to a final set of values. They were especially useful because the lines have widths proportional to their value throughout the system. Legislators could easily see the proportion of each fund throughout the flow. Initially we tried to create the diagrams in Visio, but manually sizing each line was extremely laborious.

Department officials were surprised how clearly our report presented complex aspects of their fund management. They are now using our report for in-house training. They also had us train them on creating Sankey diagrams for future reporting. The feedback from three key stakeholders further illustrates the usefulness of Sankey:

 

“This…really, really was a fine body of work.”

Representative Maxine Bell, Cochair, Joint Finance-Appropriations Committee

 

“The study does much to further enhance the transparency and understandability of the largest budget in state government.”

State Controller Brandon Woolf

 

“[The report] will provide valuable assistance for future planning.”

Governor Butch Otter

Hot Tips:

  1. We used 11×17 paper so the diagram would be big enough to show detail and keep the same orientation as the text.
  2. Subtle colors within similar families were more effective than contrasting colors. We also made colors transparent to clarify intersecting lines.
  3. We wanted to edit text during publishing, so we imported the diagram as an image and added text within the publishing software.

Rad Resources:

  1. We purchased e!sankey, which comes in two versions. The pro version allowed us to link to data in Excel.
  2. Google Charts Sankey
  3. Sankey Diagram History

The American Evaluation Association is celebrating Data Visualization and Reporting (DVR) Week with our colleagues in the DVR Topical Interest Group. The contributions all this week to aea365 come from DVR TIG members. Do you have questions, concerns, kudos, or content to extend this aea365 contribution? Please add them in the comments section for this post on the aea365 webpage so that we may enrich our community of practice. Would you like to submit an aea365 Tip? Please send a note of interest to aea365@eval.org. aea365 is sponsored by the American Evaluation Association and provides a Tip-a-Day by and for evaluators.

4 comments

  • Ann K. Emery · July 15, 2014 at 9:13 am

    Rakesh, Lance, Tony, Bryon, and Margaret — great work!

    Reply

    • Rakesh Mohan · September 1, 2014 at 7:09 pm

      Thank you much, Ann. Sorry for the late acknowledgement.

      Reply

  • Why Are Evaluators So Tentative about the Advocacy Aspect of Our Profession? (Guest Post by Rakesh Mohan) | Evaluspheric Perceptions · July 8, 2014 at 8:06 am

    […] I’ve recently had the pleasure of meeting an evaluator whose work I’ve followed, and I invited him to write for Evaluspheric Perceptions. Rakesh Mohan has been a regular on EvalTalk, and I’ve admired him for putting his work out there and asking for feedback. In early 2014, his office released a report, Confinement of Juvenile Offenders, and I found myself curious enough to read it. Quite honestly, it wasn’t the topic that interested me, but rather, it was the idea of reading a governmental evaluation report produced by someone who is a great fan of and frequent presenter at the American Evaluation Association. Needless to say, the report impressed me to no end. Rakesh put into place nearly every principle of good evaluation reporting and data visualization that I have been learning and studying myself. I’m not the only one impressed by the work coming out of his office. In 2011, they received AEA’s Alva and Gunnar Myrdal Government Evaluation Award. Recent posts on two of my favorite blogs highlight the work of his office as well. One can be found at Better Evaluation – Week 15: Fitting reporting methods to evaluation findings – and audiences and the other at AEA365 – Sankey diagrams: A cool tool for explaining the complex flow of resources in large organizations. […]

    Reply

    • Rakesh Mohan · September 1, 2014 at 7:11 pm

      Thank you much, Sheila. Sorry for the late acknowledgement.

      Reply

Leave a Reply

<<

>>

Archives

To top