How Dealer Trade Network delivered 60 X faster analytics
公司规模
Large Corporate
地区
- America
国家
- United States
产品
- Firebolt
- Amazon Redshift
- Aurora MySQL
技术栈
- SQL
- REST APIs
- AWS
实施规模
- Enterprise-wide Deployment
影响指标
- Productivity Improvements
- Cost Savings
- Revenue Growth
技术
- 分析与建模 - 预测分析
- 平台即服务 (PaaS) - 数据管理平台
适用行业
- 汽车
适用功能
- 销售与市场营销
- 商业运营
服务
- 系统集成
- 软件设计与工程服务
关于客户
Dealer Trade Network (DTN) is the largest new car dealer-to-dealer trading network in the United States, supporting over 4000 dealerships. The network relies on proprietary analytics built on tracking current and historical vehicle inventory and market trends. DTN is also developing digital products that allow dealers to integrate supply and demand analytics into their business operations. The company aims to enhance its offerings by providing dealer-specific reports and leveraging historical data to identify new sales leads and drive revenue growth.
挑战
As data volumes and access requirements grew, DTN faced challenges in analyzing data beyond a 30-day window and comparing inventory snapshots over multiple time frames. These comparisons were crucial for identifying potential trades within the DTN network. The effectiveness of DTN's digital products depended on providing timely trend reports covering a 12-month data retention period. To address the need for fast response times while analyzing large data volumes, Firebolt was evaluated at the recommendation of consulting partner, Untitled Firm.
解决方案
DTN engaged Firebolt to explore technology fit, with the Firebolt team working closely with Untitled and DTN’s technology teams to move data from existing databases to a Firebolt database on AWS. The onboarding process was smooth due to the team's familiarity with SQL. Firebolt's indexing capabilities resulted in 60X faster query times compared to the previous analytics platform. DTN explored various scenarios to test data ingestion and environment management, leveraging Firebolt’s documentation and REST APIs. The transition to Firebolt allowed DTN to generate dealer-specific reports in 2 minutes, a 30X improvement over the previous system.
运营影响
数量效益
Case Study missing?
Start adding your own!
Register with your work email and create a new case study profile for your business.
相关案例.
Case Study
Integral Plant Maintenance
Mercedes-Benz and his partner GAZ chose Siemens to be its maintenance partner at a new engine plant in Yaroslavl, Russia. The new plant offers a capacity to manufacture diesel engines for the Russian market, for locally produced Sprinter Classic. In addition to engines for the local market, the Yaroslavl plant will also produce spare parts. Mercedes-Benz Russia and his partner needed a service partner in order to ensure the operation of these lines in a maintenance partnership arrangement. The challenges included coordinating the entire maintenance management operation, in particular inspections, corrective and predictive maintenance activities, and the optimizing spare parts management. Siemens developed a customized maintenance solution that includes all electronic and mechanical maintenance activities (Integral Plant Maintenance).
Case Study
Monitoring of Pressure Pumps in Automotive Industry
A large German/American producer of auto parts uses high-pressure pumps to deburr machined parts as a part of its production and quality check process. They decided to monitor these pumps to make sure they work properly and that they can see any indications leading to a potential failure before it affects their process.
