Day Of The Week Analysis in SQL

How to break down user activity by day of the week in SQL

Weekday usage analysis (also known as DOW analysis — day of the week) is my favorite quick data exploration. I often run it as the first query working on a new dataset — breaking user actions down on days of the week. Also, it’s a common question during SQL interviews for beginner analyst positions.

It’s my favorite data question because it’s simple to pull, literally takes a few minutes to write the query, and the data is easy to interpret and present…