• About
    • Blog
    • Business Process
    • Charity Work
    • History
    • News
  • Services
    • Legacy System Support
    • Bespoke System Development
    • Web Design & Development
    • View all services
  • Products
  • Our work
    • Customers
    • Case Studies
  • Careers
  • Contact
Microsoft Partner - Application Development
17th December 2013

Vision CRM-Data warehouse system integration

CRM Data Warehouse

PSP-IT have worked with Gainsborough based Eminox to develop a data warehouse moduel to plug into our off the shelf CRM "Vision"that integrates their existing legacy systems into a modern interface to give rapid response data retrieval for users. Eminox are an international company who design and manufacture high performance stainless steel exhausts and emission control systems for commercial vehicles.

Eminox's have multiple existing data systems which are in different formats meaning that when management need to run reports on current budget, forecast and sales figures it was taking days to prepare into one understandable report.

PSP-IT have designed a system that imports data from Access and Oracle databases on an hourly schedule to collate the data thus enabling it to be viewed using an online dashboard and pivot charts to show the information in an easy to read format. The intuitive reporting interface enables the user to customise the dashboard views of data they are looking at and it can be broken down by Date, Salesman, Site and Product as required. The customer also required the system to have an overnight automated processing run to import data to ensure it is ready for display the next morning, the timing of which can be altered as the business needs change.

Eminox are now experiencing the benefits of near real time data, saving days of management time in compiling reports and more accurate reporting.

Jog Lall, Sales & Marketing Director at Eminox wrote

"PSP did a great job for Eminox in creating a world class front end system for monitoring and managing the sales performance, but more importantly, the order book and business development pipeline. The data is extracted from three disparate systems to provide the complete picture on a single user friendly "dashboard". The project was well managed, on time and within budget; with an excellent Return on Investment. "

Click here to view the case study.

Share:
PSP IT Design & Development
About Us
  • Privacy Policy
  • History
  • Customers
  • News
  • Blogs
Services
  • Legacy System Modernisation
  • Website Design & Development
  • Bespoke Application Development
  • Outsource IT Strategy
  • All Services
Contact
  • 01775 722377
  • letstalk@psp-it.co.uk
  • Carver House, Apex Court, Spalding Office Park, Elsoms Way, Pinchbeck, Spalding,Lincolnshire, PE11 3UL

Terms & Conditions Privacy Policy

© PSP People Systems Process Ltd. 2022. All Rights Reserved.

MENU

MENU

  • About

    • Blog

    • Business Process

    • Charity Work

    • History

    • News

  • Services

    • Legacy System Support

    • Bespoke System Development

    • Web Design & Development

    • View all services

  • Products

  • Our work

    • Customers

    • Case Studies

  • Careers

  • Contact

© PSP People Systems Process Ltd. 2022. All Rights Reserved. Privacy Policy

give us a call
01775 722377
drop us an email