My window to the world


Geekzone data analytics with Power BI

By Mauricio Freitas, in , posted: 3-Apr-2016 12:49

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

freitasm's profile

Mauricio Freitas
Wellington
New Zealand


I live in New Zealand and my interests include mobile devices, good books, movies and food of course! 

I'm the Geekzone admin. On Geekzone we publish news, reviews and articles on technology topics. The site also has some busy forums.

Subscribe now to my blog RSS feed or the Geekzone RSS feed.

If you want to contact me, please use this page or email me freitasm@geekzone.co.nz. Note this email is not for technical support. I don't give technical support. You can use our Geekzone Forums for community discussions on technical issues.

Here's is my full disclosure post.

A couple of blog posts you should read:

Social networks presence

View Mauricio Freitas's profile on LinkedIn


My Blog by tags...

Blog...
Entrepreneurship...
Media...
Personal...
State of Browsers...
Technology...
Viral Marketing...
Web Performance Optimization...
Windows...
Windows Phone...

Other recent posts in my blog

Microsoft Ignite New Zealand, ...
If the headlines indicate the ...
State of browsers Geekzone Mar...
2Cheap Cars discussion...
Now with more fibre...
Unlimited is not unlimited: Vo...
How bad is Vodafone cable at t...
Frustrated with Microsoft Fami...
State of browsers Geekzone Mar...
You are still a pirate accordi...

New posts on Geekzone