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

Uber Geek
+1 received by user: 11138

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
120 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
60051 posts

Uber Geek
+1 received by user: 11138

Administrator
Trusted
Geekzone
Lifetime subscriber

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


Try Wrike: fast, easy, and efficient project collaboration software


BDFL - Memuneh
60051 posts

Uber Geek
+1 received by user: 11138

Administrator
Trusted
Geekzone
Lifetime subscriber

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

Uber Geek
+1 received by user: 1608

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

Ultimate Geek
+1 received by user: 192

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

Uber Geek
+1 received by user: 11138

Administrator
Trusted
Geekzone
Lifetime subscriber

1212 posts

Uber Geek
+1 received by user: 115


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

Uber Geek
+1 received by user: 11138

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'
7543 posts

Uber Geek
+1 received by user: 1524

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

Uber Geek
+1 received by user: 11138

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 »

Opera launches new mobile browser: Opera Touch
Posted 25-Apr-2018 20:45


TCF and Telcos Toughen Up on Scam Callers
Posted 23-Apr-2018 09:39


Amazon launches the International Shopping Experience in the Amazon Shopping App
Posted 19-Apr-2018 08:38


Spark New Zealand and TVNZ to bring coverage of Rugby World Cup 2019
Posted 16-Apr-2018 06:55


How Google can seize Microsoft Office crown
Posted 14-Apr-2018 11:08


How back office transformation drives IRD efficiency
Posted 12-Apr-2018 21:15


iPod laws in a smartphone world: will we ever get copyright right?
Posted 12-Apr-2018 21:13


Lightbox service using big data and analytics to learn more about customers
Posted 9-Apr-2018 12:11


111 mobile caller location extended to iOS
Posted 6-Apr-2018 13:50


Huawei announces the HUAWEI P20 series
Posted 29-Mar-2018 11:41


Symantec Internet Security Threat Report shows increased endpoint technology risks
Posted 26-Mar-2018 18:29


Spark switches on long-range IoT network across New Zealand
Posted 26-Mar-2018 18:22


Stuff Pix enters streaming video market
Posted 21-Mar-2018 09:18


Windows no longer Microsoft’s main focus
Posted 13-Mar-2018 07:47


Why phone makers are obsessed with cameras
Posted 11-Mar-2018 12:25



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.