I have been playing with Excel’s Power View, Power Query (my favorite) and Power Pivot (older but still fantastic) and a few weeks ago someone tweeted something about their twitter archive. That gave me an idea to see if there is any pattern in my tweeting.
So I went to twitter web settings and requested a fresh archive. As a side, how awesome is it that twitter lets you request an archive and that it is ready in minutes. This is a company that could not go back more than a few days in history not so long ago!
Anyway, I brought in all the data from the csv file and put a couple of simple charts together. I’d have loved to share this as an embedded Excel file but because it has all the data, the file is ~19MB and Excel Online can only handle file size of 5MB and below :-(
Anyway, it is interesting to see that my peak twitter was 2012, and for some reason, April of 2012. And as for the clients, MetroTwit, which is still one of the best twitter experiences I have had, very surprisingly dropped to negligible levels after 2012.
Anyway … as usual, there is more insight to gain from the data. I just found these to be the quick and easy ones to look at.
[caption id=“attachment_3601” align=“aligncenter” width=“646”] Tweets by month[/caption]
[caption id=“attachment_3602” align=“aligncenter” width=“646”] Tweets by client[/caption]
I posted a few pictures of beer from a recent trip and here are some more pictures, this time of flowers at Keukenoff Gardens.
As you know, these are all mostly from a Lumia 920, and some from an iPhone 5s.
Some samples embedded below:
[gallery type=“slideshow” columns=“2” link=“file” ids=“3581,3582,3583,3584,3585,3586,3587,3588” orderby=“rand”]
I tweeted this out a few days ago, but I thought I’d put it here as well. Some shots of beer I took on a recent trip to Brussels, Bruges, Amsterdam and Copenhagen. (All pics are Lumia 920 or iPhone 5s, as you may have read in my earlier post about this vacation.)
[office src=“https://onedrive.live.com/embed?cid=BABF6748D49265DB&resid=BABF6748D49265DB%2139263&authkey=AF_Yr6GQQE5HMWM” width=“339” height=“163”]
Some Cinemagraphs I created in the past week or so, and shared at Nokia Memories website.
[caption id=“attachment_3041” align=“aligncenter” width=“800”] Cinemagraph - Spinning top[/caption]
See this on Nokia Cinemagraph sharing site.
[caption id=“attachment_3037” align=“alignnone” width=“448”] Cinemagraph - India Republic Day[/caption]
See this on Nokia’s Cinemagraph sharing site.
[caption id=“attachment_3039” align=“aligncenter” width=“800”] Cinemagraph - Swimming pool[/caption]
See this on Nokia’s Cinemagraph sharing site.
Twitter is now showing pictures posted on SkyDrive inline, much like other photo services such as Twitpic, YFrog, etc.
Skydrive Pictures Now Showing Inline on Twitter
I saw this in the Ultrabook section at the Intel CES booth. Why bother with these apps, at least on display PCs?? Sigh.
Look at this website. Could there be more columns or rows added to obscure the content? Someone's gotta give some peace of mind to Penton folks to clean this up. It is horrible!
In this age of microblogs and instant communications, it is awesome to see the consistency (and high quality of course) of blog posts from Louis Gray.
Congrats Louis, and keep 'em coming!
I like the nice touch provided by bing with the Breaking News. Meanwhile Google is nowhere.