Google Street View Panoramas Statistics with Power BI Report

Since 2013, I have been actively shooting spherical panoramas and posting them on the Google Street View project. At the time of writing this report, I have already shot over 14,000 panoramas.
I was always interested in how quickly the views of my panoramas grow. How quickly new panoramas start to increase views. Which panoramas get the most views and why.
But Google from statistics gives only the current number of views of all panoramas. And a small graph on which nothing is visible.

Therefore, almost from the very beginning, I periodically began to write down the readings of the number of views of panoramas on my plate. And also, after a while, I began to download regular photos, so I separately saved the readings of a similar counter from Google Maps.
I analyzed the resulting statistics in Excel.
But this is not very convenient, so I made this report. Now all you need to do is add data in the table and the report will be rebuilt itself.

Online-version - http://q-stat.ru/en/google-street-view-panoramas-statistics/

Link to the project’s github - https://github.com/q-stat-ru/panoramas

You can download this report for yourself. And use it with your data. To work with the report, you need to download and install the free Microsoft Power BI program.

Screenshot:

3 Likes

Hello @AlekseiF

Though I use other power add-ons many a time, it’s great to know that Power BI is now free.

However, there is a catch. One needs to signup with into the proposal through a work email. Also as I understand, the free use offer is not perpetual.

Thus, in my opinion, making a mention of a commercially available analytical tool on this forum is not correct.

1 Like

It’s just a tool. And at least it’s free now. I just wanted to demonstrate the possibility to visualize statistics. In theory, this can be done with other instruments as well. Perhaps, it will be more convenient for someone to use Google Data Studio or something else. I use Power BI because it is convenient for me. Please do not consider this an advertisement.

Hi @AlekseiF

Thank you so much for sharing your interesting code and display of your data. Much appreciated.

I took a brief look at your github files. Am I correct when assuming that your code will display your data and not collect your data? Ie. you have to extract the data manually into a spreadsheet at regular intervals to make this work?

In the top graph I noticed the tall spikes. How come they be flat at the top?

Also the yellow line in the lower graph has some dominating sections where it is flat/level for quite some periods of time. Are those due to Google not updating the numbers of views or you not collecting the data?

Cheers

Morten

Yes, you understand correctly, the data must be collected manually. In theory, you can try to collect this data through the Google Maps API. But I didn’t work with the Google Maps API. There is no other way to get this data.
Tall and flat spikes can be for two reasons. The first reason is that I entered data too rarely. The second reason is that Google hasn’t updated statistics for a long time.
The yellow line is the number of panoramas. As a rule, I shoot panoramas in sets and lay out in sets. Therefore, this behavior is normal.

1 Like