About this project
New Harvest Finance & Analytics is a fictional company — a framing device for a personal project that demonstrates a complete finance data pipeline end to end.
What it demonstrates
Most analytics portfolios show skills in isolation — a dashboard here, a model there. This project is designed to show how those skills connect: getting data into an accounting system, building the integration layer that moves it onward, capturing operational data separately, and combining both sources in a reporting tool.
The pipeline runs from Xero (configured from scratch with a chart of accounts designed for reporting, not just compliance) through a custom Bridge App I built in Python, which pulls from the Xero API and makes the data available to Power BI without a commercial connector. In parallel, an operations application tracks hours and project data — the operational dimension that accounting software can't capture on its own.
Power BI then combines both sources: financial data from Xero and operational data from the Ops App, side by side. The output is metrics like effective hourly rate by client, revenue vs cost by project, and utilisation — things that require both datasets to calculate.
The Bridge App is the most technically interesting piece. Rather than paying for an off-the-shelf Xero connector, I built the integration from scratch: OAuth 2.0 authentication, API pagination, field mapping, data transformation, and scheduled refresh. Full control, no dependency on a third-party connector.
What this covers
Finance & Accounting
- –Xero setup & configuration
- –Chart of accounts design
- –Management reporting
- –Financial modelling
Data Engineering
- –API integration (Xero OAuth 2.0)
- –Data transformation & modelling
- –ETL pipeline design
- –Power Query / M
Analytics & BI
- –Power BI dashboard development
- –DAX calculations
- –Data modelling
- –Combined financial + operational analysis
Development
- –Python
- –REST APIs
- –Web application development
- –Add your stack here