A PowerBI Dashboard has been launched to allow Maintained Devon schools to access and view near live finance system (Finest) data. Please find guidance below relating to the initial stages around setting up school user accounts to access the data.
Any transactions input to Finest until 10pm will be extracted and loaded into the data warehouse. The report is then set to update from the data warehouse at 7:30am the next morning, hence the report contains everything from the previous day.
User Account Queries
If you wish to register as a user of the PowerBI dashboard or have any queries with it, please contact us via our Team Mailbox
In your email, please state that your query relates to the Maintained Schools PowerBI Dashboard to ensure this reaches to correct team member.
financeschools-mailbox@devon.gov.uk
AnyComms Pre-populated Forms Response Procedure
If you received an AnyComms invite to the PowerBI Report, please follow this procedure to respond.
- Please access AnyComms with your login information and select the ‘Pre-populated Forms’ option; click the ‘Request for user account information’ pre-populated form.
- Please complete your email address, this must be a school email address for example: admin@devonprimary-school.devon.sch.uk or other official school domain email address.
- Complete activity code you require access to, in the format GXXXX.
- Please complete your name in the next field.
- Add any notes relevant to your request in the notes field.
- Add an additional line if you require access to more than one school, in cases where your school may be part of a multiple budget federation. ( We will require approval from the headteacher if you are requesting access to a school different to the one at which you are based. Please request that an email as sent to financeschools-mailbox@devon.gov.uk by the headteacher.)
- Once complete, please submit a return to us for processing
PowerBI Report Access Procedure
Once you have completed the AnyComms Pre-populated form requirements above, your account will be created and access will be granted to the following address:
Financial Data for Schools – Power BI
The link will only be accessible with the email address originally provided to us when access was requested. The report will only show transactions relating to the assigned school(s).
Using the Report
Once logged into the report, there will be a number of filter options for your data, shown on the left hand side of the screen (A screenshot is shown below)
Data can be extracted from the report using the menu on the top right of the report data, in any of the four reporting options (See screenshot shown below. Click ‘More Options’ and then ‘Extract Data’ where this data can then be used in Microsoft Excel as required.
Note: Be aware that the ‘More Options’ menu is obscured on the ‘Breakdown’ report but will still allow you to export, please see screenshot below.
