How morgan-jo/end2end-da-project works
This repository is a portfolio of three finance projects: an expense-tracking web app, an FX rates insight hub, and a stock-price analysis pipeline. The principal workflows run from user input or market-data retrieval through persistence and analysis to web views or dashboard-ready exports. The root README describes a broader analytics lifecycle; the map reflects the capabilities supported by the available tree and sampled source. The stock and FX app internals are only partially sampled, so uncertain connections are omitted.
Main entry points: pennywise/app.py Expense Web Routes · stock-market-price-explore/app.py Price Analysis Pipeline · fetch_fx.py Rate Fetcher · fx_database.py FX Database Access
Components 24
Expense Tracker
- Expense Web Routes
Finance & Banking/pennywise/app.py - Account Auth
Finance & Banking/pennywise/app.py - Expense Records
Finance & Banking/pennywise/app.py - Monthly Dashboard
Finance & Banking/pennywise/app.py - Expense Database
Finance & Banking/pennywise/instance/pennywise.db - Expense Views
Finance & Banking/pennywise/templates
FX Insights
- Rate Fetcher
Finance & Banking/real-time-fx-insight-hub/fetch_fx.py - FX Database Access
Finance & Banking/real-time-fx-insight-hub/fx_database.py - FX Rates Database
Finance & Banking/real-time-fx-insight-hub/data/fx_rates.db - Daily FX Analysis
Finance & Banking/real-time-fx-insight-hub/eda_fx.py - FX Analysis Exports
Finance & Banking/real-time-fx-insight-hub/data/fx_rates_daily.csv - Converter Web App
Finance & Banking/real-time-fx-insight-hub/app.py - Converter View
Finance & Banking/real-time-fx-insight-hub/templates/index.html - FX Tableau Workbook
Finance & Banking/real-time-fx-insight-hub/tableau/FX Volatility Overview.twb
Stock Analysis
- Price Analysis Pipeline
Finance & Banking/stock-market-price-explore/app.py - Analysis Settings
Finance & Banking/stock-market-price-explore/config.py - Market Data Database
Finance & Banking/stock-market-price-explore/market_data.db - Tableau Data Exports
Finance & Banking/stock-market-price-explore/data/price_data_for_tableau.csv - Stock Tableau Workbook
Finance & Banking/stock-market-price-explore/stock_market_insights.twb
Other components
- Expense User
- Pipeline Operator
- Open Exchange Rates
- Pipeline Operator
- Yahoo Finance
Connections 24
- Expense User → Expense Web Routes: submits requests
- Expense Web Routes → Account Auth: routes auth
- Expense Web Routes → Expense Records: routes expenses
- Expense Web Routes → Monthly Dashboard: routes dashboard
- Account Auth → Expense Database: reads and writes
- Expense Records → Expense Database: reads and writes
- Monthly Dashboard → Expense Database: reads records
- Expense Web Routes → Expense Views: renders pages
- Pipeline Operator → Rate Fetcher: runs pipeline
- Rate Fetcher → Open Exchange Rates: fetches rates
- Rate Fetcher → FX Database Access: stores rates
- Rate Fetcher → FX Database Access: exports history
- FX Database Access → FX Rates Database: reads and writes
- Daily FX Analysis → FX Database Access: reads rates
- Daily FX Analysis → FX Analysis Exports: writes daily data
- Converter Web App → FX Rates Database: reads latest rates
- Converter Web App → Converter View: renders converter
- FX Tableau Workbook → FX Analysis Exports: uses analysis data
- Pipeline Operator → Price Analysis Pipeline: runs pipeline
- Price Analysis Pipeline → Yahoo Finance: downloads prices
- Price Analysis Pipeline → Analysis Settings: loads settings
- Price Analysis Pipeline → Market Data Database: writes price data
- Price Analysis Pipeline → Tableau Data Exports: exports curated data
- Stock Tableau Workbook → Tableau Data Exports: uses analysis data