insightsoftware > Case Studies > How Rental One Replaced Complex Excel-Based Processes with Robust Analytics

How Rental One Replaced Complex Excel-Based Processes with Robust Analytics

insightsoftware Logo
Company Size
200-1,000
Region
  • America
Country
  • United States
Product
  • Dundas BI
Tech Stack
  • Business Intelligence
  • Data Cubes
  • Real-Time Analytics
Implementation Scale
  • Enterprise-wide Deployment
Impact Metrics
  • Cost Savings
  • Productivity Improvements
Technology Category
  • Analytics & Modeling - Big Data Analytics
  • Analytics & Modeling - Real Time Analytics
Applicable Industries
  • Construction & Infrastructure
Applicable Functions
  • Business Operation
Use Cases
  • Predictive Quality Analytics
  • Real-Time Location System (RTLS)
Services
  • Data Science Services
About The Customer
Rental One, located in Colleyville, Texas, is a premier equipment rental company that provides customers locally and state-wide with a broad selection of the best construction equipment and the most personalized service possible. The company operates through 11 retail locations, serving customers from a wide range of markets. Rental One has evolved and grown significantly since it began as a family-run business over six decades ago. Despite its growth, the company's commitment to excellence and belief that good work relies on dependability, integrity, honesty, and teamwork, has never wavered. Rental One continues to support its customers' projects regardless of equipment, supply, or service need.
The Challenge
Rental One, a premier equipment rental company, was struggling with an enormous Excel spreadsheet that tracked key performance indicators (KPIs) for financial data company-wide. The spreadsheet was becoming increasingly cumbersome as it accumulated data and expanded. The process was partially automated, but the majority of content was added manually. As the number of variables and quantity of content increased, the spreadsheet continued to grow, becoming more unwieldy. At the end of each month, additional consolidations were prepared to provide an executive review of business performance. However, the Excel spreadsheet was producing incorrect results, and different users reached different conclusions based on how the spreadsheet was interpreted and which data stacks they ran. The Excel-based system was grinding to a halt and impacting multiple facets of the business.
The Solution
Rental One decided to replace their Excel-based processes with a Business Intelligence (BI) platform. They required a BI platform that could negate Excel’s shortcomings, unlock and consolidate data from their ERP, simplify ad-hoc queries, and automatically produce correct, consistent results for everyone in the organization. They chose Dundas BI for its long-standing leadership in the data visualization space, and for its ability to fulfil Rental One’s key requirements specifically in regards to advanced data prep. Dundas BI’s advanced data prep capabilities allowed Rental One to be more proactive, and focus on the data they needed, and from there, easily enrich it. With Dundas BI, Rental One acquired the ability to retrieve data directly from its sources on regular intervals. This meant they could display their data in real-time on their dashboards, providing users with unfettered access to stored information and empowering them to track KPIs down to the minute.
Operational Impact
  • Rental One’s Excel-based processes were replaced with a single dashboard that updates in real-time, allowing store managers and executives to see KPIs immediately, at any time, and easily refer to any previous period.
  • Rental One was able to easily sort and visualize where collections needed to be made with the automated Accounts Receivables Aging report.
  • Rental One noticed a distinct cultural shift among store managers, who are now more aligned with the dashboards in Dundas BI than in Excel.
  • With Dundas BI, store managers are able to more effectively manage staffing needs to store revenue, and can visualize store revenues by sales categories, overdue contracts, and thumbnail views of fleet utilization.
Quantitative Benefit
  • Rental One saved the equivalent of 1.5 man-days per month of report creation with the automated Accounts Receivables Aging report.
  • Current projects continue to strip hours of clerical effort previously consumed managing Excel workbooks that can be now performed with real-time results in just seconds.

Case Study missing?

Start adding your own!

Register with your work email and create a new case study profile for your business.

Add New Record

Related Case Studies.

Contact us

Let's talk!
* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.