Financial Benchmarking and Insights Tool

The Financial Benchmarking and Insights Tool (FBIT) provides a single service for the management of schools' financial data.

• Benchmarking: Compare resource use against similar schools.
• Insights: Interrogate financial data to identify planning improvements.
• Outcomes: Support better financial planning for improved pupil outcomes.
• Accountability: Support Governors and Trustees in their oversight roles.

Primary Resources

• 🚀 Getting Started: Onboarding instructions, local environment setup, and common make commands.
• 📚 Documentation Index: Full directory of architecture, design, and operational guides.
• 🛠️ Contributing: Guidelines for opening issues and pull requests.

Project Status

Project Backlog

Build Status (CI)

Pipeline	Build	Automated Test	Test
Core infrastructure
Data pipeline
Platform
Front-end components
Web

Release Status (CD)

Pre-production	Production

System Overview

Monorepo Structure

• web/: ASP.NET Core MVC portal (Vue 3 for interactive features).
• platform/: .NET Azure Functions REST APIs (Backend data access).
• front-end-components/: React/TypeScript visualization library.
• data-pipeline/: Python/Pandas processing engine.
• core-infrastructure/: Terraform IaC and .NET DbUp migrations.
• pipelines/: YAML-based CI/CD pipeline definitions for Azure DevOps.
• support-analytics/: Log Analytics queries and KQL for operational monitoring.
• documentation/: Docs-as-code generation pipeline (Markdown/Pandoc).

Core Architecture & Data Flow

1. Ingestion: Raw CSV/Excel data is uploaded to Azure Blob Storage.
2. Processing: data-pipeline (Python) transforms data and persists to Azure SQL.
3. Serving: platform (Azure Functions) exposes data via RESTful APIs.
4. Presentation: web (ASP.NET MVC) portal renders dashboards using front-end-components.