How Dealer Trade Network delivered 60 X faster analytics
Customer Company Size
Large Corporate
Region
- America
Country
- United States
Product
- Firebolt
- Amazon Redshift
- Aurora MySQL
Tech Stack
- SQL
- REST APIs
- AWS
Implementation Scale
- Enterprise-wide Deployment
Impact Metrics
- Productivity Improvements
- Cost Savings
- Revenue Growth
Technology Category
- Analytics & Modeling - Predictive Analytics
- Platform as a Service (PaaS) - Data Management Platforms
Applicable Industries
- Automotive
Applicable Functions
- Sales & Marketing
- Business Operation
Services
- System Integration
- Software Design & Engineering Services
About The Customer
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.
The Challenge
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.
The Solution
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.
Operational Impact
Quantitative Benefit
Case Study missing?
Start adding your own!
Register with your work email and create a new case study profile for your business.
Related Case Studies.
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.
