Northwind Traders

• Tech Stack: SQL , R , Jupyter Notebook
• Github URL: Project Link

Used R to pull out Data from SQL database. The project consists of querying The northwind database to find : The top food category , top 10 most sold products , which products should be ordered immediately among other questions that I have answered using this data.

Practised SQL joins by joining different tables.

Practised the Group By & Order By & Where Clauses

Used CASE statements to analyze the reordering urgence of the different products.