CASE STUDY // TREK BICYCLE

Trek Bicycle Accelerates Retail Analytics

Global bicycle leader uses Qlik and Databricks Data Intelligence Platform to unify data.

80-90%

Acceleration in run-time

Analytics results are now available in six to eight hours, instead of 48 hours previously.

3x

Increase in daily data refreshes

Business analytics data is now refreshed three times a day, ensuring accurate and actionable results.

1 week

Reduction in ERP data replication

ERP data is now replicated in near-real time, instead of weekly using bulk copies.

CHALLENGE

Slow data processing hinders retail analytics

The business has achieved impressive global growth, but the core values that made Trek Bicycle successful haven’t changed: it aims to provide an outstanding experience to customers and staff. To achieve this, it needs quick and reliable access to high-quality data.

However, as Trek grew it became increasingly affected by the rising costs and decreasing performance of its data warehouse. Specifically, running analytics on retail data was challenging as Trek relied on a platform that was not scaling cost-effectively, which impacted processing speeds.

APPROACH

Qlik unifies retail data from around the globe

As the business grew, Trek needed an agile data ingestion and transformation solution for its lakehouse. The solution needed to keep pace with growth and integrate with Databricks to deliver a global view of its performance and allow it to process data more quickly and regularly.

Trek now uses Qlik and Databricks to collect sales data from nearly 500 stores worldwide. All computation happens on top of the lakehouse in a new data warehouse, with a semantic layer powering everything from strategic high-level reporting to daily store sales reports.


RESULTS

New platform accelerates analytics by up to 90%

By moving its data processing to the lakehouse and integrating data with Qlik, Trek has dramatically increased processing speeds and overall data availability. Instead of replicating enterprise resource planning (ERP) data once a week using bulk copies, Qlik helps to facilitate the process in near-real time.

Trek’s retail analytics solution used to take 48 hours to produce meaningful results. Today, Trek gets results in six to eight hours — an 80 to 90% improvement — with refreshes running three times a day, compared to only once a day previously.

WHAT THIS MEANS FOR YOU

Turbocharge your retail analytics capability

Databricks Lakehouse has been a game-changer for Trek. With Qlik Cloud® Data Integration, the business can replicate transactional data in real time from hundreds of stores and digital sources worldwide and take some impressive steps toward achieving its cloud-first vision.

With the quick and reliable access to accurate data that this enables, businesses can cut costs, meet critical needs and focus on delivering world-class engagements with customers — whether online or in person at retail stores.

Databricks Data Intelligence Platform, along with data replication using Qlik, aligns perfectly with our broader cloud-first strategy.

Steve Novoselac
Vice President, IT and Digital, Trek Bicycle

Get started now