Advanced SQL Recipes to jump start your Analysis
This is a compendium of Advanced SQL tricks meant to serve as a reference for data analysts. There's no particular order to reading these recipes – each one starts with an applicable business case. Start with the most pressing business decision you are facing, and solve it by using the SQL recipe as a template.
Our goal is to make this the most comprehensive and insightful resource on the internet. We ensure that new recipes continue to be insightful based on the experience working with our agency clients.
You will learn – bucketing, finding outliers, calculating correlations, budgeting & forecasting, return on spend and investment, data smoothing and cleaning applied to freemium, transactional, advertising, two-sided marketplace and subscription based business models.
Here's a list of what we have so far, and we'll be adding to our library over time:
- Calculating Running Total
- Smoothing Data
- Calculations Per Group
- Growth Rates
- Summarizing Data
- Ranking your Best and Worst Customers
- Calculating N-tiles (quartiles, deciles and percentiles)
- Calculating Z-Score
- Predicting the Future
- Database compatibility
- Data Cleansing (aka "Wrangling")
Business Model Analysis
Comparing Means with Statistical Testing (coming soon!)
- Calculating Median (coming soon!)
- Calculating Rank (coming soon!)
- Calculating n-grams (coming soon!)
- String Parsing (coming soon!)
- Full text search and text mining (coming soon!)
- Calculating Funnel drop-off (coming soon!)
- Calculating Marketing Channel Attribution Coefficients (coming soon!)
- Cohort charts for Retention Analysis (coming soon!)
- JSON document stores (coming soon!)
- EXPLAIN ANALYZE (coming soon!)
- Pivoting and Unpivoting data (coming soon!)
- Intrusion Dection with IP addresses (coming soon!)
- Nested data types (coming soon!)
- GIS/Spatial queries (coming soon!)
- Recursive queries (coming soon!)
- Correlated and Uncorrelated subqueries (coming soon!)
Please reach out with your feedback and suggestions!
No spam, ever! Unsubscribe any time.