AdventureWorks-Python-SQL-Streamlit

Data cleansing, analysis and dashboard using SQL and Python language. Data visualization using Streamlit library.

The project goal was to present, on a dashboard, 4 indicators obtained with the dataset AdvetureWorks2019 updated:

1. Total Internet Sales by Category
2. Total Internet Sales by OrderDate Month
3. Total Internet Sales Amount vs Cost by Country
4. Total Internet Sales by Gender

With the possibility of filtering it by year, country, gender and category

SQLSERVER: Updating database

Python Code:

• Queries to access and filter database
• Streamlit library to setup the dashboard
• Plotly.access library to create the charts

Libraries needed to run the code:

• SQLAlchemy
• Pandas
• Streamlit
• Plotly

Datasets used:

Dataset: https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver16&tabs=ssms

Data Update code: https://github.com/techtalkcorner/SampleDemoFiles/blob/master/Database/AdventureWorks/Update_AdventureWorksDW_Data.sql