Connected Action
Menu
  • Services
    • Buy a social media network map and report
    • Training
    • Conferences
    • Data Reporting
    • Log in or Join us
    • Customize NodeXL
    • NodeXL
    • Marc Smith
    • About Us
  • Buy maps
    • Twitter Search Network Map and Report
    • Graph Server Twitter Search Network Map and Report
    • Other products and services
  • Sample maps
  • Blog
    • Books
    • NodeXL
    • Events
  • Newsletter
  • Videos
  • Contact
  • Log In

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

10MarMay 7, 2015 By Marc Smith

2014-PASSBAC_San_Jose_Banner

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

2014-SQL PASS_logo

This entry was posted in 2014, All posts, Conference, Connected Action, Data Mining, Foundation, Industry, Measuring social media, Metrics, NodeXL, Presentation, SMRF, SNA, Social Interaction, Social Media, Social Media Research Foundation, Social network, Social Network Analysis, Sociology, Talk, Talks, Training, Visualization, Workshop and tagged 2014, Analysis, Conference, Lecture, Marc Smith, NodeXL, PASSBAC, San Jose, SNA, social, Social network, SQL, SQLPASS, Talk. Bookmark the permalink.

Post navigation

May 1-2, 2014 Talk at Social Media & Web Analytics Summit in San Francisco
May 19-23, 2014: International Conference on Collaboration Technologies and Systems, Minneapolis, Minnesota

Connected Action Services

  • Buy a social media network map
  • Log in or Join us
  • My Cart
  • Training
  • Conferences
  • Data Reporting
  • Customize NodeXL
  • Marc Smith
  • About Us

Subscribe to Connected Action

Get updates when there is new content from Connected Action.

Related content:

Twitter Facebookflickrlinkedin
slidesharedeliciousdeliciousVimeo


Social Media Research Foundation

Help support the Social Media Research Foundation

Book: Analyzing Social Media Networks with NodeXL: Insights from a connected world

The book Analyzing Social Media Networks with NodeXL: Insights from a connected world is now available from Morgan-Kaufman and Amazon.

Communities in Cyberspace

Communities in Cyberspace

Recent Posts

  • Buy a map
  • Book: Transparency in Social Media Edited by Sorin Matei, Martha Russell and Elisa Bertino – with a chapter on NodeXL
  • June 5, 2015: Personal Democracy Forum – Talk on taking pictures of virtual crowds
  • Trust issues and Excel: how to open other people’s NodeXL documents
  • May 1st, 2015 at LSU: NodeXL social media networks talk at the “Telling Stories and Using Visuals for Coastal Environmental Communication” workshop

Tags

2009 2010 2011 2013 2014 2015 Analysis Analytics April Chart Conference Data Event Excel graph June Lecture Map March Marc Smith May Media network NodeXL October Paper Presentation Research San Francisco SMRF SMRFoundation SNA social Social Media socialmedia Social Media Research Foundation Social network Sociology Talk Training Twitter University Video Visualization workshop

Categories

Archives

March 2023
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
2728293031  
« Jul    

Transparency in Social Media

2015-07-30-Transparency in Social Media-Structures of Twitter Crowds and COnversations
Transparency in Social Media
Sorin Adam Matei, Martha G. Russell, Elisa Bertino

CÓMO ENCONTRAR LOS HASHTAGS MÁS POTENTES: Para convertir LEADS a VENTAS (SEOHashtag nº 1) (Spanish Edition)

Apply NodeXL in espanol!

CÓMO ENCONTRAR LOS HASHTAGS MÁS POTENTES - Para convertir LEADS a VENTAS (SEOHashtag nº 1) (Spanish Edition)
By: Vivian Francos from #SEOHashtag Comparto algunas de las mejores formas de elegir los hashtags más poderosos y
que puedan generar tráfico a tus redes sociales para aprovechar el poder del
hashtag.
Si quieres aumentar tus interacciones, debes aprender a utilizar los hashtags como herramienta.

https://amzn.to/305Hpsv

Networked


Networked By Lee Rainie and Barry Wellman

Social Media in the Public Sector

2015-07-31Social Media in the Public Sector-Cover
Ines Mergel

Ways of Knowing in HCI

2014-Ways of Knowing in HCI - Olson and Kellogg

The Virtual Community


Virtual Community

The Evolution of Cooperation


The Evolution of Cooperation

Governing the Commons


Governing the Commons

SmartMobs


SmartMobs

Networks, Crowds, and Markets


Networks, Crowds, and Markets

Development of Social Network Analysis


Development of Social Network Analysis: A Study in the Sociology of Science

Search

Services

  • Buy a social media network map
  • Log in or Join us
  • My Cart
  • Training
  • Conferences
  • Data Reporting
  • Customize NodeXL
  • Marc Smith
  • About Us
© 2023 Connected Action
AccessPress Parallax by AccessPress Themes
0

Your Cart