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.
© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2021D. SarkaAdvanced Analytics with Transact-SQLhttps://doi.org/10.1007/978-1-4842-7173-5_6
6. Time-Oriented Analyses
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 ...