Who are my top customers, and what are my top-selling products? How long is a customer faithful to the supplier or the subscribed services and service provider? Which are the most likely days to lose a customer? What are the sales for the next few periods? This chapter shows how to answer these questions using T-SQL.
6. Time-Oriented Analyses
Get Advanced Analytics with Transact-SQL: Exploring Hidden Patterns and Rules in Your Data now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.