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 (You are here) Part 5: Expenses Table Part 6: Revenue Table This is the Cash Movements table, and the first of the complex tables in this series. It joins many tables together into a single table … Continue reading Simplifying Stitch ETL’s Quickbooks Data in Redshift: Cash Movements Table