Turkiye Ecommerce Sales Dashboard

My goal in this project is to explore the data so that stakeholder could know what happen in the past 2 years in Turkiye E-Commerce activity.

From this data i am formulate several problem statement :

1. Create a query to get the total transaction per month. Please use time frame from 01 January 2021 until 31 Desember 2021.
2. Create a query to get total revenue grouped by shopping mall in 2022.
3. Create a query to get which payment method most used by customer and total revenue of each payment method 3 month before 01 January 2022.
4. Get the total_revenue of each category_variant. 1 month after 30 April 2022.
5. Find monthly growth of total_revenue in percentage breakdown by Shopping Mall, ordered by time descendingly.
6. Find from which age group the most transaction, and ratio percentage.
7. Query to ge revenue ratio percentage from total revenue in each year revenue.

and finally I presented my work through visualization using tableau, with the aim that the insights from the data are easy to read.

Here for my slide project that contain syntax SQL.