Analyze Your Data

Interactive data analysis and visualization — all in your browser

---

A free, open-source tool for interactive data analysis and visualization. Upload your data, explore it in a powerful grid, build charts, and export dashboards — no account needed, no data stored on the server.

Whether you're a data analyst exploring a dataset, a manager reviewing monthly reports, or a student working on a project — this tool gives you a full analysis workflow without installing anything or writing a single line of code.

🚀 How It Works

Step	What you do
1. Load	Drag & drop a file, paste a Google Sheets link, or connect to Airtable
2. Explore	Sort, filter, group, and pivot your data in an enterprise-grade AG Grid table
3. Visualize	Pick from 13 chart types, configure up to 3 independent charts
4. Connect	Filter data in the grid — all charts update in real-time
5. Export	Download charts as interactive HTML, or export grid data to CSV/Excel

💡 The core power: Grid and charts are always in sync. Every filter, sort, or group action updates all charts instantly. Right-click the grid to export the exact data you see.

📁 Supported Data Sources

📤 Direct Upload	Excel .xlsx .xls · CSV .csv .txt .log · JSON · Parquet · HDF5 · SQLite .db .sqlite
📊 Google Sheets	Paste a public sharing link, optionally specify a sheet GID
🔗 Airtable	Connect with a Personal Access Token and Base ID

📈 13 Chart Types

Scatter · Scatter (multi-Y) · Line · Bar (grouped) · Bar (stacked) · Histogram (grouped) · Histogram (stacked) · Pie · Bubble · Heatmap · Logarithmic · Sunburst · Icicle

Each chart is independently configurable with custom axes, colors, titles, and Z-axis parameters. Download individual charts or a combined dashboard as standalone interactive HTML files.

🕐 Datetime Intelligence

If your data contains a datetime column, the tool automatically generates useful time-based columns — year, month, day, weekday, calendar week, hour, and more. Group and chart by time periods without any manual preparation.

🌍 Available in 15 Languages

🇬🇧 English · 🇨🇿 Čeština · 🇩🇰 Dansk · 🇩🇪 Deutsch · 🇪🇸 Español · 🇫🇷 Français · 🇭🇷 Hrvatski · 🇮🇹 Italiano · 🇳🇱 Nederlands · 🇵🇱 Polski · 🇵🇹 Português · 🇸🇰 Slovenčina · 🇸🇮 Slovenščina · 🇸🇪 Svenska · 🇺🇦 Українська

Each language runs as an independent Docker container with fully translated UI, tooltips, and documentation.

🔒 Data Privacy

Your uploaded data stays in your browser session memory and is never stored on the server. No file contents, column names, or data values are logged. Closing the browser tab clears everything.

We only store voluntary feedback submissions and anonymous usage analytics (event types, file formats, row counts — never actual data). See PRIVACY.md for the full policy.

🔍 Build Transparency

Every deployment includes a git commit hash visible in the footer, linking directly to the source code on GitHub. The /api/version endpoint returns the exact commit running in production — anyone can verify that the deployed app matches this public repository.

🛠️ Tech Stack

Component	Version	Purpose
Plotly Dash	4.0.0	Web framework
AG Grid Enterprise	33.3.3	Interactive data grid
Pandas	3.0.0	Data processing
Plotly	6.0.0+	Chart rendering
MongoDB	—	Usage analytics
Gunicorn	23.0.0+	Production WSGI server

Architecture: One Docker container per language, routed via Cloudflare Tunnel subdomains. All containers share the same codebase — differentiated only by the APP_LANGUAGE environment variable.

🐳 Self-Hosting

git clone https://github.com/zboardio/analyzeyourdata.git
cd analyzeyourdata
cp .env.example .env    # configure your settings
docker compose up       # starts all language instances

You'll need an AG Grid Enterprise license and optionally a MongoDB connection for analytics. See .env.example for the full configuration reference.

🤝 Contributing

Contributions are welcome! The project uses Python 3.12+, Dash 4.0.0, and follows a modular callback architecture.

pip install -r requirements.txt
pip install pre-commit && pre-commit install  # enables gitleaks secret scanning on commits
python app.py  # starts on http://127.0.0.1:8050

See docs/ for the full developer reference — project structure, callback patterns, environment variables, and i18n system.

⚠️ Known Limitations

• Microsoft SharePoint / OneDrive — Microsoft has disabled unauthenticated access to the OneDrive sharing API. Direct loading from SharePoint/OneDrive links is no longer supported. Download the file and use Direct File Upload instead.
• Airtable — Requires a Personal Access Token with data.records:read and schema.bases:read scopes.

📄 License

This project is licensed under the MIT License.

---

Developed with care and respect to the time of others by zboardio