© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2021
D. SarkaAdvanced Analytics with Transact-SQLhttps://doi.org/10.1007/978-1-4842-7173-5_6

6. Time-Oriented Analyses

Dejan Sarka1  
(1)
Ljubjana, Slovenia
 

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.

In Chapter 5, you learned the basics of time-oriented data and some advanced querying problems with this data. By the end of that chapter, you knew about moving averages. This chapter continues with ...

Get Advanced Analytics with Transact-SQL: Exploring Hidden Patterns and Rules in Your Data now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.