Cart Abandonment Analysis: 4 Useful SQL Queries
I add things to my cart and change my mind too, and it turns out businesses can measure exactly where that happens. Here is how I explored cart abandonment analysis with SQL and a dashboard.
SQL & Data Analysis
SQL Window Functions Explained: 7 Powerful Techniques (With a Live Demo)
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 »
