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
- Analytical Case Study On User Engagement - Issue 68dataanalysis.substack.com
- 5 Mistakes To Avoid When Running A/B Tests - Issue 87dataanalysis.substack.com
- Introduction to Simple Association Rules Mining for Market Basket Analysis | Towards Data Sciencetowardsdatascience.com
- Stop aggregating away the signal in your data - Stack Overflowstackoverflow.blog
- Average Post Hiatus | Facebook SQL Interview Questiondatalemur.com
- How do product analytics work?technically.substack.com
- Day in the Life Studies: A Unique Method for Gathering User Context - Dscoutdscout.com
- A faster way to calculate the day-of-the-weekbenjoffe.com
- A More Human Approach To Databasesccorcos.github.io
- Blog | Dovetaildovetailapp.com
- 🕖Waitlistsread.first1000.co
- Time Series Clustering - Deriving Trends and Archetypes from Sequential Data | Towards Data Sciencetowardsdatascience.com