I Built a Financial Analysis Dashboard with Claude Code in Real-Time | Python + Dash + Plotly

🎯 Watch me build a complete financial analysis dashboard from scratch with AI assistance! In this live coding session, I work with Claude (Anthropic's AI) to create a professional web-based dashboard that analyzes 350,000+ government financial transactions from Oklahoma's FY25 Q4 ledger data. 📊 WHAT WE BUILT: • Interactive web dashboard using Python, Dash, and Plotly • Automated outlier detection with 4 different methods • Real-time data visualization with agency filtering • Statistical analysis engine processing 141MB CSV files • Professional UI with drag-and-drop file upload 🔍 KEY FEATURES: ✓ Statistical Overview (transactions, amounts, distributions) ✓ Automated Outlier Detection: - Z-Score Analysis (over 3 standard deviations) - Rare High-Value Account Detection - Round Number Pattern Recognition - Zero-Dollar Transaction Identification ✓ Interactive Visualizations: - Top Accounts & Funds Analysis - Time-Series Trends - Agency Breakdown - Transaction Distribution ✓ Dynamic Filtering by Agency 💻 TECH STACK: • Python 3.13 • Dash (web framework) • Plotly (visualizations) • Pandas (data processing) • Bootstrap (UI styling) 📈 REAL RESULTS: • Analyzed 356,845 transactions • Identified 537 statistical outliers • Detected transactions ranging from -$1.49 billion to +$1.46 billion • Found 13,432 zero-dollar transactions • Uncovered rare accounts with high values