Intro

Data Analysis doesn't need to be hard. You can keep things very simple and still achieve all of the insights you need while moving fast.

This app serves as a simple demo of a lightweight approach to this. Add in DBT and Dagster and you really do have all you need. pip installable business analysis.

This is a one database analytics tool, whatever CSV you upload will end up in the same SQLite file behind the scenes.

Features

• Connect to Snowflake.
• Way to delete queries.
• Integrate DBT / smoothly work with it
• Save and load queries.
• SSO with facebook / google / azure login
• Remove the select y axis and x axis in favour of using 1st for X etc.
• Create API endpoint to return query results
• Open-source a way to create forms with streamlit
• Apply the same process / system to your QDrant UI
• Submit to Analytics Vidhya
• Should have table name as query to follow single entity convention.
• Add method to save chart config (e.g. bar vs line vs scatter)
• Do the same for a Vector Database with json queries!

A self-serve API. Written up in more depth here https://medium.com/p/cd6a9ba8a48f

BI tools like Tableau, Metabase, Mode, Looker, lightdash (and more!) offer a way to grab hold of data in different ways and illustrate its present impact.

uvicorn api:app --reload