This project encompasses the complete data lifecycle, from data extraction and transformation to in-depth analysis and compelling visualizations. The process is divided into three main phases

Designing a star schema data warehouse based on the Northwind database and implementing the ETL process using the SSIS tool.

A simplified introdocutory data analysis report to show how using SQL queries can answer questions from a data warehouse with a star schema. The report answers why server downtime happens and how it can be fixed.

Staging and de-normalized data warehouse tables, in a star schema, with a date table, dimension and fact tables designed for data analysis.

This project documentation was developed as a free project, as a data analyst from the fictional company Sell Boardgames would do in his daily work.

This repository presents a comprehensive SQL project, beginning with Data Warehousing, followed by Exploratory Data Analysis (EDA), and culminating in Advanced Analytics. Throughout the project, SQL Server Management Studio (SSMS) was used to design, query, and manage the entire workflow.