Download PDF
Jack Doheny Companies’ Data-Driven Culture Saves Millions Of Dollars
Technology Category
- Application Infrastructure & Middleware - Data Visualization
- Analytics & Modeling - Predictive Analytics
Applicable Industries
- Transportation
- Utilities
Applicable Functions
- Business Operation
- Quality Assurance
Use Cases
- Fleet Management
- Predictive Maintenance
- Process Control & Optimization
Services
- System Integration
- Data Science Services
The Challenge
The decision to evaluate BI solutions came in the wake of what could be defined as a “cultural revolution” taking place in JDC: from siloed data, with each stakeholder holding on to his or her own data and only sharing it with others on a “need to know” basis, to a corporate culture of complete transparency of information that aims to make data available to everyone, and challenge them to make good use of it. The data itself was being stored in a Cobalt character-based CRM system running on the IBM RS/6000 platform, as well as Excel spreadsheets. This data consisted of sales, operational, utilization, financial and other data. Prior to Sisense, reporting was done with Excel and Access. JDC has been looking for some sort of dashboard software for roughly two years but did not find any product that could suit their needs, until they ran into Sisense in a user group in which two Sisense customers had presented it. The VP of Parts and Business Systems downloaded the trial version right there at the convention, and within two days was already publishing dashboards.
About The Customer
Jack Doheny Companies (JDC) is the North American market leader in vacuum equipment, specializing in large vacuum trucks used for sucking up waste, liquid or dry product. The company’s current annual sales cycle is around $220 million dollars, and it has some 750-800 trucks in its rental fleet. JDC runs its operations from 16 facilities spread throughout the United States and Canada. The company has a significant presence in the vacuum equipment industry, running a fleet of hundreds of trucks covering the United States and Canada. JDC is a multi-million dollar company with a strong market position and a large operational footprint.
The Solution
Sisense was ultimately selected due to its ease of use, and mainly the product’s ability to merge large datasets. JDC stores its data in many Sort and Filter tables created in Excel in order to refine and consolidate the data from the CRM. The ability to pull in the Excel data and mash-up with the Cobalt (CRM) data was a game-changer. JDC were similarly wowed by Sisense’s performance: generating an Elasticube build of 4 million rows takes a mere few minutes. During the trial they were quickly able to replicate what they had been doing in Excel, then started playing around with other features such as the heatmaps and were immediately sold on Sisense. Since Sisense was deployed in JDC, data has started driving strategic business decisions. For example, the company planned to spend $250 million on equipment in one year – but after visualizing the data in BI dashboards and displaying the locations and utilization rates of trucks, that figure was reduced to $130 million. Part of this was due to external circumstances, but part was the result of viewing a heatmap visualizing the locations of the company’s current fleet of trucks, which made executives realize that there were holes in their coverage in the USA – which in turn led to a decision to open two additional facilities.
Operational Impact
Quantitative Benefit
Related Case Studies.
Case Study
IoT Solutions for Smart City | Internet of Things Case Study
There were several challenges faced: It is challenging to build an appliance that can withstand a wide range of voltage fluctuations from as low at 90v to as high as 320v. Since the device would be installed in remote locations, its resilience was of paramount importance. The device would have to deal with poor network coverage and have the ability to store and re-transmit data if networks were not available, which is often the case in rural India. The device could store up to 30 days of data.
Case Study
Automation of the Oguz-Gabala-Baku water pipeline, Azerbaijan
The Oguz-Gabala-Baku water pipeline project dates back to plans from the 1970’s. Baku’s growth was historically driven by the booming oil industry and required the import of drinking water from outside of the city. Before the construction of the pipeline, some 60 percent of the city’s households received water for only a few hours daily. After completion of the project, 75 percent of the two million Baku residents are now served around the clock with potable water, based on World Health Organization (WHO) standards. The 262-kilometer pipeline requires no pumping station, but uses the altitude differences between the Caucasian mountains and the capital to supply 432,000 m³/d to the Ceyranbatan water reservoir. To the people of Baku, the pipeline is “the most important project not only in 2010, but of the last 20 years.”
Case Study
GPRS Mobile Network for Smart Metering
Around the world, the electricity supply industry is turning to ‘smart’ meters to lower costs, reduce emissions and improve the management of customer supplies. Smart meters collect detailed consumption information and using this feedback consumers can better understand their energy usage which in turn enables them to modify their consumption to save money and help to cut carbon emissions. A smart meter can be defined in many ways, but generally includes an element of two-way communication between the household meter and the utility provider to efficiently collect detailed energy usage data. Some implementations include consumer feedback beyond the energy bill to include online web data, SMS text messages or an information display in consumers’ premises. Providing a cost-effective, reliable communications mechanism is one of the most challenging aspects of a smart meter implementation. In New Zealand, the utilities have embraced smart metering and designed cost effective ways for it to be implemented. The New Zealand government has encouraged such a move to smart metering by ensuring the energy legislation is consistent with the delivery of benefits to the consumer while allowing innovation in this area. On the ground, AMS is a leader in the deployment of smart metering and associated services. Several of New Zealand’s energy retailers were looking for smart metering services for their residential and small business customers which will eventually account for over 500,000 meters when the multi-year national deployment program is concluded. To respond to these requirements, AMS needed to put together a solution that included data communications between each meter and the central data collection point and the solution proposed by Vodafone satisfied that requirement.
Case Study
Airport SCADA Systems Improve Service Levels
Modern airports are one of the busiest environments on Earth and rely on process automation equipment to ensure service operators achieve their KPIs. Increasingly airport SCADA systems are being used to control all aspects of the operation and associated facilities. This is because unplanned system downtime can cost dearly, both in terms of reduced revenues and the associated loss of customer satisfaction due to inevitable travel inconvenience and disruption.
Case Study
NB-IoT connected smart meters to improve gas metering in Shenzhen
Shenzhen Gas has a large fleet of existing gas meters, which are installed in a variety of hard to reach locations, such as indoors and underground, meaning that existing communications networks have struggled to maintain connectivity with all meters. The meter success rate is low, data transmissions are so far unstable and power consumption is too high. Against this background, Shenzhen Gas, China Telecom, Huawei, and Goldcard have jointly trialed NB-IoT gas meters to try and solve some of the challenges that the industry faces with today’s smart gas meters.
Case Study
IoT-based Fleet Intelligence Innovation
Speed to market is precious for DRVR, a rapidly growing start-up company. With a business model dependent on reliable mobile data, managers were spending their lives trying to negotiate data roaming deals with mobile network operators in different countries. And, even then, service quality was a constant concern.