Using SQL and dbt, we create a date dimension table using a retail/merchandising calendar known as a 4-5-4 calendar.
We try to solve a plant production example problem using linear programming with Julia using two different formulations.
How to randomly select rows within a subset or group of your data using SQL
An opinionated introduction to ‘advanced’ SQL for data warehouse platforms, such as Redshift, Snowflake and Teradata, Part 2 of N
An opinionated introduction to query strategies for data warehouse platforms, such as Redshift, Snowflake and Teradata