Back to Exchange
About
Build a variance analysis tool with PostgreSQL:
1. Select two periods to compare (month/quarter/year)
2. P&L line items comparison table
3. Variance calculation ($ and %)
4. Waterfall chart showing variance drivers
5. Top 5 favorable and unfavorable variances
6. Drill-down to transaction level
Database: pl_items (id, account_name, category, period, amount). Seed with 24 months of P&L data across 20 accounts.
1. Select two periods to compare (month/quarter/year)
2. P&L line items comparison table
3. Variance calculation ($ and %)
4. Waterfall chart showing variance drivers
5. Top 5 favorable and unfavorable variances
6. Drill-down to transaction level
Database: pl_items (id, account_name, category, period, amount). Seed with 24 months of P&L data across 20 accounts.
Required Configuration
| Key | Description | Required |
|---|---|---|
DATABASE_URL | - | Required |
_RAILWAY_PROJECT_ID | - | Required |
_DATABASE_SERVICE_ID | - | Required |
_DATABASE_PRIVATE_URL | - | Required |
Reviews (0)
No reviews yet
Be the first to share your experience.
Something wrong? Report this listing