Each colour maps a published value to the exact source passage used to support it. Only bounded excerpts are public; administrators can inspect the complete captured source.
Title
hipages simplifies home improvements with targeted customer engagement via Databricks
…Demo Login Contact Us Try Databricks Customer Stories / Hipages CUSTOMER STORY Simplifying home improvements with targeted customer engagement 100% Uptime for key report (Job Estimator) on Databricks compared with Redash T…
Description
Australian tradie marketplace hipages consolidated three legacy data warehouses (MySQL, Redshift, Athena) into a single Databricks lakehouse with Databricks SQL, Kafka CDC ingestion and dbt, achieving 100% uptime on its key Job Estimator report versus its prior Redash setup and projecting thousands of dollars in annual infrastructure savings.
…ility and scalability. Minas described the impact of this transition, stating, “We transformed our stack from three data warehouses into one data lakehouse, using Databricks, which majorly streamlined our operations and allowed our data users more autonomy.” Databricks SQL significantly accelerates the process of data analysis and repo…
…CUSTOMER STORY Simplifying home improvements with targeted customer engagement 100% Uptime for key report (Job Estimator) on Databricks compared with Redash Thousands of dollars Projected annual infrastructure cost savings hipages has r…
…t 100% Uptime for key report (Job Estimator) on Databricks compared with Redash Thousands of dollars Projected annual infrastructure cost savings hipages has revolutionized Australia’s home improvement industry by connecting…
Company
hipages
…g. Separate data warehouses stifle productivity and insight in home improvement hipages stands as Australia’s largest online tradie marketplace, serving as a pivotal connection between homeowners looking to improve their homes and tradies seeking job opportunities. Founded over 20 years ago, hipages has facilitated over 4 million connections b…
Country
Australia
…g. Separate data warehouses stifle productivity and insight in home improvement hipages stands as Australia’s largest online tradie marketplace, serving as a pivotal connection between homeowners looking to improve their homes and tradies seeking job opportunities. Founded over 20 years ago, hipages has facilitated over 4 million connections b…
Industry
Technology & Software
…rough technological excellence and strategic foresight. Share this post Details Industry : Technology and Software Use Case : Data Science , Data Warehousing , Data Engineering Cloud : AWS Produ…
Problem
hipages ended up with three generations of data warehouses (MySQL, then Redshift, then Athena), with data taking two days on average to transition between warehouses, delaying access for analysts and decision-makers, and making self-service analytics nearly impossible since analysts depended on data engineers to access and interpret data.
…gement approach, which stifled productivity and hindered insightful analytics. “We ended up with three generations of data warehouses,” Minas explained, detailing the transition from MySQL to Redshift and then to Athena. “When things broke, it took a while to figure out where the issue was.” This la…
…Athena. “When things broke, it took a while to figure out where the issue was.” This layered legacy system led to inefficiencies, with data taking two days on average to transition between warehouses — delaying access for analysts and decision-makers. The lack of a unified platform meant that data analysts were dependent on data…
…nsition between warehouses — delaying access for analysts and decision-makers. The lack of a unified platform meant that data analysts were dependent on data engineers to access and interpret data, making self-service analytics nearly impossible. “How would we have autonomous teams that have access to data with that convolut…
Solution
hipages migrated its three data warehouses into a single Databricks lakehouse, using Databricks SQL to let data analysts build dynamic dashboards and run rapid analyses, Kafka to capture change-data-capture events from its production database, Fivetran for batch ingestion, dbt to standardize and modularize SQL data models, and Hightouch for reverse ETL into marketing platforms like Braze.
…h majorly streamlined our operations and allowed our data users more autonomy.” Databricks SQL significantly accelerates the process of data analysis and reporting at hipages. Data analysts now have the capability to create dynamic dashboards and perform…
…s. Our data analysts prefer to use Databricks SQL for easy and quick analysis.” The integration of Kafka for capturing CDC (change data capture) events from their production database and Fivetran for batch ingestion from various sources has streamlined the data flow into their systems. This setup supports real-time data processing and enhances the overall responsi…
…reate reusable and modular SQL code, simplifying complex data transformations. “By using dbt, we were able to standardize and modularize our data models, and automate the creation and testing of these models. For example, we have a single customer view model that is built in dbt and used…
…that is built in dbt and used by Braze for improving our marketing campaigns.” The use of Hightouch for reverse ETL (extract, transform, load) processes ensures that marketing platforms like Braze are seamlessly integrated with up-to-date data — enabling targeted customer interactions based on the latest insights. Acceler…
Business value
Since moving the Job Estimator report from Redash to Databricks five months ago, hipages has had zero incidents, giving 100% uptime on this key report, and the company expects to save over thousands of dollars annually once it decommissions its legacy systems.
…which our sales team uses to estimate which package a tradie should sign up to. Since we moved this report to Databricks five months ago, we have had zero incidents.” Due to the success of Databricks’ infrastructure, hipages is set to finalize t…
…ing all legacy systems and transitioning all existing cron jobs to dbt models. “We are expecting to save over thousands of dollars annually,” Minas noted. Looking ahead, hipages plans to further enhance their self-servi…
AI capabilities
Machine Learning
…d by data analysis, and all our business metrics are data-driven,” Minas noted, underscoring the integral use of machine learning in optimizing lead pricing for tradies. Despite their advancements, hipages faced significant challenges due to legacy…
Technology
Databricks SQL, Delta Lake, Unity Catalog, Kafka, dbt
…tware Use Case : Data Science , Data Warehousing , Data Engineering Cloud : AWS Product : Databricks SQL , Delta Lake , Unity Catalog Ready to get started? Try Databricks for free Learn more about our product Talk…
…s. Our data analysts prefer to use Databricks SQL for easy and quick analysis.” The integration of Kafka for capturing CDC (change data capture) events from their production database and Fivetran for batch ingestion from various sources has streamlined the data…
Deployment model
cloud
…logy and Software Use Case : Data Science , Data Warehousing , Data Engineering Cloud : AWS Product : Databricks SQL , Delta Lake , Unity Catalog Ready to get started? Try…
Deployment options
cloud
…logy and Software Use Case : Data Science , Data Warehousing , Data Engineering Cloud : AWS Product : Databricks SQL , Delta Lake , Unity Catalog Ready to get started? Try…
Headline outcome
…CUSTOMER STORY Simplifying home improvements with targeted customer engagement 100% Uptime for key report (Job Estimator) on Databricks compared with Redash Thousands of dollars Projected annual infrastructure cost savings hipages has r…
Use case type
Analytics augmentation
…strategic foresight. Share this post Details Industry : Technology and Software Use Case : Data Science , Data Warehousing , Data Engineering Cloud : AWS Product : Databricks SQL , Delta Lake , Unity Catalog Ready to get…
