We can't find the internet
Attempting to reconnect
Something went wrong!
Hang in there while we get back on track
Postgres is being used more and more for analytical workloads. There's a few hidden gems I recently ran across that are really handy for doing SQL for data analysis,
ROLLUPandCUBE. Rollup and cube don't get a lot of attention, but follow along with me in this post to see how they can save you a few steps and enhance your date binning and summary reporting.We also have a web-based tutorial that covers Postgres Functions for Rolling Up Data by Date if you want to try it yourself with a sample data set.
continue reading on www.crunchydata.com
⚠️ This post links to an external website. ⚠️
If this post was enjoyable or useful for you, please share it! If you have comments, questions, or feedback, you can email my personal email. To get new posts, subscribe use the RSS feed.