Global Market Insight
A comprehensive financial analytics platform analyzing 21 major global companies. From automated ETL pipelines to interactive dashboards and predictive reports.
Key Platform Features
Automated ETL Pipeline
Daily data refresh via GitHub Actions with error handling and logging
Interactive Dashboards
Real-time visualization with filtering, comparison, and trend analysis
Analysis Report
Stock price trend forecasting integrating Technical Analysis, Quantitative Analysis, and ML models (XGBoost, Scikit-Learn)
Interactive SQL Queries
8+ analytical queries with runnable examples and downloadable results
CI/CD Automation
Scheduled workflows for data processing, testing, and deployment
Data Architecture Flow
yFinance API
Real-time financial data for 21 global companies
1. Fetch Data
Extract raw financial data via Python scripts
2. Clean & Transform
Process data and calculate 15+ financial ratios
CSV Files
Dashboard data - refreshed daily via GitHub Actions
MySQL Database
Full financial data - historical records & SQL queries
Interactive Dashboards
Real-time visualizations powered by CSV files
Analytical Reports
In-depth analysis based on data exported from MySQL
SQL Queries
Analytical queries
Companies by Sector
21 major global companies across 6 key market sectors
Technology
AAPL, MSFT, GOOGL, NVDA, ADBE, META
Financial Services
JPM, V, MA, PYPL, BAC
Healthcare
JNJ, UNH
Consumer Cyclical
TSLA, HD, AMZN
Consumer Defensive
KO, PG, WMT
Entertainment
DIS, NFLX
Technology Stack
Modern tools and frameworks powering the analytics platform
Python
ETL pipelines, data processing, machine learning models
MySQL
Relational database for structured financial data
HTML5/CSS3
Responsive web interface & dashboards
JavaScript
Interactive visualizations & UI components
GitHub Actions
CI/CD automation & scheduled pipelines
yFinance API
Real-time financial data extraction
Explore the Complete Codebase
Access the full repository containing Python ETL scripts, SQL schemas, interactive dashboards, machine learning models, and automated workflows.
View on GitHub