About

Project Summary

This repository combines an Excel-to-PostgreSQL data pipeline with a SolidStart dashboard for reviewing revenue, activity, and sale journal data.

Data pipeline

The Python code under src/extract, src/transform, and src/load reads workbook data, reshapes it with Polars, and loads structured records into PostgreSQL.

Database layer

SQL files in src/sql define the schema, lookup tables, triggers, indexes, and reporting views used by the dashboard and API routes.

Dashboard app

The exceldashboard app is a SolidStart frontend with officer dashboards, officer reports, source and revenue summaries, and sale journal entry screens.

Charts and tables

Reusable chart and table components present aggregated reporting data from the backend, including activity counts, revenue totals, and detailed sale journal records.