Case Study: Bamboo achieves data-driven decision making with Mechanical Rock

Using AWS QuickSight, Snowflake and dbt to visualise data for data-driven decision making

Mechanical Rock was engaged by Bamboo, a Perth-based micro-investment company, to address a significant operational challenge. As Bamboo expanded, its staff struggled to visualize user data and perform back-office tasks, which relied on a complex command line interface that required deep technical expertise to operate.

Mechanical Rock implemented a solution by ingesting data into Bamboo's Snowflake warehouse and creating accessible dashboards using AWS QuickSight. This new system integrated with Google authentication for single-sign-on and removed the need for ad hoc scripts. As a result, Bamboo staff can now efficiently monitor the application, perform tasks without specialized technical knowledge, and leverage visualized data to make informed, company-wide decisions.

Bamboo