What Is FRTB? Trading Book, Expected Shortfall & the Math
FRTB is Basel's rewrite of trading-book capital. See the boundary, the standardized math, expected shortfall, and why the U.S. rule is still not final.
Blog
Notes on building apps, teaching what we learn, and the tools we use along the way.
What Is Bank Stress Testing? Scenarios, Capital Math & the SCB
A stress test asks whether capital survives a severe but plausible downturn. See the start-earn-burn math, the stress capital buffer, and reverse tests.
Spark SQL in PySpark: Temp Views and a Safe Managed Delta Table Write (Part 3 of 3)
Part 3 of a PySpark series: query DataFrames with Spark SQL temp views, match the DataFrame results, and save a managed Delta summary with mode error.
PySpark select and filter: Columns, Rows and Null Values (Part 1 of 3)
Part 1 of a PySpark series on Databricks Free Edition: shape data with select, filter and withColumn, sort with a tiebreaker, and count nulls before cleaning.
PySpark Joins and Aggregations: Inner vs Left Joins on Databricks Free Edition
Join and aggregate data with PySpark on Databricks: check lookup keys, choose inner or left joins, see how duplicate keys inflate totals, and reconcile results.
Databricks SQL Editor: GROUP BY, Joins, Common Table Expressions and Windows (Part 2 of 3)
Part 2 of a Databricks SQL Editor series: GROUP BY and HAVING, inner vs left joins, common table expressions, and window functions for ranks and running totals.
Databricks Data Engineer Associate Exam Prep, Lesson 3: COPY INTO Incremental Loading
Databricks Data Engineer Associate exam prep: how COPY INTO loads only new files, why reruns insert zero rows, format vs copy options, and when Auto Loader wins.
Databricks Data Engineer Associate Exam Prep, Lesson 2: Batch, Streaming and Incremental Ingestion
Databricks Data Engineer Associate exam prep, Section 2: compare batch, incremental and streaming ingestion with Auto Loader, and Lakeflow Connect connectors.
Databricks Data Engineer Associate Exam Prep, Lesson 1: Platform, Unity Catalog and Compute
Databricks Data Engineer Associate exam prep, Section 1: control and compute planes, Unity Catalog, managed Delta tables, and picking compute by workload and cost.
Build Your First Delta Lake Table with PySpark on Databricks Free Edition
Create a managed Delta table on Databricks Free Edition, read it with SQL and PySpark, update a row, and time travel to the version before the update.
What Is Liquidity Risk? Deposit Runs, the Cash Buffer & the LCR
Liquidity risk is whether you can pay cash today. See how fast a deposit run can move, the LCR and NSFR, and why backup lines must be pledged and tested.
What Is Basel Capital? CET1, Risk-Weighted Assets & the Math
Basel capital is a loss cushion sized to risk. Learn CET1, risk-weighted assets, the minimums plus the buffer, and where the 2026 U.S. proposals stand.
Value at Risk (VaR) Explained: The Math, Limits & Backtesting
Value at Risk, or VaR, is the loss line on a normal bad day. Learn the math, how limit breaches differ from backtesting exceptions, and what VaR misses.
PySpark groupBy and Window Functions: Aggregations, Ranks and Running Totals (Part 2 of 3)
Part 2 of a PySpark series on Databricks: aggregate with groupBy, reconcile rollups to a known total, and rank and accumulate rows with window functions.
PySpark Data Cleaning on Databricks: Nulls, withColumn and Safe Delta Writes
Clean data with PySpark on Databricks Free Edition: select columns, filter invalid rows, handle nulls on purpose, and save a Delta table that never overwrites.
Databricks SQL Editor: Summary Tables, Charts and Query History (Part 3 of 3)
Databricks SQL Editor Part 3: save tables with CREATE TABLE AS SELECT, validate a summary table, build a bar chart, and find work in query history.
Databricks SQL Editor: SELECT, WHERE, CASE and NULLs (Part 1 of 3)
Part 1 of a Databricks SQL Editor series: run SELECT, WHERE, ORDER BY and CASE on a serverless SQL warehouse, and learn the null rules that trip people up.
Databricks Auto Loader Tutorial: Ingest Only New Files into a Bronze Delta Table
Use Databricks Auto Loader with a checkpoint and availableNow to load only new files into a bronze Delta table, rescue bad values, and prove reruns add nothing.
What Is CVA Risk? FRTB Credit Valuation Adjustment Explained
CVA is the discount for a trading partner's possible default. See how spread moves create real losses with no defaults, and what Basel and U.S. rules require.
No posts yet — check back soon.