May 7-9, 2014 – SQLPASS – San Jose – Social media network maps in Excel with NodeXL

10MarMay 7, 2015 By Marc Smith

I will present a talk at the 2014 SQL PASS Business Analytics Conference in San Jose on May 8th.

The talk will focus on free and open tools for creating network maps and reports that can illuminate the landscape of social media.

The graph represents a network of 633 Twitter users whose tweets in the requested date range contained “sqlpass”, or who were replied to or mentioned in those tweets. The tweets in the network were tweeted over the 15-day, 2-hour, 48-minute period from Tuesday, 25 February 2014 at 00:26 UTC to Wednesday, 12 March 2014 at 03:15 UTC.

There is an edge for each “replies-to” relationship in a tweet, an edge for each “mentions” relationship in a tweet, and a self-loop edge for each tweet that is not a “replies-to” or “mentions”.

The graph’s vertices were grouped by cluster using the Clauset-Newman-Moore cluster algorithm. The graph was laid out using the Harel-Koren Fast Multiscale layout algorithm.

The edge colors are based on edge weight values. The edge widths are based on edge weight values. The edge opacities are based on edge weight values. The vertex sizes are based on followers values. The vertex opacities are based on followers values.

Top 10 Vertices, Ranked by Betweenness Centrality:
@sqlpass
@laertesqldba
@nikoneugebauer
@karlakay22
@jenstirrup
@retracement
@grrl_geek
@sqlrockstar
@markvsql
@sqlservermag

Top URLs in Tweet in Entire Graph:
http://www.sqlpass.org/ss2014launch/Webinars.aspx
http://www.sqlpass.org/summit/2014/Speakers/CallForSpeakers.aspx
http://sqlsaturday.com/287/schedule.aspx
http://bi.sqlpass.org/
https://attendee.gotowebinar.com/register/5759204879042322946
https://attendee.gotowebinar.com/register/2383471085904007682
http://paper.li/PASSAppDev/1391708680
https://attendee.gotowebinar.com/register/3165768110532010497
https://attendee.gotowebinar.com/register/2196441958679840002
http://www.linkedin.com/slink?code=bNfBsHy

Top Hashtags in Tweet in Entire Graph:
#sqlpass
#sqlserver
#sql
#sqlsatexeter
#sqlpass_de
#sqlsaturday
#sqlsatvienna
#sqlsatportugal
#msbi
#sqlsatmadison

Upcoming talks: NodeXL and Social Media in San Francisco, Indiana, Chicago, San Diego and Kentucky

08MarMay 7, 2015 By Marc Smith

Here is a round up of the social media network analysis talks, workshops, and training events I will be doing in the coming months:

	June 3-7, 2013 Social Media Network Analysis Workshop at LINKS2013 University of Kentucky
	May 20-24, 2013 International Symposium on Collaboration, Social Computing, New Media & Networks (SoMNet) San Diego, CA.
	April 15th, 2013 Predictive Analytics World, Mapping Social Media to Predict Influence and Measure Propagation San Francisco, CA.
	April 12, 2013 PASS Business Analytics Conference: Mapping social media with NodeXL Chicago, IL.
	April 8 and 9, 2013 NSF workshop: Kredible.Net – Study reputation and social roles on social mediaPurdue University
	March 26, 2013 OCTribe – San Francisco Online Community Meetup – Mapping Social Media with NodeXL San Francisco, CA

April 12, 2013 PASS Business Analytics Conference: Mapping social media with NodeXL

06MarMay 7, 2015 By Marc Smith

I will speak at the 2013 PASS Business Analytics Conference in Chicago on April 12, 2013. The event focuses on data discovery, data exploration and visualization, predictive analytics, content management and architecture, collaboration, information strategies, and more. I will speak about social media Data Analytics and Visualization in a presentation titled: Charting Collections of Social Media Connections with NodeXL.

This is a sample NodeXL graph that represents a network of 106 Twitter users whose recent tweets contained “passbac”. The network was obtained on Wednesday, 30 January 2013 at 01:09 UTC. There is an edge for each follows relationship. There is an edge for each “replies-to” relationship in a tweet. There is an edge for each “mentions” relationship in a tweet. There is a self-loop edge for each tweet that is not a “replies-to” or “mentions”. The tweets were made over the 7-day, 5-hour, 32-minute period from Tuesday, 22 January 2013 at 17:40 UTC to Tuesday, 29 January 2013 at 23:12 UTC.

Learn to make your own network maps of social media at PASSBAC 2013!

Your Cart