Start Now Login

intermix Blog

Best practices and lessons learned for cloud ETL and data engineering.

Webinar: Amazon Redshift remains #1 Learn how and when to consider the competition

0 min READ
July 15th 2019
Join us August 1st 12 pm PT - 3 pm ETWith the growing number of cloud data warehouse options even the most invested of companies may be considering their options for cost efficiency and performance.  In this webinar we’ll be covering:1. The 5 major players and a high level strengths & weaknesses of each […]
Cass McCrory Cass McCrory

Query Optimization: How to efficiently compare two rows in a SQL query

3 min READ
July 12th 2019
Query optimization that dramatically reduces runtime for queries which use window functions.The Simplified ProblemA common problem we see our customers solving in SQL is how to compare two rows per group in a dataset.  For example, say you have the following data in the product_prices table […]
Stefan Gromoll Stefan Gromoll

What is Amazon Redshift? A Deep Dive Into Pricing and Technology

11 min READ
June 21st 2019
Data is valuable resource powering up analytics, predictive models and decision making. For a company to make data-driven decisions, it first must go through building its data infrastructure. And a data warehouse plays a central role in such an infrastructure.Data warehouses are data storage and pr […]
Lars Kamp Lars Kamp

What is the worst part of data engineering?

4 min READ
June 13th 2019
In data engineering teams the list is long and depends on your personal role. But my general pick is “Poor SQL statements by end data scientists and data analysts”.Probably not an obvious answer, so let me explain.Let’s look at this from a perspective of what three major areas of work are for da […]
Lars Kamp Lars Kamp

Intuit’s Journey to Cloud Analytics

13 min READ
June 11th 2019
How to Use Amazon Redshift For a New Generation of Data ServicesIn 2014 Intuit's then-CTO Tayloe Sainsbury went all in on the cloud and started migrating Intuit’s legacy on-premise IT infrastructure to Amazon AWS. By February 2018, Intuit had sold its largest data center and processed 100% of 2018 […]
Lars Kamp Lars Kamp
1 2 3 4 8