Adventure Works Analysis With Stored Procedures,Streamlit, plotly

This projects seeks to analyse the AdventuresWorks sample data using of Stored Procedures in MS SQL and Python for data analysis. I also used streamlit to create a web app that displays the visualisations

Intallations

Kindly install the neccessary packages by running "pip install -r requirements.txt" and then ensure that your sample MS SQL Server AdventureWorks database is configured, run the sql script (adventured works.sql) to create the stored procedures that were used in this project