Prithu Verma

Company Data Analysis on Databricks

Nearly 12 million company records from People Data Labs, processed with PySpark and Spark SQL on Databricks and presented in a Databricks dashboard: 11.7M companies across 149 industries, broken down by country and size.

• PySpark
• Spark SQL
• Databricks
• Pandas

Health Insurance Claim Analysis

750,000+ synthetic healthcare records generated with Faker, pushed through an ETL pipeline into 6 normalized MySQL tables, then queried for trends in claim costs, approval rates, providers and patient utilization.

• Python
• SQL
• SQLAlchemy
• ETL Pipeline

Stock Portfolio Analytics

A 6-table PostgreSQL schema fed by a yfinance ETL pipeline, with 15+ advanced SQL queries computing returns, volatility, Sharpe ratio and position-level P&L, surfaced through an interactive Streamlit dashboard.

• Python
• PostgreSQL
• ETL Pipeline
• Streamlit
• yfinance

Business Analysis Dashboards

Three end-to-end Power BI dashboards across banking, toy retail and superstore data: 30+ interactive visuals, reusable DAX measures, and drill-throughs that take you from headline KPIs to the detail behind them.

• Power BI
• DAX
• Power Query

BBD and Tax Loopholes

26 September 2026 · 6 min read

How the ultra-wealthy use Buy, Borrow, Die to grow their fortunes while paying almost no tax: borrowing against appreciating assets instead of selling, then passing them on with a stepped-up basis.

• Finance
• Billionaires
• Economics
• Wealth

Stock Market Crash

19 September 2026 · 4 min read

What actually causes a stock market crash, from recessions and inflation to bubbles and panic selling, and the indicators that tend to show up before one.

• Recession
• Finance
• Stock Market Crash
• Stock Market
• Economics

Game Theory: Backward Induction and the Endgame Problem

19 September 2026 · 2 min read

Reasoning backwards from the last move, and why cooperation collapses all at once the moment players know exactly when a repeated game ends.

• Strategy
• Game Theory
• Human Behavior

Bonds and Debentures

18 September 2026 · 5 min read

How bonds and debentures work: face value, coupons, maturity, premiums and discounts, and how the two differ in security, risk and liquidity.

• Finance
• Money
• Investing

Game Theory: Tit-for-tat

8 September 2026 · 2 min read

Why repeating the Prisoner's Dilemma changes everything, and how a simple strategy, cooperating first and then copying your opponent, makes cooperation last.

• Strategic Thinking
• Cooperation
• Game Theory
• Human Behavior

Freeports and Wealth Tricks

8 September 2026 · 4 min read

Tax-free warehouses in Geneva, Luxembourg and Singapore where art, gold and wine sit legally "in transit", and how billionaires use them for tax avoidance and secrecy.

• Tax Avoidance
• Billionaires
• Strategy
• Wealth
• Money

Data Warehousing, from OLTP to the Modern Cloud Stack

1 September 2026 · 16 min read

A study guide built in three days with Claude, NotebookLM, ChatGPT and Perplexity: OLTP vs OLAP, star and snowflake schemas, fact and dimension types, grain, surrogate keys, SCDs, data marts, and why ELT won.

• Data Warehousing
• ETL
• OLAP
• SQL
• Data Engineering

PySpark for Data Engineers: The Docs, Distilled

30 August 2026 · 11 min read

I read the entire PySpark documentation so you don't have to. The parts that matter for data engineering: DataFrames, types, cleaning, transformations, joins, file formats and ANSI mode.

• PySpark
• Apache Spark
• Databricks
• Data Engineering

PE and PB Ratio

24 August 2026 · 3 min read

Using price-to-earnings and price-to-book ratios to judge whether a stock is overvalued or undervalued, and what a low or high ratio can really mean.

• Investing
• Finance
• Stocks
• Corporate Finance

Game Theory: Nash Equilibrium

19 August 2026 · 2 min read

The central idea of game theory: a state where no player can do better by changing only their own strategy, and why every finite game has one.

• Game Theory
• Strategy
• Human Behavior
• Leadership

Game Theory: Prisoner's Dilemma

14 August 2026 · 3 min read

The most famous scenario in game theory, and the gap it exposes between what is best for an individual and what is best for the group.

• Game Theory
• Cooperation
• Human Behavior
• Strategy

NPV and IRR

13 August 2026 · 3 min read

Net Present Value and Internal Rate of Return, built on the time value of money: discounting future cash flows to decide whether an investment is worth it.

• Money
• Corporate Finance
• Budgeting
• Finance