All Projects
Data Analysis
EGX Stock Market Dashboard
A Power BI report consisting of four interactive pages connected via DirectQuery to the Hive data lake from the EGX Big Data Pipeline. It provides real-time market overview, individual symbol analysis with technical indicators (Bollinger Bands, SMA/EMA, MACD, RSI), signal screening with risk assessment, and a live ticker feed.
Gallery
Screenshots & diagrams
Architecture
How it's built
Hive Data Lake (HDFS)Power BI DirectQuery4-Page Interactive Dashboard (Market Overview, Symbol Detail, Signals & Risk, Live Ticks)
Data analyst — designed dashboard, built DAX measures for technical indicators, created interactive visuals.
Highlights
Key achievements
- 01Market Overview with KPIs, volume ranking, daily movers, and RSI distribution
- 02Symbol Detail page with Bollinger Bands, SMA/EMA overlays, MACD histogram, and RSI gauge
- 03Signals & Risk screening: RSI overbought/oversold alerts, Bollinger width, risk scatter plots
- 04Live Ticks page with real-time market status, intraday charts, and streaming ticker table
- 05DirectQuery connection to Hive for near-real-time data refresh
Stack
Technologies used
SQLSQLPythonPython