#SQLSatOregon, Twitter, 10/24/2020 4:39:27 PM, 238661


FAQ | Problem?

#SQLSatOregon_2020-10-24_09-33-04.xlsx
#SQLSatOregon_2020-10-24_09-33-04.xlsx
From:
Connected Action NodeXL-Reports
Uploaded on:
October 24, 2020
Short Description:
#SQLSatOregon via NodeXL https://bit.ly/37F5k6C
@michaeldwall1
@mssqlgirl
@sqlpass
@sqlallfather
@sqlatspeed
@sqlworldwide
@sql_handle
@dbanuggets
@paul_turley
@sqldbawithbeard

Top hashtags:
#sqlsatoregon
#sqlserver
#powerbi
#sqlsat1000
#sqlpass
#powershell
#azure

Description:
Description
The graph represents a network of 95 Twitter users whose recent tweets contained "#SQLSatOregon", or who were replied to or mentioned in those tweets, taken from a data set limited to a maximum of 18,000 tweets. The network was obtained from Twitter on Saturday, 24 October 2020 at 16:33 UTC.

The tweets in the network were tweeted over the 8-day, 7-hour, 9-minute period from Friday, 16 October 2020 at 09:14 UTC to Saturday, 24 October 2020 at 16:23 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 is directed.

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.


Author Description


Overall Graph Metrics
Vertices : 95
Unique Edges : 176
Edges With Duplicates : 54
Total Edges : 230
Number of Edge Types : 5
Tweet : 33
Mentions : 63
Replies to : 13
Retweet : 67
MentionsInRetweet : 54
Self-Loops : 33
Reciprocated Vertex Pair Ratio : 0.150326797385621
Reciprocated Edge Ratio : 0.261363636363636
Connected Components : 5
Single-Vertex Connected Components : 4
Maximum Vertices in a Connected Component : 91
Maximum Edges in a Connected Component : 225
Maximum Geodesic Distance (Diameter) : 6
Average Geodesic Distance : 2.543633
Graph Density : 0.0197088465845465
Modularity : 0.442198
NodeXL Version : 1.0.1.441
Data Import : The graph represents a network of 95 Twitter users whose recent tweets contained "#SQLSatOregon", or who were replied to or mentioned in those tweets, taken from a data set limited to a maximum of 18,000 tweets. The network was obtained from Twitter on Saturday, 24 October 2020 at 16:33 UTC.

The tweets in the network were tweeted over the 8-day, 7-hour, 9-minute period from Friday, 16 October 2020 at 09:14 UTC to Saturday, 24 October 2020 at 16:23 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".

Layout Algorithm : The graph was laid out using the Harel-Koren Fast Multiscale layout algorithm.
Graph Source : TwitterSearch
Graph Term : #SQLSatOregon
Groups : The graph's vertices were grouped by cluster using the Clauset-Newman-Moore cluster algorithm.
Edge Color : Edge Weight
Edge Width : Edge Weight
Edge Alpha : Edge Weight
Vertex Radius : Betweenness Centrality

Top Influencers: Top 10 Vertices, Ranked by Betweenness Centrality
Top URLs
Top URLs in Tweet in Entire Graph:
[52] https://www.sqlsaturday.com/1000/Register-Now
[8] https://www.sqlsaturday.com/1000
[7] https://twitter.com/sqlpass/status/1319680271520845829
[3] https://www.sqlsaturday.com/1000/
[2] https://twitter.com/paul_turley/status/1319998782033981440
[2] https://twitter.com/paul_turley/status/1317520546892935169
[2] https://www.sqlsaturday.com/1000/Sessions/Details/sid/107610
[2] https://twitter.com/GuyInACube/status/1319654819779334144
[2] https://twitter.com/SQLAllFather/status/1319657333912301569
[2] https://twitter.com/YatesSQL/status/1319639797296779267

Top URLs in Tweet in G1:
[37] https://www.sqlsaturday.com/1000/Register-Now
[1] https://twitter.com/SQLAllFather/status/1319657333912301569
[1] https://www.sqlsaturday.com/1000/Sessions/Schedule
[1] https://twitter.com/paul_turley/status/1317520546892935169
[1] https://twitter.com/YatesSQL/status/1319639797296779267
[1] https://www.sqlsaturday.com/1000/Sessions/Details/sid/107610
[1] https://twitter.com/DBAKevlar/status/1319766442636554241
[1] https://twitter.com/michaeldwall1/status/1319765814484951040

Top URLs in Tweet in G2:
[7] https://www.sqlsaturday.com/1000
[5] https://www.sqlsaturday.com/1000/Register-Now
[1] https://twitter.com/paul_turley/status/1317520546892935169
[1] https://www.sqlsaturday.com/1000/Sessions/Details/sid/107610

Top URLs in Tweet in G3:
[6] https://www.sqlsaturday.com/1000/Register-Now
[3] https://www.sqlsaturday.com/1000/
[1] https://attendee.gotowebinar.com/register/6161550322785488139
[1] https://www.sqlsaturday.com/1000/User-Login?returnurl=%2f1000%2fSessions%2fSession-Evaluation

Top URLs in Tweet in G4:
[7] https://twitter.com/sqlpass/status/1319680271520845829
[2] https://twitter.com/paul_turley/status/1319998782033981440
[2] https://www.sqlsaturday.com/1000/Register-Now
[1] https://twitter.com/michaeldwall1/status/1317903009989287936

Top URLs in Tweet in G5:
[1] http://www.sqlsaturday.com/1000
[1] https://twitter.com/YatesSQL/status/1319639797296779267

Top URLs in Tweet in G6:
[2] https://twitter.com/GuyInACube/status/1319654819779334144
[1] https://twitter.com/SQLAllFather/status/1319657333912301569

Top URLs in Tweet in G7:
[1] https://twitter.com/MichaelDWall1/status/1319784739721498624

Top URLs in Tweet in G8:
[1] https://www.sqlsaturday.com/1000
[1] https://www.sqlsaturday.com/1000/Sessions/Details/sid/105851

Top URLs in Tweet in G10:
[2] https://www.sqlsaturday.com/1000/Register-Now

Top Domains
Top Domains in Tweet in Entire Graph:
[69] sqlsaturday.com
[21] twitter.com
[1] gotowebinar.com

Top Domains in Tweet in G1:
[39] sqlsaturday.com
[5] twitter.com

Top Domains in Tweet in G2:
[13] sqlsaturday.com
[1] twitter.com

Top Domains in Tweet in G3:
[10] sqlsaturday.com
[1] gotowebinar.com

Top Domains in Tweet in G4:
[10] twitter.com
[2] sqlsaturday.com

Top Domains in Tweet in G5:
[1] sqlsaturday.com
[1] twitter.com

Top Domains in Tweet in G6:
[3] twitter.com

Top Domains in Tweet in G7:
[1] twitter.com

Top Domains in Tweet in G8:
[2] sqlsaturday.com

Top Domains in Tweet in G10:
[2] sqlsaturday.com

Top Hashtags
Top Hashtags in Tweet in Entire Graph:
[159] sqlsatoregon
[28] sqlserver
[11] powerbi
[9] sqlsat1000
[8] sqlpass
[8] powershell
[7] azure
[7] bigdataclusters
[7] migrations
[6] sqlfriends



Top Hashtags in Tweet in G1:
[85] sqlsatoregon
[25] sqlserver
[9] powerbi
[6] azure
[6] migrations
[4] cosmosdb
[3] python
[3] datascience
[3] analytics
[3] bigdataclusters

Top Hashtags in Tweet in G2:
[23] sqlsatoregon
[6] sqlfriends
[6] powershell
[3] dba
[3] bigdataclusters
[1] sql
[1] data
[1] sqlsaturday
[1] dbas
[1] sqlserver

Top Hashtags in Tweet in G3:
[14] sqlsatoregon
[4] sqlserver2019
[3] azuresql
[2] sql
[2] jupyter
[2] notebooks
[1] jupyternotebooks
[1] sqlsaturday1000
[1] sqlsat1000
[1] jupyternotebook

Top Hashtags in Tweet in G4:
[19] sqlsatoregon
[7] sqlsat1000
[5] sqlpass
[3] sqlfamily
[2] sqlsaturday
[2] sqlserver
[1] sql
[1] migrations

Top Hashtags in Tweet in G5:
[2] sqlsatoregon
[1] sqlsaturday
[1] sqlsat
[1] sqlpass
[1] polybase
[1] bigdataclusters

Top Hashtags in Tweet in G6:
[3] sqlsatoregon
[2] powerbi

Top Hashtags in Tweet in G7:
[5] sqlsatoregon
[2] sqlfamily
[1] mvpbuzz
[1] etl
[1] azure
[1] databricks
[1] azuredevops
[1] tfs
[1] devops

Top Hashtags in Tweet in G8:
[5] sqlsatoregon
[1] sqlsaturday
[1] datamodeling

Top Hashtags in Tweet in G9:
[1] sqlmi
[1] sqlsatoregon

Top Hashtags in Tweet in G10:
[2] sqlsatoregon

Top Words
Top Words in Tweet in Entire Graph:
[159] #sqlsatoregon
[101] hrs
[99] pst
[73] 24th
[60] october
[55] come
[52] saturday
[47] register
[42] presentation
[39] see

Top Words in Tweet in G1:
[85] #sqlsatoregon
[79] hrs
[79] pst
[54] 24th
[43] october
[42] come
[33] saturday
[32] presentation
[30] see
[28] register

Top Words in Tweet in G2:
[23] #sqlsatoregon
[9] register
[8] hrs
[8] 24th
[8] october
[7] saturday
[7] please
[7] tell
[7] arnierowland
[6] public

Top Words in Tweet in G3:
[14] #sqlsatoregon
[9] sql
[8] saturday
[7] hrs
[7] pst
[6] 24th
[6] register
[6] server
[5] sqldbawithbeard
[5] mssqlgirl

Top Words in Tweet in G4:
[19] #sqlsatoregon
[11] time
[8] sessions
[7] great
[7] #sqlsat1000
[7] session
[7] present
[6] happy
[6] presenting
[6] stutterer

Top Words in Tweet in G5:
[2] #sqlsatoregon

Top Words in Tweet in G6:
[3] #sqlsatoregon
[2] less
[2] hour
[2] before
[2] #powerbi
[2] session
[2] hope
[2] join
[2] patrickdba
[2] sqlallfather

Top Words in Tweet in G7:
[5] #sqlsatoregon
[3] azure
[3] databricks
[3] great
[2] #sqlfamily
[2] presentation
[2] hrs
[2] pst
[2] way0utwest
[2] speakers

Top Words in Tweet in G8:
[5] #sqlsatoregon
[2] presenting
[2] 24

Top Words in Tweet in G10:
[2] everyone
[2] going
[2] #sqlsatoregon
[2] chance
[2] learn
[2] true
[2] expert
[2] mr
[2] hugo_kornelis
[2] troubleshoot

Top Word Pairs
Top Word Pairs in Tweet in Entire Graph:
[98] hrs,pst
[59] 24th,october
[43] saturday,24th
[36] pst,saturday
[30] come,see
[30] pst,24th
[21] 1730,hrs
[19] 0730,hrs
[19] october,#sqlsatoregon
[18] 0900,hrs

Top Word Pairs in Tweet in G1:
[78] hrs,pst
[43] 24th,october
[30] saturday,24th
[28] pst,saturday
[24] pst,24th
[24] come,see
[17] 1730,hrs
[14] 0730,hrs
[14] 0900,hrs
[14] october,#sqlsatoregon

Top Word Pairs in Tweet in G2:
[8] 24th,october
[7] saturday,24th
[6] public,service
[6] service,announcement
[6] announcement,attend
[6] attend,#sqlsatoregon
[6] #sqlsatoregon,underwear
[6] underwear,please
[6] please,tell
[6] tell,register

Top Word Pairs in Tweet in G3:
[7] hrs,pst
[6] sql,server
[4] pst,saturday
[4] saturday,24th
[4] 24th,october
[3] 0900,hrs
[3] server,2019
[3] dennes,going
[3] buckwoodymsft,mssqlgirl
[3] mssqlgirl,industry

Top Word Pairs in Tweet in G4:
[8] time,#sqlsatoregon
[7] #sqlsatoregon,#sqlsat1000
[6] happy,presenting
[6] presenting,stutterer
[6] stutterer,speaker
[6] speaker,overcoming
[6] overcoming,fears
[6] fears,tomorrow
[6] tomorrow,pm
[6] pm,pacific

Top Word Pairs in Tweet in G6:
[2] less,hour
[2] hour,before
[2] before,#powerbi
[2] #powerbi,session
[2] session,#sqlsatoregon
[2] #sqlsatoregon,hope
[2] hope,join
[2] join,patrickdba
[2] patrickdba,sqlallfather
[2] sqlallfather,cmfinlan

Top Word Pairs in Tweet in G7:
[2] azure,databricks
[2] databricks,#sqlsatoregon
[2] hrs,pst

Top Word Pairs in Tweet in G10:
[2] everyone,going
[2] going,#sqlsatoregon
[2] #sqlsatoregon,chance
[2] chance,learn
[2] learn,true
[2] true,expert
[2] expert,mr
[2] mr,hugo_kornelis
[2] hugo_kornelis,troubleshoot
[2] troubleshoot,execution

Top Replied-To
Top Mentioned
Top Mentioned in Entire Graph:
@mssqlgirl
@michaeldwall1
@arnierowland
@kleegeek
@mspowerbi
@sqlserver
@dennes
@sqldbawithbeard
@william_a_dba
@hrtact

Top Mentioned in G1:
@kleegeek
@william_a_dba
@hrtact
@willvelida
@geekusa33
@satyaramesh230
@paul_turley
@anind0
@dennes
@irishsql

Top Mentioned in G2:
@mspowerbi
@sqlserver
@michaeldwall1
@arnierowland
@harrychandrapdx
@javier_vill
@paul_turley
@mssqlgirl
@hugo_kornelis
@bweissman

Top Mentioned in G3:
@mssqlgirl
@sqldbawithbeard
@dennes
@buckwoodymsft
@azuredatastudio

Top Mentioned in G4:
@dbanuggets
@dennes
@mssqlgirl
@michaeldwall1
@kleegeek

Top Mentioned in G5:
@marquamgroup
@googlecloud
@melissadata
@redhat
@sqlpass

Top Mentioned in G6:
@patrickdba
@sqlallfather
@cmfinlan
@paginatedbear

Top Mentioned in G7:
@codenamesql
@way0utwest
@arnierowland

Top Mentioned in G9:
@rocavalc

Top Mentioned in G10:
@hugo_kornelis

Top Tweeters
Top Tweeters in Entire Graph:
@dataaugmented
@sql_handle
@jimlynchcodes
@intoleranse
@tripathiam3
@way0utwest
@dbakevlar
@youngapp_pf
@sqldbawithbeard
@jasonhorner

Top Tweeters in G1:
@dataaugmented
@jimlynchcodes
@dbakevlar
@youngapp_pf
@jasonhorner
@ruyame
@irishsql
@bknudtson
@a_bansal
@microsoft

Top Tweeters in G2:
@intoleranse
@tripathiam3
@rad_reza
@sqlserver
@mspowerbi
@bweissman
@arnierowland
@paul_turley
@ruiromano
@javier_vill

Top Tweeters in G3:
@sqldbawithbeard
@sqlmct
@dennes
@buckwoodymsft
@mssqlgirl
@mrs_fatherjack
@steverezhener
@cblackuk1
@azuresql
@azuredatastudio

Top Tweeters in G4:
@sql_handle
@timweigel
@jpomfret
@sqlatspeed
@sqlworldwide
@adipesa
@dbanuggets
@jazzartist
@sqlweigel

Top Tweeters in G5:
@redhat
@sqlpass
@yatessql
@googlecloud
@melissadata
@marquamgroup

Top Tweeters in G6:
@sqlallfather
@guyinacube
@patrickdba
@cmfinlan
@paginatedbear

Top Tweeters in G7:
@way0utwest
@dstokes123
@azuredevopsbot
@codenamesql

Top Tweeters in G8:
@sqlmal
@milhouse
@havensbi
@_mikemckinley_

Top Tweeters in G9:
@jmjuradodiaz
@mrjohnmobley
@rocavalc

Top Tweeters in G10:
@hugo_kornelis
@osorio33