Graphics Reference
In-Depth Information
"),""),IF(AT4,CONCATENATE(AT$1," "),""),IF(AU4,
CONCATENATE(AU$1," "),""))
Copy the calculated symbol cells and use Paste Values to insert them into
the Topic Symbols column you created earlier. Save the results, and export
them in GraphML form.
ImporttheenhancedgraphdataintoGephi,andmapthecolortosentiment.
Use a neutral color such as gray for neutral sentiment. Black is a natural
choice for negative and will work well with any color you choose for positive.
Click the expander at the bottom of the graph view. On the Labels tab, turn
on node labels and switch their mapping from the Label data column to the
newTopicSymbolscolumn.IntheRankingtab,mapthelabelsizetodegree.
In the Preview task mode, set the node outlines to zero width so they don't
interfere visually with the labels. Choose a condensed font for the labels.
Make them white and give them a thick outline of 8.0. Select the label
outline color option, which inherits the parent node color. Reduce the edge
opacity to a minimal number like 8.0 percent and refresh the view.
As you might expect, the fans in the middle of the graph who comment most
often also talk about more of the players. Also notice that in the very tight
clusters, the same symbols tend to repeat. They are relatively consistent in
topic. The dominance of red across the graph indicates that the mood is
more positive than negative, with a strong nucleus of positive sentiment
around the most active fans. Interestingly, with the exception of some of the
peripheralbanterinvolvingDrake,mostofthenegativesentimentinblackis
inthecenterofthefancommunity.Lookingclosely,however,youwillnotice
that black is very often surrounded by red, implying heated exchanges.
Symbols and color together make for a powerful combination. This is the
picture of social media buzz that this chapter's case study set out to see.
Not only are patterns revealed, but enough individual character is expressed
that you can spot community conversations that would be interesting to
investigate further. What are those seemingly heated comments to the east
about Drake about, or those clusters of red and black that did not mention
the players or Drake?
Graph visualization and interactive exploration of social media topics and
sentiment enables you to take the overall pulse of customer communities,
and identify heated discussion around products and initiatives that are
