In October 2024, 1.31 million new vehicles were estimated to have been sold across the United States.
The Challenge Our client, an investment bank, often constructs cancellation and claims frequency and severity curves for their clients’ financial products. These curves are critical for predicting future cancellations, claim timing, and severity. However, the process is labor-intensive, requiring significant time and manual effort to build each curve from raw data. Updates are even more […]
Our client, a direct-to-consumer marketer of financial products, faced a hidden challenge that was significantly impacting their marketing efficiency and profitability. By purchasing mailing data from multiple vendors, they were unintentionally remailing the same potential customers—resulting in wasted resources and missed opportunities. With a direct mail database of 18 million records, the inefficiencies were costing […]
Cars continue to be more expensive and less affordable. In September 2024, the average price of a new car was $48,423, a 0.9% increase over August but a 0.4% decrease from September 2023.
In August 2024, 1.42 million new vehicles were estimated to have been sold across the United States. This marks a 9.9% increase over July and a 6.1% increase compared to August 2023.
In July 2024, 1.29 million new vehicles were estimated to have been sold across the United States. This marks a 3.4% decrease from June and a 1.3% decrease compared to July 2023.
Colonnade Advisors, an M&A investment bank, faced a significant data challenge when a client provided customer data in an Excel file and CSV format. The data was disorganized, with customer information spread across multiple rows—sometimes as many as ten per customer. With hundreds of thousands of rows, the fragmented data made it nearly impossible to efficiently manipulate or analyze the dataset.