This is the first post of a six-part series of posts explaining how we make analyzing Quickbooks data easier by creating cached data sets from complex queries, resulting in simplified tables that anyone at our company is able to easily understand. Part 1: Introduction + Shadow Schema Strategy Explanation Part 2: The Quickbooks Shadow Schema Part 3: Budgets Table Part 4: Cash Movements Table Part 5: Expenses Table Part 6: Revenue Table Stitch exports Quickbooks Online data in the way that Quickbooks structures its API – each type of record is its own separate object, and each object has child … Continue reading Simplifying Stitch ETL’s Quickbooks Data in Redshift: Introduction