AI|BI Tools

It not just about old school BI Tools, or the well known propietary ones like Looker or PBi

Today, we will have a look to:

• ChartDB: A database diagrams editor that lets you visualize and design your database with a single query.
• Quix (wix-incubator): A powerful, open-source platform for data exploration and analysis.
• Querybook: Pinterest’s open-source big data ad-hoc query and visualization tool.
• Quix Streams: A Python library designed for building real-time data streaming applications.

ChartBrew

• https://github.com/chartbrew/chartbrew
  • https://docs.chartbrew.com/deployment/run-on-docker#run-on-docker
  • https://raw.githubusercontent.com/chartbrew/chartbrew/refs/heads/master/docker-compose.yml

Open-source web platform used to create live reporting dashboards from APIs, MongoDB, Firestore, MySQL, PostgreSQL, and more 📈📊

Which resonates with my recent post on BI Tools

ChartDB

I thought everything was done with LangChain querying DBs with LLMs in DAG mode.

Then I found this:

• https://github.com/chartdb/chartdb

agpl 3 | Database diagrams editor that allows you to visualize and design your DB with a single query.

DB2Rest

• https://github.com/9tigerio/db2rest

Apache v2 | Instant no code DATA API platform. Connect any database, run anywhere. Power your GENAI application function/tools calls in seconds.

Conclusions

PyGWalker

You can also have a look to a killer combi: Streamlit x pygwalker

Give the users a webapp that they can play with tables / graph that does not require huge development!

If you want to use actively AI to develop the dashboarding, consider LLM x Streamlit:

As can also render mermaidJS and plotly graphs with your aissistant, via streamlit webapp

Other D&A Tools

• https://github.com/wix-incubator/quix
• https://github.com/pinterest/querybook
• https://github.com/quixio/quix-streams
  • https://quix.io/templates/ai-customer-support