Forum Discussion
Creating a Quality Dashboard from Raw data
Super UserPlease provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to work with. Please show the expected outcome.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
I have attatched a link to an example of the raw data we get from the system.
I'm looking to build a similar report to the above and from there create dashboards to facilitate summaries and visuals to Operations
- lbendlin
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.
great!!, thank you for your assistance, do you know would I be able to drill the data to percentages by Agent?
- lbendlin
yes, try it out. The measure is written in a way that should allow all kinds of drill downs.