Improve Financial Management reporting using PowerBI
Northumbria Healthcare NHS Foundation Trust · North East
Key facts
- Contract value
- £16,150
- Awarded
- 11 Dec 2023
- Contract starts
- 22 Jan 2024
- Contract ends
- 20 Feb 2024
- Procedure
- Open procedure
- Buyer type
- Health
Awarded to
| Supplier | Value |
|---|---|
| TRUSTMARQUE SOLUTIONS LIMITED | £16,150 |
Description
We are seeking an on-site multiple weeks' worth of onsite support. We are looking to recruit a small team and not just an individual. We already have PowerBI licenses for this. Training day to summarise to be provided at the end. Background Our current reporting is from Oracle Financials. We wish to implement PowerBI to improve our Financial Management reporting across the Trust. This will include reporting from Trust Board level down to individual budget holders. We already have PowerBI licences available from our Trust IT department. The Trust is organised into Business Units with devolved financial management responsibilities. - example Business Units (BU's) are Medicine, Surgery, Corporate etc We have 2 fully-owned subsidiaries, NHFML Ltd (provides Estates, Facilities, new builds etc) and NPC Ltd (a group of GP Practices) - hence, we have 3 Orgs in Oracle: Trust, NHFM & NPC Reports are either for the Group i.e. exclude inter-company balances or for BU's which include inter-company balances Our reporting hierarchy goes from Trust to BU to Directorate to Department to Cost Centre Our typical budget holder reports are Budget / Actual / Variance for both in-month and year to date, plus WTE budget and actual in-month 1 Improve monthly Finance reporting to BU Boards Help design improved / standardised month-end BU Board / Specialty / Directorate £ / WTE reports to e.g. Medicine BU Board To include appropriate summarised info / visuals on WTE/£/trends etc To include normalisation of previous periods by stripping out certain cost centre / subjective / £ values Setup Trustwide "base" £ / WTE data with lookups to standard hierarchies 2 Improve monthly Budget Holder reporting a) Help design improved / standardised reports to include appropriate info / visuals on WTE/£/trends etc b) Setup daily refresh of Trustwide "base" £ / WTE data from Days 0 to 5 c) Budget holders to see only their cost centres 3 Improve Trust Board reports Setup Group BU Finance Reports to get budgets / actuals for Finance Director & details underlying this for Finance Managers 4 Train in-house "experts" in PowerBI Train up to 10 in-house staff so they can setup & amend new reports/visuals/dashboards. We are looking to have onsite support and training from the provider at Northumbria House, Unit 7/8 silverfox way, cobalt business park, Newcastle, NE27 0QJ. We are looking to have this support on site for up to one week, for any questions that may arise within the week for onsite training.
Categories (CPV)
- 66171000 Financial consultancy services
Similar open tenders
Digital Marketplace
Location: Yorkshire and the HumberBuyer: Yorkshire Purchasing Organisation
Open tenderCloses 6 Nov, 20262 daysValue £800.00mSource Find a TenderYPO are looking for a Provider to be appointed onto a Framework Agreement for the provision of a Digital Marketplace. The Framework is designed to meet the needs of all public sector organisations which includes YPO’s internal requirements. This Framework is designed to meet the needs of YPO and Other Contracting Autho
Fair Value & Expected Credit Loss
Location: West MidlandsBuyer: Warwickshire County Council
Open tenderCloses 27 Nov, 202623 daysValue £160.00kSource Find a TenderWarwickshire County Council (the Council) is seeking a single provider to produce annual reports detailing the fair value and expected credit loss of relevant non-treasury investments. Where deemed material, these valuations will be included in the Council's Annual Statement of Accounts. The maximum contract value ove
The Provision of Work Planning Software Application [642]
Location: IrelandBuyer: Commission for Regulation of Utilities
Open tenderCloses 30 Nov, 202626 daysValue €210.00KSource TEDThe CRU prepares a Strategic Plan on a three-year cycle and develops annual Work Plans to support delivery of its priorities, objectives and outcomes. Progress is monitored quarterly through Work Plan review reports and monthly through Focus Area Reports for selected highpriority programmes, projects and organisational
Insurance brokerage and associated services III
Location: Yorkshire and the HumberBuyer: Yorkshire Purchasing Organisation
Open tenderCloses 14 Dec, 202640 daysValue £10.00mSource Find a TenderYPO as the lead authority, together with collaborating authorities ESPO and NEPO, are seeking to establish a compliant route to market for the provision of insurance brokerage and associated services, for use across the whole public sector. YPO is managing this procurement process in accordance with the Procurement Act
York College - Provision of EV Cars Salary Sacrifice Scheme
Location: Yorkshire and the HumberBuyer: York College
Open tenderCloses 27 Nov, 202623 daysValue £4.00mSource Find a TenderYork College wishes to appoint a single supplier to deliver a fully managed Electric Vehicle (EV) Salary Sacrifice Scheme for eligible employees. The College's objectives are to: • Support net zero and sustainability commitments. • Enhance employee benefits, wellbeing, recruitment and retention. • Provide employees wit
LEGO299 End-to-End Reporting, Budgeting, Forecasting and Financial Reporting Solution
Location: West MidlandsBuyer: The Office for Legal Complaints
Open tenderCloses 30 Nov, 202626 daysValue £100.00kSource Find a TenderA fit-for-purpose budgeting, forecasting and financial reporting solution that automates LeO's existing Finance processes, integrates with relevant source systems and can be operated by Finance following implementation.