In the past I have looked at Geekzone data to find trends, influentials and other information. This data was used to support decisions such as “should we create a new forum for this subject” or “should we close this sub-forum?” and so on. We also used it for marketing, answering questions such as “Where are the discussions around [insert subject here] and who are the participants”.
Lately I have been using a lot of Microsoft Power BI at Intergen. It is a great tool to create dashboards that tell a story, or for people to find and work on trends that data reveal. So I decided to use Power BI on Geekzone as well and make some of this information public.
Basically I created a Geekzone Power BI dashboard which visitors can use to check some of the data we have – answering questions such as “What sub-forums have the most discussions?” or “How many participants reply on an average discussion in the [insert sub-forum here]”. It is even fun to see how big jumps caused sub-forum to come up – for example looking at when Freeview was launched in New Zealand or the months when a new iPhone or Samsung device came out you can clear see a trend growing on each related sub-forum.
Around 2013 we created a +1 feature on Geekzone. This allows people to support a reply by giving an “approval” without having to post “I like this”. The user who posted the replies can see who voted for his post. But when you look at the data you start seeing different things. For example you can see who gets more votes in different sub-forums and where their interests lie.
Every year, around March, I post a Geekzone State of the Browser based on Google Analytics data. Last night I decide to add this data to Power BI. This means that instead of having an annual report based on the last 30 days of data anyone can have a look at reports updated to the previous day, with data covering any period from a month to all the data we ever had – just clicking on filters. This data covers the entire period we have Google Analytics on Geekzone – since December 2005.
You can clearly see when smartphones as we know now came to the market – the small presence of this technology appearing for the first time in 2010. You can also see the decline of Internet Explorer and the rise of Google Chrome.
I have been fine tuning these charts as we go – and there’s more to come.
Data is updated twice daily so you know it is always the freshest dataset around. Go have a play: Geekzone Power BI dashboard.
Other related posts:
Microsoft Ignite New Zealand, Microsoft Surface Studio
Now with more fibre
Unlimited is not unlimited: Vodafone cable going gigabit
comments powered by Disqus