BRM / RSM offers fantastic access to your raw data, and also to some structured reports and graphs.


But what do you do with that data?


imagine you want to analyse how your rental inventory has performed using pivot tables.

First of all extract your bike data.

Then when you have it in a google spreadsheet, create a pivot table.


Then add;

  1.  Category (Cat) as your row
  2. Revenue (The first one, for current year) as your value (make sure you sum)



here is what it might look like:




See also

a helpful video on using Pivot Tables in Google - non BRM resource, but very good background.

extracting your raw bike usage data