Using complex SQL queries to answer specific business questions. Notably using multiple named subqueries, views to extract data from a database to address specific problems.
We will be using the Chinook database which is provided as a SQLite database file called chinook.db to answer some business questions. The database schema in PDF can be downloaded SQLite Sample database schema(diagram). The color version is found at SQLite Sample database schema(color).
You are a Data Analyst at Northwind Traders, an international gourmet food distributor. Management is looking to you for insights to make strategic decisions in several aspects of the business. The projects focus on:
- Evaluating employee performance to boost productivity,
- Understanding product sales and category performance to optimize inventory and marketing strategies,
- Analyzing sales growth to identify trends, monitor company progress, and make more accurate forecasts,
- And evaluating customer purchase behavior to target high-value customers with promotional incentives.
Using the PostgreSQL window functions on the Northwind database, you will provide these essential insights to management, contributing significantly to the company's strategic decisions.
This project focuses on the rich Northwind database, which provides a real-world-like platform for exploring and analyzing sales data.