Enterprise Sales Star Schema Analytics in MySQL: 5-Table Fact/Dimension Model, Subqueries, and Advanced Window Functions (RANK, PARTITION BY)
-
Updated
Oct 18, 2026
Enterprise Sales Star Schema Analytics in MySQL: 5-Table Fact/Dimension Model, Subqueries, and Advanced Window Functions (RANK, PARTITION BY)
100+ SQL problems on Subqueries & Window Functions to master Data Analyst interview concepts.
Exploratory analysis of a global layoffs dataset using MySQL, covering company, time, country, industry, funding stage, and yearly ranking analysis with CTEs and window functions.
To associate your repository with the partition-by topic, visit your repo's landing page and select "manage topics."