Northwind Company Analysis Using SQL

This repository is one of mini project that i do when participating in Data Consultant Bootcamp 2023 conducted by Data Science Indonesia

📙 Table Of Contents

• 📂 Dataset
• 🎯 Objective
• 💻 Tools
• 💹 Output

📂 Dataset

The Northwind database is a sample database used by Microsoft. The database contains the sales data for Northwind Traders, a fictitious specialty foods export import company. To see SQL script of this dataset, click here

🎯 Objective

The objective is to analyze the northwind company business activities in these perspective :

• Sales Analysis
• Product Analysis
• Customer Analysis

💻 Tools

• ETL - Microsoft SQL Server Management Studio
• Visualization - Looker Studio (Google Data Studio)
• Flowchart - drawio

💹 Output

• Analysis Report
• Visualization Dashboard
  • Sales Analysis Dashboard
  • Product Analysis Dashboard
  • Customer Analysis Dashboard