Revenue is up about 15%, but why? A beginner-friendly revenue analysis in SQL on the Brazilian Olist dataset that splits growth into volume, price, and mix, with real outputs and a business recommendation.
Revenue Grew 15% Last Quarter: Was It Volume, Price, or Product Mix? Read Post »
A working set of 75 ecommerce and marketing analytics interview questions, each with a model answer and SQL query built against one shared practice schema, from business fundamentals through advanced SQL and statistics.
75 Ecommerce and Marketing Analytics Interview Questions (With Model SQL and Answers) Read Post »
RANK() and DENSE_RANK() appear practically identical until you reach a tie, and that single difference causes more SQL interviews than anything else. Here’s an interactive description of each of the 7 window function strategies, along with a live demo you can try yourself.
SQL Window Functions Explained: 7 Powerful Techniques (With a Live Demo) Read Post »
