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

Uber Geek
+1 received by user: 11727

Administrator
Trusted
Geekzone
Lifetime subscriber

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





Create new topic
121 posts

Master Geek
+1 received by user: 46


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

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




BDFL - Memuneh
60858 posts

Uber Geek
+1 received by user: 11727

Administrator
Trusted
Geekzone
Lifetime subscriber

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

 

 







BDFL - Memuneh
60858 posts

Uber Geek
+1 received by user: 11727

Administrator
Trusted
Geekzone
Lifetime subscriber

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

Uber Geek
+1 received by user: 1728

Lifetime subscriber

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

Very cool stuff.

 

 

 

 





Information wants to be free. The Net interprets censorship as damage and routes around it.

 

Thinking about signing up to BigPipe? Get $20 credit with my referral link.


What does this tag do
955 posts

Ultimate Geek
+1 received by user: 194

Subscriber

  Reply # 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
60858 posts

Uber Geek
+1 received by user: 11727

Administrator
Trusted
Geekzone
Lifetime subscriber

1221 posts

Uber Geek
+1 received by user: 123


  Reply # 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

 




BDFL - Memuneh
60858 posts

Uber Geek
+1 received by user: 11727

Administrator
Trusted
Geekzone
Lifetime subscriber

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





'That VDSL Cat'
8117 posts

Uber Geek
+1 received by user: 1694

Trusted
Spark
Subscriber

  Reply # 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
60858 posts

Uber Geek
+1 received by user: 11727

Administrator
Trusted
Geekzone
Lifetime subscriber

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

 

 





199 posts

Master Geek
+1 received by user: 28


  Reply # 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 »

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 »

Hawaiki Transpacific cable ready-for-service
Posted 20-Jul-2018 11:29


Microsoft Dynamics 365 Business Central launches
Posted 10-Jul-2018 10:40


Spark completes first milestone in voice platform upgrade
Posted 10-Jul-2018 09:36


Microsoft ices heated developers
Posted 6-Jul-2018 20:16


PB Technologies charged for its extended warranties and warned for bait advertising
Posted 3-Jul-2018 15:45


Almost 20,000 people claim credits from Spark
Posted 29-Jun-2018 10:40


Cove sells NZ's first insurance policy via chatbot
Posted 25-Jun-2018 10:04


N4L helping TAKA Trust bridge the digital divide for Lower Hutt students
Posted 18-Jun-2018 13:08


Winners Announced for 2018 CIO Awards
Posted 18-Jun-2018 13:03


Logitech Rally sets new standard for USB-connected video conference cameras
Posted 18-Jun-2018 09:27


Russell Stanners steps down as Vodafone NZ CEO
Posted 12-Jun-2018 09:13


Intergen recognised as 2018 Microsoft Country Partner of the Year for New Zealand
Posted 12-Jun-2018 08:00


Finalists Announced For Microsoft NZ Partner Awards
Posted 6-Jun-2018 15:12


Vocus Group and Vodafone announce joint venture to accelerate fibre innovation
Posted 5-Jun-2018 10:52


Kogan.com to launch Kogan Mobile in New Zealand
Posted 4-Jun-2018 14:34



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.

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