How to parse nested dictionaries in Snowflake table columns using SQL
Here we share new things we’ve learned and think you’ll hopefully find useful. Lately, we’ve been learning more about our new favorite data warehouse platform Snowflake, optimization in Julia and probabilistic programming.
What are you excited about? Let us know!
We explore a few applications of the Dirichlet Multinomial distribution using PyMC3.
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
How to calculate approximations of confidence intervals for proportions & probabilities in Tableau
How to calculate approximations of confidence intervals for proportions & probabilities in SQL
Working with clients on migrating their Tableau dashboards from Redshift to Snowflake, I ended up writing this little helper in Python that does much of the ...
We’ll be at JuliaCon 2018 from August 7th to 11th in London to learn more about this exciting language and community. Let us know if you’ll be there - we’d l...
We solve a textbook optimization example involving planning multiple warehouse locations using Julia
A Julia port from Python of the Wedding Table Assignment example from PuLP.