I'm currently using SQL and Python to pull data from Oracle and Impala databases, then pushing the results into Google Sheets, which connects to Looker Studio for visualizations. While this approach works, I find it somewhat clunky and limiting, especially when I want external users to have the ability to filter the data by parameters like Client ID. I'm looking for alternatives that would allow me to publish tables and charts in a more user-friendly way, while still enabling users to run parameterized queries securely. Should I be considering tools like Streamlit or FastAPI with JavaScript? I'd love to hear what others have found effective for sharing query results!
6 Answers
If you're looking to allow users to view datasets and build visualizations without having to create everything from scratch, check out Metabase. It provides data sandboxing and is pretty user-friendly for external users. It might save you some coding time too!
If you're looking for an alternative to PowerBI, check out Evidence. It allows you to write SQL queries (mostly against DuckDB), pre-loads them for fast access, and you can create dashboards using Markdown or HTML-like syntax. Plus, it supports version control with git!
I’ve built a backend API that pulls data from SQL or files and sends it to the frontend. For filtering and running complex SQL queries, I use DuckDB with WebAssembly and some JavaScript. This way, users can interact and run queries directly in the client without worrying about backend sandboxing. It’s been a game changer for me!
Have you thought about using Power Query in Excel or PowerBI? It's designed for this kind of task and can embed the data, making sharing much easier and more efficient!
Consider Grafana as well! It's great for building dashboards and displaying data in a user-friendly format.
It really depends on your audience! Since I'm working on Big Data projects, I'm exporting tables to parquet files for researchers to load into Python for their analyses. Just a thought if your users are more technical!
Related Questions
How To: Running Codex CLI on Windows with Azure OpenAI
Set Wordpress Featured Image Using Javascript
How To Fix PHP Random Being The Same
Why no WebP Support with Wordpress
Replace Wordpress Cron With Linux Cron
Customize Yoast Canonical URL Programmatically