SQL-Driven-Data-Analytics

(Python+SQL)

環境設定：

1. Jupyter Notebook https://jupyter.org/
2. SQL server download https://www.microsoft.com/en-us/sql-server/sql-server-downloads
3. SQL Server Management Studio 20 https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16

課題：

1. Find the top 10 highest revenue-generating products.

2. Identify the top 3 best-selling products in each region.

3. Compare month-over-month growth between 2022~2023

4. Identify the top3 month with the highest sales for each category

5. identify the which top 5 sub category has highest growth by profit in 2023 compare to 2022