deeper analysis using spreadsheets (and pivot tables)

Created by Doug Stoddart, Modified on Thu, 13 May 2021 at 10:29 AM by Jorrit Reitsma

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

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article