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
79250 posts

Uber Geek

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.





Please support Geekzone by subscribing, or using one of our referral links: Samsung | AliExpress | Wise | Sharesies | Hatch | GoodSyncBackblaze backup


Create new topic
ethanbmnz
138 posts

Master Geek


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

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




freitasm

BDFL - Memuneh
79250 posts

Uber Geek

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.

 

 





Please support Geekzone by subscribing, or using one of our referral links: Samsung | AliExpress | Wise | Sharesies | Hatch | GoodSyncBackblaze backup


freitasm

BDFL - Memuneh
79250 posts

Uber Geek

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.





Please support Geekzone by subscribing, or using one of our referral links: Samsung | AliExpress | Wise | Sharesies | Hatch | GoodSyncBackblaze backup




Lias
5589 posts

Uber Geek

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.


jnimmo
1097 posts

Uber Geek


  #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
79250 posts

Uber Geek

Administrator
ID Verified
Trusted
Geekzone
Lifetime subscriber

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




Please support Geekzone by subscribing, or using one of our referral links: Samsung | AliExpress | Wise | Sharesies | Hatch | GoodSyncBackblaze backup


TwoSeven
1623 posts

Uber Geek

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...


 
 
 

Cloud spending continues to surge globally, but most organisations haven’t made the changes necessary to maximise the value and cost-efficiency benefits of their cloud investments. Download the whitepaper From Overspend to Advantage now.
freitasm

BDFL - Memuneh
79250 posts

Uber Geek

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.





Please support Geekzone by subscribing, or using one of our referral links: Samsung | AliExpress | Wise | Sharesies | Hatch | GoodSyncBackblaze backup


hio77
12999 posts

Uber Geek

ID Verified
Trusted
Lizard Networks

  #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
79250 posts

Uber Geek

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)...

 

 





Please support Geekzone by subscribing, or using one of our referral links: Samsung | AliExpress | Wise | Sharesies | Hatch | GoodSyncBackblaze backup


CapBBeard
211 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





News and reviews »

Air New Zealand Starts AI adoption with OpenAI
Posted 24-Jul-2025 16:00


eero Pro 7 Review
Posted 23-Jul-2025 12:07


BeeStation Plus Review
Posted 21-Jul-2025 14:21


eero Unveils New Wi-Fi 7 Products in New Zealand
Posted 21-Jul-2025 00:01


WiZ Introduces HDMI Sync Box and other Light Devices
Posted 20-Jul-2025 17:32


RedShield Enhances DDoS and Bot Attack Protection
Posted 20-Jul-2025 17:26


Seagate Ships 30TB Drives
Posted 17-Jul-2025 11:24


Oclean AirPump A10 Water Flosser Review
Posted 13-Jul-2025 11:05


Samsung Galaxy Z Fold7: Raising the Bar for Smartphones
Posted 10-Jul-2025 02:01


Samsung Galaxy Z Flip7 Brings New Edge-To-Edge FlexWindow
Posted 10-Jul-2025 02:01


Epson Launches New AM-C550Z WorkForce Enterprise printer
Posted 9-Jul-2025 18:22


Samsung Releases Smart Monitor M9
Posted 9-Jul-2025 17:46


Nearly Half of Older Kiwis Still Write their Passwords on Paper
Posted 9-Jul-2025 08:42


D-Link 4G+ Cat6 Wi-Fi 6 DWR-933M Mobile Hotspot Review
Posted 1-Jul-2025 11:34


Oppo A5 Series Launches With New Levels of Durability
Posted 30-Jun-2025 10:15









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.