How tandah-marcelle/pipeline-etl-dashboard-finance-market works
Finance Market Analytics is a notebook-based market-data ETL project paired with a Power BI dashboard. The documented workflow ingests stock-index prices and EUR/USD rates, transforms them into analytical measures and a star-schema model, then presents interactive historical trends and filters. The tree contains the notebook, raw rate snapshots, a stock-index CSV, and the Power BI file. Source excerpts were unavailable, so stage wiring follows README claims; database implementation details and specific notebook calls cannot be verified.
Main entry points: Pipeline_ETL_Finance_Market.ipynb ETL Notebook · BI_Pipeline_ETL_Finance_Market.pbix Power BI Report · Stock_Market_Index.csv Stock Indices · raw FX Rate Snapshots
Components 7
ETL Pipeline
- ETL Notebook
Pipeline_ETL_Finance_Market.ipynb - Market Data Model
Pipeline_ETL_Finance_Market.ipynb - Market Metrics
Pipeline_ETL_Finance_Market.ipynb
Market Data
- Stock Indices
Stock_Market_Index.csv - FX Rate Snapshots
data/raw
Analytics Dashboard
- Power BI Report
BI_Pipeline_ETL_Finance_Market.pbix
Other components
- Analyst
Connections 6
- ETL Notebook → Stock Indices: reads
- ETL Notebook → FX Rate Snapshots: reads
- ETL Notebook → Market Data Model: transforms
- ETL Notebook → Market Metrics: calculates
- Power BI Report → Market Data Model: models
- Analyst → Power BI Report: explores