Skip to main content

🚛 Advanced US Freight Analytics Dashboard

🎯 Overview

An interactive, data-driven dashboard for comprehensive analysis of US freight transportation patterns across rail and port modes. This enhanced visualization platform provides deep insights into seasonal trends, performance metrics, and predictive analytics for freight transportation.

🚀 Enhanced Features

✨ Professional UI/UX

  • Modern, responsive design with custom CSS styling
  • Interactive metric cards and KPI displays
  • Mobile-friendly layouts

📊 Advanced Analytics

  • Multi-Modal Analysis: Compare rail and port freight transportation
  • Seasonal Decomposition: Deep dive into seasonal patterns
  • Trend Analysis: Statistical trend detection with R-squared values
  • Predictive Insights: Moving averages and anomaly detection
  • Interactive Heatmaps: Correlation analysis between variables

🗺️ Enhanced Geospatial Visualization

  • Interactive port location maps with volume bubbles
  • Regional analysis by coast (Atlantic, Pacific, Gulf)
  • Geographic performance distribution

📈 Advanced Chart Types

  • Sunburst charts for hierarchical data
  • Interactive heatmaps with hover details
  • Time series with statistical trend lines
  • Growth rate analysis with year-over-year comparisons
  • Capacity utilization indicators

📂 Project Structure

DashBoard/
├── 📱 streamlit_app.py          
├── 📋 requirements.txt           
├── 📖 README.md                 
├── 📜 LICENSE                  
├── 🔧 .gitignore            
├── 🛠️ setup.py                 
├── 📝 CHANGELOG.md             
├── 🤝 CONTRIBUTING.md          
├── 🔐 SECURITY.md              
├── 🚀 run_dashboard.bat        
├── 📊 Data/                    
│   ├── Rail_Carloadings_originated.csv    
│   └── port_dataset.json                  
├── 📁 Script/                  
│   ├── enhanced_dashboard.py              
│   ├── dash_water_rail.py                
│   └── test_dashboard.py               
├── ⚙️ .vscode/                
├── 🐳 .devcontainer/         
└── 🔄 .github/                
    ├── workflows/
    │   └── ci.yml             
    └── ISSUE_TEMPLATE/
        ├── bug_report.yml      
        └── feature_request.yml 

🎨 Dashboard Sections

1. 🚆 Rail Analytics

  • Overview: Trend analysis with statistical insights, interactive heatmaps
  • Seasonal Analysis: Sunburst charts, year-over-year seasonal comparisons
  • Trend Analysis: Growth rate calculations, performance tracking
  • Predictive Insights: Moving averages, anomaly detection

2. 🚢 Port Analytics

  • Overview: Interactive maps, time series comparisons
  • Performance Metrics: Capacity utilization, regional analysis
  • Seasonal Patterns: Coast-based seasonal analysis
  • Growth Analysis: Port ranking and performance trends

3. 📊 Comparative Analysis

  • Multi-Modal Comparison: Rail vs Port volume analysis
  • Market Share Evolution: Modal share tracking over time
  • Conversion Analytics: TEU equivalent calculations
  • Strategic Insights: Mode-specific advantages analysis

🛠️ Technical Features

Performance Optimizations

  • @st.cache_data for efficient data loading
  • Progressive loading for large datasets

Advanced Libraries

  • Plotly: Interactive charts with hover details
  • SciPy: Statistical analysis and trend detection
  • Pandas
  • NumPy

🚀 Quick Start

📦 Package Installation (Recommended)

# Install from PyPI (when published)
pip install freight-analytics-dashboard

# Launch dashboard immediately  
freight-dashboard

# Custom configuration
freight-dashboard --port 8502 --host 0.0.0.0

# Get help
freight-dashboard --help

🌐 Live Demo

View Live Dashboard on Streamlit Cloud 🔗

💻 Local Development

Option 1: From Package Source

# Clone the repository
git clone https://github.com/meghkc/DashBoard.git
cd DashBoard

# Install in development mode
pip install -e .

# Launch via CLI
freight-dashboard

Option 2: Direct Streamlit

# Clone and navigate
git clone https://github.com/meghkc/DashBoard.git
cd DashBoard

# Create virtual environment (recommended)
python -m venv venv
source venv/bin/activate  # Windows: venv\Scripts\activate

# Install dependencies
pip install -r requirements.txt

# Run the main dashboard (Streamlit Cloud compatible)
streamlit run streamlit_app.py

Option 3: One-Click Launch (Windows)

# Double-click the launcher
run_dashboard.bat

🐳 Container Deployment

# Docker
docker build -t freight-dashboard .
docker run -p 8501:8501 freight-dashboard

# Or use pre-built image (when available)
docker run -p 8501:8501 meghkc/freight-analytics-dashboard

☁️ Cloud Deployment

  • Streamlit Cloud: Fork repo → Connect GitHub → Deploy
  • Heroku/Railway/Render: Direct deployment support via Procfile
  • Any Python hosting: Install package and run freight-dashboard
## 📊 Data Sources & Specifications

### **Rail Dataset**
- **Source**: USDA Agricultural Transportation
- **Timespan**: 2017-2023 (7 years)
- **Key Metrics**: Carloads by railroad, commodity, and time

### **Port Dataset**
- **Source**: Individual port authority websites
- **Coverage**: 9 major US container ports
- **Timespan**: 2018-2024
- **Key Metrics**: TEU (Twenty-foot Equivalent Units)

## 🎯 Analytics Features

### **KPI Dashboard**
- Total freight volume metrics
- Growth rate calculations
- Peak performance indicators
- Operational efficiency metrics

### **Data Insights**
- Anomaly detection alerts
- Seasonal pattern recognition
- Performance benchmarking
- Trend significance testing

### **Export Capabilities**
- Data download options
- Chart export functionality
- Report generation ready

## 👨‍💻 Technical Specifications

### **System Requirements**
- Python 3.8+
- 4GB RAM minimum
- Modern web browser
- Internet connection for maps

### **Dependencies**

streamlit >= 1.48.0
pandas >= 1.5.0
plotly >= 5.0.0
scipy >= 1.9.0
scikit-learn >= 1.1.0
seaborn >= 0.11.0
numpy >= 1.21.0

## 🔗 Links & Resources

- **Data Source (Rail)**: [USDA Agricultural Transportation](https://agtransport.usda.gov/stories/s/appm-bhti)
- **Data Source (Ports)**: Individual port authority websites
- **Framework**: Built with Streamlit
- **Visualization**: Powered by Plotly
- **Author**: Megh KC | Created 2024 | Enhanced 2025

---

Release files for freight-analytics-dashboard 1.0.0

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for freight-analytics-dashboard 1.0.0
File Size Uploaded
freight_analytics_dashboard-1.0.0.tar.gz 1.4 MB Details

Built distribution (wheel)

Table of built distributions (wheels) for freight-analytics-dashboard 1.0.0
File Interpreter ABI Platform
freight_analytics_dashboard-1.0.0-py3-none-any.whl Python 3 none any Details

Total release size: 2.1 MB

Release files / freight_analytics_dashboard-1.0.0.tar.gz

Download URL freight_analytics_dashboard-1.0.0.tar.gz
Size 1.4 MB
Tags Source
SHA-256 checksum
How to use checksums
84cc75aa88619df2f931563cf11d0ef375d49e473690dd00f7688016b2731b1d
BLAKE2b-256 checksum
How to use checksums
381d21f1024b0f05b992f867fc3ad34530a6348022fedfdd6b3b8bfbe7d1a7ab
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/6.1.0 CPython/3.13.5

Release files / freight_analytics_dashboard-1.0.0-py3-none-any.whl

Download URL freight_analytics_dashboard-1.0.0-py3-none-any.whl
Size 685.8 kB
Tags Python 3
SHA-256 checksum
How to use checksums
cd590ce9e8a9643291e1cdca042a74277f5add278e6006d92dc3705f9989eed7
BLAKE2b-256 checksum
How to use checksums
cd4afe05101efbba5b3203641a9dab5e7976d82118efe78aa9b27e46210f7f4e
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/6.1.0 CPython/3.13.5

Release history Release notifications | RSS feed

This release

1.0.0 This release

2 release files

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page