What This App Does
#Connect to databases and perform advanced analytics directly in Excel:
- Connect to PostgreSQL/MySQL databases via FastAPI
- Explore tables, run custom SQL queries
- Statistical analysis and exploratory data analysis (EDA)
- Build ML models with XGBoost classifier
- Decile tables, ROC curves, gains charts
- Model scoring and evaluation metrics
Important Note
The ML pipeline demonstrates capabilities - it is not a point-and-click app. For new datasets, work iteratively with an AI coder to adapt the script.
How to Use
#- Download & Install: get the app and install xlwings Lite
- Configure Database: update connection credentials in the MASTER sheet
- Built-in Functions:
list_tables- list all database tablesget_custom_query- run SQL queriesperform_eda- exploratory data analysisscore_and_deciles- XGBoost + decile tables
How It Works
#Database Connectivity
- FastAPI server handles database connections
- API requests connect to PostgreSQL/MySQL
- Responses returned to Excel for processing
ML Processing
- All processing occurs locally in xlwings
- XGBoost runs directly in the browser environment
- Generates charts and tables for analysis
