When creating our data science solutions, the data that we want to use in these tasks should be explored carefully. As we learned in Chapter 5, Data Transformation and Cleansing with T-SQL, when data is loaded into a desired format, we need to find the distributions and patterns within it. We should also use data exploration during the staging process to check and improve data quality.
In this chapter, we will learn how to use T-SQL language to get statistical results from our data. To do this, we will use the following techniques:
- T-SQL aggregate queries: This section explains what the aggregate query is and which statistical measures it can show.
- Ranking, framing, and windowing with T-SQL: Using framing and windowing helps to obtain results enriched by sorting or ranking. In this section, we will play with framing and windowing from...
