MedStar May 25, 2016
Brittany Fong
Why?
Start with a question or multiple questions that you want to answer.
Is there a unique identifier?
What level of detail is the data at?
Do you need additional data/tables?
Pull out a pencil and paper to get the ideas flowing.
Executive - Quick glance summary
Manager - High level comparisons
Analyst - In depth discoveries
Use color to compare quarters but still have the ability to see over all changes over time
Change the color or size of data to highlight and guide your user through analysis
View percent changes between periods on a sorted bar graph to make comparisons over time and easily view top and bottom performers
View percent of total across periods to determine which items make up the biggest percentage of quantity sold
Give your users the flexibility to choose what they want to view
See the top N items in each product category