Creating a Quality Dashboard from Raw data

Thank you for providing the sample data - that is very helpful. 

It looks like your "Question" column may need some refinement, especially for the BEHAVIORS section. From what I understand each main question (like "Take Ownership") is then divided into a positive and negative path.

There is a (0.00) note behind each question.  Is that where the weight would be?  Or should all these items be treated equally? Is "quality" the ratio of "Effectively or Exceptionally Demonstrated" to the overall count?

Ultimately - what behavior are you trying to drive with the report?  Identify and reduce the negative answers? Or only the top issues?

Side note: There is a data quality issue for "Build a Personal Connection" - the main question has tagged 20 calls but the sub-questions have tagged 21.  The label for MIE is inconsistent too. Not a big issue but data quality assurance should be part of your process. 

See attached for a first stab at a quality chart.