Supermarket Transaction Analysis in SQL

The checkout line is a familiar part of the retail experience. Any retailer needs to understand their checkout data to answer important questions like "do people spend more with card or cash?", "how many items do people buy at different times?", and "are self-service checkouts quicker than those with a cashier?".

In this live training, you'll use SQL to analyze transaction data from a Polish supermarket to answer financial and logistical questions.

What will I learn?

• Learn to analyze distributions using SQL

• Learn to work with numeric and datetime data in SQL

• Learn to answer financial and logistics questions about retail transaction data

Useful Links

• Dataset: point of sale supermarket dataset

• Related track: SQL Fundamentals

• Related track: SQL for Business Analysts