3 ms·
1) Look at 3rd party solutions (Stitch, Fivetran, Segment, etc.) to ingest your raw data into a data warehouse (strong preference for Snowflake). 2) Use dbt (h
by dapearce 7y ago
1) Look at 3rd party solutions (Stitch, Fivetran, Segment, etc.) to ingest your raw data into a data warehouse (strong preference for Snowflake).
2) Use dbt (https://www.getdbt.com https://www.getdbt.com) to clean, transform and model the raw data into analytic tables.
3) Add a BI layer (Mode, Looker, etc.) on top of the analytic tables for reporting.