Weekly Cash Balances

Overview

A production-grade weekly cash balances analysis blueprint built on Omora Labs components. This system demonstrates how semantic layers, facts, transformations, and reporting work together to deliver automated cash balances reporting.

Assets

Source code: GitHub
Live report: Hex

Live Report

Dependencies

Semantic Layers: Asset Types, Assets Providers, Currencies, Currency Pairs, and Dates
Facts: Assets and Exchange Rates
Workers: Exchange Rates
Transformations: Assets Metadata, Assets Values, Reporting Rates, Assets by Currency, Assets Converted, and Cash Balances by Reporting Currency

How to Use

Run the following command from your terminal or clone or fork the GitHub repository.

npx omoralabs@latest add weekly_cash_balances

Replace the CSVs with your own data.
Create a local or remote database and load sample data:

The remote database service is provided by Motherduck, a remote service for DuckDB databases. You must have an account to complete the remote setup. Motherduck provides a generours free tier.

# Create a local database and load sample data
  uv run omora-local

  # Create a remote database and load sample data
  uv run omora-remote

Run dbt to materialize the analytics models:

cd src/weekly_cash_balances/weekly_cash_balances_dbt
uv run dbt run

Connect to your favorite BI tool directly to the analytics layer. Example consumption on BI Tool:

SELECT * from weekly_cash_balances.analytics.assets_values
SELECT * from weekly_cash_balances.analytics.cash_balances_byrc