Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.




BDFL - Memuneh
67460 posts

Uber Geek

Administrator
Trusted
Geekzone
Lifetime subscriber

#193869 27-Mar-2016 23:37
Send private message

Hello folks

 

I have been playing with Microsoft Power BI and decided to publish some data. I am still building the datasets and filtering things. The data is refreshed once daily, automatically.

 

you can find the Geekzone Analytics page here. With time I will add more data - also sometimes it may take up to an hour for a refresh.

 

You can look at this data in different ways. Click a column and everything else will be filtered to reflect that. CLick a year and the charts will show data for that year. This will answer questions such as "How many new topics were created in 2014?" and also show the distribution by forums.

 

Later I will add charts to also answer queries such as "Which users are more active on forums XYZ", "In which forums user ABC is most active?" or "What's the average number of replies in each forum, year by year?"

 

Post your query suggestions below.





 

 

These links are referral codes

 

Geekzone broadband switch | Eletricity comparison and switch | Hatch investment (NZ$ 10 bonus if NZ$100 deposited within 30 days) | Sharesies | Mighty Ape | Backblaze | Amazon | My technology disclosure 


Create new topic
130 posts

Master Geek


  #1520618 28-Mar-2016 00:04
Send private message

How I see the data: another example of Zipf's law.




BDFL - Memuneh
67460 posts

Uber Geek

Administrator
Trusted
Geekzone
Lifetime subscriber

  #1520724 28-Mar-2016 12:23
Send private message

Added an extra tab with average replies per forum and average users per topic by forum.

 

 





 

 

These links are referral codes

 

Geekzone broadband switch | Eletricity comparison and switch | Hatch investment (NZ$ 10 bonus if NZ$100 deposited within 30 days) | Sharesies | Mighty Ape | Backblaze | Amazon | My technology disclosure 


 
 
 
 




BDFL - Memuneh
67460 posts

Uber Geek

Administrator
Trusted
Geekzone
Lifetime subscriber

  #1520786 28-Mar-2016 16:23
Send private message

Also note these stats do not include private forums and deleted threads/replies.





 

 

These links are referral codes

 

Geekzone broadband switch | Eletricity comparison and switch | Hatch investment (NZ$ 10 bonus if NZ$100 deposited within 30 days) | Sharesies | Mighty Ape | Backblaze | Amazon | My technology disclosure 


4137 posts

Uber Geek

Trusted
Lifetime subscriber

What does this tag do
1026 posts

Uber Geek

Subscriber

  #1525997 4-Apr-2016 20:07
Send private message

That is cool, do you know how does Power BI pricing works? Haven't looked into enough detail yet

 

 

 

I wonder how many people are running tracking blocking or uBlock Origin etc (like me), need some server based analytics to see them




BDFL - Memuneh
67460 posts

Uber Geek

Administrator
Trusted
Geekzone
Lifetime subscriber

  #1525999 4-Apr-2016 20:09
Send private message




 

 

These links are referral codes

 

Geekzone broadband switch | Eletricity comparison and switch | Hatch investment (NZ$ 10 bonus if NZ$100 deposited within 30 days) | Sharesies | Mighty Ape | Backblaze | Amazon | My technology disclosure 


1463 posts

Uber Geek


  #1526002 4-Apr-2016 20:11
Send private message

Just a question about the technology, is this hosted in the cloud or on-premises.  I see there is a feature in SQL server 2016 to allow on-premises - is it related?

 

Is the dashboard doing real-time queries against the CRUD/OLTP database or is there an ETL/Data Warehouse component in there?

 

 





Software Engineer
   (the practice of real science, engineering and management)


 
 
 
 




BDFL - Memuneh
67460 posts

Uber Geek

Administrator
Trusted
Geekzone
Lifetime subscriber

  #1526006 4-Apr-2016 20:16
Send private message

It is a mix.

 

For the Geekzone DB I decided what information I wanted to show so I created SQL Views with the data I needed (Power BI does not load SQL Queries yet). I used the Power BI desktop to load this data, created summary fields based on this data and used drag-and-drop to create the charts.

 

For the Google Analytics data I logged using OAuth and selected which dimensions and values I wanted, creating a model with the information I wanted, not too different from the Views.

 

I then published this to my Power BI cloud account, 

 

I have running a Power BI connector on a VM on my server and currently refreshes this data twice a day, pushing the updates to the Power BI cloud account.

 

If a company wants to just create a content pack and make it private, they can do it. In my case I made the content public. Different strategies, different outcomes.





 

 

These links are referral codes

 

Geekzone broadband switch | Eletricity comparison and switch | Hatch investment (NZ$ 10 bonus if NZ$100 deposited within 30 days) | Sharesies | Mighty Ape | Backblaze | Amazon | My technology disclosure 


'That VDSL Cat'
12339 posts

Uber Geek

Trusted
Spark
Subscriber

  #1526008 4-Apr-2016 20:18
Send private message

Very cool, Interesting to see some of the trends showing up too.





#include <std_disclaimer>

 

Any comments made are personal opinion and do not reflect directly on the position my current or past employers may have.

 




BDFL - Memuneh
67460 posts

Uber Geek

Administrator
Trusted
Geekzone
Lifetime subscriber

  #1527076 6-Apr-2016 15:54
Send private message

Update: I have added a tab now that allows you to see all the top threads (the ones with most replies) and filter this by sub-forum, year and month (these are the date the topic was created, not last reply)...

 

 





 

 

These links are referral codes

 

Geekzone broadband switch | Eletricity comparison and switch | Hatch investment (NZ$ 10 bonus if NZ$100 deposited within 30 days) | Sharesies | Mighty Ape | Backblaze | Amazon | My technology disclosure 


203 posts

Master Geek


  #1527108 6-Apr-2016 16:09
Send private message

I had to do a double-take when I saw 'Sports' massively leading the charge in 'Average replies by forum'. Unexpected!


Create new topic





Twitter and LinkedIn »



Follow us to receive Twitter updates when new discussions are posted in our forums:



Follow us to receive Twitter updates when news items and blogs are posted in our frontpage:



Follow us to receive Twitter updates when tech item prices are listed in our price comparison site:





News »

Chorus completes the build and commissioning of two new core Ethernet switches
Posted 8-Jul-2020 09:48


National Institute for Health Innovation develops treatment app for gambling
Posted 6-Jul-2020 16:25


Nokia 2.3 to be available in New Zealand
Posted 6-Jul-2020 12:30


Menulog change colours as parent company merges with Dutch food delivery service
Posted 2-Jul-2020 07:53


Techweek2020 goes digital to make it easier for Kiwis to connect and learn
Posted 2-Jul-2020 07:48


Catalyst Cloud launches new Solutions Hub to support their kiwi Partners and Customers
Posted 2-Jul-2020 07:44


Microsoft to help New Zealand job seekers acquire new digital skills needed for the COVID-19 economy
Posted 2-Jul-2020 07:41


Hewlett Packard Enterprise introduces new HPE GreenLake cloud services
Posted 24-Jun-2020 08:07


New cloud data protection services from Hewlett Packard Enterprise
Posted 24-Jun-2020 07:58


Hewlett Packard Enterprise unveils HPE Ezmeral, new software portfolio and brand
Posted 24-Jun-2020 07:10


Apple reveals new developer technologies to foster the next generation of apps
Posted 23-Jun-2020 15:30


Poly introduces solutions for Microsoft Teams Rooms
Posted 23-Jun-2020 15:14


Lenovo launches new ThinkPad P Series mobile workstations
Posted 23-Jun-2020 09:17


Lenovo brings Linux certification to ThinkPad and ThinkStation Workstation portfolio
Posted 23-Jun-2020 08:56


Apple introduces new features for iPhone iOS14 and iPadOS 14
Posted 23-Jun-2020 08:28



Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.


Support Geekzone »

Our community of supporters help make Geekzone possible. Click the button below to join them.

Support Geezone on PressPatron



Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.

Alternatively, you can receive a daily email with Geekzone updates.