flâneur

Day Of The Week Analysis in SQL - Issue 39

dataanalysis.substack.com · 188 words · saved by 1 readers

How to break down user activity by day of the week in SQL. Simple to pull, takes a few minutes to write the query, and data is easy to interpret and present.

Hello everyone! Today’s topic is a SQL solution for one of my favorite quick data explorations - weekday usage analysis (also known as DOW analysis - day of the week). I often run it as the first query working on a new dataset - breaking user actions down on days of the week. It’s my favorite because it’s simple to pull, literally takes a few minutes to write the query, and the data is easy to interpret and present. At the same time, it opens a virtual universe of insight into the business type, lifecycle, and user behavior. It helps to answer questions like: Does the business have…

saved by

related reading