SQL Project – Unveiling Insights into Northwind Traders

Project Goal: Analyze sales data from the Northwind Traders PostgreSQL database to enhance strategic decision-making across various business areas

Project Outcome: Evaluated employee performance, identified high-value customers, and tracked monthly company progress to aid in forecasting. Also identified top-selling categories and the top three products in each category, providing essential insights for inventory and marketing strategies

Project Methods: Connected to the Northwind database, retrieved and combined data from various tables, ranked employees by sales performance, categorized customers, calculated monthly sales growth rates, computed sales percentages for each product category, and ranked products within each category