I'm currently using SQL and Python to query data from Oracle and Impala databases, then I push the results into Google Sheets, which feeds into Looker Studio for my dashboards. While this setup works, it feels a bit clunky, especially when I want external users to filter the data themselves, like using a Client ID. I'm looking for better alternatives that would allow me to publish tables and charts in a more user-friendly way, where users can run parameterized queries safely. Should I go with something like Streamlit or FastAPI with JavaScript? I'm interested in hearing what others have found effective for this kind of task.
3 Answers
Consider using Power Query in Excel or Power BI. It's designed for exactly this purpose. You can save the data embedded, making it easily accessible for users without a hassle.
The choice really hinges on who your audience is. For instance, I'm working with Big Data projects, so I typically export tables to parquet files that researchers can import into Python for analysis. This approach provides great flexibility for deeper data exploration.
If your main goal is to let users view datasets based on certain parameters and create dashboards, you might want to check out Metabase. It allows data sandboxing, which means users can safely interact with the data without needing to develop a complete app from scratch. It's a great option for simplifying the process!
That sounds interesting! Thanks for sharing your approach. It's cool that you're tailoring the solution to your user's needs!