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.


freitasm

BDFL - Memuneh
80655 posts

Uber Geek
+1 received by user: 41052

Administrator
ID Verified
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.





Referral links: Quic Broadband (free setup code: R587125ERQ6VE) | Samsung | AliExpress | Wise | Sharesies 

 

Support Geekzone by subscribing (browse ads-free), or making a one-off or recurring donation through PressPatron.

 


Create new topic
CodeSourcerer
138 posts

Master Geek
+1 received by user: 49


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

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




freitasm

BDFL - Memuneh
80655 posts

Uber Geek
+1 received by user: 41052

Administrator
ID Verified
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.

 

 





Referral links: Quic Broadband (free setup code: R587125ERQ6VE) | Samsung | AliExpress | Wise | Sharesies 

 

Support Geekzone by subscribing (browse ads-free), or making a one-off or recurring donation through PressPatron.

 


freitasm

BDFL - Memuneh
80655 posts

Uber Geek
+1 received by user: 41052

Administrator
ID Verified
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.





Referral links: Quic Broadband (free setup code: R587125ERQ6VE) | Samsung | AliExpress | Wise | Sharesies 

 

Support Geekzone by subscribing (browse ads-free), or making a one-off or recurring donation through PressPatron.

 




Lias
5655 posts

Uber Geek
+1 received by user: 3978

ID Verified
Trusted
Lifetime subscriber

  #1525940 4-Apr-2016 18:27
Send private message

Very cool stuff.

 

 

 

 





I'm a geek, a gamer, a dad, a Quic user, and an IT Professional. I have a full rack home lab, size 15 feet, an epic beard and Asperger's. I'm a bit of a Cypherpunk, who believes information wants to be free and the Net interprets censorship as damage and routes around it. If you use my Quic signup you can also use the code R570394EKGIZ8 for free setup. Opinions are my own and not the views of my employer.


jnimmo
1098 posts

Uber Geek
+1 received by user: 255


  #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


freitasm

BDFL - Memuneh
80655 posts

Uber Geek
+1 received by user: 41052

Administrator
ID Verified
Trusted
Geekzone
Lifetime subscriber

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




Referral links: Quic Broadband (free setup code: R587125ERQ6VE) | Samsung | AliExpress | Wise | Sharesies 

 

Support Geekzone by subscribing (browse ads-free), or making a one-off or recurring donation through PressPatron.

 


 
 
 
 

Shop now for Lenovo laptops and other devices (affiliate link).
TwoSeven
1712 posts

Uber Geek
+1 received by user: 304

Subscriber

  #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)
A.I.  (Automation rebranded)
Gender Neutral
   (a person who believes in equality and who does not believe in/use stereotypes. Examples such as gender, binary, nonbinary, male/female etc.)

 

 ...they/their/them...


freitasm

BDFL - Memuneh
80655 posts

Uber Geek
+1 received by user: 41052

Administrator
ID Verified
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.





Referral links: Quic Broadband (free setup code: R587125ERQ6VE) | Samsung | AliExpress | Wise | Sharesies 

 

Support Geekzone by subscribing (browse ads-free), or making a one-off or recurring donation through PressPatron.

 


hio77
'That VDSL Cat'
13036 posts

Uber Geek
+1 received by user: 3896

ID Verified
Trusted
Lizard Networks
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. 


freitasm

BDFL - Memuneh
80655 posts

Uber Geek
+1 received by user: 41052

Administrator
ID Verified
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)...

 

 





Referral links: Quic Broadband (free setup code: R587125ERQ6VE) | Samsung | AliExpress | Wise | Sharesies 

 

Support Geekzone by subscribing (browse ads-free), or making a one-off or recurring donation through PressPatron.

 


CapBBeard
211 posts

Master Geek
+1 received by user: 14


  #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








Geekzone Live »

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



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.