Case Studies

Case Company Profile:
  • Industry leader with over $202 billion in annual sales
  • 2000+ Locations in the United States
  • Holds 16+% of domestic market
Software Implemented:
  • ASP.NET 2.0 (C#)
  • JAVA
  • MS SQL Server 2005

Business Intelligence for Global Automotive Leader


Challenge

Field Managers were mired in paper reports. They're responsible for quickly tracking huge volumes of discrete data for numerous dealerships to grow sales and profits, yet their time and efforts were dominated by a cumbersome paper-based reporting method that provided little except ad hoc analysis. How could they effectively analyze trends, implement sales promotions or forecast revenue and profit without easy, real-time access to essential data? How could the corporate managers accurately monitor regions if reporting was slow and unwieldy?

Solution

Peart-Hannon developed an Enterprise Portal solution, a 10-12 year project, including:
  • Enterprise database solutions - provides data across the entire organization
  • Custom Web Applications - offers dimensional reporting
  • Data Analysis Solutions - allows for strategic planning and ROI forecasting
  • ETL Processes - supporting 60+ applications and 1000+ reports

Results

  • A tedious, time-consuming paper process transformed into a seamless, efficient digital process
  • Operational data is effectively consolidated, aggregated, and analyzed
  • Company is eagerly adopting the solution into its global markets