Data, AI & Analytics
Design
Development
July 12, 2023
RSC operates in 13 states, more than 10,000 sites spread across United States. Its business was expanding where they were running HVAC operations in more than 8500 sites with more than 300 technician, electricians, dispatchers and drivers in the field to serve their corporate customers.
RSC Group use VENTUS a software developed by Vertical Markets to maintain Service Tickets, Invoices, General Ledgers, Accounts, Quotes and Budgeting etc.
RSC Group field managers (Region, Area and Account Managers) were facing an increasingly difficult task to manage over 10,000 active service tickets daily for their respective regions, markets and areas. It was not only consuming a significant amount of time but also requires to prioritize tickets as per criticality, large business portfolio client tickets review and separate prioritization, handle tickets on hold to ensure sufficient inventory and manpower allocation, and carefully review ticket notes coming through personnels in field.
The leadership team acknowledged the challenges, importance of Quality of Services (QoS) in parallel to determine cost reduction through workload optimization across various sites, managers, and field technicians. Additionally, they aimed to gain insights into the tickets priority, tickets stay on hold and identify the underlying reasons for the delays causing labor cost which enabled them to meet Service Level Agreements (SLAs), continuous improvement in Quality of Services (QoS) and competitive edge in price quotes by appropriately manpower utilization.
The team of data analysts engaged with RSC Group leadership to understand business problems, identifications of stake holders from operations, billings and finance stand-point to define desired KPIs and dashboards by using VENTUS and other source systems. Here are some critical KPIs we defined in collaboration:
The data engineering team developed enterprise data warehouse containing self-service reporting capabilities for power users to build their reports without involving IT team to fulfil their job requirements. Data engineering team developed ETL packages and pipelines to synchronize Tickets, Accounts, Materials, Technicians and rest of datasets every minute to empower operations visibility as quickly as possible. Simultaneously, the data analysts focused on data story explanation through visualization, results review and business users experience in close collaboration with the business stakeholders.
The effective implementation of a business intelligence system, combined with comprehensive training for field managers, led to significant operational and financial improvements. The following benefits were achieved:
Overall, the successful implementation and training initiatives resulted in operational and financial efficiencies, promoting a more streamlined and effective workflow.
The leadership team at RSC Group made a strategic decision to integrate various information systems with their Enterprise Data Warehouse. This integration aimed to enable advanced analytics for functions such as Purchase Orders, Inventory Pricing, and Inventory Maintenance. Additionally, the goal was to create role-specific dashboards and reports that would provide valuable insights to different stakeholders within the organization. By connecting these systems, RSC Group aimed to leverage the power of data and analytics to enhance decision-making, improve operational efficiency, and drive overall business growth.
Brickclay is a digital solutions provider that empowers businesses with data-driven strategies and innovative solutions. Our team of experts specializes in digital marketing, web design and development, big data and BI. We work with businesses of all sizes and industries to deliver customized, comprehensive solutions that help them achieve their goals.
More case studies from Brickclay