Metadata-Version: 2.1
Name: streamlit-business-intelligence
Version: 0.0.3
Summary: Python library for SQL Data Analysis
Home-page: https://github.com/GeorgePearse/streamlit-projects/tree/master/streamlit-bi
Author: George Pearse
Author-email: georgehwp26@gmail.com
License: MIT
Classifier: Development Status :: 3 - Alpha
Classifier: Intended Audience :: Developers
Classifier: Topic :: Software Development
Classifier: License :: OSI Approved :: MIT License
Classifier: Operating System :: OS Independent
Classifier: Programming Language :: Python :: 3.6
Description-Content-Type: text/markdown

# 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 
- [x] Save and load queries.
- [ ] SSO with facebook / google / azure login
- [x] Remove the select y axis and x axis in favour of using 1st for X etc.
- [x] 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
```
