From "Wild West" reporting to a governed analytics foundation.
DI Squared took ownership of four critical use cases that a lower-cost consultancy could not complete, delivered the original project a week ahead of schedule, and has spent the last six-plus years building Dorman a governed Qlik and Power BI foundation that runs the business every day.
Six years of compounding wins.
Per-container savings via forecasting
Of ongoing managed development support
Automotive Manufacturing & Distribution
North America
Data Strategy, Analytics, Data Engineering
Qlik Sense, Power BI
SAP HANA, Warehouse Management Systems
Lakehouse
Broker & Government Trade Feeds
Multi-Year Strategic Partnership
About the Company
Dorman is a leading manufacturer of aftermarket automotive replacement parts for cars, SUVs, trucks, and commercial vehicles. Its products are distributed through major automotive retailers and serve customers throughout North America.
As the company expanded through acquisitions and navigated increasing supply chain complexity, tariffs, and warehouse modernization, Dorman recognized the need for a more scalable and trusted analytics environment to support operational decision-making.
The Challenge
Dorman’s reporting environment had evolved over many years through replicated databases, Excel spreadsheets, and independently developed reports owned by individual departments.
This created several business challenges:
A previous consulting firm failed to deliver four critical analytics initiatives.
Manual Excel processes routinely froze and delayed business decisions.
Departments maintained separate reports with inconsistent business definitions.
Business users lacked a governed self-service analytics environment.
Warehouse operations and container forecasting lacked timely operational visibility.
Growing supply chain complexity demanded faster, more reliable decision support.
Rather than investing in additional point solutions, Dorman needed a strategic partner capable of delivering scalable analytics that both IT and business teams could trust.
The Solution
DI Squared partnered with Dorman to establish a governed enterprise analytics platform that combined modern data engineering with practical business intelligence.
The engagement included:
- Enterprise Qlik analytics applications connected directly to operational systems
- Governed Power BI workspaces for secure self-service reporting
- Standardized business definitions across ERP, warehouse, logistics, and trade data
- Automated data pipelines replacing manual exports and spreadsheet processes
- Lakehouse architecture supporting future AI and advanced analytics initiatives
- Enterprise reporting solutions for trade compliance, container forecasting, warehouse operations, and executive reporting
Over the course of a long-term partnership, DI Squared not only recovered four failed initiatives from a previous consultancy but also helped establish a trusted data foundation that continues to support both operational reporting and future innovation.
Results Achieved
Recovered Critical Business Initiatives
DI Squared successfully delivered four high-priority analytics projects that had previously stalled, completing the initial engagement one week ahead of schedule.
Faster Operational Decisions
Automated reporting replaced spreadsheet processes that previously required more than 30 minutes to execute, giving leadership faster access to tariff, logistics, and operational information.
Greater Supply Chain Visibility
Real-time warehouse dashboards and container forecasting provide distribution centers with the operational insight needed to improve productivity, reduce bottlenecks, and avoid costly shipping delays.
Trusted Self-Service Analytics
Business users now create reports within governed Power BI workspaces built on curated datasets, allowing teams to move quickly without sacrificing consistency, security, or data quality.
Stronger Enterprise Data Foundation
Standardized business entities and automated data pipelines have created a single, trusted source of operational data shared across finance, supply chain, logistics, and warehouse operations.
Ready for AI and Automation
By implementing lakehouse architecture, governed pipelines, and modern data engineering practices, Dorman now has an enterprise data platform capable of supporting automation, AI, and natural language analytics as future initiatives evolve.
Client Perspective
“I value working with DI Squared because they are very mature, they’re very knowledgeable, and I trust them. That level of direct access to business partners is not something I just give out to everybody.”
IT Leader
“The partnership has been awesome. DI Squared has become our standard bearer. They’re the team that remembers what we’ve done before and brings that knowledge into every new project.”