deeper analysis using spreadsheets (and pivot tables)

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 all your bike data: Exporting data from BRM

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:

Here is how the 'pivot table editor' might look within Google Spreadsheets, for example:

See also

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

extracting your raw bike usage data