Using DbT and Redshift to provide efficient Quicksight reports
TL;DR: Using Redshift as a Data Warehouse to integrate data from AWS Pinpoint, AWS DynamoDB, Microsoft Dynamics 365 and other external sources. Once the data is ingested to Redshift, DbT is used to transform the data into a format that is easier to be consumed by AWS Quicksight. Each Quicksight report/chart has a fact table. […]