Real-Time Crypto Analytics Dashboard (with ML Forecasting)
Category
Data Analytics · ML
Date
May 2025
Client
Self-Initiated Project (Portfolio)
Objective
Track and predict crypto prices in real-time
A real-time cryptocurrency tracking and forecasting dashboard built with Python, MySQL, and Power BI. It combines live data ingestion, historical context, and machine learning predictions to help visualize and anticipate price trends.
PROBLEM STATEMENT
In the fast-moving world of cryptocurrency, every second counts. I noticed a common frustration among crypto analysts: 👉 “I can track current prices… or I can analyze historical trends… or I can run future predictions. But not all in one place — and not automatically.” That’s what inspired this project — to build a unified platform that tracks, understands, and forecasts the crypto market in real-time using ML.
MY APPROACH
he Build: From Idea to Automation -
✅ Live Tracking: CoinGecko API integration for live updates every 15 min (BTC, ETH, DOGE)
✅ Historical Data: 3+ years of crypto data stored in Supabase (PostgreSQL) cloud database
✅ Forecasting: 7-day price prediction using Facebook Prophet
✅ Smart Tagging: Tagging system to differentiate Live, Historical, Forecast data
✅ Automation & Uptime: End-to-end automation using GitHub Actions (no manual runs needed)
✅ Dashboard UI: Power BI dashboard for data visualization, filtering, and performance tracking
WHY IT MATTERS?
This project solves a real-world problem by unifying live monitoring, historical analysis, and predictive modeling in one platform. It helps:
Traders act faster with real-time updates
Analysts make data-driven decisions based on trends
Learners understand full data pipelines, end-to-end
Everything happens automatically — with zero manual intervention.
LESSONS LEARNED
What I Learned -
Built real-time data pipelines using Python & APIs
Applied ML forecasting in volatile markets (Facebook Prophet)
Managed cloud-based deployment with GitHub Actions
Designed an end-to-end system (ETL + ML + BI + Automation)
Understood forecasting accuracy metrics and error handling
FEATURES HIGHLIGHTS
Key Features At a Glance
✔️ Live price updates every 15 min
✔️ 7-day future forecasting (Prophet)
✔️ 3+ years of historical data
✔️ Smart data source tagging (Live / Historical / Forecast)
✔️ Top gainers & losers
✔️ Forecast accuracy vs actual prices
✔️ Cloud-deployed backend (GitHub actions)
✔️ Filterable dashboard (coin, date, type)
TECH STACK
GIT LINK
GitHub Repository
LINK
From raw data to live decisions — this dashboard is my blueprint for building real-time, AI-powered analytics.
