E-commerce data analytics and dashboard

E-commerce data analytics and dashboard (SQL and Tableau)

Tech Stack: Microsoft SQL server, Docker, Tableau
Github URL: Project Link

Analyzed a database of 9 tables consisting of 100,000 transactions, reviews, and customer data on the eCommerce platform, Olist. Created a Tableau dashboard with quick/global filters. Analyzed the impact of product descriptions on sales, the impact of shipping heavy product categories to rural areas, and the impact of delivery time on review scores using Microsoft SQL Server.