Automating Reporting at Algolia

This post details how Algolia's data team automated their quarterly reporting process by integrating Fivetran, Redshift, dbt, and Hex. They moved from manual CSV downloads and Google Sheets to an automated pipeline where data is transformed in Redshift using dbt, then queried and visualized in Hex. The output is pushed to Google Sheets, and then into Google Slides for reporting. This reduced the reporting time from two weeks to 5-10 minutes.