Search For - GROUP BY
Best seen via Google Chrome
NOT
Internet Exploiter...
TIP : Look at the navigation arrows in the bottom right . This will help you see when the down key is needed.
GOAL
To create a simple way of talking
about building visualisations
..thus..
making it easier to quantify and explain what we want to achieve among ourselves and to the client...
...thus...
Making it easier to quantify requirements.
Taking that further...
I think we need to put ourselves in the users position and consider what they are saying to themselves and how we can unify those things into a shared vocabulary.
e.g.
I want to see who is working on which current activities in our team
I want to see what activities are happening in 2013
I want to see which events are happening in Europe in August with representative A
INTRODUCING VISUAL recipeS
This is a self coined term
A [Data]Visual recipe in most basic terms
is summed up by this idea of
Search for <something>
+
Group By <a context>
=
Interactive Visual Output
<press down>
aN APPLIED real life example
Search for languages spoken in New York
and
Group by the location they are in the city itself
you would end up with...
Twitters NEW YORK LANGUAGE MAP
Our data (So far...)
- Activity title
- Objectives of said activities
- Dates
- Locations
- GSK Representative (Flu team for now)
- Key Opinion Leaders
Applying recipes to this project...
Search for [SF] and Group By [GB] shorthand applied in the following ideas
These are just our ideas in a few hours thinking time,
and a little chop-shop Photoshop....
TIP : Use your imagination... :)
[SF] Activities && [GB] Date = Timeline Visual
[SF] Activities && [GB] Date AND LOCATION = Timeline WITH MAP Visual
date+location is easy to imagine
What about
Group By
Activity Title
or
Objective of Activity
or
GSK Contact etc
CONSIDER this
Activity or Objective or GSK Contact
are...
Single Dimensional
They become useful when...
...you use two together you end up with something useful
[SF] Activities && [GB] GSK Reps = Bubble Chart
[SF] Activities && [GB] GSK Reps and time = Timeline Bubble
I hope you followed that...
Just a little more now to extend the usefulness...
Now add the concept of drilling down OR filtering into the data...
Filtering More
By extending the recipe a little
Search For
+
Group By
+
Filter Criteria
you can turn a visual complexity into a simple message.
Filter what?
The filters we apply will depend on the original data sets:
LOCATION FILTERS
Maps are easiest to explain first.
Data shown on a map can be filtered by :
- Continent
- Hemisphere
- Country
- City
- + Others
Date and Time Filters
The data in a timeline can be filtered by:
- From Date
- To Date
- By Season
- By Fiscal Quarter erc
GSK REPRESENTATIVE FILTERS
Turn on and off the team members.. remember this...
KOL Filters ( i didn't cover these)
Example Recipe using KOLS :
[SF] KOL and Activity && [GB] Location and Date
=
Map Visual with Activities linked KOLS shown
Filtering KOLS would be about changing :
- KOL Score range wanted e.g. >= 70
- Distance Limiting e.g. max 20km
- Country Limiting e.g. same country/language
Objectives and Activity Filters
Text objects at best but we could make it better by adding categories to them :
- By letter (A-Z)
- By Category (if we invent them)
- Show only count > X
- Show only count < Y
- Show top 5
- Show bottom 5
- etc
I propose you offer it in stages
- e.g. 3 Recipes with filtering by May
- Every 3 months offer another recipe with filters
Let them vote for recipes they would like to see.
Which Recipes will depend on the most important needs.
To solve this problem as a whole
Understand the most important recipes the client wants
Decide on the platforms they want to see the visuals on
Decide on the technology based on the platforms
Decide on the best medium to enter the data in a separate talk.
DISCUSS
or say...
