NTILE(5) OVER (ORDER BY recency_days DESC) AS r_score, NTILE(5) OVER (ORDER BY frequency_orders) AS f_score, NTILE(5) OVER (ORDER BY monetary_value) AS m_score CONCAT(CAST(s.r_score AS STRING), CAST(s ...
System size: ~1000 customers and ~10,000 orders per operator over a 12-month window. The resulting DW contains ~20,000 rows in fact_sales, ~2000 unique customers, 30 products, and 17 Syrian cities.
Yes, I would like to be contacted by a representative to learn more about Bloomberg's solutions and services. By submitting this information, I agree to the privacy policy and to learn more about ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results