# 📊 Tech Stock Analytics Dashboard (MAANG-Ready) End-to-end data analytics pipeline for **Microsoft (MSFT)**, **Apple (AAPL)**, and **Google (GOOG)** stock prices using **Python, MySQL, Azurite, Power BI, and DAX**. --- ## 🚀 Project Overview This project demonstrates a **MAANG-ready pipeline**: - **Python** → Extract stock data from Yahoo Finance using `yfinance`. - **MySQL / Azurite** → Store structured data locally. - **Pandas** → Clean & preprocess stock data. - **Power BI** → Create advanced dashboards with DAX measures, drill-throughs, and KPIs. - **SQL** → Complex queries for insights. - **DAX** → Build advanced analytics (moving averages, volatility, correlation). --- ## 🛠️ Tech Stack - **Python** (Data extraction + cleaning) - **MySQL / Azurite** (Data storage) - **Power BI Desktop** (Visualization & storytelling) - **DAX** (Advanced measures) - **SQL** (Complex queries) --- ## 📂 Project Structure