Introduction

Throughout The Applied SQL Data Analytics Workshop, Second Edition, you have learned a range of new skills (including basic descriptive statistics, SQL commands, and importing and exporting data in PostgreSQL) as well as more advanced methods to optimize and automate SQL (such as functions and triggers). In this final chapter of this workshop, we will combine these new skills with the scientific method and critical thinking to solve a real-world problem and determine the cause of an unexpected drop in sales.

This chapter provides a case study and will help you build your confidence in applying your new SQL skillset to your own problem domains. To solve the problem presented in this use case, you will use the complete range of your newly developed skills, from using basic SQL searches to filter out the available information to aggregating and joining multiple sets of information and using windowing methods to group the data in a logical manner. By completing case studies...