SQL for Data Analysis

This discusses the capabilities of SQL in relation to data analysis. It compares various types of databases, describes methods for preparing data for analysis. It discusses data types, the structure of SQL queries, profiling, structuring, and cleaning data. Methods for analyzing time series and trends are described, with examples of data analysis considering seasonality. Separate chapters are devoted to cohort analysis, text analysis, identifying and processing anomalies, analysis of experiment results and A/B testing. It describes the creation of complex datasets, combining analytical methods. Practical examples of analyzing sales funnels and consumer baskets are provided.