Read on Twitter
[1/N]
I wanted to analyse my Social Media data.
I exported my @Twitter data and analysed with the #OracleText in the #OracleAutonomousDatabase @OracleDatabase and @OracleAnalytics Cloud
Starting from the easy… which is the tweet with most likes?
hint: Becoming @oracleace #ACED!
![[1/N]I wanted to analyse my Social Media data.I exported my @Twitter data and analysed with the #OracleText in the #OracleAutonomousDatabase @OracleDatabase and @OracleAnalytics CloudStarting from the easy… which is the tweet with most likes?hint: Becoming @oracleace #ACED!](https://pbs.twimg.com/media/ElVixIvXUAAa7yt.jpg "[1/N]I wanted to analyse my Social Media data.I exported my @Twitter data and analysed with the #OracleText in the #OracleAutonomousDatabase @OracleDatabase and @OracleAnalytics CloudStarting from the easy… which is the tweet with most likes?hint: Becoming @oracleace #ACED!")
I wanted to analyse my Social Media data.
I exported my @Twitter data and analysed with the #OracleText in the #OracleAutonomousDatabase @OracleDatabase and @OracleAnalytics Cloud
Starting from the easy… which is the tweet with most likes?
hint: Becoming @oracleace #ACED!
[2/N]
Second question: which are the most used words when I tweet?
Easy, create an index (type CTXSYS.CONTEXT) in the @OracleDatabase
More info at
As expectable the most frequent words are around OUGs, Tech, Analytics, Oracle Products and Talks
![[2/N]Second question: which are the most used words when I tweet?Easy, create an index (type CTXSYS.CONTEXT) in the @OracleDatabase More info at As expectable the most frequent words are around OUGs, Tech, Analytics, Oracle Products and Talks](https://pbs.twimg.com/media/ElVix4MWMAIFNDz.jpg "[2/N]Second question: which are the most used words when I tweet?Easy, create an index (type CTXSYS.CONTEXT) in the @OracleDatabase More info at As expectable the most frequent words are around OUGs, Tech, Analytics, Oracle Products and Talks")
Second question: which are the most used words when I tweet?
Easy, create an index (type CTXSYS.CONTEXT) in the @OracleDatabase
More info at
As expectable the most frequent words are around OUGs, Tech, Analytics, Oracle Products and Talks
[3/N]
How does it change when I reply to people?
Well, you can see that words about OUG sessions and Oracle are still there, but there is the emerging topic of #Food!
![[3/N]How does it change when I reply to people?Well, you can see that words about OUG sessions and Oracle are still there, but there is the emerging topic of #Food!](https://pbs.twimg.com/media/ElViyo6XUAEfETX.jpg "[3/N]How does it change when I reply to people?Well, you can see that words about OUG sessions and Oracle are still there, but there is the emerging topic of #Food!")
How does it change when I reply to people?
Well, you can see that words about OUG sessions and Oracle are still there, but there is the emerging topic of #Food!
[4/N] Who do I interact most with?
I plotted the # of Replies to specific Users…
No wonder (at least to me) that I get most interaction with people that tag me with italian food abominations… Does it ring a bell @dw_pete, @HeliFromFinland, @stewartbryson and @connor_mc_d ?
![[4/N] Who do I interact most with?I plotted the # of Replies to specific Users…No wonder (at least to me) that I get most interaction with people that tag me with italian food abominations… Does it ring a bell @dw_pete, @HeliFromFinland, @stewartbryson and @connor_mc_d ?](https://pbs.twimg.com/media/ElViy-oXUAIwoD4.jpg "[4/N] Who do I interact most with?I plotted the # of Replies to specific Users…No wonder (at least to me) that I get most interaction with people that tag me with italian food abominations… Does it ring a bell @dw_pete, @HeliFromFinland, @stewartbryson and @connor_mc_d ?")
I plotted the # of Replies to specific Users…
No wonder (at least to me) that I get most interaction with people that tag me with italian food abominations… Does it ring a bell @dw_pete, @HeliFromFinland, @stewartbryson and @connor_mc_d ?
[5/N]
So how do I reply them?
Again, very easy with #OracleAnalyticsCloud Trellis Options.
You can spot that #Food is the major discussion topic with @HeliFromFinland and @dw_pete, while my chats with @connor_mc_d and @stewartbryson are covering more topics
![[5/N]So how do I reply them?Again, very easy with #OracleAnalyticsCloud Trellis Options.You can spot that #Food is the major discussion topic with @HeliFromFinland and @dw_pete, while my chats with @connor_mc_d and @stewartbryson are covering more topics](https://pbs.twimg.com/media/ElVizT-XEAAEpoI.jpg "[5/N]So how do I reply them?Again, very easy with #OracleAnalyticsCloud Trellis Options.You can spot that #Food is the major discussion topic with @HeliFromFinland and @dw_pete, while my chats with @connor_mc_d and @stewartbryson are covering more topics")
So how do I reply them?
Again, very easy with #OracleAnalyticsCloud Trellis Options.
You can spot that #Food is the major discussion topic with @HeliFromFinland and @dw_pete, while my chats with @connor_mc_d and @stewartbryson are covering more topics
[6/N]
One Last mention to my interactions with @Nephentur:
It’s clear his love for OUGs, Airports, Flights, Hotels… all driven by #TheBergEffect
![[6/N]One Last mention to my interactions with @Nephentur:It’s clear his love for OUGs, Airports, Flights, Hotels… all driven by #TheBergEffect](https://pbs.twimg.com/media/ElVizvkWkAAnpan.jpg "[6/N]One Last mention to my interactions with @Nephentur:It’s clear his love for OUGs, Airports, Flights, Hotels… all driven by #TheBergEffect")
One Last mention to my interactions with @Nephentur:
It’s clear his love for OUGs, Airports, Flights, Hotels… all driven by #TheBergEffect
[7/N]
Useful Links:
- Download your twitter data: https://help.twitter.com/en/managing-your-account/how-to-download-your-twitter-archive
- Token analysis with #OAC part 1:
- Token analysis with #OAC part 2:
Useful Links:
- Download your twitter data: https://help.twitter.com/en/managing-your-account/how-to-download-your-twitter-archive
- Token analysis with #OAC part 1:
- Token analysis with #OAC part 2:
[8/N]
In a future #OracleAnalyticsCloud release we’ll see Token Analysis being a native step of #DataFlows within the #DataBaseAnalytics options
@oracleace @rittmanmead
Thanks to @philippe_lions for the hints on the index usage!
![[8/N]In a future #OracleAnalyticsCloud release we’ll see Token Analysis being a native step of #DataFlows within the #DataBaseAnalytics options @oracleace @rittmanmead Thanks to @philippe_lions for the hints on the index usage!](https://pbs.twimg.com/media/ElVi0O-WoAEG8jS.jpg "[8/N]In a future #OracleAnalyticsCloud release we’ll see Token Analysis being a native step of #DataFlows within the #DataBaseAnalytics options @oracleace @rittmanmead Thanks to @philippe_lions for the hints on the index usage!")
In a future #OracleAnalyticsCloud release we’ll see Token Analysis being a native step of #DataFlows within the #DataBaseAnalytics options
@oracleace @rittmanmead
Thanks to @philippe_lions for the hints on the index usage!
